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 735: p_person_id per_all_people_f.person_id%type;

731: is
732: p_event_key varchar2(100);
733: p_event_message WF_EVENT_T;
734: p_event_data clob;
735: p_person_id per_all_people_f.person_id%type;
736: p_person_data clob;
737: p_assignment_data clob;
738: p_unique_key number;
739: p_assignment_id number;

Line 911: p_person_id per_all_people_f.person_id%type;

907: p_event_key varchar2(100);
908: p_event_message WF_EVENT_T;
909: p_event_data clob;
910: p_person_data clob;
911: p_person_id per_all_people_f.person_id%type;
912: p_unique_key number;
913: v_document dbms_xmldom.domdocument;
914: v_nodes dbms_xmldom.DOMNodeList;
915: v_element_x dbms_xmldom.DOMElement;

Line 1126: p_person_id per_all_people_f.person_id%type;

1122: p_event_key varchar2(100);
1123: p_event_message WF_EVENT_T;
1124: p_event_data clob;
1125: p_person_data clob;
1126: p_person_id per_all_people_f.person_id%type;
1127: p_unique_key number;
1128:
1129: v_document dbms_xmldom.domdocument;
1130: v_nodes dbms_xmldom.DOMNodeList;

Line 1250: p_person_id per_all_people_f.person_id%type;

1246: p_event_key varchar2(100);
1247: p_event_message WF_EVENT_T;
1248: p_event_data clob;
1249: p_person_data clob;
1250: p_person_id per_all_people_f.person_id%type;
1251: p_unique_key number;
1252:
1253: v_document dbms_xmldom.domdocument;
1254: v_nodes dbms_xmldom.DOMNodeList;

Line 1272: and PARENT_TABLE = 'PER_ALL_PEOPLE_F'

1268:
1269: cursor csr_person_id(p_phone_id varchar2,p_eff_date date)
1270: is select parent_id from per_phones
1271: where phone_id = p_phone_id
1272: and PARENT_TABLE = 'PER_ALL_PEOPLE_F'
1273: and p_eff_date between date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
1274:
1275: begin
1276:

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

1724: to_char(nvl(date_to,trunc(sysdate)),''YYYY-MM-DD'') as "EFFECTIVE_DATE",
1725: ''I'' as "EFFECTIVE_STATUS",
1726: cursor(select language lang_code,name data from hr_all_organization_units_tl TL where tl.organization_id = org.organization_id) as "ORGANIZATIONNAME",
1727: ORG.LOCATION_ID as "LOCATION_ID",
1728: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1
1729: where ppf.person_id = hrorg1.ORG_INFORMATION2
1730: and ppf.business_group_id = org.business_group_id
1731: and hrorg1.org_information_context = ''Organization Name Alias''
1732: and hrorg1.organization_id = org.organization_id

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

1748: to_char(DATE_FROM,''YYYY-MM-DD'') as "EFFECTIVE_DATE" ,
1749: ''A'' as "EFFECTIVE_STATUS" ,
1750: cursor(select language lang_code,name data from hr_all_organization_units_tl TL where tl.organization_id = org.organization_id) as "ORGANIZATIONNAME",
1751: ORG.LOCATION_ID as "LOCATION_ID",
1752: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1
1753: where ppf.person_id = hrorg1.ORG_INFORMATION2
1754: and ppf.business_group_id = org.business_group_id
1755: and hrorg1.org_information_context = ''Organization Name Alias''
1756: and hrorg1.organization_id = org.organization_id

Line 1872: FROM PER_ALL_PEOPLE_F ppf

1868: and language_code = USERENV(''LANG'') ) as "NATIONAL_IDENTIFIER_LABEL",
1869: hr_hrhd_initial_load.hr_hrhd_encrypt(:1) as "ENCRYPTED_PERSON_ID",
1870: hr_hrhd_initial_load.hr_hrhd_encrypt(ppf.business_group_id) as "ENCRYPTED_BUS_GRP_ID"
1871:
1872: FROM PER_ALL_PEOPLE_F ppf
1873: where ppf.person_id = :1
1874: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
1875:
1876: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);

Line 1935: FROM PER_ALL_PEOPLE_F ppf,per_addresses paddr

1931: and language_code = USERENV(''LANG'') ) as "NATIONAL_IDENTIFIER_LABEL",
1932: hr_hrhd_initial_load.hr_hrhd_encrypt(:1) as "ENCRYPTED_PERSON_ID",
1933: hr_hrhd_initial_load.hr_hrhd_encrypt(ppf.business_group_id) as "ENCRYPTED_BUS_GRP_ID"
1934:
1935: FROM PER_ALL_PEOPLE_F ppf,per_addresses paddr
1936: where ppf.person_id = :1
1937: and ppf.person_id = paddr.person_id
1938: and paddr.address_id = :4
1939: AND :2 between nvl(paddr.date_from,:2) and nvl(paddr.date_to,to_date(''31/12/4712'',''DD/MM/YYYY''))

Line 2003: FROM PER_ALL_PEOPLE_F ppf,per_phones ppn

1999: and language_code = USERENV(''LANG'') ) as "NATIONAL_IDENTIFIER_LABEL",
2000: hr_hrhd_initial_load.hr_hrhd_encrypt(:1) as "ENCRYPTED_PERSON_ID",
2001: hr_hrhd_initial_load.hr_hrhd_encrypt(ppf.business_group_id) as "ENCRYPTED_BUS_GRP_ID"
2002:
2003: FROM PER_ALL_PEOPLE_F ppf,per_phones ppn
2004: where ppf.person_id = :1
2005: and ppf.person_id = ppn.PARENT_ID
2006: and ppn.phone_id = :5
2007: AND PPN.PARENT_TABLE = ''PER_ALL_PEOPLE_F''

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

2003: FROM PER_ALL_PEOPLE_F ppf,per_phones ppn
2004: where ppf.person_id = :1
2005: and ppf.person_id = ppn.PARENT_ID
2006: and ppn.phone_id = :5
2007: AND PPN.PARENT_TABLE = ''PER_ALL_PEOPLE_F''
2008: AND :2 between nvl(ppn.date_from,:2) and nvl(ppn.date_to,to_date(''31/12/4712'',''DD/MM/YYYY''))
2009: AND :2 between ppf.effective_start_date and nvl(ppf.effective_end_date,to_date(''31/12/4712'',''DD/MM/YYYY''))');
2010:
2011: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_person_id);

Line 2304: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;

2300: p_assignment_id per_all_assignments_f.assignment_id%type;
2301: p_assignment_number per_all_assignments_f.assignment_number%type;
2302: p_eff_start_date per_all_assignments_f.effective_start_date%type;
2303: p_eff_end_Date per_all_assignments_f.effective_end_date%type;
2304: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;
2305: p_probation_period per_all_assignments_f.probation_period%type;
2306: p_probation_units per_all_assignments_f.probation_unit%type;
2307: p_organization_id per_all_assignments_f.organization_id%type;
2308: p_job_id per_all_assignments_f.job_id%type;

Line 2327: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;

2323: p_assignment_id_t per_all_assignments_f.assignment_id%type;
2324: p_assignment_number_t per_all_assignments_f.assignment_number%type;
2325: p_eff_start_date_t per_all_assignments_f.effective_start_date%type;
2326: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;
2327: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;
2328: p_probation_period_t per_all_assignments_f.probation_period%type;
2329: p_probation_units_t per_all_assignments_f.probation_unit%type;
2330: p_organization_id_t per_all_assignments_f.organization_id%type;
2331: p_job_id_t per_all_assignments_f.job_id%type;

Line 2378: FROM per_all_people_f ppf,

2374: 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 ,
2375:
2376: primary_flag
2377:
2378: FROM per_all_people_f ppf,
2379: per_all_assignments_f pas,
2380: per_periods_of_service pos,
2381: per_periods_of_placement pop
2382: WHERE pas.assignment_id = p_ass_id

Line 2646: p_person_id per_all_people_f.person_id%type;

2642: p_date date;
2643: p_event_data clob;
2644:
2645: --data required for this
2646: p_person_id per_all_people_f.person_id%type;
2647: p_business_grp_id per_all_people_f.business_group_id%type;
2648: p_legislation_code varchar2(50);
2649: p_person_type_id per_all_people_f.person_type_id%type;
2650: p_emp_number per_all_people_f.employee_number%type;

Line 2647: p_business_grp_id per_all_people_f.business_group_id%type;

2643: p_event_data clob;
2644:
2645: --data required for this
2646: p_person_id per_all_people_f.person_id%type;
2647: p_business_grp_id per_all_people_f.business_group_id%type;
2648: p_legislation_code varchar2(50);
2649: p_person_type_id per_all_people_f.person_type_id%type;
2650: p_emp_number per_all_people_f.employee_number%type;
2651: p_applicant_number per_all_people_f.applicant_number%type;

Line 2649: p_person_type_id per_all_people_f.person_type_id%type;

2645: --data required for this
2646: p_person_id per_all_people_f.person_id%type;
2647: p_business_grp_id per_all_people_f.business_group_id%type;
2648: p_legislation_code varchar2(50);
2649: p_person_type_id per_all_people_f.person_type_id%type;
2650: p_emp_number per_all_people_f.employee_number%type;
2651: p_applicant_number per_all_people_f.applicant_number%type;
2652: p_npw_number per_all_people_f.npw_number%type;
2653: p_date_of_birth per_all_people_f.date_of_birth%type;

Line 2650: p_emp_number per_all_people_f.employee_number%type;

2646: p_person_id per_all_people_f.person_id%type;
2647: p_business_grp_id per_all_people_f.business_group_id%type;
2648: p_legislation_code varchar2(50);
2649: p_person_type_id per_all_people_f.person_type_id%type;
2650: p_emp_number per_all_people_f.employee_number%type;
2651: p_applicant_number per_all_people_f.applicant_number%type;
2652: p_npw_number per_all_people_f.npw_number%type;
2653: p_date_of_birth per_all_people_f.date_of_birth%type;
2654: p_town_of_birth per_all_people_f.town_of_birth%type;

Line 2651: p_applicant_number per_all_people_f.applicant_number%type;

2647: p_business_grp_id per_all_people_f.business_group_id%type;
2648: p_legislation_code varchar2(50);
2649: p_person_type_id per_all_people_f.person_type_id%type;
2650: p_emp_number per_all_people_f.employee_number%type;
2651: p_applicant_number per_all_people_f.applicant_number%type;
2652: p_npw_number per_all_people_f.npw_number%type;
2653: p_date_of_birth per_all_people_f.date_of_birth%type;
2654: p_town_of_birth per_all_people_f.town_of_birth%type;
2655: p_cntry_of_birth per_all_people_f.country_of_birth%type;

Line 2652: p_npw_number per_all_people_f.npw_number%type;

2648: p_legislation_code varchar2(50);
2649: p_person_type_id per_all_people_f.person_type_id%type;
2650: p_emp_number per_all_people_f.employee_number%type;
2651: p_applicant_number per_all_people_f.applicant_number%type;
2652: p_npw_number per_all_people_f.npw_number%type;
2653: p_date_of_birth per_all_people_f.date_of_birth%type;
2654: p_town_of_birth per_all_people_f.town_of_birth%type;
2655: p_cntry_of_birth per_all_people_f.country_of_birth%type;
2656: p_date_of_death per_all_people_f.date_of_death%type;

Line 2653: p_date_of_birth per_all_people_f.date_of_birth%type;

2649: p_person_type_id per_all_people_f.person_type_id%type;
2650: p_emp_number per_all_people_f.employee_number%type;
2651: p_applicant_number per_all_people_f.applicant_number%type;
2652: p_npw_number per_all_people_f.npw_number%type;
2653: p_date_of_birth per_all_people_f.date_of_birth%type;
2654: p_town_of_birth per_all_people_f.town_of_birth%type;
2655: p_cntry_of_birth per_all_people_f.country_of_birth%type;
2656: p_date_of_death per_all_people_f.date_of_death%type;
2657: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;

Line 2654: p_town_of_birth per_all_people_f.town_of_birth%type;

2650: p_emp_number per_all_people_f.employee_number%type;
2651: p_applicant_number per_all_people_f.applicant_number%type;
2652: p_npw_number per_all_people_f.npw_number%type;
2653: p_date_of_birth per_all_people_f.date_of_birth%type;
2654: p_town_of_birth per_all_people_f.town_of_birth%type;
2655: p_cntry_of_birth per_all_people_f.country_of_birth%type;
2656: p_date_of_death per_all_people_f.date_of_death%type;
2657: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;
2658: p_eff_st_dt per_all_people_f.effective_start_date%type;

Line 2655: p_cntry_of_birth per_all_people_f.country_of_birth%type;

2651: p_applicant_number per_all_people_f.applicant_number%type;
2652: p_npw_number per_all_people_f.npw_number%type;
2653: p_date_of_birth per_all_people_f.date_of_birth%type;
2654: p_town_of_birth per_all_people_f.town_of_birth%type;
2655: p_cntry_of_birth per_all_people_f.country_of_birth%type;
2656: p_date_of_death per_all_people_f.date_of_death%type;
2657: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;
2658: p_eff_st_dt per_all_people_f.effective_start_date%type;
2659: p_eff_end_dt per_all_people_f.effective_end_date%type;

Line 2656: p_date_of_death per_all_people_f.date_of_death%type;

2652: p_npw_number per_all_people_f.npw_number%type;
2653: p_date_of_birth per_all_people_f.date_of_birth%type;
2654: p_town_of_birth per_all_people_f.town_of_birth%type;
2655: p_cntry_of_birth per_all_people_f.country_of_birth%type;
2656: p_date_of_death per_all_people_f.date_of_death%type;
2657: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;
2658: p_eff_st_dt per_all_people_f.effective_start_date%type;
2659: p_eff_end_dt per_all_people_f.effective_end_date%type;
2660: p_sex per_all_people_f.sex%type;

Line 2657: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;

2653: p_date_of_birth per_all_people_f.date_of_birth%type;
2654: p_town_of_birth per_all_people_f.town_of_birth%type;
2655: p_cntry_of_birth per_all_people_f.country_of_birth%type;
2656: p_date_of_death per_all_people_f.date_of_death%type;
2657: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;
2658: p_eff_st_dt per_all_people_f.effective_start_date%type;
2659: p_eff_end_dt per_all_people_f.effective_end_date%type;
2660: p_sex per_all_people_f.sex%type;
2661: p_full_name per_all_people_f.full_name%type;

Line 2658: p_eff_st_dt per_all_people_f.effective_start_date%type;

2654: p_town_of_birth per_all_people_f.town_of_birth%type;
2655: p_cntry_of_birth per_all_people_f.country_of_birth%type;
2656: p_date_of_death per_all_people_f.date_of_death%type;
2657: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;
2658: p_eff_st_dt per_all_people_f.effective_start_date%type;
2659: p_eff_end_dt per_all_people_f.effective_end_date%type;
2660: p_sex per_all_people_f.sex%type;
2661: p_full_name per_all_people_f.full_name%type;
2662: p_suffix per_all_people_f.suffix%type;

Line 2659: p_eff_end_dt per_all_people_f.effective_end_date%type;

2655: p_cntry_of_birth per_all_people_f.country_of_birth%type;
2656: p_date_of_death per_all_people_f.date_of_death%type;
2657: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;
2658: p_eff_st_dt per_all_people_f.effective_start_date%type;
2659: p_eff_end_dt per_all_people_f.effective_end_date%type;
2660: p_sex per_all_people_f.sex%type;
2661: p_full_name per_all_people_f.full_name%type;
2662: p_suffix per_all_people_f.suffix%type;
2663: p_title per_all_people_f.title%type;

Line 2660: p_sex per_all_people_f.sex%type;

2656: p_date_of_death per_all_people_f.date_of_death%type;
2657: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;
2658: p_eff_st_dt per_all_people_f.effective_start_date%type;
2659: p_eff_end_dt per_all_people_f.effective_end_date%type;
2660: p_sex per_all_people_f.sex%type;
2661: p_full_name per_all_people_f.full_name%type;
2662: p_suffix per_all_people_f.suffix%type;
2663: p_title per_all_people_f.title%type;
2664: p_last_name per_all_people_f.last_name%type;

Line 2661: p_full_name per_all_people_f.full_name%type;

2657: p_orgnl_dt_of_hire per_all_people_f.original_date_of_hire%type;
2658: p_eff_st_dt per_all_people_f.effective_start_date%type;
2659: p_eff_end_dt per_all_people_f.effective_end_date%type;
2660: p_sex per_all_people_f.sex%type;
2661: p_full_name per_all_people_f.full_name%type;
2662: p_suffix per_all_people_f.suffix%type;
2663: p_title per_all_people_f.title%type;
2664: p_last_name per_all_people_f.last_name%type;
2665: p_first_name per_all_people_f.first_name%type;

Line 2662: p_suffix per_all_people_f.suffix%type;

2658: p_eff_st_dt per_all_people_f.effective_start_date%type;
2659: p_eff_end_dt per_all_people_f.effective_end_date%type;
2660: p_sex per_all_people_f.sex%type;
2661: p_full_name per_all_people_f.full_name%type;
2662: p_suffix per_all_people_f.suffix%type;
2663: p_title per_all_people_f.title%type;
2664: p_last_name per_all_people_f.last_name%type;
2665: p_first_name per_all_people_f.first_name%type;
2666: p_middle_names per_all_people_f.middle_names%type;

Line 2663: p_title per_all_people_f.title%type;

2659: p_eff_end_dt per_all_people_f.effective_end_date%type;
2660: p_sex per_all_people_f.sex%type;
2661: p_full_name per_all_people_f.full_name%type;
2662: p_suffix per_all_people_f.suffix%type;
2663: p_title per_all_people_f.title%type;
2664: p_last_name per_all_people_f.last_name%type;
2665: p_first_name per_all_people_f.first_name%type;
2666: p_middle_names per_all_people_f.middle_names%type;
2667: p_nationality per_all_people_f.nationality%type;

Line 2664: p_last_name per_all_people_f.last_name%type;

2660: p_sex per_all_people_f.sex%type;
2661: p_full_name per_all_people_f.full_name%type;
2662: p_suffix per_all_people_f.suffix%type;
2663: p_title per_all_people_f.title%type;
2664: p_last_name per_all_people_f.last_name%type;
2665: p_first_name per_all_people_f.first_name%type;
2666: p_middle_names per_all_people_f.middle_names%type;
2667: p_nationality per_all_people_f.nationality%type;
2668: p_national_identifier per_all_people_f.national_identifier%type;

Line 2665: p_first_name per_all_people_f.first_name%type;

2661: p_full_name per_all_people_f.full_name%type;
2662: p_suffix per_all_people_f.suffix%type;
2663: p_title per_all_people_f.title%type;
2664: p_last_name per_all_people_f.last_name%type;
2665: p_first_name per_all_people_f.first_name%type;
2666: p_middle_names per_all_people_f.middle_names%type;
2667: p_nationality per_all_people_f.nationality%type;
2668: p_national_identifier per_all_people_f.national_identifier%type;
2669: p_email_address per_all_people_f.email_address%type;

Line 2666: p_middle_names per_all_people_f.middle_names%type;

2662: p_suffix per_all_people_f.suffix%type;
2663: p_title per_all_people_f.title%type;
2664: p_last_name per_all_people_f.last_name%type;
2665: p_first_name per_all_people_f.first_name%type;
2666: p_middle_names per_all_people_f.middle_names%type;
2667: p_nationality per_all_people_f.nationality%type;
2668: p_national_identifier per_all_people_f.national_identifier%type;
2669: p_email_address per_all_people_f.email_address%type;
2670:

Line 2667: p_nationality per_all_people_f.nationality%type;

2663: p_title per_all_people_f.title%type;
2664: p_last_name per_all_people_f.last_name%type;
2665: p_first_name per_all_people_f.first_name%type;
2666: p_middle_names per_all_people_f.middle_names%type;
2667: p_nationality per_all_people_f.nationality%type;
2668: p_national_identifier per_all_people_f.national_identifier%type;
2669: p_email_address per_all_people_f.email_address%type;
2670:
2671: --data required for this

Line 2668: p_national_identifier per_all_people_f.national_identifier%type;

2664: p_last_name per_all_people_f.last_name%type;
2665: p_first_name per_all_people_f.first_name%type;
2666: p_middle_names per_all_people_f.middle_names%type;
2667: p_nationality per_all_people_f.nationality%type;
2668: p_national_identifier per_all_people_f.national_identifier%type;
2669: p_email_address per_all_people_f.email_address%type;
2670:
2671: --data required for this
2672: p_business_grp_id_t per_all_people_f.business_group_id%type;

Line 2669: p_email_address per_all_people_f.email_address%type;

2665: p_first_name per_all_people_f.first_name%type;
2666: p_middle_names per_all_people_f.middle_names%type;
2667: p_nationality per_all_people_f.nationality%type;
2668: p_national_identifier per_all_people_f.national_identifier%type;
2669: p_email_address per_all_people_f.email_address%type;
2670:
2671: --data required for this
2672: p_business_grp_id_t per_all_people_f.business_group_id%type;
2673: p_person_type_id_t per_all_people_f.person_type_id%type;

Line 2672: p_business_grp_id_t per_all_people_f.business_group_id%type;

2668: p_national_identifier per_all_people_f.national_identifier%type;
2669: p_email_address per_all_people_f.email_address%type;
2670:
2671: --data required for this
2672: p_business_grp_id_t per_all_people_f.business_group_id%type;
2673: p_person_type_id_t per_all_people_f.person_type_id%type;
2674: p_emp_number_t per_all_people_f.employee_number%type;
2675: p_applicant_number_t per_all_people_f.applicant_number%type;
2676: p_npw_number_t per_all_people_f.npw_number%type;

Line 2673: p_person_type_id_t per_all_people_f.person_type_id%type;

2669: p_email_address per_all_people_f.email_address%type;
2670:
2671: --data required for this
2672: p_business_grp_id_t per_all_people_f.business_group_id%type;
2673: p_person_type_id_t per_all_people_f.person_type_id%type;
2674: p_emp_number_t per_all_people_f.employee_number%type;
2675: p_applicant_number_t per_all_people_f.applicant_number%type;
2676: p_npw_number_t per_all_people_f.npw_number%type;
2677: p_date_of_birth_t per_all_people_f.date_of_birth%type;

Line 2674: p_emp_number_t per_all_people_f.employee_number%type;

2670:
2671: --data required for this
2672: p_business_grp_id_t per_all_people_f.business_group_id%type;
2673: p_person_type_id_t per_all_people_f.person_type_id%type;
2674: p_emp_number_t per_all_people_f.employee_number%type;
2675: p_applicant_number_t per_all_people_f.applicant_number%type;
2676: p_npw_number_t per_all_people_f.npw_number%type;
2677: p_date_of_birth_t per_all_people_f.date_of_birth%type;
2678: p_town_of_birth_t per_all_people_f.town_of_birth%type;

Line 2675: p_applicant_number_t per_all_people_f.applicant_number%type;

2671: --data required for this
2672: p_business_grp_id_t per_all_people_f.business_group_id%type;
2673: p_person_type_id_t per_all_people_f.person_type_id%type;
2674: p_emp_number_t per_all_people_f.employee_number%type;
2675: p_applicant_number_t per_all_people_f.applicant_number%type;
2676: p_npw_number_t per_all_people_f.npw_number%type;
2677: p_date_of_birth_t per_all_people_f.date_of_birth%type;
2678: p_town_of_birth_t per_all_people_f.town_of_birth%type;
2679: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;

Line 2676: p_npw_number_t per_all_people_f.npw_number%type;

2672: p_business_grp_id_t per_all_people_f.business_group_id%type;
2673: p_person_type_id_t per_all_people_f.person_type_id%type;
2674: p_emp_number_t per_all_people_f.employee_number%type;
2675: p_applicant_number_t per_all_people_f.applicant_number%type;
2676: p_npw_number_t per_all_people_f.npw_number%type;
2677: p_date_of_birth_t per_all_people_f.date_of_birth%type;
2678: p_town_of_birth_t per_all_people_f.town_of_birth%type;
2679: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;
2680: p_date_of_death_t per_all_people_f.date_of_death%type;

Line 2677: p_date_of_birth_t per_all_people_f.date_of_birth%type;

2673: p_person_type_id_t per_all_people_f.person_type_id%type;
2674: p_emp_number_t per_all_people_f.employee_number%type;
2675: p_applicant_number_t per_all_people_f.applicant_number%type;
2676: p_npw_number_t per_all_people_f.npw_number%type;
2677: p_date_of_birth_t per_all_people_f.date_of_birth%type;
2678: p_town_of_birth_t per_all_people_f.town_of_birth%type;
2679: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;
2680: p_date_of_death_t per_all_people_f.date_of_death%type;
2681: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;

Line 2678: p_town_of_birth_t per_all_people_f.town_of_birth%type;

2674: p_emp_number_t per_all_people_f.employee_number%type;
2675: p_applicant_number_t per_all_people_f.applicant_number%type;
2676: p_npw_number_t per_all_people_f.npw_number%type;
2677: p_date_of_birth_t per_all_people_f.date_of_birth%type;
2678: p_town_of_birth_t per_all_people_f.town_of_birth%type;
2679: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;
2680: p_date_of_death_t per_all_people_f.date_of_death%type;
2681: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;
2682: p_eff_st_dt_t per_all_people_f.effective_start_date%type;

Line 2679: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;

2675: p_applicant_number_t per_all_people_f.applicant_number%type;
2676: p_npw_number_t per_all_people_f.npw_number%type;
2677: p_date_of_birth_t per_all_people_f.date_of_birth%type;
2678: p_town_of_birth_t per_all_people_f.town_of_birth%type;
2679: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;
2680: p_date_of_death_t per_all_people_f.date_of_death%type;
2681: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;
2682: p_eff_st_dt_t per_all_people_f.effective_start_date%type;
2683: p_eff_end_dt_t per_all_people_f.effective_end_date%type;

Line 2680: p_date_of_death_t per_all_people_f.date_of_death%type;

2676: p_npw_number_t per_all_people_f.npw_number%type;
2677: p_date_of_birth_t per_all_people_f.date_of_birth%type;
2678: p_town_of_birth_t per_all_people_f.town_of_birth%type;
2679: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;
2680: p_date_of_death_t per_all_people_f.date_of_death%type;
2681: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;
2682: p_eff_st_dt_t per_all_people_f.effective_start_date%type;
2683: p_eff_end_dt_t per_all_people_f.effective_end_date%type;
2684: p_sex_t per_all_people_f.sex%type;

Line 2681: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;

2677: p_date_of_birth_t per_all_people_f.date_of_birth%type;
2678: p_town_of_birth_t per_all_people_f.town_of_birth%type;
2679: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;
2680: p_date_of_death_t per_all_people_f.date_of_death%type;
2681: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;
2682: p_eff_st_dt_t per_all_people_f.effective_start_date%type;
2683: p_eff_end_dt_t per_all_people_f.effective_end_date%type;
2684: p_sex_t per_all_people_f.sex%type;
2685: p_full_name_t per_all_people_f.full_name%type;

Line 2682: p_eff_st_dt_t per_all_people_f.effective_start_date%type;

2678: p_town_of_birth_t per_all_people_f.town_of_birth%type;
2679: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;
2680: p_date_of_death_t per_all_people_f.date_of_death%type;
2681: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;
2682: p_eff_st_dt_t per_all_people_f.effective_start_date%type;
2683: p_eff_end_dt_t per_all_people_f.effective_end_date%type;
2684: p_sex_t per_all_people_f.sex%type;
2685: p_full_name_t per_all_people_f.full_name%type;
2686: p_suffix_t per_all_people_f.suffix%type;

Line 2683: p_eff_end_dt_t per_all_people_f.effective_end_date%type;

2679: p_cntry_of_birth_t per_all_people_f.country_of_birth%type;
2680: p_date_of_death_t per_all_people_f.date_of_death%type;
2681: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;
2682: p_eff_st_dt_t per_all_people_f.effective_start_date%type;
2683: p_eff_end_dt_t per_all_people_f.effective_end_date%type;
2684: p_sex_t per_all_people_f.sex%type;
2685: p_full_name_t per_all_people_f.full_name%type;
2686: p_suffix_t per_all_people_f.suffix%type;
2687: p_title_t per_all_people_f.title%type;

Line 2684: p_sex_t per_all_people_f.sex%type;

2680: p_date_of_death_t per_all_people_f.date_of_death%type;
2681: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;
2682: p_eff_st_dt_t per_all_people_f.effective_start_date%type;
2683: p_eff_end_dt_t per_all_people_f.effective_end_date%type;
2684: p_sex_t per_all_people_f.sex%type;
2685: p_full_name_t per_all_people_f.full_name%type;
2686: p_suffix_t per_all_people_f.suffix%type;
2687: p_title_t per_all_people_f.title%type;
2688: p_last_name_t per_all_people_f.last_name%type;

Line 2685: p_full_name_t per_all_people_f.full_name%type;

2681: p_orgnl_dt_of_hire_t per_all_people_f.original_date_of_hire%type;
2682: p_eff_st_dt_t per_all_people_f.effective_start_date%type;
2683: p_eff_end_dt_t per_all_people_f.effective_end_date%type;
2684: p_sex_t per_all_people_f.sex%type;
2685: p_full_name_t per_all_people_f.full_name%type;
2686: p_suffix_t per_all_people_f.suffix%type;
2687: p_title_t per_all_people_f.title%type;
2688: p_last_name_t per_all_people_f.last_name%type;
2689: p_first_name_t per_all_people_f.first_name%type;

Line 2686: p_suffix_t per_all_people_f.suffix%type;

2682: p_eff_st_dt_t per_all_people_f.effective_start_date%type;
2683: p_eff_end_dt_t per_all_people_f.effective_end_date%type;
2684: p_sex_t per_all_people_f.sex%type;
2685: p_full_name_t per_all_people_f.full_name%type;
2686: p_suffix_t per_all_people_f.suffix%type;
2687: p_title_t per_all_people_f.title%type;
2688: p_last_name_t per_all_people_f.last_name%type;
2689: p_first_name_t per_all_people_f.first_name%type;
2690: p_middle_names_t per_all_people_f.middle_names%type;

Line 2687: p_title_t per_all_people_f.title%type;

2683: p_eff_end_dt_t per_all_people_f.effective_end_date%type;
2684: p_sex_t per_all_people_f.sex%type;
2685: p_full_name_t per_all_people_f.full_name%type;
2686: p_suffix_t per_all_people_f.suffix%type;
2687: p_title_t per_all_people_f.title%type;
2688: p_last_name_t per_all_people_f.last_name%type;
2689: p_first_name_t per_all_people_f.first_name%type;
2690: p_middle_names_t per_all_people_f.middle_names%type;
2691: p_nationality_t per_all_people_f.nationality%type;

Line 2688: p_last_name_t per_all_people_f.last_name%type;

2684: p_sex_t per_all_people_f.sex%type;
2685: p_full_name_t per_all_people_f.full_name%type;
2686: p_suffix_t per_all_people_f.suffix%type;
2687: p_title_t per_all_people_f.title%type;
2688: p_last_name_t per_all_people_f.last_name%type;
2689: p_first_name_t per_all_people_f.first_name%type;
2690: p_middle_names_t per_all_people_f.middle_names%type;
2691: p_nationality_t per_all_people_f.nationality%type;
2692: p_national_identifier_t per_all_people_f.national_identifier%type;

Line 2689: p_first_name_t per_all_people_f.first_name%type;

2685: p_full_name_t per_all_people_f.full_name%type;
2686: p_suffix_t per_all_people_f.suffix%type;
2687: p_title_t per_all_people_f.title%type;
2688: p_last_name_t per_all_people_f.last_name%type;
2689: p_first_name_t per_all_people_f.first_name%type;
2690: p_middle_names_t per_all_people_f.middle_names%type;
2691: p_nationality_t per_all_people_f.nationality%type;
2692: p_national_identifier_t per_all_people_f.national_identifier%type;
2693: p_email_address_t per_all_people_f.email_address%type;

Line 2690: p_middle_names_t per_all_people_f.middle_names%type;

2686: p_suffix_t per_all_people_f.suffix%type;
2687: p_title_t per_all_people_f.title%type;
2688: p_last_name_t per_all_people_f.last_name%type;
2689: p_first_name_t per_all_people_f.first_name%type;
2690: p_middle_names_t per_all_people_f.middle_names%type;
2691: p_nationality_t per_all_people_f.nationality%type;
2692: p_national_identifier_t per_all_people_f.national_identifier%type;
2693: p_email_address_t per_all_people_f.email_address%type;
2694:

Line 2691: p_nationality_t per_all_people_f.nationality%type;

2687: p_title_t per_all_people_f.title%type;
2688: p_last_name_t per_all_people_f.last_name%type;
2689: p_first_name_t per_all_people_f.first_name%type;
2690: p_middle_names_t per_all_people_f.middle_names%type;
2691: p_nationality_t per_all_people_f.nationality%type;
2692: p_national_identifier_t per_all_people_f.national_identifier%type;
2693: p_email_address_t per_all_people_f.email_address%type;
2694:
2695: l_transaction_id Number;

Line 2692: p_national_identifier_t per_all_people_f.national_identifier%type;

2688: p_last_name_t per_all_people_f.last_name%type;
2689: p_first_name_t per_all_people_f.first_name%type;
2690: p_middle_names_t per_all_people_f.middle_names%type;
2691: p_nationality_t per_all_people_f.nationality%type;
2692: p_national_identifier_t per_all_people_f.national_identifier%type;
2693: p_email_address_t per_all_people_f.email_address%type;
2694:
2695: l_transaction_id Number;
2696: l_transaction_id_canonical Varchar2(30);

Line 2693: p_email_address_t per_all_people_f.email_address%type;

2689: p_first_name_t per_all_people_f.first_name%type;
2690: p_middle_names_t per_all_people_f.middle_names%type;
2691: p_nationality_t per_all_people_f.nationality%type;
2692: p_national_identifier_t per_all_people_f.national_identifier%type;
2693: p_email_address_t per_all_people_f.email_address%type;
2694:
2695: l_transaction_id Number;
2696: l_transaction_id_canonical Varchar2(30);
2697:

Line 2725: FROM PER_ALL_PEOPLE_F ppf

2721: NATIONALITY,
2722: NATIONAL_IDENTIFIER,
2723: EMAIL_ADDRESS
2724:
2725: FROM PER_ALL_PEOPLE_F ppf
2726: where person_id = p_person_id
2727: and p_eff_st_date between effective_start_date and effective_end_date;
2728:
2729:

Line 2995: p_person_id per_all_people_f.person_id%type;

2991: p_person_op_flag varchar2(5);
2992: p_unique_key number;
2993: p_date date;
2994: p_event_data clob;
2995: p_person_id per_all_people_f.person_id%type;
2996:
2997: p_address_id per_addresses.address_id%type;
2998: p_address_type per_addresses.address_type%type;
2999: p_addr_date_from per_addresses.date_from%type;

Line 3238: p_person_id per_all_people_f.person_id%type;

3234: p_person_op_flag varchar2(5);
3235: p_unique_key number;
3236: p_date date;
3237: p_event_data clob;
3238: p_person_id per_all_people_f.person_id%type;
3239:
3240: p_phone_id per_phones.phone_id%type;
3241: p_phn_date_from per_phones.date_from%type;
3242: p_phn_date_to per_phones.date_to%type;

Line 3262: AND PPN.PARENT_TABLE = 'PER_ALL_PEOPLE_F'

3258: PHONE_TYPE,
3259: PHONE_NUMBER
3260: FROM per_phones ppn
3261: where ppn.PARENT_ID = P_PERSON_ID
3262: AND PPN.PARENT_TABLE = 'PER_ALL_PEOPLE_F'
3263: and P_Eff_St_Dt between date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
3264:
3265: v_document dbms_xmldom.domdocument;
3266: v_nodes dbms_xmldom.DOMNodeList;