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_HRHD_RIR_WF dependencies on PER_ALL_PEOPLE_F

Line 731: p_person_id per_all_people_f.person_id%type;

727: is
728: p_event_key varchar2(100);
729: p_event_message WF_EVENT_T;
730: p_event_data clob;
731: p_person_id per_all_people_f.person_id%type;
732: p_person_data clob;
733: p_assignment_data clob;
734: p_unique_key number;
735: p_assignment_id number;

Line 853: p_person_id per_all_people_f.person_id%type;

849: p_event_key varchar2(100);
850: p_event_message WF_EVENT_T;
851: p_event_data clob;
852: p_person_data clob;
853: p_person_id per_all_people_f.person_id%type;
854: p_assignment_data clob;
855: p_unique_key number;
856: p_assignment_id number;
857: v_document dbms_xmldom.domdocument;

Line 976: p_person_id per_all_people_f.person_id%type;

972: p_event_key varchar2(100);
973: p_event_message WF_EVENT_T;
974: p_event_data clob;
975: p_person_data clob;
976: p_person_id per_all_people_f.person_id%type;
977: p_unique_key number;
978:
979: v_document dbms_xmldom.domdocument;
980: v_nodes dbms_xmldom.DOMNodeList;

Line 1093: p_person_id per_all_people_f.person_id%type;

1089: p_event_key varchar2(100);
1090: p_event_message WF_EVENT_T;
1091: p_event_data clob;
1092: p_person_data clob;
1093: p_person_id per_all_people_f.person_id%type;
1094: p_unique_key number;
1095:
1096: v_document dbms_xmldom.domdocument;
1097: v_nodes dbms_xmldom.DOMNodeList;

Line 1112: and PARENT_TABLE = 'PER_ALL_PEOPLE_F'

1108:
1109: cursor csr_person_id(p_phone_id varchar2,p_eff_date date)
1110: is select parent_id from per_phones
1111: where phone_id = p_phone_id
1112: and PARENT_TABLE = 'PER_ALL_PEOPLE_F'
1113: and p_eff_date between date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
1114:
1115: begin
1116:

Line 1548: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1

1544: to_char(nvl(date_to,trunc(sysdate)),''YYYY-MM-DD'') as "EFFECTIVE_DATE",
1545: ''I'' as "EFFECTIVE_STATUS",
1546: cursor(select language lang_code,name data from hr_all_organization_units_tl TL where tl.organization_id = org.organization_id) as "ORGANIZATIONNAME",
1547: ORG.LOCATION_ID as "LOCATION_ID",
1548: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1
1549: where ppf.person_id = hrorg1.ORG_INFORMATION2
1550: and ppf.business_group_id = org.business_group_id
1551: and hrorg1.org_information_context = ''Organization Name Alias''
1552: and hrorg1.organization_id = org.organization_id

Line 1572: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1

1568: to_char(DATE_FROM,''YYYY-MM-DD'') as "EFFECTIVE_DATE" ,
1569: ''A'' as "EFFECTIVE_STATUS" ,
1570: cursor(select language lang_code,name data from hr_all_organization_units_tl TL where tl.organization_id = org.organization_id) as "ORGANIZATIONNAME",
1571: ORG.LOCATION_ID as "LOCATION_ID",
1572: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1
1573: where ppf.person_id = hrorg1.ORG_INFORMATION2
1574: and ppf.business_group_id = org.business_group_id
1575: and hrorg1.org_information_context = ''Organization Name Alias''
1576: and hrorg1.organization_id = org.organization_id

Line 1691: FROM PER_ALL_PEOPLE_F ppf

1687: and language_code = USERENV(''LANG'') ) as "NATIONAL_IDENTIFIER_LABEL",
1688: hr_hrhd_initial_load.hr_hrhd_encrypt(:1) as "ENCRYPTED_PERSON_ID",
1689: hr_hrhd_initial_load.hr_hrhd_encrypt(ppf.business_group_id) as "ENCRYPTED_BUS_GRP_ID"
1690:
1691: FROM PER_ALL_PEOPLE_F ppf
1692: where ppf.person_id = :1
1693: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
1694:
1695: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);

Line 1753: FROM PER_ALL_PEOPLE_F ppf,per_addresses paddr

1749: and language_code = USERENV(''LANG'') ) as "NATIONAL_IDENTIFIER_LABEL",
1750: hr_hrhd_initial_load.hr_hrhd_encrypt(:1) as "ENCRYPTED_PERSON_ID",
1751: hr_hrhd_initial_load.hr_hrhd_encrypt(ppf.business_group_id) as "ENCRYPTED_BUS_GRP_ID"
1752:
1753: FROM PER_ALL_PEOPLE_F ppf,per_addresses paddr
1754: where ppf.person_id = :1
1755: and ppf.person_id = paddr.person_id
1756: and paddr.address_id = :4
1757: AND :2 between nvl(paddr.date_from,:2) and nvl(paddr.date_to,to_date(''31/12/4712'',''DD/MM/YYYY''))

Line 1820: FROM PER_ALL_PEOPLE_F ppf,per_phones ppn

1816: and language_code = USERENV(''LANG'') ) as "NATIONAL_IDENTIFIER_LABEL",
1817: hr_hrhd_initial_load.hr_hrhd_encrypt(:1) as "ENCRYPTED_PERSON_ID",
1818: hr_hrhd_initial_load.hr_hrhd_encrypt(ppf.business_group_id) as "ENCRYPTED_BUS_GRP_ID"
1819:
1820: FROM PER_ALL_PEOPLE_F ppf,per_phones ppn
1821: where ppf.person_id = :1
1822: and ppf.person_id = ppn.PARENT_ID
1823: and ppn.phone_id = :5
1824: AND PPN.PARENT_TABLE = ''PER_ALL_PEOPLE_F''

Line 1824: AND PPN.PARENT_TABLE = ''PER_ALL_PEOPLE_F''

1820: FROM PER_ALL_PEOPLE_F ppf,per_phones ppn
1821: where ppf.person_id = :1
1822: and ppf.person_id = ppn.PARENT_ID
1823: and ppn.phone_id = :5
1824: AND PPN.PARENT_TABLE = ''PER_ALL_PEOPLE_F''
1825: AND :2 between nvl(ppn.date_from,:2) and nvl(ppn.date_to,to_date(''31/12/4712'',''DD/MM/YYYY''))
1826: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
1827:
1828: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);

Line 2121: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;

2117: p_assignment_id per_all_assignments_f.assignment_id%type;
2118: p_assignment_number per_all_assignments_f.assignment_number%type;
2119: p_eff_start_date per_all_assignments_f.effective_start_date%type;
2120: p_eff_end_Date per_all_assignments_f.effective_end_date%type;
2121: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;
2122: p_probation_period per_all_assignments_f.probation_period%type;
2123: p_probation_units per_all_assignments_f.probation_unit%type;
2124: p_organization_id per_all_assignments_f.organization_id%type;
2125: p_job_id per_all_assignments_f.job_id%type;

Line 2143: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;

2139: p_assignment_id_t per_all_assignments_f.assignment_id%type;
2140: p_assignment_number_t per_all_assignments_f.assignment_number%type;
2141: p_eff_start_date_t per_all_assignments_f.effective_start_date%type;
2142: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;
2143: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;
2144: p_probation_period_t per_all_assignments_f.probation_period%type;
2145: p_probation_units_t per_all_assignments_f.probation_unit%type;
2146: p_organization_id_t per_all_assignments_f.organization_id%type;
2147: p_job_id_t per_all_assignments_f.job_id%type;

Line 2188: FROM per_all_people_f ppf,

2184: case when (pas.person_id = pos.person_id and pas.effective_end_date = pos.actual_termination_date)
2185: then to_char(pos.ACTUAL_TERMINATION_DATE,'YYYY-MM-DD')
2186: when (pas.person_id = pop.person_id and pas.effective_end_date = pop.actual_termination_date) then to_char(pop.ACTUAL_TERMINATION_DATE,'YYYY-MM-DD') end
2187:
2188: FROM per_all_people_f ppf,
2189: per_all_assignments_f pas,
2190: per_periods_of_service pos,
2191: per_periods_of_placement pop
2192: WHERE pas.assignment_id = p_ass_id

Line 2443: p_person_id per_all_people_f.person_id%type;

2439: p_date date;
2440: p_event_data clob;
2441:
2442: --data required for this
2443: p_person_id per_all_people_f.person_id%type;
2444: p_business_grp_id per_all_people_f.business_group_id%type;
2445: p_legislation_code varchar2(50);
2446: p_person_type_id per_all_people_f.person_type_id%type;
2447: p_emp_number per_all_people_f.employee_number%type;

Line 2444: p_business_grp_id per_all_people_f.business_group_id%type;

2440: p_event_data clob;
2441:
2442: --data required for this
2443: p_person_id per_all_people_f.person_id%type;
2444: p_business_grp_id per_all_people_f.business_group_id%type;
2445: p_legislation_code varchar2(50);
2446: p_person_type_id per_all_people_f.person_type_id%type;
2447: p_emp_number per_all_people_f.employee_number%type;
2448: p_applicant_number per_all_people_f.applicant_number%type;

Line 2446: p_person_type_id per_all_people_f.person_type_id%type;

2442: --data required for this
2443: p_person_id per_all_people_f.person_id%type;
2444: p_business_grp_id per_all_people_f.business_group_id%type;
2445: p_legislation_code varchar2(50);
2446: p_person_type_id per_all_people_f.person_type_id%type;
2447: p_emp_number per_all_people_f.employee_number%type;
2448: p_applicant_number per_all_people_f.applicant_number%type;
2449: p_npw_number per_all_people_f.npw_number%type;
2450: p_date_of_birth per_all_people_f.date_of_birth%type;

Line 2447: p_emp_number per_all_people_f.employee_number%type;

2443: p_person_id per_all_people_f.person_id%type;
2444: p_business_grp_id per_all_people_f.business_group_id%type;
2445: p_legislation_code varchar2(50);
2446: p_person_type_id per_all_people_f.person_type_id%type;
2447: p_emp_number per_all_people_f.employee_number%type;
2448: p_applicant_number per_all_people_f.applicant_number%type;
2449: p_npw_number per_all_people_f.npw_number%type;
2450: p_date_of_birth per_all_people_f.date_of_birth%type;
2451: p_town_of_birth per_all_people_f.town_of_birth%type;

Line 2448: p_applicant_number per_all_people_f.applicant_number%type;

2444: p_business_grp_id per_all_people_f.business_group_id%type;
2445: p_legislation_code varchar2(50);
2446: p_person_type_id per_all_people_f.person_type_id%type;
2447: p_emp_number per_all_people_f.employee_number%type;
2448: p_applicant_number per_all_people_f.applicant_number%type;
2449: p_npw_number per_all_people_f.npw_number%type;
2450: p_date_of_birth per_all_people_f.date_of_birth%type;
2451: p_town_of_birth per_all_people_f.town_of_birth%type;
2452: p_cntry_of_birth per_all_people_f.country_of_birth%type;

Line 2449: p_npw_number per_all_people_f.npw_number%type;

2445: p_legislation_code varchar2(50);
2446: p_person_type_id per_all_people_f.person_type_id%type;
2447: p_emp_number per_all_people_f.employee_number%type;
2448: p_applicant_number per_all_people_f.applicant_number%type;
2449: p_npw_number per_all_people_f.npw_number%type;
2450: p_date_of_birth per_all_people_f.date_of_birth%type;
2451: p_town_of_birth per_all_people_f.town_of_birth%type;
2452: p_cntry_of_birth per_all_people_f.country_of_birth%type;
2453: p_date_of_death per_all_people_f.date_of_death%type;

Line 2450: p_date_of_birth per_all_people_f.date_of_birth%type;

2446: p_person_type_id per_all_people_f.person_type_id%type;
2447: p_emp_number per_all_people_f.employee_number%type;
2448: p_applicant_number per_all_people_f.applicant_number%type;
2449: p_npw_number per_all_people_f.npw_number%type;
2450: p_date_of_birth per_all_people_f.date_of_birth%type;
2451: p_town_of_birth per_all_people_f.town_of_birth%type;
2452: p_cntry_of_birth per_all_people_f.country_of_birth%type;
2453: p_date_of_death per_all_people_f.date_of_death%type;
2454: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;

Line 2451: p_town_of_birth per_all_people_f.town_of_birth%type;

2447: p_emp_number per_all_people_f.employee_number%type;
2448: p_applicant_number per_all_people_f.applicant_number%type;
2449: p_npw_number per_all_people_f.npw_number%type;
2450: p_date_of_birth per_all_people_f.date_of_birth%type;
2451: p_town_of_birth per_all_people_f.town_of_birth%type;
2452: p_cntry_of_birth per_all_people_f.country_of_birth%type;
2453: p_date_of_death per_all_people_f.date_of_death%type;
2454: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;
2455: p_eff_st_dt per_all_people_f.effective_start_date%type;

Line 2452: p_cntry_of_birth per_all_people_f.country_of_birth%type;

2448: p_applicant_number per_all_people_f.applicant_number%type;
2449: p_npw_number per_all_people_f.npw_number%type;
2450: p_date_of_birth per_all_people_f.date_of_birth%type;
2451: p_town_of_birth per_all_people_f.town_of_birth%type;
2452: p_cntry_of_birth per_all_people_f.country_of_birth%type;
2453: p_date_of_death per_all_people_f.date_of_death%type;
2454: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;
2455: p_eff_st_dt per_all_people_f.effective_start_date%type;
2456: p_eff_end_dt per_all_people_f.effective_end_date%type;

Line 2453: p_date_of_death per_all_people_f.date_of_death%type;

2449: p_npw_number per_all_people_f.npw_number%type;
2450: p_date_of_birth per_all_people_f.date_of_birth%type;
2451: p_town_of_birth per_all_people_f.town_of_birth%type;
2452: p_cntry_of_birth per_all_people_f.country_of_birth%type;
2453: p_date_of_death per_all_people_f.date_of_death%type;
2454: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;
2455: p_eff_st_dt per_all_people_f.effective_start_date%type;
2456: p_eff_end_dt per_all_people_f.effective_end_date%type;
2457: p_sex per_all_people_f.sex%type;

Line 2454: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;

2450: p_date_of_birth per_all_people_f.date_of_birth%type;
2451: p_town_of_birth per_all_people_f.town_of_birth%type;
2452: p_cntry_of_birth per_all_people_f.country_of_birth%type;
2453: p_date_of_death per_all_people_f.date_of_death%type;
2454: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;
2455: p_eff_st_dt per_all_people_f.effective_start_date%type;
2456: p_eff_end_dt per_all_people_f.effective_end_date%type;
2457: p_sex per_all_people_f.sex%type;
2458: p_full_name per_all_people_f.full_name%type;

Line 2455: p_eff_st_dt per_all_people_f.effective_start_date%type;

2451: p_town_of_birth per_all_people_f.town_of_birth%type;
2452: p_cntry_of_birth per_all_people_f.country_of_birth%type;
2453: p_date_of_death per_all_people_f.date_of_death%type;
2454: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;
2455: p_eff_st_dt per_all_people_f.effective_start_date%type;
2456: p_eff_end_dt per_all_people_f.effective_end_date%type;
2457: p_sex per_all_people_f.sex%type;
2458: p_full_name per_all_people_f.full_name%type;
2459: p_suffix per_all_people_f.suffix%type;

Line 2456: p_eff_end_dt per_all_people_f.effective_end_date%type;

2452: p_cntry_of_birth per_all_people_f.country_of_birth%type;
2453: p_date_of_death per_all_people_f.date_of_death%type;
2454: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;
2455: p_eff_st_dt per_all_people_f.effective_start_date%type;
2456: p_eff_end_dt per_all_people_f.effective_end_date%type;
2457: p_sex per_all_people_f.sex%type;
2458: p_full_name per_all_people_f.full_name%type;
2459: p_suffix per_all_people_f.suffix%type;
2460: p_title per_all_people_f.title%type;

Line 2457: p_sex per_all_people_f.sex%type;

2453: p_date_of_death per_all_people_f.date_of_death%type;
2454: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;
2455: p_eff_st_dt per_all_people_f.effective_start_date%type;
2456: p_eff_end_dt per_all_people_f.effective_end_date%type;
2457: p_sex per_all_people_f.sex%type;
2458: p_full_name per_all_people_f.full_name%type;
2459: p_suffix per_all_people_f.suffix%type;
2460: p_title per_all_people_f.title%type;
2461: p_last_name per_all_people_f.last_name%type;

Line 2458: p_full_name per_all_people_f.full_name%type;

2454: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;
2455: p_eff_st_dt per_all_people_f.effective_start_date%type;
2456: p_eff_end_dt per_all_people_f.effective_end_date%type;
2457: p_sex per_all_people_f.sex%type;
2458: p_full_name per_all_people_f.full_name%type;
2459: p_suffix per_all_people_f.suffix%type;
2460: p_title per_all_people_f.title%type;
2461: p_last_name per_all_people_f.last_name%type;
2462: p_first_name per_all_people_f.first_name%type;

Line 2459: p_suffix per_all_people_f.suffix%type;

2455: p_eff_st_dt per_all_people_f.effective_start_date%type;
2456: p_eff_end_dt per_all_people_f.effective_end_date%type;
2457: p_sex per_all_people_f.sex%type;
2458: p_full_name per_all_people_f.full_name%type;
2459: p_suffix per_all_people_f.suffix%type;
2460: p_title per_all_people_f.title%type;
2461: p_last_name per_all_people_f.last_name%type;
2462: p_first_name per_all_people_f.first_name%type;
2463: p_middle_names per_all_people_f.middle_names%type;

Line 2460: p_title per_all_people_f.title%type;

2456: p_eff_end_dt per_all_people_f.effective_end_date%type;
2457: p_sex per_all_people_f.sex%type;
2458: p_full_name per_all_people_f.full_name%type;
2459: p_suffix per_all_people_f.suffix%type;
2460: p_title per_all_people_f.title%type;
2461: p_last_name per_all_people_f.last_name%type;
2462: p_first_name per_all_people_f.first_name%type;
2463: p_middle_names per_all_people_f.middle_names%type;
2464: p_nationality per_all_people_f.nationality%type;

Line 2461: p_last_name per_all_people_f.last_name%type;

2457: p_sex per_all_people_f.sex%type;
2458: p_full_name per_all_people_f.full_name%type;
2459: p_suffix per_all_people_f.suffix%type;
2460: p_title per_all_people_f.title%type;
2461: p_last_name per_all_people_f.last_name%type;
2462: p_first_name per_all_people_f.first_name%type;
2463: p_middle_names per_all_people_f.middle_names%type;
2464: p_nationality per_all_people_f.nationality%type;
2465: p_national_identifier per_all_people_f.national_identifier%type;

Line 2462: p_first_name per_all_people_f.first_name%type;

2458: p_full_name per_all_people_f.full_name%type;
2459: p_suffix per_all_people_f.suffix%type;
2460: p_title per_all_people_f.title%type;
2461: p_last_name per_all_people_f.last_name%type;
2462: p_first_name per_all_people_f.first_name%type;
2463: p_middle_names per_all_people_f.middle_names%type;
2464: p_nationality per_all_people_f.nationality%type;
2465: p_national_identifier per_all_people_f.national_identifier%type;
2466: p_email_address per_all_people_f.email_address%type;

Line 2463: p_middle_names per_all_people_f.middle_names%type;

2459: p_suffix per_all_people_f.suffix%type;
2460: p_title per_all_people_f.title%type;
2461: p_last_name per_all_people_f.last_name%type;
2462: p_first_name per_all_people_f.first_name%type;
2463: p_middle_names per_all_people_f.middle_names%type;
2464: p_nationality per_all_people_f.nationality%type;
2465: p_national_identifier per_all_people_f.national_identifier%type;
2466: p_email_address per_all_people_f.email_address%type;
2467:

Line 2464: p_nationality per_all_people_f.nationality%type;

2460: p_title per_all_people_f.title%type;
2461: p_last_name per_all_people_f.last_name%type;
2462: p_first_name per_all_people_f.first_name%type;
2463: p_middle_names per_all_people_f.middle_names%type;
2464: p_nationality per_all_people_f.nationality%type;
2465: p_national_identifier per_all_people_f.national_identifier%type;
2466: p_email_address per_all_people_f.email_address%type;
2467:
2468: --data required for this

Line 2465: p_national_identifier per_all_people_f.national_identifier%type;

2461: p_last_name per_all_people_f.last_name%type;
2462: p_first_name per_all_people_f.first_name%type;
2463: p_middle_names per_all_people_f.middle_names%type;
2464: p_nationality per_all_people_f.nationality%type;
2465: p_national_identifier per_all_people_f.national_identifier%type;
2466: p_email_address per_all_people_f.email_address%type;
2467:
2468: --data required for this
2469: p_business_grp_id_t per_all_people_f.business_group_id%type;

Line 2466: p_email_address per_all_people_f.email_address%type;

2462: p_first_name per_all_people_f.first_name%type;
2463: p_middle_names per_all_people_f.middle_names%type;
2464: p_nationality per_all_people_f.nationality%type;
2465: p_national_identifier per_all_people_f.national_identifier%type;
2466: p_email_address per_all_people_f.email_address%type;
2467:
2468: --data required for this
2469: p_business_grp_id_t per_all_people_f.business_group_id%type;
2470: p_person_type_id_t per_all_people_f.person_type_id%type;

Line 2469: p_business_grp_id_t per_all_people_f.business_group_id%type;

2465: p_national_identifier per_all_people_f.national_identifier%type;
2466: p_email_address per_all_people_f.email_address%type;
2467:
2468: --data required for this
2469: p_business_grp_id_t per_all_people_f.business_group_id%type;
2470: p_person_type_id_t per_all_people_f.person_type_id%type;
2471: p_emp_number_t per_all_people_f.employee_number%type;
2472: p_applicant_number_t per_all_people_f.applicant_number%type;
2473: p_npw_number_t per_all_people_f.npw_number%type;

Line 2470: p_person_type_id_t per_all_people_f.person_type_id%type;

2466: p_email_address per_all_people_f.email_address%type;
2467:
2468: --data required for this
2469: p_business_grp_id_t per_all_people_f.business_group_id%type;
2470: p_person_type_id_t per_all_people_f.person_type_id%type;
2471: p_emp_number_t per_all_people_f.employee_number%type;
2472: p_applicant_number_t per_all_people_f.applicant_number%type;
2473: p_npw_number_t per_all_people_f.npw_number%type;
2474: p_date_of_birth_t per_all_people_f.date_of_birth%type;

Line 2471: p_emp_number_t per_all_people_f.employee_number%type;

2467:
2468: --data required for this
2469: p_business_grp_id_t per_all_people_f.business_group_id%type;
2470: p_person_type_id_t per_all_people_f.person_type_id%type;
2471: p_emp_number_t per_all_people_f.employee_number%type;
2472: p_applicant_number_t per_all_people_f.applicant_number%type;
2473: p_npw_number_t per_all_people_f.npw_number%type;
2474: p_date_of_birth_t per_all_people_f.date_of_birth%type;
2475: p_town_of_birth_t per_all_people_f.town_of_birth%type;

Line 2472: p_applicant_number_t per_all_people_f.applicant_number%type;

2468: --data required for this
2469: p_business_grp_id_t per_all_people_f.business_group_id%type;
2470: p_person_type_id_t per_all_people_f.person_type_id%type;
2471: p_emp_number_t per_all_people_f.employee_number%type;
2472: p_applicant_number_t per_all_people_f.applicant_number%type;
2473: p_npw_number_t per_all_people_f.npw_number%type;
2474: p_date_of_birth_t per_all_people_f.date_of_birth%type;
2475: p_town_of_birth_t per_all_people_f.town_of_birth%type;
2476: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;

Line 2473: p_npw_number_t per_all_people_f.npw_number%type;

2469: p_business_grp_id_t per_all_people_f.business_group_id%type;
2470: p_person_type_id_t per_all_people_f.person_type_id%type;
2471: p_emp_number_t per_all_people_f.employee_number%type;
2472: p_applicant_number_t per_all_people_f.applicant_number%type;
2473: p_npw_number_t per_all_people_f.npw_number%type;
2474: p_date_of_birth_t per_all_people_f.date_of_birth%type;
2475: p_town_of_birth_t per_all_people_f.town_of_birth%type;
2476: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;
2477: p_date_of_death_t per_all_people_f.date_of_death%type;

Line 2474: p_date_of_birth_t per_all_people_f.date_of_birth%type;

2470: p_person_type_id_t per_all_people_f.person_type_id%type;
2471: p_emp_number_t per_all_people_f.employee_number%type;
2472: p_applicant_number_t per_all_people_f.applicant_number%type;
2473: p_npw_number_t per_all_people_f.npw_number%type;
2474: p_date_of_birth_t per_all_people_f.date_of_birth%type;
2475: p_town_of_birth_t per_all_people_f.town_of_birth%type;
2476: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;
2477: p_date_of_death_t per_all_people_f.date_of_death%type;
2478: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;

Line 2475: p_town_of_birth_t per_all_people_f.town_of_birth%type;

2471: p_emp_number_t per_all_people_f.employee_number%type;
2472: p_applicant_number_t per_all_people_f.applicant_number%type;
2473: p_npw_number_t per_all_people_f.npw_number%type;
2474: p_date_of_birth_t per_all_people_f.date_of_birth%type;
2475: p_town_of_birth_t per_all_people_f.town_of_birth%type;
2476: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;
2477: p_date_of_death_t per_all_people_f.date_of_death%type;
2478: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;
2479: p_eff_st_dt_t per_all_people_f.effective_start_date%type;

Line 2476: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;

2472: p_applicant_number_t per_all_people_f.applicant_number%type;
2473: p_npw_number_t per_all_people_f.npw_number%type;
2474: p_date_of_birth_t per_all_people_f.date_of_birth%type;
2475: p_town_of_birth_t per_all_people_f.town_of_birth%type;
2476: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;
2477: p_date_of_death_t per_all_people_f.date_of_death%type;
2478: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;
2479: p_eff_st_dt_t per_all_people_f.effective_start_date%type;
2480: p_eff_end_dt_t per_all_people_f.effective_end_date%type;

Line 2477: p_date_of_death_t per_all_people_f.date_of_death%type;

2473: p_npw_number_t per_all_people_f.npw_number%type;
2474: p_date_of_birth_t per_all_people_f.date_of_birth%type;
2475: p_town_of_birth_t per_all_people_f.town_of_birth%type;
2476: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;
2477: p_date_of_death_t per_all_people_f.date_of_death%type;
2478: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;
2479: p_eff_st_dt_t per_all_people_f.effective_start_date%type;
2480: p_eff_end_dt_t per_all_people_f.effective_end_date%type;
2481: p_sex_t per_all_people_f.sex%type;

Line 2478: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;

2474: p_date_of_birth_t per_all_people_f.date_of_birth%type;
2475: p_town_of_birth_t per_all_people_f.town_of_birth%type;
2476: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;
2477: p_date_of_death_t per_all_people_f.date_of_death%type;
2478: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;
2479: p_eff_st_dt_t per_all_people_f.effective_start_date%type;
2480: p_eff_end_dt_t per_all_people_f.effective_end_date%type;
2481: p_sex_t per_all_people_f.sex%type;
2482: p_full_name_t per_all_people_f.full_name%type;

Line 2479: p_eff_st_dt_t per_all_people_f.effective_start_date%type;

2475: p_town_of_birth_t per_all_people_f.town_of_birth%type;
2476: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;
2477: p_date_of_death_t per_all_people_f.date_of_death%type;
2478: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;
2479: p_eff_st_dt_t per_all_people_f.effective_start_date%type;
2480: p_eff_end_dt_t per_all_people_f.effective_end_date%type;
2481: p_sex_t per_all_people_f.sex%type;
2482: p_full_name_t per_all_people_f.full_name%type;
2483: p_suffix_t per_all_people_f.suffix%type;

Line 2480: p_eff_end_dt_t per_all_people_f.effective_end_date%type;

2476: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;
2477: p_date_of_death_t per_all_people_f.date_of_death%type;
2478: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;
2479: p_eff_st_dt_t per_all_people_f.effective_start_date%type;
2480: p_eff_end_dt_t per_all_people_f.effective_end_date%type;
2481: p_sex_t per_all_people_f.sex%type;
2482: p_full_name_t per_all_people_f.full_name%type;
2483: p_suffix_t per_all_people_f.suffix%type;
2484: p_title_t per_all_people_f.title%type;

Line 2481: p_sex_t per_all_people_f.sex%type;

2477: p_date_of_death_t per_all_people_f.date_of_death%type;
2478: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;
2479: p_eff_st_dt_t per_all_people_f.effective_start_date%type;
2480: p_eff_end_dt_t per_all_people_f.effective_end_date%type;
2481: p_sex_t per_all_people_f.sex%type;
2482: p_full_name_t per_all_people_f.full_name%type;
2483: p_suffix_t per_all_people_f.suffix%type;
2484: p_title_t per_all_people_f.title%type;
2485: p_last_name_t per_all_people_f.last_name%type;

Line 2482: p_full_name_t per_all_people_f.full_name%type;

2478: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;
2479: p_eff_st_dt_t per_all_people_f.effective_start_date%type;
2480: p_eff_end_dt_t per_all_people_f.effective_end_date%type;
2481: p_sex_t per_all_people_f.sex%type;
2482: p_full_name_t per_all_people_f.full_name%type;
2483: p_suffix_t per_all_people_f.suffix%type;
2484: p_title_t per_all_people_f.title%type;
2485: p_last_name_t per_all_people_f.last_name%type;
2486: p_first_name_t per_all_people_f.first_name%type;

Line 2483: p_suffix_t per_all_people_f.suffix%type;

2479: p_eff_st_dt_t per_all_people_f.effective_start_date%type;
2480: p_eff_end_dt_t per_all_people_f.effective_end_date%type;
2481: p_sex_t per_all_people_f.sex%type;
2482: p_full_name_t per_all_people_f.full_name%type;
2483: p_suffix_t per_all_people_f.suffix%type;
2484: p_title_t per_all_people_f.title%type;
2485: p_last_name_t per_all_people_f.last_name%type;
2486: p_first_name_t per_all_people_f.first_name%type;
2487: p_middle_names_t per_all_people_f.middle_names%type;

Line 2484: p_title_t per_all_people_f.title%type;

2480: p_eff_end_dt_t per_all_people_f.effective_end_date%type;
2481: p_sex_t per_all_people_f.sex%type;
2482: p_full_name_t per_all_people_f.full_name%type;
2483: p_suffix_t per_all_people_f.suffix%type;
2484: p_title_t per_all_people_f.title%type;
2485: p_last_name_t per_all_people_f.last_name%type;
2486: p_first_name_t per_all_people_f.first_name%type;
2487: p_middle_names_t per_all_people_f.middle_names%type;
2488: p_nationality_t per_all_people_f.nationality%type;

Line 2485: p_last_name_t per_all_people_f.last_name%type;

2481: p_sex_t per_all_people_f.sex%type;
2482: p_full_name_t per_all_people_f.full_name%type;
2483: p_suffix_t per_all_people_f.suffix%type;
2484: p_title_t per_all_people_f.title%type;
2485: p_last_name_t per_all_people_f.last_name%type;
2486: p_first_name_t per_all_people_f.first_name%type;
2487: p_middle_names_t per_all_people_f.middle_names%type;
2488: p_nationality_t per_all_people_f.nationality%type;
2489: p_national_identifier_t per_all_people_f.national_identifier%type;

Line 2486: p_first_name_t per_all_people_f.first_name%type;

2482: p_full_name_t per_all_people_f.full_name%type;
2483: p_suffix_t per_all_people_f.suffix%type;
2484: p_title_t per_all_people_f.title%type;
2485: p_last_name_t per_all_people_f.last_name%type;
2486: p_first_name_t per_all_people_f.first_name%type;
2487: p_middle_names_t per_all_people_f.middle_names%type;
2488: p_nationality_t per_all_people_f.nationality%type;
2489: p_national_identifier_t per_all_people_f.national_identifier%type;
2490: p_email_address_t per_all_people_f.email_address%type;

Line 2487: p_middle_names_t per_all_people_f.middle_names%type;

2483: p_suffix_t per_all_people_f.suffix%type;
2484: p_title_t per_all_people_f.title%type;
2485: p_last_name_t per_all_people_f.last_name%type;
2486: p_first_name_t per_all_people_f.first_name%type;
2487: p_middle_names_t per_all_people_f.middle_names%type;
2488: p_nationality_t per_all_people_f.nationality%type;
2489: p_national_identifier_t per_all_people_f.national_identifier%type;
2490: p_email_address_t per_all_people_f.email_address%type;
2491:

Line 2488: p_nationality_t per_all_people_f.nationality%type;

2484: p_title_t per_all_people_f.title%type;
2485: p_last_name_t per_all_people_f.last_name%type;
2486: p_first_name_t per_all_people_f.first_name%type;
2487: p_middle_names_t per_all_people_f.middle_names%type;
2488: p_nationality_t per_all_people_f.nationality%type;
2489: p_national_identifier_t per_all_people_f.national_identifier%type;
2490: p_email_address_t per_all_people_f.email_address%type;
2491:
2492: /*Cursor to fetch the person details*/

Line 2489: p_national_identifier_t per_all_people_f.national_identifier%type;

2485: p_last_name_t per_all_people_f.last_name%type;
2486: p_first_name_t per_all_people_f.first_name%type;
2487: p_middle_names_t per_all_people_f.middle_names%type;
2488: p_nationality_t per_all_people_f.nationality%type;
2489: p_national_identifier_t per_all_people_f.national_identifier%type;
2490: p_email_address_t per_all_people_f.email_address%type;
2491:
2492: /*Cursor to fetch the person details*/
2493:

Line 2490: p_email_address_t per_all_people_f.email_address%type;

2486: p_first_name_t per_all_people_f.first_name%type;
2487: p_middle_names_t per_all_people_f.middle_names%type;
2488: p_nationality_t per_all_people_f.nationality%type;
2489: p_national_identifier_t per_all_people_f.national_identifier%type;
2490: p_email_address_t per_all_people_f.email_address%type;
2491:
2492: /*Cursor to fetch the person details*/
2493:
2494: cursor csr_person_data(p_person_id number,p_eff_st_date date) is

Line 2519: FROM PER_ALL_PEOPLE_F ppf

2515: NATIONALITY,
2516: NATIONAL_IDENTIFIER,
2517: EMAIL_ADDRESS
2518:
2519: FROM PER_ALL_PEOPLE_F ppf
2520: where person_id = p_person_id
2521: and p_eff_st_date between effective_start_date and effective_end_date;
2522:
2523:

Line 2786: p_person_id per_all_people_f.person_id%type;

2782: p_person_op_flag varchar2(5);
2783: p_unique_key number;
2784: p_date date;
2785: p_event_data clob;
2786: p_person_id per_all_people_f.person_id%type;
2787:
2788: p_address_id per_addresses.address_id%type;
2789: p_address_type per_addresses.address_type%type;
2790: p_addr_date_from per_addresses.date_from%type;

Line 3007: p_person_id per_all_people_f.person_id%type;

3003: p_person_op_flag varchar2(5);
3004: p_unique_key number;
3005: p_date date;
3006: p_event_data clob;
3007: p_person_id per_all_people_f.person_id%type;
3008:
3009: p_phone_id per_phones.phone_id%type;
3010: p_phn_date_from per_phones.date_from%type;
3011: p_phn_date_to per_phones.date_to%type;

Line 3028: AND PPN.PARENT_TABLE = 'PER_ALL_PEOPLE_F'

3024: PHONE_TYPE,
3025: PHONE_NUMBER
3026: FROM per_phones ppn
3027: where ppn.PARENT_ID = P_PERSON_ID
3028: AND PPN.PARENT_TABLE = 'PER_ALL_PEOPLE_F'
3029: and P_Eff_St_Dt between date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
3030:
3031: v_document dbms_xmldom.domdocument;
3032: v_nodes dbms_xmldom.DOMNodeList;