Thursday, November 17, 2011

VO Details

There are 2 VOs -
1)-*IrcVacancySearchCriteriaVO* - XML Code is given below.. This VO is used in the search region..



Name="IrcVacancySearchCriteriaVO"
BindingStyle="Oracle"
CustomQuery="true"
RowClass="oracle.apps.irc.candidateSearch.server.IrcVacancySearchCriteriaVORowImpl"
ComponentClass="oracle.apps.irc.candidateSearch.server.IrcVacancySearchCriteriaVOImpl"
MsgBundleClass="oracle.jbo.common.JboResourceBundle"
FetchMode="FETCH_AS_NEEDED"
Passivate="All"
UseGlueCode="false" >
SELECT NULL AS SELECTFLAG,
CSC.OBJECT_ID, CSC.OBJECT_TYPE, CSC.LOCATION, CSC.DISTANCE_TO_LOCATION, CSC.EMPLOYEE, CSC.CONTRACTOR, CSC.EMPLOYMENT_CATEGORY, CSC.KEYWORDS, CSC.TRAVEL_PERCENTAGE, CSC.MAX_SALARY, CSC.MIN_SALARY, CSC.SALARY_CURRENCY,
CSC.MATCH_COMPETENCE, CSC.JOB_TITLE, CSC.DEPARTMENT, CSC.PROFESSIONAL_AREA, CSC.WORK_AT_HOME, CSC.USE_FOR_MATCHING, CSC.ATTRIBUTE_CATEGORY, CSC.ATTRIBUTE1, CSC.ATTRIBUTE2, CSC.ATTRIBUTE3, CSC.ATTRIBUTE4, CSC.ATTRIBUTE5,
CSC.ATTRIBUTE6, CSC.ATTRIBUTE7, CSC.ATTRIBUTE8, CSC.ATTRIBUTE9, CSC.ATTRIBUTE10, CSC.ATTRIBUTE11, CSC.ATTRIBUTE12, CSC.ATTRIBUTE13, CSC.ATTRIBUTE14, CSC.ATTRIBUTE15, CSC.ATTRIBUTE16, CSC.ATTRIBUTE17, CSC.ATTRIBUTE18,
CSC.ATTRIBUTE19, CSC.ATTRIBUTE20, CSC.ATTRIBUTE21, CSC.ATTRIBUTE22, CSC.ATTRIBUTE23, CSC.ATTRIBUTE24, CSC.ATTRIBUTE25, CSC.ATTRIBUTE26, CSC.ATTRIBUTE27, CSC.ATTRIBUTE28, CSC.ATTRIBUTE29, CSC.ATTRIBUTE30, CSC.ISC_INFORMATION_CATEGORY, CSC.ISC_INFORMATION1,
CSC.ISC_INFORMATION2, CSC.ISC_INFORMATION3, CSC.ISC_INFORMATION4, CSC.ISC_INFORMATION5, CSC.ISC_INFORMATION6, CSC.ISC_INFORMATION7, CSC.ISC_INFORMATION8, CSC.ISC_INFORMATION9, CSC.ISC_INFORMATION10, CSC.ISC_INFORMATION11, CSC.ISC_INFORMATION12, CSC.ISC_INFORMATION13, CSC.ISC_INFORMATION14, CSC.ISC_INFORMATION15, CSC.ISC_INFORMATION16, CSC.ISC_INFORMATION17, CSC.ISC_INFORMATION18, CSC.ISC_INFORMATION19, CSC.ISC_INFORMATION20, CSC.ISC_INFORMATION21, CSC.ISC_INFORMATION22, CSC.ISC_INFORMATION23,
CSC.ISC_INFORMATION24, CSC.ISC_INFORMATION25, CSC.ISC_INFORMATION26, CSC.ISC_INFORMATION27, CSC.ISC_INFORMATION28, CSC.ISC_INFORMATION29, CSC.ISC_INFORMATION30, to_char(CSC.MIN_QUAL_LEVEL), to_char(CSC.MAX_QUAL_LEVEL),
fnd_number.canonical_to_number(distance_to_location) AS DISTANCE_TO_LOCATION_INT FROM IRC_SEARCH_CRITERIA CSC WHERE CSC.OBJECT_TYPE = 'VACANCY'
]]>







Name="SelectFlag"
IsQueriable="false"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
AliasName="SELECTFLAG"
ColumnType="VARCHAR2"
Expression="SELECTFLAG"
SQLType="VARCHAR" >

Name="ObjectId"
IsQueriable="false"
IsPersistent="false"
Precision="15"
Scale="0"
Type="oracle.jbo.domain.Number"
AliasName="OBJECT_ID"
ColumnType="NUMBER"
Expression="OBJECT_ID"
SQLType="NUMERIC" >

Name="ObjectType"
IsQueriable="false"
IsPersistent="false"
Precision="30"
Type="java.lang.String"
AliasName="OBJECT_TYPE"
ColumnType="VARCHAR2"
Expression="OBJECT_TYPE"
SQLType="VARCHAR" >




Name="Location"
IsQueriable="false"
IsPersistent="false"
Precision="240"
Type="java.lang.String"
AliasName="LOCATION"
ColumnType="VARCHAR2"
Expression="LOCATION"
SQLType="VARCHAR" >




Name="DistanceToLocationInt"
IsQueriable="false"
IsPersistent="false"
Precision="30"
Type="java.lang.String"
AliasName="DISTANCE_TO_LOCATION"
ColumnType="VARCHAR2"
Expression="DISTANCE_TO_LOCATION"
SQLType="VARCHAR" >




Name="Employee"
IsQueriable="false"
IsPersistent="false"
Precision="30"
Type="java.lang.String"
AliasName="EMPLOYEE"
ColumnType="VARCHAR2"
Expression="EMPLOYEE"
SQLType="VARCHAR" >




Name="Contractor"
IsQueriable="false"
IsPersistent="false"
Precision="30"
Type="java.lang.String"
AliasName="CONTRACTOR"
ColumnType="VARCHAR2"
Expression="CONTRACTOR"
SQLType="VARCHAR" >




Name="EmploymentCategory"
IsQueriable="false"
IsPersistent="false"
Precision="30"
Type="java.lang.String"
AliasName="EMPLOYMENT_CATEGORY"
ColumnType="VARCHAR2"
Expression="EMPLOYMENT_CATEGORY"
SQLType="VARCHAR" >




Name="Keywords"
IsQueriable="false"
IsPersistent="false"
Precision="2000"
Type="java.lang.String"
AliasName="KEYWORDS"
ColumnType="VARCHAR2"
Expression="KEYWORDS"
SQLType="VARCHAR" >




Name="TravelPercentage"
IsQueriable="false"
IsPersistent="false"
Type="oracle.jbo.domain.Number"
AliasName="TRAVEL_PERCENTAGE"
ColumnType="NUMBER"
Expression="TRAVEL_PERCENTAGE"
SQLType="NUMERIC" >

Name="MaxSalary"
IsQueriable="false"
IsPersistent="false"
Type="oracle.jbo.domain.Number"
AliasName="MAX_SALARY"
ColumnType="NUMBER"
Expression="MAX_SALARY"
SQLType="NUMERIC" >

Name="MinSalary"
IsQueriable="false"
IsPersistent="false"
Type="oracle.jbo.domain.Number"
AliasName="MIN_SALARY"
ColumnType="NUMBER"
Expression="MIN_SALARY"
SQLType="NUMERIC" >

Name="SalaryCurrency"
IsQueriable="false"
IsPersistent="false"
Precision="30"
Type="java.lang.String"
AliasName="SALARY_CURRENCY"
ColumnType="VARCHAR2"
Expression="SALARY_CURRENCY"
SQLType="VARCHAR" >




Name="MatchCompetence"
IsQueriable="false"
IsPersistent="false"
Precision="30"
Type="java.lang.String"
AliasName="MATCH_COMPETENCE"
ColumnType="VARCHAR2"
Expression="MATCH_COMPETENCE"
SQLType="VARCHAR" >




Name="JobTitle"
IsQueriable="false"
IsPersistent="false"
Precision="240"
Type="java.lang.String"
AliasName="JOB_TITLE"
ColumnType="VARCHAR2"
Expression="JOB_TITLE"
SQLType="VARCHAR" >




Name="Department"
IsQueriable="false"
IsPersistent="false"
Precision="240"
Type="java.lang.String"
AliasName="DEPARTMENT"
ColumnType="VARCHAR2"
Expression="DEPARTMENT"
SQLType="VARCHAR" >




Name="ProfessionalArea"
IsQueriable="false"
IsPersistent="false"
Precision="30"
Type="java.lang.String"
AliasName="PROFESSIONAL_AREA"
ColumnType="VARCHAR2"
Expression="PROFESSIONAL_AREA"
SQLType="VARCHAR" >




Name="WorkAtHome"
IsQueriable="false"
IsPersistent="false"
Precision="30"
Type="java.lang.String"
AliasName="WORK_AT_HOME"
ColumnType="VARCHAR2"
Expression="WORK_AT_HOME"
SQLType="VARCHAR" >




Name="UseForMatching"
IsQueriable="false"
IsPersistent="false"
Precision="30"
Type="java.lang.String"
AliasName="USE_FOR_MATCHING"
ColumnType="VARCHAR2"
Expression="USE_FOR_MATCHING"
SQLType="VARCHAR" >




Name="AttributeCategory"
IsQueriable="false"
IsPersistent="false"
Precision="30"
Type="java.lang.String"
AliasName="ATTRIBUTE_CATEGORY"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE_CATEGORY"
SQLType="VARCHAR" >




Name="Attribute1"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE1"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE1"
SQLType="VARCHAR" >




Name="Attribute2"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE2"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE2"
SQLType="VARCHAR" >




Name="Attribute3"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE3"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE3"
SQLType="VARCHAR" >




Name="Attribute4"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE4"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE4"
SQLType="VARCHAR" >




Name="Attribute5"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE5"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE5"
SQLType="VARCHAR" >




Name="Attribute6"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE6"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE6"
SQLType="VARCHAR" >




Name="Attribute7"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE7"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE7"
SQLType="VARCHAR" >




Name="Attribute8"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE8"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE8"
SQLType="VARCHAR" >




Name="Attribute9"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE9"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE9"
SQLType="VARCHAR" >




Name="Attribute10"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE10"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE10"
SQLType="VARCHAR" >




Name="Attribute11"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE11"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE11"
SQLType="VARCHAR" >




Name="Attribute12"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE12"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE12"
SQLType="VARCHAR" >




Name="Attribute13"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE13"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE13"
SQLType="VARCHAR" >




Name="Attribute14"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE14"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE14"
SQLType="VARCHAR" >




Name="Attribute15"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE15"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE15"
SQLType="VARCHAR" >




Name="Attribute16"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE16"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE16"
SQLType="VARCHAR" >




Name="Attribute17"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE17"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE17"
SQLType="VARCHAR" >




Name="Attribute18"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE18"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE18"
SQLType="VARCHAR" >




Name="Attribute19"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE19"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE19"
SQLType="VARCHAR" >




Name="Attribute20"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ATTRIBUTE20"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE20"
SQLType="VARCHAR" >




Name="Attribute21"
IsQueriable="false"
IsPersistent="false"
Precision="240"
Type="java.lang.String"
AliasName="ATTRIBUTE21"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE21"
SQLType="VARCHAR" >




Name="Attribute22"
IsQueriable="false"
IsPersistent="false"
Precision="240"
Type="java.lang.String"
AliasName="ATTRIBUTE22"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE22"
SQLType="VARCHAR" >




Name="Attribute23"
IsQueriable="false"
IsPersistent="false"
Precision="240"
Type="java.lang.String"
AliasName="ATTRIBUTE23"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE23"
SQLType="VARCHAR" >




Name="Attribute24"
IsQueriable="false"
IsPersistent="false"
Precision="240"
Type="java.lang.String"
AliasName="ATTRIBUTE24"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE24"
SQLType="VARCHAR" >




Name="Attribute25"
IsQueriable="false"
IsPersistent="false"
Precision="240"
Type="java.lang.String"
AliasName="ATTRIBUTE25"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE25"
SQLType="VARCHAR" >




Name="Attribute26"
IsQueriable="false"
IsPersistent="false"
Precision="240"
Type="java.lang.String"
AliasName="ATTRIBUTE26"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE26"
SQLType="VARCHAR" >




Name="Attribute27"
IsQueriable="false"
IsPersistent="false"
Precision="240"
Type="java.lang.String"
AliasName="ATTRIBUTE27"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE27"
SQLType="VARCHAR" >




Name="Attribute28"
IsQueriable="false"
IsPersistent="false"
Precision="240"
Type="java.lang.String"
AliasName="ATTRIBUTE28"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE28"
SQLType="VARCHAR" >




Name="Attribute29"
IsQueriable="false"
IsPersistent="false"
Precision="240"
Type="java.lang.String"
AliasName="ATTRIBUTE29"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE29"
SQLType="VARCHAR" >




Name="Attribute30"
IsQueriable="false"
IsPersistent="false"
Precision="240"
Type="java.lang.String"
AliasName="ATTRIBUTE30"
ColumnType="VARCHAR2"
Expression="ATTRIBUTE30"
SQLType="VARCHAR" >




Name="IscInformationCategory"
IsQueriable="false"
IsPersistent="false"
Precision="30"
Type="java.lang.String"
AliasName="ISC_INFORMATION_CATEGORY"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION_CATEGORY"
SQLType="VARCHAR" >




Name="IscInformation1"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION1"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION1"
SQLType="VARCHAR" >




Name="IscInformation2"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION2"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION2"
SQLType="VARCHAR" >




Name="IscInformation3"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION3"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION3"
SQLType="VARCHAR" >




Name="IscInformation4"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION4"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION4"
SQLType="VARCHAR" >




Name="IscInformation5"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION5"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION5"
SQLType="VARCHAR" >




Name="IscInformation6"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION6"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION6"
SQLType="VARCHAR" >




Name="IscInformation7"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION7"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION7"
SQLType="VARCHAR" >




Name="IscInformation8"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION8"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION8"
SQLType="VARCHAR" >




Name="IscInformation9"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION9"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION9"
SQLType="VARCHAR" >




Name="IscInformation10"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION10"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION10"
SQLType="VARCHAR" >




Name="IscInformation11"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION11"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION11"
SQLType="VARCHAR" >




Name="IscInformation12"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION12"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION12"
SQLType="VARCHAR" >




Name="IscInformation13"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION13"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION13"
SQLType="VARCHAR" >




Name="IscInformation14"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION14"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION14"
SQLType="VARCHAR" >




Name="IscInformation15"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION15"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION15"
SQLType="VARCHAR" >




Name="IscInformation16"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION16"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION16"
SQLType="VARCHAR" >




Name="IscInformation17"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION17"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION17"
SQLType="VARCHAR" >




Name="IscInformation18"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION18"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION18"
SQLType="VARCHAR" >




Name="IscInformation19"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION19"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION19"
SQLType="VARCHAR" >




Name="IscInformation20"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION20"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION20"
SQLType="VARCHAR" >




Name="IscInformation21"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION21"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION21"
SQLType="VARCHAR" >




Name="IscInformation22"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION22"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION22"
SQLType="VARCHAR" >




Name="IscInformation23"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION23"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION23"
SQLType="VARCHAR" >




Name="IscInformation24"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION24"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION24"
SQLType="VARCHAR" >




Name="IscInformation25"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION25"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION25"
SQLType="VARCHAR" >




Name="IscInformation26"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION26"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION26"
SQLType="VARCHAR" >




Name="IscInformation27"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION27"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION27"
SQLType="VARCHAR" >




Name="IscInformation28"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION28"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION28"
SQLType="VARCHAR" >




Name="IscInformation29"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION29"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION29"
SQLType="VARCHAR" >




Name="IscInformation30"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="ISC_INFORMATION30"
ColumnType="VARCHAR2"
Expression="ISC_INFORMATION30"
SQLType="VARCHAR" >




Name="ApplicantType"
IsQueriable="false"
IsPersistent="false"
Type="java.lang.String"
AliasName="APPLICANT_TYPE"
ColumnType="$none$"
SQLType="VARCHAR" >

Name="EmployeeType"
IsQueriable="false"
IsPersistent="false"
Type="java.lang.String"
AliasName="EMPLOYEE_TYPE"
ColumnType="$none$"
SQLType="VARCHAR" >

Name="MinQualification"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
AliasName="MIN_QUALIFICATION"
ColumnType="VARCHAR2"
Expression="to_char(MIN_QUAL_LEVEL)"
SQLType="VARCHAR" >

Name="MaxQualification"
IsQueriable="false"
IsPersistent="false"
Precision="9"
Scale="0"
Type="java.lang.String"
AliasName="MAX_QUALIFICATION"
ColumnType="VARCHAR2"
Expression="to_char(MAX_QUAL_LEVEL)"
SQLType="VARCHAR" >

Name="Consideration"
IsQueriable="false"
IsPersistent="false"
Type="java.lang.String"
AliasName="CONSIDERATION"
ColumnType="$none$"
SQLType="VARCHAR" >

Name="CandidateName"
IsQueriable="false"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
AliasName="CANDIDATE_NAME"
ColumnType="VARCHAR2"
SQLType="VARCHAR" >

Name="FirstName"
IsQueriable="false"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
AliasName="FIRST_NAME"
ColumnType="VARCHAR2"
SQLType="VARCHAR" >

Name="LastName"
IsQueriable="false"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
AliasName="LAST_NAME"
ColumnType="VARCHAR2"
SQLType="VARCHAR" >

Name="Email"
IsQueriable="false"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
AliasName="EMAIL"
ColumnType="VARCHAR2"
SQLType="VARCHAR" >

Name="SearchLocation"
IsQueriable="false"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
AliasName="SEARCH_LOCATION"
ColumnType="VARCHAR2"
SQLType="VARCHAR" >

Name="HomePhone"
IsQueriable="false"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
AliasName="HOME_PHONE"
ColumnType="VARCHAR2"
SQLType="VARCHAR" >

Name="BirthDate"
IsQueriable="false"
IsPersistent="false"
Type="oracle.jbo.domain.Date"
AliasName="BIRTH_DATE"
ColumnType="DATE"
SQLType="DATE" >

Name="AgencyId"
IsPersistent="false"
Type="oracle.jbo.domain.Number"
AliasName="AGENCY_ID"
ColumnType="NUMBER"
SQLType="NUMERIC" >

Name="ExcludeAgencyCands"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
AliasName="VIEW_ATTR"
ColumnType="VARCHAR2"
SQLType="VARCHAR" >

Name="GeocodeLocation"
IsQueriable="false"
IsPersistent="false"
Precision="240"
Type="java.lang.String"
AliasName="VIEW_ATTR"
ColumnType="VARCHAR2"
SQLType="VARCHAR" >

Name="GeocodePoplistLocation"
IsQueriable="false"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
AliasName="VIEW_ATTR"
ColumnType="VARCHAR2"
SQLType="VARCHAR" >

Name="GeocodeCountry"
IsQueriable="false"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
AliasName="VIEW_ATTR"
ColumnType="VARCHAR2"
SQLType="VARCHAR" >

Name="OldGeocodeLocation"
IsQueriable="false"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
AliasName="VIEW_ATTR"
ColumnType="VARCHAR2"
SQLType="VARCHAR" >

Name="Latitude"
IsQueriable="false"
IsPersistent="false"
Type="oracle.jbo.domain.Number"
AliasName="VIEW_ATTR"
ColumnType="NUMBER"
SQLType="NUMERIC" >

Name="Longitude"
IsQueriable="false"
IsPersistent="false"
Type="oracle.jbo.domain.Number"
AliasName="VIEW_ATTR"
ColumnType="NUMBER"
SQLType="NUMERIC" >

Name="DistanceToLocation"
IsPersistent="false"
Type="oracle.jbo.domain.Number"
AliasName="DISTANCE_TO_LOCATION_INT"
ColumnType="Number"
Expression="fnd_number.canonical_to_number(distance_to_location)"
SQLType="NUMERIC" >

Name="TestStatus"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
AliasName="TEST_STATUS"
ColumnType="VARCHAR2"
SQLType="VARCHAR" >

Name="Referred"
IsSelected="false"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
ColumnType="VARCHAR2"
AliasName="REFERRED"
SQLType="VARCHAR" >

* *Name="PPFAttribute15"*
*IsSelected="false"*
*IsPersistent="false"*
*Precision="255"*
*Type="java.lang.String"*
*ColumnType="VARCHAR2"*
*AliasName="PPFATTRIBUTE15"*
* SQLType="VARCHAR" >*
**






2) CandidateListVO - XML is given below ..this VO is used in the search result set region




Name="CandidateListVO"
SelectList="NULL AS SelectFlag, PPF.FULL_NAME AS PERSON_NAME, ADDR.DERIVED_LOCALE, ADDR.ADDRESS_ID,PHN.PHONE_NUMBER, PHN.PHONE_ID, PPF.DATE_OF_BIRTH, PPF.EMAIL_ADDRESS, ADDR.ADDRESS_LINE1, to_number( decode ( :1 , 1, IRC_SKILLS_MATCHING_PKG.vacancy_match_percent(
ppf.person_id, :2 , :3 ), 2, IRC_SKILLS_MATCHING_PKG.skills_match_percent(:4 , :5 , :6 , :7 , :8 , :9 , ppf.person_id),-1) ) AS Match_Percent, decode(irc_utilities_pkg.is_open_party(PPF.PARTY_ID,:10),'TRUE',(select count(*) from PER_ALL_ASSIGNMENTS_F PAF2 , PER_ALL_PEOPLE_F PPF2 where PPF.PARTY_ID = PPF2.PARTY_ID and :11 between PPF2.EFFECTIVE_START_DATE and PPF2.EFFECTIVE_END_DATE and PAF2.ASSIGNMENT_TYPE = 'A' and :12 between PAF2.effective_start_date and PAF2.effective_end_date and PAF2.person_id = PPF2.person_id having count(*)>0),null) AS Jobs_Applied_For, decode(irc_utilities_pkg.is_open_party(PPF.PARTY_ID,:13),'TRUE',(select MAX(PAF.effective_start_date) from PER_ALL_ASSIGNMENTS_F PAF, PER_ALL_PEOPLE_F PPF2 where PPF.PARTY_ID = PPF2.PARTY_ID AND :14 between PPF2.EFFECTIVE_START_DATE AND PPF2.EFFECTIVE_END_DATE AND PAF.ASSIGNMENT_TYPE = 'A' and :15 >= PAF.effective_start_date AND PAF.person_id = PPF2.person_id),null) AS Last_Application, VCN.CONSIDERATION_STATUS, VCN.PERSON_ID AS CONSIDERATION_PERSON_ID, VCN.VACANCY_ID AS CONSIDERATION_VACANCY_ID, to_number(:16) AS VACANCY_ID, (select meaning from HR_LOOKUPS LKP where LKP.LOOKUP_TYPE= 'IRC_CONSIDERATION' AND LKP.LOOKUP_CODE = VCN.consideration_status) AS CONSIDERATION, VCN.CONSIDERATION_STATUS AS CONSIDERATION_STATUS_DISPLAY, PPF.FIRST_NAME AS PERSON_FIRST_NAME, PPF.LAST_NAME AS PERSON_LAST_NAME, DOC.DOCUMENT_ID, DOC.FILE_NAME, NVL2( DOC.DOCUMENT_ID,'Y','N') AS PreviewEnabled, VCN.VACANCY_CONSIDERATION_ID, INP.NOTIFICATION_PREFERENCE_ID, PPF.PERSON_ID, PPF.EFFECTIVE_START_DATE, PPF.EFFECTIVE_END_DATE,
PPF.ATTRIBUTE1 AS PPFATTRIBUTE1, PPF.ATTRIBUTE2 AS PPFATTRIBUTE2 ,PPF.ATTRIBUTE3 AS PPFATTRIBUTE3, PPF.ATTRIBUTE4 AS PPFATTRIBUTE4, PPF.ATTRIBUTE5 AS PPFATTRIBUTE5, PPF.ATTRIBUTE6 AS PPFATTRIBUTE6, PPF.ATTRIBUTE7 AS PPFATTRIBUTE7, PPF.ATTRIBUTE8 AS PPFATTRIBUTE8, PPF.ATTRIBUTE9 AS PPFATTRIBUTE9, PPF.ATTRIBUTE10 AS PPFATTRIBUTE10, PPF.ATTRIBUTE11 AS PPFATTRIBUTE11, PPF.ATTRIBUTE12 AS PPFATTRIBUTE12, PPF.ATTRIBUTE13 AS PPFATTRIBUTE13, PPF.ATTRIBUTE14 AS PPFATTRIBUTE14, PPF.ATTRIBUTE15 AS PPFATTRIBUTE15, PPF.ATTRIBUTE16 AS PPFATTRIBUTE16, PPF.ATTRIBUTE17 AS PPFATTRIBUTE17, PPF.ATTRIBUTE18 AS PPFATTRIBUTE18, PPF.ATTRIBUTE19 AS PPFATTRIBUTE19, PPF.ATTRIBUTE20 AS PPFATTRIBUTE20, PPF.ATTRIBUTE21 AS PPFATTRIBUTE21, PPF.ATTRIBUTE22 AS PPFATTRIBUTE22, PPF.ATTRIBUTE23 AS PPFATTRIBUTE23, PPF.ATTRIBUTE24 AS PPFATTRIBUTE24, PPF.ATTRIBUTE25 AS PPFATTRIBUTE25, PPF.ATTRIBUTE26 AS PPFATTRIBUTE26, PPF.ATTRIBUTE27 AS PPFATTRIBUTE27, PPF.ATTRIBUTE28 AS PPFATTRIBUTE28, PPF.ATTRIBUTE29 AS PPFATTRIBUTE29, PPF.ATTRIBUTE30 AS PPFATTRIBUTE30, PPF.ATTRIBUTE_CATEGORY AS PPFATTRIBUTE_CATEGORY, VCN.PERSON_ID AS PERSON_ID1, CSC.SEARCH_CRITERIA_ID, CSC.LOCATION, CSC.DISTANCE_TO_LOCATION, CSC.EMPLOYEE, CSC.CONTRACTOR, CSC.EMPLOYMENT_CATEGORY, CSC.KEYWORDS, CSC.TRAVEL_PERCENTAGE, CSC.MIN_SALARY, CSC.SALARY_CURRENCY, CSC.SALARY_PERIOD, CSC.MATCH_COMPETENCE, CSC.MATCH_QUALIFICATION, CSC.JOB_TITLE, CSC.DEPARTMENT, CSC.PROFESSIONAL_AREA, CSC.WORK_AT_HOME, CSC.ATTRIBUTE_CATEGORY, CSC.ATTRIBUTE1, CSC.ATTRIBUTE2, CSC.ATTRIBUTE3, CSC.ATTRIBUTE4, CSC.ATTRIBUTE5, CSC.ATTRIBUTE6, CSC.ATTRIBUTE7,CSC.ATTRIBUTE8, CSC.ATTRIBUTE9, CSC.ATTRIBUTE10, CSC.ATTRIBUTE11, CSC.ATTRIBUTE12, CSC.ATTRIBUTE13, CSC.ATTRIBUTE14, CSC.ATTRIBUTE15, CSC.ATTRIBUTE16, CSC.ATTRIBUTE17, CSC.ATTRIBUTE18, CSC.ATTRIBUTE19, CSC.ATTRIBUTE20, CSC.ATTRIBUTE21, CSC.ATTRIBUTE22, CSC.ATTRIBUTE23, CSC.ATTRIBUTE24, CSC.ATTRIBUTE25, CSC.ATTRIBUTE26, CSC.ATTRIBUTE27, CSC.ATTRIBUTE28, CSC.ATTRIBUTE29, CSC.ATTRIBUTE30, to_char(RowNum) AS RowNumber, PPF.PARTY_ID, POV.VENDOR_ID, POV.VENDOR_NAME, INP.CREATION_DATE, to_char(decode(:17,'Y',nvl2(ADDR.geometry,floor(irc_location_utility.sdo_miles(mdsys.sdo_geometry(2001,8307,mdsys.sdo_point_type(:18,:19,null),null,null),ADDR.geometry,0.01)),''),'')) AS DISTANCE_TO_LOCATION_RESULTS, fnd_number.canonical_to_number(distance_to_location) AS DISTANCE_TO_LOCATION_INT, nvl2(ATMPT.MASTERY_SCORE,decode(greatest(ATMPT.MASTERY_SCORE,ATMPT.RAW_SCORE), ATMPT.RAW_SCORE, 'P', 'F'),nvl2(FND_PROFILE.VALUE('IRC_REGISTER_TEST'),nvl2(INP.ATTEMPT_ID, 'A','N'),null)) AS ATTEMPT_STATUS, to_number(decode(ATMPT.RAW_SCORE, -1000, null, ATMPT.RAW_SCORE)) AS ATTEMPT_SCORE, ATMPT.ATTEMPT_ID, decode(IrcReferralInfoEO.source_type,'ER','Y','N') AS Referred, IrcReferralInfoEO.START_DATE, IrcReferralInfoEO.OBJECT_ID, IrcReferralInfoEO.OBJECT_TYPE, IrcReferralInfoEO.END_DATE, (select meaning from hr_lookups where lookup_code = IRCREFERRALINFOEO.source_type and lookup_type = 'REC_TYPE') AS SourceType, decode (IrcReferralInfoEO.source_type, 'ER',(select distinct(full_name) from per_all_people_f where person_id = IrcReferralInfoEO.source_person_id), IrcReferralInfoEO.source_name ) AS SourceName"
FromList="PER_ADDRESSES ADDR, PER_PHONES PHN, IRC_VACANCY_CONSIDERATIONS VCN, IRC_NOTIFICATION_PREFERENCES INP, IRC_DOCUMENTS DOC, PER_ALL_PEOPLE_F PPF, IRC_SEARCH_CRITERIA CSC, PO_VENDORS POV, OTA_ATTEMPTS ATMPT, IRC_REFERRAL_INFO IrcReferralInfoEO"
Where=":20 BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE AND PPF.PERSON_ID = DOC.PERSON_ID(+) AND PPF.PERSON_ID = PHN.PARENT_ID(+) AND PHN.PARENT_TABLE(+) = 'PER_ALL_PEOPLE_F' AND PHN.phone_type(+) = 'H1' AND :21 between nvl(PHN.date_from,:22) and NVL(PHN.date_to,:23) AND PPF.PERSON_ID = VCN.PERSON_ID(+) AND VCN.VACANCY_ID(+) = :24 AND nvl(VCN.consideration_status,'X') <> 'NO' and PPF.PERSON_ID = INP.PERSON_ID AND INP.PERSON_ID = ADDR.PERSON_ID(+) AND NVL(INP.ADDRESS_ID, DECODE(ADDR.ADDRESS_TYPE(+),'REC',ADDR.ADDRESS_ID(+),-1)) = addr.ADDRESS_ID(+) AND :25 between ADDR.DATE_FROM(+) and nvl(ADDR.DATE_TO(+),:26) AND doc.type(+) like '%RESUME' AND doc.end_date(+) is null AND CSC.object_id = PPF.PERSON_ID AND CSC.object_type= 'WPREF' AND EXISTS (SELECT NULL FROM PER_PEOPLE_F PPFS WHERE PPFS.PERSON_ID = PPF.PERSON_ID) and ((INP.AGENCY_ID = FND_PROFILE.VALUE('IRC_AGENCY_NAME')) or (FND_PROFILE.VALUE('IRC_AGENCY_NAME') is null and INP.ALLOW_ACCESS='Y')) and INP.AGENCY_ID = POV.VENDOR_ID(+) and INP.ATTEMPT_ID = ATMPT.ATTEMPT_ID(+) and ppf.party_id = IrcReferralInfoEO.object_id(+) and sysdate between IrcReferralInfoEO.start_date(+) and IrcReferralInfoEO.end_date(+)"
QueryHint="FIRST_ROWS"
BindingStyle="Oracle"
CustomQuery="false"
RowClass="oracle.apps.irc.candidateSearch.server.CandidateListVORowImpl"
ComponentClass="oracle.apps.irc.candidateSearch.server.CandidateListVOImpl"
FetchMode="FETCH_AS_NEEDED"
Passivate="All"
UseGlueCode="false" >







Name="ADDR"
Entity="oracle.apps.per.schema.server.PerAddressesEO"
ReadOnly="true" >











Name="PHN"
Entity="oracle.apps.per.schema.server.PerPhonesEO"
SourceUsage="oracle.apps.irc.candidateSearch.server.CandidateListVO.ADDR"
ReadOnly="true"
Reference="true" >














Name="VCN"
Entity="oracle.apps.irc.schema.server.IrcVacancyConsiderationsEO"
Association="oracle.apps.irc.schema.server.IrcVacancyConsiderationsHZPersonProfilesEA"
AssociationEnd="oracle.apps.irc.schema.server.IrcVacancyConsiderationsHZPersonProfilesEA.IrcVacancyConsiderationsEO"
SourceUsage="oracle.apps.irc.candidateSearch.server.CandidateListVO.PHN"
ReadOnly="true"
Reference="true" >










Name="INP"
Entity="oracle.apps.irc.schema.server.IrcNotificationPreferencesEO"
SourceUsage="oracle.apps.irc.candidateSearch.server.CandidateListVO.VCN"
ReadOnly="true"
Reference="true" >














Name="DOC"
Entity="oracle.apps.irc.schema.server.IrcDocumentsEO"
Association="oracle.apps.irc.schema.server.IrcDocumentsHZPersonProfilesEA"
AssociationEnd="oracle.apps.irc.schema.server.IrcDocumentsHZPersonProfilesEA.IrcDocumentsEO"
SourceUsage="oracle.apps.irc.candidateSearch.server.CandidateListVO.VCN"
ReadOnly="true"
Reference="true" >










Name="PPF"
Entity="oracle.apps.per.schema.server.PerAllPeopleFEO"
Association="oracle.apps.per.schema.server.PerPhonesPerAllPeopleFEA"
AssociationEnd="oracle.apps.per.schema.server.PerPhonesPerAllPeopleFEA.PerAllPeopleFEO"
SourceUsage="oracle.apps.irc.candidateSearch.server.CandidateListVO.ADDR"
ReadOnly="true" >










Name="CSC"
Entity="oracle.apps.irc.schema.server.IrcCandidateSearchCriteriaEO"
SourceUsage="oracle.apps.irc.candidateSearch.server.CandidateListVO.PPF"
ReadOnly="true"
Reference="true" >




Name="POV"
Entity="oracle.apps.per.schema.server.PoVendorsEO"
SourceUsage="oracle.apps.irc.candidateSearch.server.CandidateListVO.CSC"
ReadOnly="true"
Reference="true" >














Name="ATMPT"
Entity="oracle.apps.ota.schema.server.AttemptEO"
SourceUsage="oracle.apps.irc.candidateSearch.server.CandidateListVO.POV"
ReadOnly="true" >





Name="IrcReferralInfoEO"
Entity="oracle.apps.irc.schema.server.IrcReferralInfoEO"
SourceUsage="oracle.apps.irc.candidateSearch.server.CandidateListVO.ATMPT"
ReadOnly="true"
Reference="true" >














Name="SelectFlag"
IsQueriable="false"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
ColumnType="VARCHAR2"
AliasName="SelectFlag"
Expression="NULL"
SQLType="VARCHAR" >

Name="PersonName"
EntityAttrName="FullName"
EntityUsage="PPF"
AliasName="PERSON_NAME" >

Name="DerivedLocale"
IsUpdateable="false"
EntityAttrName="DerivedLocale"
EntityUsage="ADDR"
AliasName="DERIVED_LOCALE" >

Name="AddressId"
IsUpdateable="false"
IsNotNull="true"
EntityAttrName="AddressId"
EntityUsage="ADDR"
AliasName="ADDRESS_ID" >

Name="PhoneNumber"
IsUpdateable="false"
EntityAttrName="PhoneNumber"
EntityUsage="PHN"
AliasName="PHONE_NUMBER" >

Name="PhoneId"
IsUpdateable="false"
EntityAttrName="PhoneId"
EntityUsage="PHN"
AliasName="PHONE_ID" >

Name="DateOfBirth"
EntityAttrName="DateOfBirth"
EntityUsage="PPF"
AliasName="DATE_OF_BIRTH" >

Name="EmailAddress"
EntityAttrName="EmailAddress"
EntityUsage="PPF"
AliasName="EMAIL_ADDRESS" >

Name="AddressLine1"
IsUpdateable="false"
EntityAttrName="AddressLine1"
EntityUsage="ADDR"
AliasName="ADDRESS_LINE1" >

Name="MatchPercent"
IsUpdateable="false"
IsQueriable="false"
IsPersistent="false"
Type="oracle.jbo.domain.Number"
ColumnType="NUMBER"
AliasName="Match_Percent"
Expression="to_number( decode ( :1 , 1, IRC_SKILLS_MATCHING_PKG.vacancy_match_percent( ppf.person_id, :2 , :3 ), 2, IRC_SKILLS_MATCHING_PKG.skills_match_percent( :4 , :5 , :6 , :7 , :8 , :9 , ppf.person_id),-1) )"
SQLType="NUMERIC" >

Name="JobsAppliedFor"
IsUpdateable="false"
IsQueriable="false"
IsPersistent="false"
Type="oracle.jbo.domain.Number"
ColumnType="NUMBER"
AliasName="Jobs_Applied_For"
Expression="decode(irc_utilities_pkg.is_open_party(PPF.PARTY_ID,:10),'TRUE',(select count(*)
from PER_ALL_ASSIGNMENTS_F PAF2, PER_ALL_PEOPLE_F PPF2 where PPF.PARTY_ID = PPF2.PARTY_ID
and :11 between PPF2.EFFECTIVE_START_DATE and PPF2.EFFECTIVE_END_DATE
and PAF2.ASSIGNMENT_TYPE ='A'
and :12 between PAF2.effective_start_date and PAF2.effective_end_date
and PAF2.person_id = PPF2.person_id
having count(*)>0),null)"
SQLType="NUMERIC" >

Name="LastApplication"
IsUpdateable="false"
IsQueriable="false"
IsPersistent="false"
Type="oracle.jbo.domain.Date"
ColumnType="DATE"
AliasName="Last_Application"
Expression="decode(irc_utilities_pkg.is_open_party(PPF.PARTY_ID,:13),'TRUE',(select
MAX(PAF.effective_start_date)
from PER_ALL_ASSIGNMENTS_F PAF, PER_ALL_PEOPLE_F PPF2
where PPF.PARTY_ID = PPF2.PARTY_ID
AND :14 between PPF2.EFFECTIVE_START_DATE AND PPF2.EFFECTIVE_END_DATE
AND PAF.ASSIGNMENT_TYPE = 'A'
and :15 >= PAF.effective_start_date
AND PAF.person_id = PPF2.person_id),null)"
SQLType="DATE" >

Name="ConsiderationStatus"
IsUpdateable="false"
EntityAttrName="ConsiderationStatus"
EntityUsage="VCN"
AliasName="CONSIDERATION_STATUS"
Passivate="true" >

Name="ConsiderationPersonId"
EntityAttrName="PersonId"
EntityUsage="VCN"
AliasName="CONSIDERATION_PERSON_ID"
Passivate="true" >

Name="ConsiderationVacancyId"
IsUpdateable="false"
EntityAttrName="VacancyId"
EntityUsage="VCN"
AliasName="CONSIDERATION_VACANCY_ID"
Passivate="true" >

Name="VacancyId"
IsQueriable="false"
IsPersistent="false"
Type="oracle.jbo.domain.Number"
ColumnType="NUMBER"
AliasName="VACANCY_ID"
Expression="to_number(:16)"
SQLType="NUMERIC" >

Name="Consideration"
IsPersistent="false"
Precision="80"
Type="java.lang.String"
ColumnType="VARCHAR2"
AliasName="CONSIDERATION"
Expression="(select meaning from HR_LOOKUPS LKP where LKP.LOOKUP_TYPE = 'IRC_CONSIDERATION' AND LKP.LOOKUP_CODE = VCN.consideration_status)"
SQLType="VARCHAR" >

Name="ConsiderationStatusDisplay"
IsQueriable="false"
IsPersistent="false"
Precision="30"
Type="java.lang.String"
ColumnType="VARCHAR2"
AliasName="CONSIDERATION_STATUS_DISPLAY"
Expression="VCN.CONSIDERATION_STATUS"
SQLType="VARCHAR" >




Name="PersonFirstName"
EntityAttrName="FirstName"
EntityUsage="PPF"
AliasName="PERSON_FIRST_NAME"
Passivate="true" >

Name="PersonLastName"
EntityAttrName="LastName"
EntityUsage="PPF"
AliasName="PERSON_LAST_NAME"
Passivate="true" >

Name="DocumentId"
IsNotNull="true"
EntityAttrName="DocumentId"
EntityUsage="DOC"
AliasName="DOCUMENT_ID"
Passivate="true" >

Name="FileName"
EntityAttrName="FileName"
EntityUsage="DOC"
AliasName="FILE_NAME"
Passivate="true" >

Name="PreviewEnabled"
IsUpdateable="false"
IsQueriable="false"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
ColumnType="VARCHAR2"
AliasName="PreviewEnabled"
Expression="NVL2( DOC.DOCUMENT_ID,'Y','N')"
SQLType="VARCHAR" >

Name="VacancyConsiderationId"
IsNotNull="true"
EntityAttrName="VacancyConsiderationId"
EntityUsage="VCN"
AliasName="VACANCY_CONSIDERATION_ID"
Passivate="true" >

Name="NotificationPreferenceId"
IsNotNull="true"
EntityAttrName="NotificationPreferenceId"
EntityUsage="INP"
AliasName="NOTIFICATION_PREFERENCE_ID"
Passivate="true" >

Name="PersonId"
EntityAttrName="PersonId"
EntityUsage="PPF"
AliasName="PERSON_ID"
Passivate="true" >

Name="EffectiveStartDate"
EntityAttrName="EffectiveStartDate"
EntityUsage="PPF"
AliasName="EFFECTIVE_START_DATE"
Passivate="true" >

Name="EffectiveEndDate"
EntityAttrName="EffectiveEndDate"
EntityUsage="PPF"
AliasName="EFFECTIVE_END_DATE"
Passivate="true" >

Name="PPFAttribute1"
EntityAttrName="Attribute1"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE1"
Passivate="true" >

Name="PPFAttribute2"
EntityAttrName="Attribute2"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE2"
Passivate="true" >

Name="PPFAttribute3"
EntityAttrName="Attribute3"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE3"
Passivate="true" >

Name="PPFAttribute4"
EntityAttrName="Attribute4"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE4"
Passivate="true" >

Name="PPFAttribute5"
EntityAttrName="Attribute5"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE5"
Passivate="true" >

Name="PPFAttribute6"
EntityAttrName="Attribute6"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE6"
Passivate="true" >

Name="PPFAttribute7"
EntityAttrName="Attribute7"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE7" >

Name="PPFAttribute8"
EntityAttrName="Attribute8"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE8" >

Name="PPFAttribute9"
EntityAttrName="Attribute9"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE9" >

Name="PPFAttribute10"
EntityAttrName="Attribute10"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE10" >

Name="PPFAttribute11"
EntityAttrName="Attribute11"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE11" >

Name="PPFAttribute12"
EntityAttrName="Attribute12"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE12" >

Name="PPFAttribute13"
EntityAttrName="Attribute13"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE13" >

Name="PPFAttribute14"
EntityAttrName="Attribute14"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE14" >

Name="PPFAttribute15"
EntityAttrName="Attribute15"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE15" >

Name="PPFAttribute16"
EntityAttrName="Attribute16"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE16" >

Name="PPFAttribute17"
EntityAttrName="Attribute17"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE17" >

Name="PPFAttribute18"
EntityAttrName="Attribute18"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE18" >

Name="PPFAttribute19"
EntityAttrName="Attribute19"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE19" >

Name="PPFAttribute20"
EntityAttrName="Attribute20"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE20" >

Name="PPFAttribute21"
EntityAttrName="Attribute21"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE21" >

Name="PPFAttribute22"
EntityAttrName="Attribute22"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE22" >

Name="PPFAttribute23"
EntityAttrName="Attribute23"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE23" >

Name="PPFAttribute24"
EntityAttrName="Attribute24"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE24" >

Name="PPFAttribute25"
EntityAttrName="Attribute25"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE25" >

Name="PPFAttribute26"
EntityAttrName="Attribute26"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE26" >

Name="PPFAttribute27"
EntityAttrName="Attribute27"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE27" >

Name="PPFAttribute28"
EntityAttrName="Attribute28"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE28" >

Name="PPFAttribute29"
EntityAttrName="Attribute29"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE29" >

Name="PPFAttribute30"
EntityAttrName="Attribute30"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE30" >

Name="PPFAttributeCategory"
EntityAttrName="AttributeCategory"
EntityUsage="PPF"
AliasName="PPFATTRIBUTE_CATEGORY" >

Name="PersonId1"
EntityAttrName="PersonId"
EntityUsage="VCN"
AliasName="PERSON_ID1"
Passivate="true" >

Name="SearchCriteriaId"
EntityAttrName="SearchCriteriaId"
EntityUsage="CSC"
AliasName="SEARCH_CRITERIA_ID"
Passivate="true" >

Name="Location"
EntityAttrName="Location"
EntityUsage="CSC"
AliasName="LOCATION"
Passivate="true" >

Name="DistanceToLocationInt"
EntityAttrName="DistanceToLocation"
EntityUsage="CSC"
AliasName="DISTANCE_TO_LOCATION"
Passivate="true" >

Name="Employee"
EntityAttrName="Employee"
EntityUsage="CSC"
AliasName="EMPLOYEE"
Passivate="true" >

Name="Contractor"
EntityAttrName="Contractor"
EntityUsage="CSC"
AliasName="CONTRACTOR"
Passivate="true" >

Name="EmploymentCategory"
EntityAttrName="EmploymentCategory"
EntityUsage="CSC"
AliasName="EMPLOYMENT_CATEGORY"
Passivate="true" >

Name="Keywords"
EntityAttrName="Keywords"
EntityUsage="CSC"
AliasName="KEYWORDS"
Passivate="true" >

Name="TravelPercentage"
EntityAttrName="TravelPercentage"
EntityUsage="CSC"
AliasName="TRAVEL_PERCENTAGE"
Passivate="true" >

Name="MinSalary"
EntityAttrName="MinSalary"
EntityUsage="CSC"
AliasName="MIN_SALARY"
Passivate="true" >

Name="SalaryCurrency"
EntityAttrName="SalaryCurrency"
EntityUsage="CSC"
AliasName="SALARY_CURRENCY"
Passivate="true" >

Name="SalaryPeriod"
EntityAttrName="SalaryPeriod"
EntityUsage="CSC"
AliasName="SALARY_PERIOD"
Passivate="true" >

Name="MatchCompetence"
EntityAttrName="MatchCompetence"
EntityUsage="CSC"
AliasName="MATCH_COMPETENCE"
Passivate="true" >

Name="MatchQualification"
EntityAttrName="MatchQualification"
EntityUsage="CSC"
AliasName="MATCH_QUALIFICATION"
Passivate="true" >

Name="JobTitle"
EntityAttrName="JobTitle"
EntityUsage="CSC"
AliasName="JOB_TITLE"
Passivate="true" >

Name="Department"
EntityAttrName="Department"
EntityUsage="CSC"
AliasName="DEPARTMENT"
Passivate="true" >

Name="ProfessionalArea"
EntityAttrName="ProfessionalArea"
EntityUsage="CSC"
AliasName="PROFESSIONAL_AREA"
Passivate="true" >

Name="WorkAtHome"
EntityAttrName="WorkAtHome"
EntityUsage="CSC"
AliasName="WORK_AT_HOME"
Passivate="true" >

Name="AttributeCategory"
EntityAttrName="AttributeCategory"
EntityUsage="CSC"
AliasName="ATTRIBUTE_CATEGORY"
Passivate="true" >

Name="Attribute1"
EntityAttrName="Attribute1"
EntityUsage="CSC"
AliasName="ATTRIBUTE1" >

Name="Attribute2"
EntityAttrName="Attribute2"
EntityUsage="CSC"
AliasName="ATTRIBUTE2" >

Name="Attribute3"
EntityAttrName="Attribute3"
EntityUsage="CSC"
AliasName="ATTRIBUTE3" >

Name="Attribute4"
EntityAttrName="Attribute4"
EntityUsage="CSC"
AliasName="ATTRIBUTE4" >

Name="Attribute5"
EntityAttrName="Attribute5"
EntityUsage="CSC"
AliasName="ATTRIBUTE5" >

Name="Attribute6"
EntityAttrName="Attribute6"
EntityUsage="CSC"
AliasName="ATTRIBUTE6" >

Name="Attribute7"
EntityAttrName="Attribute7"
EntityUsage="CSC"
AliasName="ATTRIBUTE7" >

Name="Attribute8"
EntityAttrName="Attribute8"
EntityUsage="CSC"
AliasName="ATTRIBUTE8" >

Name="Attribute9"
EntityAttrName="Attribute9"
EntityUsage="CSC"
AliasName="ATTRIBUTE9" >

Name="Attribute10"
EntityAttrName="Attribute10"
EntityUsage="CSC"
AliasName="ATTRIBUTE10" >

Name="Attribute11"
EntityAttrName="Attribute11"
EntityUsage="CSC"
AliasName="ATTRIBUTE11" >

Name="Attribute12"
EntityAttrName="Attribute12"
EntityUsage="CSC"
AliasName="ATTRIBUTE12" >

Name="Attribute13"
EntityAttrName="Attribute13"
EntityUsage="CSC"
AliasName="ATTRIBUTE13" >

Name="Attribute14"
EntityAttrName="Attribute14"
EntityUsage="CSC"
AliasName="ATTRIBUTE14" >

Name="Attribute15"
EntityAttrName="Attribute15"
EntityUsage="CSC"
AliasName="ATTRIBUTE15" >

Name="Attribute16"
EntityAttrName="Attribute16"
EntityUsage="CSC"
AliasName="ATTRIBUTE16" >

Name="Attribute17"
EntityAttrName="Attribute17"
EntityUsage="CSC"
AliasName="ATTRIBUTE17" >

Name="Attribute18"
EntityAttrName="Attribute18"
EntityUsage="CSC"
AliasName="ATTRIBUTE18" >

Name="Attribute19"
EntityAttrName="Attribute19"
EntityUsage="CSC"
AliasName="ATTRIBUTE19" >

Name="Attribute20"
EntityAttrName="Attribute20"
EntityUsage="CSC"
AliasName="ATTRIBUTE20" >

Name="Attribute21"
EntityAttrName="Attribute21"
EntityUsage="CSC"
AliasName="ATTRIBUTE21" >

Name="Attribute22"
EntityAttrName="Attribute22"
EntityUsage="CSC"
AliasName="ATTRIBUTE22" >

Name="Attribute23"
EntityAttrName="Attribute23"
EntityUsage="CSC"
AliasName="ATTRIBUTE23" >

Name="Attribute24"
EntityAttrName="Attribute24"
EntityUsage="CSC"
AliasName="ATTRIBUTE24" >

Name="Attribute25"
EntityAttrName="Attribute25"
EntityUsage="CSC"
AliasName="ATTRIBUTE25" >

Name="Attribute26"
EntityAttrName="Attribute26"
EntityUsage="CSC"
AliasName="ATTRIBUTE26" >

Name="Attribute27"
EntityAttrName="Attribute27"
EntityUsage="CSC"
AliasName="ATTRIBUTE27" >

Name="Attribute28"
EntityAttrName="Attribute28"
EntityUsage="CSC"
AliasName="ATTRIBUTE28"
Passivate="true" >

Name="Attribute29"
EntityAttrName="Attribute29"
EntityUsage="CSC"
AliasName="ATTRIBUTE29" >

Name="Attribute30"
EntityAttrName="Attribute30"
EntityUsage="CSC"
AliasName="ATTRIBUTE30" >

Name="RowNumber"
IsUpdateable="false"
IsQueriable="false"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
ColumnType="VARCHAR2"
AliasName="RowNumber"
Expression="to_char(RowNum)"
SQLType="VARCHAR" >

Name="QualificationType"
IsUpdateable="false"
IsQueriable="false"
IsPersistent="false"
Precision="150"
Type="java.lang.String"
ColumnType="VARCHAR2"
AliasName="VIEW_ATTR"
SQLType="VARCHAR" >

Name="PartyId"
EntityAttrName="PartyId"
EntityUsage="PPF"
AliasName="PARTY_ID"
Passivate="true" >

Name="EmployeeUserPersonType"
IsUpdateable="false"
IsPersistent="false"
Precision="80"
Type="java.lang.String"
ColumnType="VARCHAR2"
AliasName="VIEW_ATTR"
SQLType="VARCHAR" >

Name="ApplicantUserPersonType"
IsUpdateable="false"
IsPersistent="false"
Precision="80"
Type="java.lang.String"
ColumnType="VARCHAR2"
AliasName="VIEW_ATTR"
SQLType="VARCHAR" >

Name="EmployerName"
IsUpdateable="false"
IsPersistent="false"
Precision="240"
Type="java.lang.String"
ColumnType="VARCHAR2"
AliasName="VIEW_ATTR"
SQLType="VARCHAR" >

Name="ExApplications"
IsUpdateable="false"
IsQueriable="false"
IsPersistent="false"
Precision="10"
Type="java.lang.String"
ColumnType="VARCHAR2"
AliasName="VIEW_ATTR"
SQLType="VARCHAR" >

Name="AccessFlag"
IsUpdateable="false"
IsQueriable="false"
IsPersistent="false"
Precision="10"
Type="java.lang.String"
ColumnType="VARCHAR2"
AliasName="VIEW_ATTR"
SQLType="VARCHAR" >

Name="VendorId"
IsNotNull="true"
EntityAttrName="VendorId"
EntityUsage="POV"
AliasName="VENDOR_ID" >

Name="VendorName"
IsNotNull="true"
EntityAttrName="VendorName"
EntityUsage="POV"
AliasName="VENDOR_NAME" >

Name="RegistrationDate"
EntityAttrName="CreationDate"
EntityUsage="INP"
AliasName="CREATION_DATE" >

Name="DistanceToLocationResults"
IsUpdateable="false"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
ColumnType="VARCHAR2"
AliasName="DISTANCE_TO_LOCATION_RESULTS" Expression="to_char(decode(:17,'Y',nvl2(ADDR.geometry,floor(irc_location_utility.sdo_miles(mdsys.sdo_geometry(2001,8307,mdsys.sdo_point_type(:18,:19,null),null,null),ADDR.geometry,0.01)),''),''))"
SQLType="VARCHAR" >

Name="DistanceToLocation"
IsPersistent="false"
Type="oracle.jbo.domain.Number"
ColumnType="NUMBER"
AliasName="DISTANCE_TO_LOCATION_INT"
Expression="fnd_number.canonical_to_number(distance_to_location)"
SQLType="NUMERIC" >

Name="RegisterTestStatus"
IsUpdateable="false"
IsPersistent="false"
Precision="30"
Type="java.lang.String"
ColumnType="VARCHAR2"
AliasName="ATTEMPT_STATUS" Expression="nvl2(ATMPT.MASTERY_SCORE,decode(greatest(ATMPT.MASTERY_SCORE,ATMPT.RAW_SCORE), ATMPT.RAW_SCORE, 'P', 'F'),nvl2(FND_PROFILE.VALUE('IRC_REGISTER_TEST'),nvl2(INP.ATTEMPT_ID,
'A','N'),null))"
SQLType="VARCHAR" >

Name="RegisterTestScore"
IsUpdateable="false"
IsPersistent="false"
Precision="40"
Type="oracle.jbo.domain.Number"
ColumnType="NUMBER"
AliasName="ATTEMPT_SCORE"
Expression="to_number(decode(ATMPT.RAW_SCORE, -1000, null, ATMPT.RAW_SCORE))"
SQLType="NUMERIC" >

Name="RegisterAttemptId"
IsNotNull="true"
EntityAttrName="AttemptId"
EntityUsage="ATMPT"
AliasName="ATTEMPT_ID"
Passivate="true" >

Name="Referred"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
ColumnType="VARCHAR2"
AliasName="Referred"
Expression="decode(IrcReferralInfoEO.source_type,'ER','Y','N')"
SQLType="VARCHAR" >

Name="StartDate"
IsNotNull="true"
EntityAttrName="StartDate"
EntityUsage="IrcReferralInfoEO"
AliasName="START_DATE" >

Name="ObjectId"
IsNotNull="true"
EntityAttrName="ObjectId"
EntityUsage="IrcReferralInfoEO"
AliasName="OBJECT_ID" >

Name="ObjectType"
IsNotNull="true"
EntityAttrName="ObjectType"
EntityUsage="IrcReferralInfoEO"
AliasName="OBJECT_TYPE" >

Name="EndDate"
IsNotNull="true"
EntityAttrName="EndDate"
EntityUsage="IrcReferralInfoEO"
AliasName="END_DATE" >

Name="SourceType"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
ColumnType="VARCHAR2"
AliasName="SourceType"
Expression="(select meaning from hr_lookups where lookup_code = IRCREFERRALINFOEO.source_type and lookup_type = 'REC_TYPE')"
SQLType="VARCHAR" >

Name="SourceName"
IsPersistent="false"
Precision="255"
Type="java.lang.String"
ColumnType="VARCHAR2"
AliasName="SourceName"
Expression="decode (IrcReferralInfoEO.source_type, 'ER',(select distinct(full_name) from per_all_people_f where person_id = IrcReferralInfoEO.source_person_id), IrcReferralInfoEO.source_name )"
SQLType="VARCHAR" >









Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)