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 1731: and (nvl(date_end,hr_general.end_of_time)

1727: select 'Y'
1728: from per_contact_relationships
1729: where person_id = p_person_id
1730: and primary_contact_flag = 'Y'
1731: and (nvl(date_end,hr_general.end_of_time)
1732: > nvl(z_date_start,hr_general.start_of_time)
1733: and nvl(date_start,hr_general.start_of_time)
1734: < nvl(z_date_end,hr_general.end_of_time))
1735: and contact_type = 'EMRG';

Line 1732: > nvl(z_date_start,hr_general.start_of_time)

1728: from per_contact_relationships
1729: where person_id = p_person_id
1730: and primary_contact_flag = 'Y'
1731: and (nvl(date_end,hr_general.end_of_time)
1732: > nvl(z_date_start,hr_general.start_of_time)
1733: and nvl(date_start,hr_general.start_of_time)
1734: < nvl(z_date_end,hr_general.end_of_time))
1735: and contact_type = 'EMRG';
1736: --Added for the bug 14207426/14325833 ends

Line 1733: and nvl(date_start,hr_general.start_of_time)

1729: where person_id = p_person_id
1730: and primary_contact_flag = 'Y'
1731: and (nvl(date_end,hr_general.end_of_time)
1732: > nvl(z_date_start,hr_general.start_of_time)
1733: and nvl(date_start,hr_general.start_of_time)
1734: < nvl(z_date_end,hr_general.end_of_time))
1735: and contact_type = 'EMRG';
1736: --Added for the bug 14207426/14325833 ends
1737: --

Line 1734: < nvl(z_date_end,hr_general.end_of_time))

1730: and primary_contact_flag = 'Y'
1731: and (nvl(date_end,hr_general.end_of_time)
1732: > nvl(z_date_start,hr_general.start_of_time)
1733: and nvl(date_start,hr_general.start_of_time)
1734: < nvl(z_date_end,hr_general.end_of_time))
1735: and contact_type = 'EMRG';
1736: --Added for the bug 14207426/14325833 ends
1737: --
1738: BEGIN

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

5529: ,p_name =>upper( 'p_contact_type'));
5530: --
5531: -- Bug 1914891
5532: --
5533: p_contact_type_meaning := HR_GENERAL.DECODE_LOOKUP('CONTACT',p_contact_type);
5534: --
5535: p_ctr_comments :=
5536: hr_transaction_api.get_varchar2_value
5537: (p_transaction_step_id => p_transaction_step_id

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

5711: hr_transaction_api.get_varchar2_value
5712: (p_transaction_step_id => p_transaction_step_id
5713: ,p_name =>upper( 'p_sex'));
5714: --
5715: p_sex_meaning := HR_GENERAL.DECODE_LOOKUP('SEX',p_sex); -- 7777
5716: --
5717: p_uses_tobacco_flag :=
5718: hr_transaction_api.get_varchar2_value
5719: (p_transaction_step_id => p_transaction_step_id

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

5718: hr_transaction_api.get_varchar2_value
5719: (p_transaction_step_id => p_transaction_step_id
5720: ,p_name =>upper( 'p_uses_tobacco_flag'));
5721: --
5722: p_uses_tobacco_meaning := HR_GENERAL.DECODE_LOOKUP('TOBACCO_USER',p_uses_tobacco_flag); -- 7777
5723: --
5724: p_on_military_service :=
5725: hr_transaction_api.get_varchar2_value
5726: (p_transaction_step_id => p_transaction_step_id

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

5725: hr_transaction_api.get_varchar2_value
5726: (p_transaction_step_id => p_transaction_step_id
5727: ,p_name =>upper( 'p_on_military_service'));
5728: --
5729: p_on_military_service_meaning := HR_GENERAL.DECODE_LOOKUP('YES_NO',p_on_military_service); -- 7777
5730: --
5731: p_dpdnt_vlntry_svce_flag :=
5732: hr_transaction_api.get_varchar2_value
5733: (p_transaction_step_id => p_transaction_step_id

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

5732: hr_transaction_api.get_varchar2_value
5733: (p_transaction_step_id => p_transaction_step_id
5734: ,p_name =>upper( 'p_dpdnt_vlntry_svce_flag'));
5735: --
5736: p_dpdnt_vlntry_svce_meaning := HR_GENERAL.DECODE_LOOKUP('YES_NO',p_dpdnt_vlntry_svce_flag); -- 7777
5737: --
5738: p_person_type_id :=
5739: hr_transaction_api.get_number_value
5740: (p_transaction_step_id => p_transaction_step_id

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

5769: hr_transaction_api.get_varchar2_value
5770: (p_transaction_step_id => p_transaction_step_id
5771: ,p_name =>upper( 'p_marital_status'));
5772: --
5773: p_marital_status_meaning := HR_GENERAL.DECODE_LOOKUP('MAR_STATUS',p_marital_status); -- 7777
5774: --
5775: --
5776: p_student_status := -- 12345
5777: hr_transaction_api.get_varchar2_value

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

5777: hr_transaction_api.get_varchar2_value
5778: (p_transaction_step_id => p_transaction_step_id
5779: ,p_name =>upper( 'p_student_status'));
5780: --
5781: p_student_status_meaning := HR_GENERAL.DECODE_LOOKUP('STUDENT_STATUS',p_student_status); -- 7777
5782: --
5783: p_middle_names :=
5784: hr_transaction_api.get_varchar2_value
5785: (p_transaction_step_id => p_transaction_step_id

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

5804: hr_transaction_api.get_varchar2_value
5805: (p_transaction_step_id => p_transaction_step_id
5806: ,p_name =>upper( 'p_registered_disabled_flag'));
5807: --
5808: p_registered_disabled := HR_GENERAL.DECODE_LOOKUP('REGISTERED_DISABLED', p_registered_disabled_flag);
5809: --
5810: p_title :=
5811: hr_transaction_api.get_varchar2_value
5812: (p_transaction_step_id => p_transaction_step_id

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

5813: ,p_name =>upper( 'p_title'));
5814: --
5815: -- Bug 1914891
5816: --
5817: p_title_meaning := HR_GENERAL.DECODE_LOOKUP('TITLE', p_title);
5818: --
5819: p_work_telephone :=
5820: hr_transaction_api.get_varchar2_value
5821: (p_transaction_step_id => p_transaction_step_id

Line 9607: and (nvl(date_end,hr_general.end_of_time)

9603: select 'Y'
9604: from per_contact_relationships
9605: where person_id = l_person_id
9606: and primary_contact_flag = 'Y'
9607: and (nvl(date_end,hr_general.end_of_time)
9608: > nvl(z_date_start,hr_general.start_of_time)
9609: and nvl(date_start,hr_general.start_of_time)
9610: < nvl(z_date_end,hr_general.end_of_time));
9611: -- 9564383 ends

Line 9608: > nvl(z_date_start,hr_general.start_of_time)

9604: from per_contact_relationships
9605: where person_id = l_person_id
9606: and primary_contact_flag = 'Y'
9607: and (nvl(date_end,hr_general.end_of_time)
9608: > nvl(z_date_start,hr_general.start_of_time)
9609: and nvl(date_start,hr_general.start_of_time)
9610: < nvl(z_date_end,hr_general.end_of_time));
9611: -- 9564383 ends
9612:

Line 9609: and nvl(date_start,hr_general.start_of_time)

9605: where person_id = l_person_id
9606: and primary_contact_flag = 'Y'
9607: and (nvl(date_end,hr_general.end_of_time)
9608: > nvl(z_date_start,hr_general.start_of_time)
9609: and nvl(date_start,hr_general.start_of_time)
9610: < nvl(z_date_end,hr_general.end_of_time));
9611: -- 9564383 ends
9612:
9613: -- bug# 2115552

Line 9610: < nvl(z_date_end,hr_general.end_of_time));

9606: and primary_contact_flag = 'Y'
9607: and (nvl(date_end,hr_general.end_of_time)
9608: > nvl(z_date_start,hr_general.start_of_time)
9609: and nvl(date_start,hr_general.start_of_time)
9610: < nvl(z_date_end,hr_general.end_of_time));
9611: -- 9564383 ends
9612:
9613: -- bug# 2115552
9614: -- Using this value for P_PRIMARY_CONTACT_FLAG for addl relationship

Line 11675: and (nvl(date_end,hr_general.end_of_time)

11671: select 'Y'
11672: from per_contact_relationships
11673: where person_id = z_person_id
11674: and primary_contact_flag = 'Y'
11675: and (nvl(date_end,hr_general.end_of_time)
11676: > nvl(z_date_start,hr_general.start_of_time)
11677: and nvl(date_start,hr_general.start_of_time)
11678: < nvl(z_date_end,hr_general.end_of_time));
11679: -- 9564383 ends

Line 11676: > nvl(z_date_start,hr_general.start_of_time)

11672: from per_contact_relationships
11673: where person_id = z_person_id
11674: and primary_contact_flag = 'Y'
11675: and (nvl(date_end,hr_general.end_of_time)
11676: > nvl(z_date_start,hr_general.start_of_time)
11677: and nvl(date_start,hr_general.start_of_time)
11678: < nvl(z_date_end,hr_general.end_of_time));
11679: -- 9564383 ends
11680: --

Line 11677: and nvl(date_start,hr_general.start_of_time)

11673: where person_id = z_person_id
11674: and primary_contact_flag = 'Y'
11675: and (nvl(date_end,hr_general.end_of_time)
11676: > nvl(z_date_start,hr_general.start_of_time)
11677: and nvl(date_start,hr_general.start_of_time)
11678: < nvl(z_date_end,hr_general.end_of_time));
11679: -- 9564383 ends
11680: --
11681: l_effective_start_date date default null;

Line 11678: < nvl(z_date_end,hr_general.end_of_time));

11674: and primary_contact_flag = 'Y'
11675: and (nvl(date_end,hr_general.end_of_time)
11676: > nvl(z_date_start,hr_general.start_of_time)
11677: and nvl(date_start,hr_general.start_of_time)
11678: < nvl(z_date_end,hr_general.end_of_time));
11679: -- 9564383 ends
11680: --
11681: l_effective_start_date date default null;
11682: l_effective_end_date date default null;

Line 16384: and (nvl(date_end,hr_general.end_of_time)

16380: select 'Y'
16381: from per_contact_relationships
16382: where person_id = p_person_id
16383: and primary_contact_flag = 'Y'
16384: and (nvl(date_end,hr_general.end_of_time)
16385: > nvl(p_date_start,hr_general.start_of_time)
16386: and nvl(date_start,hr_general.start_of_time)
16387: < nvl(p_date_end,hr_general.end_of_time));
16388: -- 9564383 ends

Line 16385: > nvl(p_date_start,hr_general.start_of_time)

16381: from per_contact_relationships
16382: where person_id = p_person_id
16383: and primary_contact_flag = 'Y'
16384: and (nvl(date_end,hr_general.end_of_time)
16385: > nvl(p_date_start,hr_general.start_of_time)
16386: and nvl(date_start,hr_general.start_of_time)
16387: < nvl(p_date_end,hr_general.end_of_time));
16388: -- 9564383 ends
16389:

Line 16386: and nvl(date_start,hr_general.start_of_time)

16382: where person_id = p_person_id
16383: and primary_contact_flag = 'Y'
16384: and (nvl(date_end,hr_general.end_of_time)
16385: > nvl(p_date_start,hr_general.start_of_time)
16386: and nvl(date_start,hr_general.start_of_time)
16387: < nvl(p_date_end,hr_general.end_of_time));
16388: -- 9564383 ends
16389:
16390: begin

Line 16387: < nvl(p_date_end,hr_general.end_of_time));

16383: and primary_contact_flag = 'Y'
16384: and (nvl(date_end,hr_general.end_of_time)
16385: > nvl(p_date_start,hr_general.start_of_time)
16386: and nvl(date_start,hr_general.start_of_time)
16387: < nvl(p_date_end,hr_general.end_of_time));
16388: -- 9564383 ends
16389:
16390: begin
16391:

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

16850: cursor emrg_rel_id(p_contact_relationship_id number
16851: ,p_contact_person_id number )
16852: is
16853: select contact_relationship_id,
16854: HR_GENERAL.DECODE_LOOKUP('CONTACT', contact_type) relationship
16855: from PER_CONTACT_RELATIONSHIPS
16856: where person_id = (select person_id
16857: from PER_CONTACT_RELATIONSHIPS
16858: where contact_person_id = p_contact_person_id

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

16866:
16867: cursor other_rel_type(p_contact_relationship_id number
16868: ,p_contact_person_id number )
16869: is
16870: select HR_GENERAL.DECODE_LOOKUP('CONTACT', pcr.contact_type) relationship
16871: from PER_CONTACT_RELATIONSHIPS pcr
16872: where pcr.contact_person_id = p_contact_person_id
16873: and pcr.contact_relationship_id = p_contact_relationship_id
16874: and trunc(sysdate) >= decode(pcr.date_start,null,trunc(sysdate),trunc(pcr.date_start))