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.PER_NL_FDR_ARCHIVE dependencies on PER_NL_FDR_ARCHIVE

Line 1: PACKAGE BODY PER_NL_FDR_ARCHIVE as

1: PACKAGE BODY PER_NL_FDR_ARCHIVE as
2: /* $Header: penlfdra.pkb 120.2 2007/12/19 13:41:38 abhgangu noship $ */
3:
4:
5: /*------------------------------------------------------------------------------

Line 71: SELECT PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'REPORT_DATE')

67: ,p_bg_id OUT NOCOPY NUMBER) IS
68: --
69: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
70:
71: SELECT PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'REPORT_DATE')
72: ,TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'ORG_STRUCT_ID'))
73: ,TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'PERSON_ID'))
74: ,TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'ORG_ID'))
75: ,business_group_id

Line 72: ,TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'ORG_STRUCT_ID'))

68: --
69: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
70:
71: SELECT PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'REPORT_DATE')
72: ,TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'ORG_STRUCT_ID'))
73: ,TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'PERSON_ID'))
74: ,TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'ORG_ID'))
75: ,business_group_id
76: FROM pay_payroll_actions

Line 73: ,TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'PERSON_ID'))

69: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
70:
71: SELECT PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'REPORT_DATE')
72: ,TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'ORG_STRUCT_ID'))
73: ,TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'PERSON_ID'))
74: ,TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'ORG_ID'))
75: ,business_group_id
76: FROM pay_payroll_actions
77: WHERE payroll_action_id = p_payroll_action_id;

Line 74: ,TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'ORG_ID'))

70:
71: SELECT PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'REPORT_DATE')
72: ,TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'ORG_STRUCT_ID'))
73: ,TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'PERSON_ID'))
74: ,TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(legislative_parameters,'ORG_ID'))
75: ,business_group_id
76: FROM pay_payroll_actions
77: WHERE payroll_action_id = p_payroll_action_id;
78:

Line 441: per_nl_fdr_archive.org_check(pap.business_group_id, null, nvl(paa.establishment_id,-1), to_date(p_report_date,'RRRR/MM/DD')) = 1)

437: and information_type='NL_FIRST_DAY_REPORT')
438: )
439: and (hr_nl_org_info.get_tax_org_id(posv.org_structure_version_id,paa.organization_id) is not null
440: OR
441: per_nl_fdr_archive.org_check(pap.business_group_id, null, nvl(paa.establishment_id,-1), to_date(p_report_date,'RRRR/MM/DD')) = 1)
442: and paa.organization_id in
443: (select pose.organization_id_parent
444: from per_org_structure_elements pose
445: where posv.org_structure_version_id = pose.org_structure_version_id

Line 812: per_nl_fdr_archive.org_check(pap.business_group_id, null, nvl(paa.establishment_id,-1), to_date(p_report_date,'RRRR/MM/DD')) = 1)

808: and past.per_system_status = 'ACTIVE_ASSIGN'
809: and get_ref_date(pap.person_id) between paa.effective_start_date and paa.effective_end_date
810: and (hr_nl_org_info.get_tax_org_id(posv.org_structure_version_id,paa.organization_id) is not null
811: OR
812: per_nl_fdr_archive.org_check(pap.business_group_id, null, nvl(paa.establishment_id,-1), to_date(p_report_date,'RRRR/MM/DD')) = 1)
813: and paa.organization_id in
814: (select pose.organization_id_parent
815: from per_org_structure_elements pose
816: where posv.org_structure_version_id = pose.org_structure_version_id

Line 839: PER_NL_FDR_ARCHIVE.get_all_parameters(p_payroll_action_id, l_report_date, l_org_struct_id, l_person_id, l_org_id, l_bg_id);

835: l_org_id := NULL;
836:
837: hr_utility.set_location('Entering assg action Code',20);
838:
839: PER_NL_FDR_ARCHIVE.get_all_parameters(p_payroll_action_id, l_report_date, l_org_struct_id, l_person_id, l_org_id, l_bg_id);
840:
841: --hr_utility.set_location('Parameters:- date: '||l_report_date||' hier: '||l_org_struct_id||' org: '||l_org_id,30);
842:
843: IF l_person_id is not NULL THEN

Line 1056: SELECT PER_NL_FDR_ARCHIVE.get_parameter(ppa.legislative_parameters,'REPORT_DATE')

1052: --hr_utility.trace_on(NULL,'NL_FDR');
1053: --hr_utility.set_location('Entered archive code', 90);
1054: l_create_peit := 'Y';
1055:
1056: SELECT PER_NL_FDR_ARCHIVE.get_parameter(ppa.legislative_parameters,'REPORT_DATE')
1057: INTO l_report_date
1058: FROM pay_payroll_actions ppa,
1059: pay_assignment_actions paa
1060: WHERE paa.payroll_action_id = ppa.payroll_action_id

Line 1076: select TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(ppa.legislative_parameters,'ORG_STRUCT_ID'))

1072: l_report_date := substr(l_parameter_string,instr(l_parameter_string,'/',1,1)-4,10);
1073: END IF;
1074: g_year := to_char(to_date(l_report_date,'RRRR/MM/DD'),'RRRR');
1075:
1076: select TO_NUMBER(PER_NL_FDR_ARCHIVE.get_parameter(ppa.legislative_parameters,'ORG_STRUCT_ID'))
1077: INTO l_org_struct_id
1078: FROM pay_payroll_actions ppa,
1079: pay_assignment_actions paa
1080: WHERE paa.payroll_action_id = ppa.payroll_action_id

Line 1098: IF l_establishment_id is not NULL and per_nl_fdr_archive.org_check(l_bg_id,null,l_establishment_id,to_date(l_report_date,'RRRR/MM/DD')) = 1 THEN

1094: CLOSE csr_get_person_info;
1095:
1096: --hr_utility.set_location('Processing employee number: '||l_employee_number||' with leg emp '||l_establishment_id,95);
1097:
1098: IF l_establishment_id is not NULL and per_nl_fdr_archive.org_check(l_bg_id,null,l_establishment_id,to_date(l_report_date,'RRRR/MM/DD')) = 1 THEN
1099:
1100: --hr_utility.set_location('Entered IF condition for legal employer',97);
1101: OPEN csr_get_leg_info(p_assignment_action_id);
1102: FETCH csr_get_leg_info INTO l_org_id, l_org_name, l_tax_reg_num;

Line 1345: and per_nl_fdr_archive.org_check(pap.business_group_id, null, nvl(paa.establishment_id,-1), to_date(p_report_date,'RRRR/MM/DD')) = 0

1341: and past.assignment_status_type_id = paa.assignment_status_type_id
1342: and past.per_system_status = 'ACTIVE_ASSIGN'
1343: and get_ref_date(pap.person_id) between paa.effective_start_date and paa.effective_end_date
1344: and hr_nl_org_info.get_tax_org_id(posv.org_structure_version_id,paa.organization_id) is null
1345: and per_nl_fdr_archive.org_check(pap.business_group_id, null, nvl(paa.establishment_id,-1), to_date(p_report_date,'RRRR/MM/DD')) = 0
1346: and paa.organization_id in
1347: (select pose.organization_id_parent
1348: from per_org_structure_elements pose
1349: where posv.org_structure_version_id = pose.org_structure_version_id

Line 1372: PER_NL_FDR_ARCHIVE.get_all_parameters(p_actid, l_report_date, l_org_struct_id, l_person_id, l_org_id, l_bg_id);

1368:
1369:
1370: BEGIN
1371:
1372: PER_NL_FDR_ARCHIVE.get_all_parameters(p_actid, l_report_date, l_org_struct_id, l_person_id, l_org_id, l_bg_id);
1373:
1374: SELECT pbg.name
1375: INTO l_bg_name
1376: FROM per_business_groups pbg

Line 1483: END PER_NL_FDR_ARCHIVE;

1479:
1480: END archive_deinit_code;
1481:
1482:
1483: END PER_NL_FDR_ARCHIVE;