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.HRI_EDW_DIM_PERSON_TYPE dependencies on HRI_PERSON_TYPE_CMBNS

Line 4: g_employee hri_person_type_cmbns.employee%TYPE;

1: PACKAGE BODY hri_edw_dim_person_type AS
2: /* $Header: hriedpty.pkb 120.1 2006/03/29 02:55:20 anmajumd noship $ */
3:
4: g_employee hri_person_type_cmbns.employee%TYPE;
5: g_applicant hri_person_type_cmbns.applicant%TYPE;
6: g_permanent hri_person_type_cmbns.permanent%TYPE;
7: g_fixed_term_lower hri_person_type_cmbns.fixed_term_lower%TYPE;
8: g_fixed_term_upper hri_person_type_cmbns.fixed_term_upper%TYPE;

Line 5: g_applicant hri_person_type_cmbns.applicant%TYPE;

1: PACKAGE BODY hri_edw_dim_person_type AS
2: /* $Header: hriedpty.pkb 120.1 2006/03/29 02:55:20 anmajumd noship $ */
3:
4: g_employee hri_person_type_cmbns.employee%TYPE;
5: g_applicant hri_person_type_cmbns.applicant%TYPE;
6: g_permanent hri_person_type_cmbns.permanent%TYPE;
7: g_fixed_term_lower hri_person_type_cmbns.fixed_term_lower%TYPE;
8: g_fixed_term_upper hri_person_type_cmbns.fixed_term_upper%TYPE;
9: g_intern hri_person_type_cmbns.intern%TYPE;

Line 6: g_permanent hri_person_type_cmbns.permanent%TYPE;

2: /* $Header: hriedpty.pkb 120.1 2006/03/29 02:55:20 anmajumd noship $ */
3:
4: g_employee hri_person_type_cmbns.employee%TYPE;
5: g_applicant hri_person_type_cmbns.applicant%TYPE;
6: g_permanent hri_person_type_cmbns.permanent%TYPE;
7: g_fixed_term_lower hri_person_type_cmbns.fixed_term_lower%TYPE;
8: g_fixed_term_upper hri_person_type_cmbns.fixed_term_upper%TYPE;
9: g_intern hri_person_type_cmbns.intern%TYPE;
10: g_ex_employee hri_person_type_cmbns.ex_employee%TYPE;

Line 7: g_fixed_term_lower hri_person_type_cmbns.fixed_term_lower%TYPE;

3:
4: g_employee hri_person_type_cmbns.employee%TYPE;
5: g_applicant hri_person_type_cmbns.applicant%TYPE;
6: g_permanent hri_person_type_cmbns.permanent%TYPE;
7: g_fixed_term_lower hri_person_type_cmbns.fixed_term_lower%TYPE;
8: g_fixed_term_upper hri_person_type_cmbns.fixed_term_upper%TYPE;
9: g_intern hri_person_type_cmbns.intern%TYPE;
10: g_ex_employee hri_person_type_cmbns.ex_employee%TYPE;
11: g_ex_applicant hri_person_type_cmbns.ex_applicant%TYPE;

Line 8: g_fixed_term_upper hri_person_type_cmbns.fixed_term_upper%TYPE;

4: g_employee hri_person_type_cmbns.employee%TYPE;
5: g_applicant hri_person_type_cmbns.applicant%TYPE;
6: g_permanent hri_person_type_cmbns.permanent%TYPE;
7: g_fixed_term_lower hri_person_type_cmbns.fixed_term_lower%TYPE;
8: g_fixed_term_upper hri_person_type_cmbns.fixed_term_upper%TYPE;
9: g_intern hri_person_type_cmbns.intern%TYPE;
10: g_ex_employee hri_person_type_cmbns.ex_employee%TYPE;
11: g_ex_applicant hri_person_type_cmbns.ex_applicant%TYPE;
12: g_dependent hri_person_type_cmbns.dependent%TYPE;

Line 9: g_intern hri_person_type_cmbns.intern%TYPE;

5: g_applicant hri_person_type_cmbns.applicant%TYPE;
6: g_permanent hri_person_type_cmbns.permanent%TYPE;
7: g_fixed_term_lower hri_person_type_cmbns.fixed_term_lower%TYPE;
8: g_fixed_term_upper hri_person_type_cmbns.fixed_term_upper%TYPE;
9: g_intern hri_person_type_cmbns.intern%TYPE;
10: g_ex_employee hri_person_type_cmbns.ex_employee%TYPE;
11: g_ex_applicant hri_person_type_cmbns.ex_applicant%TYPE;
12: g_dependent hri_person_type_cmbns.dependent%TYPE;
13: g_beneficiary hri_person_type_cmbns.beneficiary%TYPE;

Line 10: g_ex_employee hri_person_type_cmbns.ex_employee%TYPE;

6: g_permanent hri_person_type_cmbns.permanent%TYPE;
7: g_fixed_term_lower hri_person_type_cmbns.fixed_term_lower%TYPE;
8: g_fixed_term_upper hri_person_type_cmbns.fixed_term_upper%TYPE;
9: g_intern hri_person_type_cmbns.intern%TYPE;
10: g_ex_employee hri_person_type_cmbns.ex_employee%TYPE;
11: g_ex_applicant hri_person_type_cmbns.ex_applicant%TYPE;
12: g_dependent hri_person_type_cmbns.dependent%TYPE;
13: g_beneficiary hri_person_type_cmbns.beneficiary%TYPE;
14: g_retiree hri_person_type_cmbns.retiree%TYPE;

Line 11: g_ex_applicant hri_person_type_cmbns.ex_applicant%TYPE;

7: g_fixed_term_lower hri_person_type_cmbns.fixed_term_lower%TYPE;
8: g_fixed_term_upper hri_person_type_cmbns.fixed_term_upper%TYPE;
9: g_intern hri_person_type_cmbns.intern%TYPE;
10: g_ex_employee hri_person_type_cmbns.ex_employee%TYPE;
11: g_ex_applicant hri_person_type_cmbns.ex_applicant%TYPE;
12: g_dependent hri_person_type_cmbns.dependent%TYPE;
13: g_beneficiary hri_person_type_cmbns.beneficiary%TYPE;
14: g_retiree hri_person_type_cmbns.retiree%TYPE;
15: g_contact hri_person_type_cmbns.contact%TYPE;

Line 12: g_dependent hri_person_type_cmbns.dependent%TYPE;

8: g_fixed_term_upper hri_person_type_cmbns.fixed_term_upper%TYPE;
9: g_intern hri_person_type_cmbns.intern%TYPE;
10: g_ex_employee hri_person_type_cmbns.ex_employee%TYPE;
11: g_ex_applicant hri_person_type_cmbns.ex_applicant%TYPE;
12: g_dependent hri_person_type_cmbns.dependent%TYPE;
13: g_beneficiary hri_person_type_cmbns.beneficiary%TYPE;
14: g_retiree hri_person_type_cmbns.retiree%TYPE;
15: g_contact hri_person_type_cmbns.contact%TYPE;
16: g_srvivng_fmly_mbr hri_person_type_cmbns.surviving_family_member%TYPE;

Line 13: g_beneficiary hri_person_type_cmbns.beneficiary%TYPE;

9: g_intern hri_person_type_cmbns.intern%TYPE;
10: g_ex_employee hri_person_type_cmbns.ex_employee%TYPE;
11: g_ex_applicant hri_person_type_cmbns.ex_applicant%TYPE;
12: g_dependent hri_person_type_cmbns.dependent%TYPE;
13: g_beneficiary hri_person_type_cmbns.beneficiary%TYPE;
14: g_retiree hri_person_type_cmbns.retiree%TYPE;
15: g_contact hri_person_type_cmbns.contact%TYPE;
16: g_srvivng_fmly_mbr hri_person_type_cmbns.surviving_family_member%TYPE;
17: g_srvivng_spouse hri_person_type_cmbns.surviving_spouse%TYPE;

Line 14: g_retiree hri_person_type_cmbns.retiree%TYPE;

10: g_ex_employee hri_person_type_cmbns.ex_employee%TYPE;
11: g_ex_applicant hri_person_type_cmbns.ex_applicant%TYPE;
12: g_dependent hri_person_type_cmbns.dependent%TYPE;
13: g_beneficiary hri_person_type_cmbns.beneficiary%TYPE;
14: g_retiree hri_person_type_cmbns.retiree%TYPE;
15: g_contact hri_person_type_cmbns.contact%TYPE;
16: g_srvivng_fmly_mbr hri_person_type_cmbns.surviving_family_member%TYPE;
17: g_srvivng_spouse hri_person_type_cmbns.surviving_spouse%TYPE;
18: g_former_fmly_mbr hri_person_type_cmbns.former_family_member%TYPE;

Line 15: g_contact hri_person_type_cmbns.contact%TYPE;

11: g_ex_applicant hri_person_type_cmbns.ex_applicant%TYPE;
12: g_dependent hri_person_type_cmbns.dependent%TYPE;
13: g_beneficiary hri_person_type_cmbns.beneficiary%TYPE;
14: g_retiree hri_person_type_cmbns.retiree%TYPE;
15: g_contact hri_person_type_cmbns.contact%TYPE;
16: g_srvivng_fmly_mbr hri_person_type_cmbns.surviving_family_member%TYPE;
17: g_srvivng_spouse hri_person_type_cmbns.surviving_spouse%TYPE;
18: g_former_fmly_mbr hri_person_type_cmbns.former_family_member%TYPE;
19: g_former_spouse hri_person_type_cmbns.former_spouse%TYPE;

Line 16: g_srvivng_fmly_mbr hri_person_type_cmbns.surviving_family_member%TYPE;

12: g_dependent hri_person_type_cmbns.dependent%TYPE;
13: g_beneficiary hri_person_type_cmbns.beneficiary%TYPE;
14: g_retiree hri_person_type_cmbns.retiree%TYPE;
15: g_contact hri_person_type_cmbns.contact%TYPE;
16: g_srvivng_fmly_mbr hri_person_type_cmbns.surviving_family_member%TYPE;
17: g_srvivng_spouse hri_person_type_cmbns.surviving_spouse%TYPE;
18: g_former_fmly_mbr hri_person_type_cmbns.former_family_member%TYPE;
19: g_former_spouse hri_person_type_cmbns.former_spouse%TYPE;
20: g_other hri_person_type_cmbns.other%TYPE;

Line 17: g_srvivng_spouse hri_person_type_cmbns.surviving_spouse%TYPE;

13: g_beneficiary hri_person_type_cmbns.beneficiary%TYPE;
14: g_retiree hri_person_type_cmbns.retiree%TYPE;
15: g_contact hri_person_type_cmbns.contact%TYPE;
16: g_srvivng_fmly_mbr hri_person_type_cmbns.surviving_family_member%TYPE;
17: g_srvivng_spouse hri_person_type_cmbns.surviving_spouse%TYPE;
18: g_former_fmly_mbr hri_person_type_cmbns.former_family_member%TYPE;
19: g_former_spouse hri_person_type_cmbns.former_spouse%TYPE;
20: g_other hri_person_type_cmbns.other%TYPE;
21: g_participant hri_person_type_cmbns.participant%TYPE;

Line 18: g_former_fmly_mbr hri_person_type_cmbns.former_family_member%TYPE;

14: g_retiree hri_person_type_cmbns.retiree%TYPE;
15: g_contact hri_person_type_cmbns.contact%TYPE;
16: g_srvivng_fmly_mbr hri_person_type_cmbns.surviving_family_member%TYPE;
17: g_srvivng_spouse hri_person_type_cmbns.surviving_spouse%TYPE;
18: g_former_fmly_mbr hri_person_type_cmbns.former_family_member%TYPE;
19: g_former_spouse hri_person_type_cmbns.former_spouse%TYPE;
20: g_other hri_person_type_cmbns.other%TYPE;
21: g_participant hri_person_type_cmbns.participant%TYPE;
22: g_employee_student hri_person_type_cmbns.employee_student%TYPE;

Line 19: g_former_spouse hri_person_type_cmbns.former_spouse%TYPE;

15: g_contact hri_person_type_cmbns.contact%TYPE;
16: g_srvivng_fmly_mbr hri_person_type_cmbns.surviving_family_member%TYPE;
17: g_srvivng_spouse hri_person_type_cmbns.surviving_spouse%TYPE;
18: g_former_fmly_mbr hri_person_type_cmbns.former_family_member%TYPE;
19: g_former_spouse hri_person_type_cmbns.former_spouse%TYPE;
20: g_other hri_person_type_cmbns.other%TYPE;
21: g_participant hri_person_type_cmbns.participant%TYPE;
22: g_employee_student hri_person_type_cmbns.employee_student%TYPE;
23: g_consultant hri_person_type_cmbns.consultant%TYPE;

Line 20: g_other hri_person_type_cmbns.other%TYPE;

16: g_srvivng_fmly_mbr hri_person_type_cmbns.surviving_family_member%TYPE;
17: g_srvivng_spouse hri_person_type_cmbns.surviving_spouse%TYPE;
18: g_former_fmly_mbr hri_person_type_cmbns.former_family_member%TYPE;
19: g_former_spouse hri_person_type_cmbns.former_spouse%TYPE;
20: g_other hri_person_type_cmbns.other%TYPE;
21: g_participant hri_person_type_cmbns.participant%TYPE;
22: g_employee_student hri_person_type_cmbns.employee_student%TYPE;
23: g_consultant hri_person_type_cmbns.consultant%TYPE;
24: g_agency hri_person_type_cmbns.agency%TYPE;

Line 21: g_participant hri_person_type_cmbns.participant%TYPE;

17: g_srvivng_spouse hri_person_type_cmbns.surviving_spouse%TYPE;
18: g_former_fmly_mbr hri_person_type_cmbns.former_family_member%TYPE;
19: g_former_spouse hri_person_type_cmbns.former_spouse%TYPE;
20: g_other hri_person_type_cmbns.other%TYPE;
21: g_participant hri_person_type_cmbns.participant%TYPE;
22: g_employee_student hri_person_type_cmbns.employee_student%TYPE;
23: g_consultant hri_person_type_cmbns.consultant%TYPE;
24: g_agency hri_person_type_cmbns.agency%TYPE;
25: g_self_employed hri_person_type_cmbns.self_employed%TYPE;

Line 22: g_employee_student hri_person_type_cmbns.employee_student%TYPE;

18: g_former_fmly_mbr hri_person_type_cmbns.former_family_member%TYPE;
19: g_former_spouse hri_person_type_cmbns.former_spouse%TYPE;
20: g_other hri_person_type_cmbns.other%TYPE;
21: g_participant hri_person_type_cmbns.participant%TYPE;
22: g_employee_student hri_person_type_cmbns.employee_student%TYPE;
23: g_consultant hri_person_type_cmbns.consultant%TYPE;
24: g_agency hri_person_type_cmbns.agency%TYPE;
25: g_self_employed hri_person_type_cmbns.self_employed%TYPE;
26:

Line 23: g_consultant hri_person_type_cmbns.consultant%TYPE;

19: g_former_spouse hri_person_type_cmbns.former_spouse%TYPE;
20: g_other hri_person_type_cmbns.other%TYPE;
21: g_participant hri_person_type_cmbns.participant%TYPE;
22: g_employee_student hri_person_type_cmbns.employee_student%TYPE;
23: g_consultant hri_person_type_cmbns.consultant%TYPE;
24: g_agency hri_person_type_cmbns.agency%TYPE;
25: g_self_employed hri_person_type_cmbns.self_employed%TYPE;
26:
27:

Line 24: g_agency hri_person_type_cmbns.agency%TYPE;

20: g_other hri_person_type_cmbns.other%TYPE;
21: g_participant hri_person_type_cmbns.participant%TYPE;
22: g_employee_student hri_person_type_cmbns.employee_student%TYPE;
23: g_consultant hri_person_type_cmbns.consultant%TYPE;
24: g_agency hri_person_type_cmbns.agency%TYPE;
25: g_self_employed hri_person_type_cmbns.self_employed%TYPE;
26:
27:
28: /******************************************************************************/

Line 25: g_self_employed hri_person_type_cmbns.self_employed%TYPE;

21: g_participant hri_person_type_cmbns.participant%TYPE;
22: g_employee_student hri_person_type_cmbns.employee_student%TYPE;
23: g_consultant hri_person_type_cmbns.consultant%TYPE;
24: g_agency hri_person_type_cmbns.agency%TYPE;
25: g_self_employed hri_person_type_cmbns.self_employed%TYPE;
26:
27:
28: /******************************************************************************/
29: /* This procedure is used to build up a person type combination for a person. */

Line 237: FROM hri_person_type_cmbns

233: /* exists in the person type combinations table */
234: CURSOR row_exists_cur
235: (v_primary_key VARCHAR2) IS
236: SELECT 1
237: FROM hri_person_type_cmbns
238: WHERE person_type_pk = v_primary_key;
239:
240: /* Variable to hold the constructed person type primary key */
241: l_person_type_pk hri_person_type_cmbns.person_type_pk%TYPE;

Line 241: l_person_type_pk hri_person_type_cmbns.person_type_pk%TYPE;

237: FROM hri_person_type_cmbns
238: WHERE person_type_pk = v_primary_key;
239:
240: /* Variable to hold the constructed person type primary key */
241: l_person_type_pk hri_person_type_cmbns.person_type_pk%TYPE;
242:
243: /* Variables to hold information from cursors */
244: l_person_id per_all_people_f.person_id%TYPE;
245: l_effective_date per_all_people_f.effective_start_date%TYPE;

Line 262: INSERT INTO hri_person_type_cmbns

258: FETCH row_exists_cur INTO l_row_exists;
259:
260: IF (row_exists_cur%NOTFOUND OR row_exists_cur%NOTFOUND IS NULL) THEN
261:
262: INSERT INTO hri_person_type_cmbns
263: ( person_type_pk
264: , person_id
265: , effective_date
266: , employee