eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PROCESS_CONTACT_SS dependencies on HR_GENERAL

Line 5464: p_contact_type_meaning := HR_GENERAL.DECODE_LOOKUP('CONTACT',p_contact_type);

5460: ,p_name =>upper( 'p_contact_type'));
5461: --
5462: -- Bug 1914891
5463: --
5464: p_contact_type_meaning := HR_GENERAL.DECODE_LOOKUP('CONTACT',p_contact_type);
5465: --
5466: p_ctr_comments :=
5467: hr_transaction_api.get_varchar2_value
5468: (p_transaction_step_id => p_transaction_step_id

Line 5646: p_sex_meaning := HR_GENERAL.DECODE_LOOKUP('SEX',p_sex); -- 7777

5642: hr_transaction_api.get_varchar2_value
5643: (p_transaction_step_id => p_transaction_step_id
5644: ,p_name =>upper( 'p_sex'));
5645: --
5646: p_sex_meaning := HR_GENERAL.DECODE_LOOKUP('SEX',p_sex); -- 7777
5647: --
5648: p_uses_tobacco_flag :=
5649: hr_transaction_api.get_varchar2_value
5650: (p_transaction_step_id => p_transaction_step_id

Line 5653: p_uses_tobacco_meaning := HR_GENERAL.DECODE_LOOKUP('TOBACCO_USER',p_uses_tobacco_flag); -- 7777

5649: hr_transaction_api.get_varchar2_value
5650: (p_transaction_step_id => p_transaction_step_id
5651: ,p_name =>upper( 'p_uses_tobacco_flag'));
5652: --
5653: p_uses_tobacco_meaning := HR_GENERAL.DECODE_LOOKUP('TOBACCO_USER',p_uses_tobacco_flag); -- 7777
5654: --
5655: p_on_military_service :=
5656: hr_transaction_api.get_varchar2_value
5657: (p_transaction_step_id => p_transaction_step_id

Line 5660: p_on_military_service_meaning := HR_GENERAL.DECODE_LOOKUP('YES_NO',p_on_military_service); -- 7777

5656: hr_transaction_api.get_varchar2_value
5657: (p_transaction_step_id => p_transaction_step_id
5658: ,p_name =>upper( 'p_on_military_service'));
5659: --
5660: p_on_military_service_meaning := HR_GENERAL.DECODE_LOOKUP('YES_NO',p_on_military_service); -- 7777
5661: --
5662: p_dpdnt_vlntry_svce_flag :=
5663: hr_transaction_api.get_varchar2_value
5664: (p_transaction_step_id => p_transaction_step_id

Line 5667: p_dpdnt_vlntry_svce_meaning := HR_GENERAL.DECODE_LOOKUP('YES_NO',p_dpdnt_vlntry_svce_flag); -- 7777

5663: hr_transaction_api.get_varchar2_value
5664: (p_transaction_step_id => p_transaction_step_id
5665: ,p_name =>upper( 'p_dpdnt_vlntry_svce_flag'));
5666: --
5667: p_dpdnt_vlntry_svce_meaning := HR_GENERAL.DECODE_LOOKUP('YES_NO',p_dpdnt_vlntry_svce_flag); -- 7777
5668: --
5669: p_person_type_id :=
5670: hr_transaction_api.get_number_value
5671: (p_transaction_step_id => p_transaction_step_id

Line 5704: p_marital_status_meaning := HR_GENERAL.DECODE_LOOKUP('MAR_STATUS',p_marital_status); -- 7777

5700: hr_transaction_api.get_varchar2_value
5701: (p_transaction_step_id => p_transaction_step_id
5702: ,p_name =>upper( 'p_marital_status'));
5703: --
5704: p_marital_status_meaning := HR_GENERAL.DECODE_LOOKUP('MAR_STATUS',p_marital_status); -- 7777
5705: --
5706: --
5707: p_student_status := -- 12345
5708: hr_transaction_api.get_varchar2_value

Line 5712: p_student_status_meaning := HR_GENERAL.DECODE_LOOKUP('STUDENT_STATUS',p_student_status); -- 7777

5708: hr_transaction_api.get_varchar2_value
5709: (p_transaction_step_id => p_transaction_step_id
5710: ,p_name =>upper( 'p_student_status'));
5711: --
5712: p_student_status_meaning := HR_GENERAL.DECODE_LOOKUP('STUDENT_STATUS',p_student_status); -- 7777
5713: --
5714: p_middle_names :=
5715: hr_transaction_api.get_varchar2_value
5716: (p_transaction_step_id => p_transaction_step_id

Line 5739: p_registered_disabled := HR_GENERAL.DECODE_LOOKUP('REGISTERED_DISABLED', p_registered_disabled_flag);

5735: hr_transaction_api.get_varchar2_value
5736: (p_transaction_step_id => p_transaction_step_id
5737: ,p_name =>upper( 'p_registered_disabled_flag'));
5738: --
5739: p_registered_disabled := HR_GENERAL.DECODE_LOOKUP('REGISTERED_DISABLED', p_registered_disabled_flag);
5740: --
5741: p_title :=
5742: hr_transaction_api.get_varchar2_value
5743: (p_transaction_step_id => p_transaction_step_id

Line 5748: p_title_meaning := HR_GENERAL.DECODE_LOOKUP('TITLE', p_title);

5744: ,p_name =>upper( 'p_title'));
5745: --
5746: -- Bug 1914891
5747: --
5748: p_title_meaning := HR_GENERAL.DECODE_LOOKUP('TITLE', p_title);
5749: --
5750: p_work_telephone :=
5751: hr_transaction_api.get_varchar2_value
5752: (p_transaction_step_id => p_transaction_step_id

Line 16660: HR_GENERAL.DECODE_LOOKUP('CONTACT', contact_type) relationship

16656: cursor emrg_rel_id(p_contact_relationship_id number
16657: ,p_contact_person_id number )
16658: is
16659: select contact_relationship_id,
16660: HR_GENERAL.DECODE_LOOKUP('CONTACT', contact_type) relationship
16661: from PER_CONTACT_RELATIONSHIPS
16662: where person_id = (select person_id
16663: from PER_CONTACT_RELATIONSHIPS
16664: where contact_person_id = p_contact_person_id

Line 16676: select HR_GENERAL.DECODE_LOOKUP('CONTACT', pcr.contact_type) relationship

16672:
16673: cursor other_rel_type(p_contact_relationship_id number
16674: ,p_contact_person_id number )
16675: is
16676: select HR_GENERAL.DECODE_LOOKUP('CONTACT', pcr.contact_type) relationship
16677: from PER_CONTACT_RELATIONSHIPS pcr
16678: where pcr.contact_person_id = p_contact_person_id
16679: and pcr.contact_relationship_id = p_contact_relationship_id
16680: and trunc(sysdate) >= decode(pcr.date_start,null,trunc(sysdate),trunc(pcr.date_start))