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

Line 1: PACKAGE BODY pay_gb_eoy_archive AS

1: PACKAGE BODY pay_gb_eoy_archive AS
2: /* $Header: pygbeoya.pkb 120.28.12020000.2 2012/10/11 14:28:34 achandwa ship $ */
3: --
4: ------------------------------- GLOBALS -------------------------------------
5: --'

Line 6: g_package CONSTANT VARCHAR2(20):= 'pay_gb_eoy_archive.';

2: /* $Header: pygbeoya.pkb 120.28.12020000.2 2012/10/11 14:28:34 achandwa ship $ */
3: --
4: ------------------------------- GLOBALS -------------------------------------
5: --'
6: g_package CONSTANT VARCHAR2(20):= 'pay_gb_eoy_archive.';
7: -- Globals populated by archinit procedure or action_creation proc
8: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
9: g_start_year DATE;
10: g_end_year DATE;

Line 530: l_arch_value := pay_gb_eoy_archive.get_arch_str(p_action_id,

526: FROM ff_user_entities fue
527: WHERE fue.user_entity_name = p_user_entity_name
528: AND fue.legislation_code= 'GB';
529: --
530: l_arch_value := pay_gb_eoy_archive.get_arch_str(p_action_id,
531: l_user_entity_id,
532: p_context_value1,
533: p_context_value2,
534: p_context_value3);

Line 655: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,

651: --
652: FOR payroll_rec in get_payroll_id(p_payroll_action_id,p_permit_ueid) LOOP
653: --
654: g_payroll_end_yr_tab(payroll_rec.payroll_id) :=
655: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,
656: p_user_entity_id => p_end_yr_ueid,
657: p_context_value1 => payroll_rec.payroll_id);
658: g_payroll_start_yr_tab(payroll_rec.payroll_id) :=
659: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,

Line 659: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,

655: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,
656: p_user_entity_id => p_end_yr_ueid,
657: p_context_value1 => payroll_rec.payroll_id);
658: g_payroll_start_yr_tab(payroll_rec.payroll_id) :=
659: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,
660: p_user_entity_id => p_start_yr_ueid,
661: p_context_value1 => payroll_rec.payroll_id);
662: g_payroll_tax_ref_tab(payroll_rec.payroll_id) :=
663: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,

Line 663: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,

659: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,
660: p_user_entity_id => p_start_yr_ueid,
661: p_context_value1 => payroll_rec.payroll_id);
662: g_payroll_tax_ref_tab(payroll_rec.payroll_id) :=
663: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,
664: p_user_entity_id => p_tax_ref_ueid,
665: p_context_value1 => payroll_rec.payroll_id);
666: g_payroll_tax_dist_tab(payroll_rec.payroll_id) :=
667: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,

Line 667: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,

663: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,
664: p_user_entity_id => p_tax_ref_ueid,
665: p_context_value1 => payroll_rec.payroll_id);
666: g_payroll_tax_dist_tab(payroll_rec.payroll_id) :=
667: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,
668: p_user_entity_id => p_tax_dist_ueid,
669: p_context_value1 => payroll_rec.payroll_id);
670: g_payroll_permit_no_tab(payroll_rec.payroll_id) :=
671: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,

Line 671: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,

667: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,
668: p_user_entity_id => p_tax_dist_ueid,
669: p_context_value1 => payroll_rec.payroll_id);
670: g_payroll_permit_no_tab(payroll_rec.payroll_id) :=
671: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,
672: p_user_entity_id => p_permit_ueid,
673: p_context_value1 => payroll_rec.payroll_id);
674: g_min_start_year :=
675: least(g_min_start_year,

Line 724: pay_gb_eoy_archive.get_arch_str

720: --
721: --RAISE; -- Initialisation in cache_archive_value must have failed.
722: --
723: l_return_value :=
724: pay_gb_eoy_archive.get_arch_str
725: (p_action_id => p_payroll_action_id,
726: p_user_entity_name => p_user_entity_name,
727: p_context_value1 => to_char(p_payroll_id));
728: --

Line 855: l_proc VARCHAR2(100) := 'pay_gb_eoy_archive.get_agg_active_start';

851: AND p_proll_eff_date BETWEEN papf.effective_start_date and papf.effective_end_date
852: AND papf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
853: AND flex.segment1 = p_tax_ref;
854: --
855: l_proc VARCHAR2(100) := 'pay_gb_eoy_archive.get_agg_active_start';
856: BEGIN
857: -- Get first active or suspended status start date for the assignment
858: OPEN get_first_active_start;
859: FETCH get_first_active_start INTO l_min_active, l_person_id;

Line 1056: l_proc VARCHAR2(100) := 'pay_gb_eoy_archive.get_agg_active_end';

1052: AND p_proll_eff_date BETWEEN papf.effective_start_date and papf.effective_end_date
1053: AND papf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
1054: AND flex.segment1 = p_tax_ref;
1055: --
1056: l_proc VARCHAR2(100) := 'pay_gb_eoy_archive.get_agg_active_end';
1057: BEGIN
1058: -- Get first active or suspended status start date for the assignment
1059: OPEN get_last_active_end;
1060: FETCH get_last_active_end INTO l_max_active, l_person_id;

Line 1141: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 10);

1137: --
1138: PROCEDURE write_output_header IS
1139: BEGIN
1140: --
1141: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 10);
1142: fnd_file.put_line(fnd_file.output, rpad(' ', 41)||
1143: 'End Of Year Process - Errors and Warnings Report'||
1144: rpad(' ', 30)||fnd_date.date_to_displaydate(sysdate));
1145: fnd_file.put_line(fnd_file.output, ' ');

Line 1159: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 100);

1155: fnd_file.put_line(fnd_file.output, rpad('-', 14, '-') || ' ' ||
1156: rpad('-', 30, '-') || ' ' || rpad('-', 10, '-') || ' ' ||
1157: rpad('-', 75, '-'));
1158: g_output_header := FALSE;
1159: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 100);
1160: END write_output_header;
1161: --
1162: FUNCTION write_output(p_assignment_number IN VARCHAR2,
1163: p_full_name IN VARCHAR2,

Line 1171: hr_utility.set_location('pay_gb_eoy_archive.write_output', 1);

1167: l_err_warn VARCHAR2(10);
1168: l_message VARCHAR2(250);
1169: BEGIN
1170: --
1171: hr_utility.set_location('pay_gb_eoy_archive.write_output', 1);
1172: hr_utility.trace('p_assignment_number='||p_assignment_number);
1173: hr_utility.trace('p_full_name='||p_full_name);
1174: hr_utility.trace('p_message_type='||p_message_type);
1175: hr_utility.trace('p_message='||p_message);

Line 1183: hr_utility.set_location('pay_gb_eoy_archive.write_output', 30);

1179: --
1180: IF g_output_header THEN
1181: write_output_header;
1182: END IF;
1183: hr_utility.set_location('pay_gb_eoy_archive.write_output', 30);
1184: IF p_message_type = 'E' THEN
1185: l_err_warn := 'Error';
1186: fnd_file.put_line(fnd_file.log, 'An error encountered when processing assignment '||p_assignment_number||', please check output file for more details.');
1187: g_err_count := nvl(g_err_count, 0) + 1;

Line 1193: hr_utility.set_location('pay_gb_eoy_archive.write_output', 40);

1189: l_err_warn := 'Warning';
1190: g_warn_count := nvl(g_warn_count, 0) + 1;
1191: END IF;
1192: --
1193: hr_utility.set_location('pay_gb_eoy_archive.write_output', 40);
1194: fnd_file.put_line(fnd_file.output, rpad(p_assignment_number, 14)||' '||
1195: rpad(p_full_name, 30)||' '||rpad(l_err_warn,10)||' '||
1196: rpad(l_message,75));
1197: --

Line 1198: hr_utility.set_location('pay_gb_eoy_archive.write_output', 50);

1194: fnd_file.put_line(fnd_file.output, rpad(p_assignment_number, 14)||' '||
1195: rpad(p_full_name, 30)||' '||rpad(l_err_warn,10)||' '||
1196: rpad(l_message,75));
1197: --
1198: hr_utility.set_location('pay_gb_eoy_archive.write_output', 50);
1199: IF length(l_message) > 75 THEN
1200: fnd_file.put_line(fnd_file.output, rpad(' ', 57)||
1201: rpad(substr(l_message,76),75));
1202: END IF;

Line 1204: hr_utility.set_location('pay_gb_eoy_archive.write_output', 100);

1200: fnd_file.put_line(fnd_file.output, rpad(' ', 57)||
1201: rpad(substr(l_message,76),75));
1202: END IF;
1203: --
1204: hr_utility.set_location('pay_gb_eoy_archive.write_output', 100);
1205: return 0;
1206: END write_output;
1207: --
1208: FUNCTION write_output_footer RETURN NUMBER IS

Line 1210: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 1);

1206: END write_output;
1207: --
1208: FUNCTION write_output_footer RETURN NUMBER IS
1209: BEGIN
1210: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 1);
1211: --
1212: IF g_output_header THEN
1213: write_output_header;
1214: END IF;

Line 1216: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 10);

1212: IF g_output_header THEN
1213: write_output_header;
1214: END IF;
1215: --
1216: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 10);
1217: fnd_file.put_line(fnd_file.output, ' ');
1218: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1219: 'Total Number of Errors = '||nvl(g_err_count,0));
1220: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||

Line 1222: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 100);

1218: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1219: 'Total Number of Errors = '||nvl(g_err_count,0));
1220: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1221: 'Total Number of Warnings = '||nvl(g_warn_count,0));
1222: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 100);
1223: return 0;
1224: END write_output_footer;
1225: --
1226: PROCEDURE range_cursor (pactid IN NUMBER,

Line 1311: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

1307: -- End of BUG 5671777-5
1308: start_year,
1309: effective_date end_year,
1310: business_group_id,
1311: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1312: 'PERMIT'),1,12) permit,
1313: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1314: 'TAX_REF'),1,3) tax_dist,
1315: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(

Line 1313: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

1309: effective_date end_year,
1310: business_group_id,
1311: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1312: 'PERMIT'),1,12) permit,
1313: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1314: 'TAX_REF'),1,3) tax_dist,
1315: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
1316: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref, -- 4011263: tax ref can be 10 chars long
1317: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

Line 1315: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(

1311: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1312: 'PERMIT'),1,12) permit,
1313: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1314: 'TAX_REF'),1,3) tax_dist,
1315: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
1316: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref, -- 4011263: tax ref can be 10 chars long
1317: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1318: 'TEST'),1,1) test_indicator,
1319: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

Line 1317: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

1313: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1314: 'TAX_REF'),1,3) tax_dist,
1315: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
1316: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref, -- 4011263: tax ref can be 10 chars long
1317: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1318: 'TEST'),1,1) test_indicator,
1319: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1320: 'UNIQUE_TEST_ID'),1,8) unique_test_id
1321: FROM pay_payroll_actions

Line 1319: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

1315: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
1316: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref, -- 4011263: tax ref can be 10 chars long
1317: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1318: 'TEST'),1,1) test_indicator,
1319: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1320: 'UNIQUE_TEST_ID'),1,8) unique_test_id
1321: FROM pay_payroll_actions
1322: WHERE payroll_action_id = p_pact_id;
1323: --

Line 1763: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

1759: l_process_asg BOOLEAN;
1760: --
1761: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
1762: SELECT
1763: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1764: 'PERMIT'),1,12) permit,
1765: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1766: 'TAX_REF'),1,3) tax_dist,
1767: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(

Line 1765: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

1761: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
1762: SELECT
1763: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1764: 'PERMIT'),1,12) permit,
1765: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1766: 'TAX_REF'),1,3) tax_dist,
1767: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
1768: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref, --4011263
1769: effective_date end_year,

Line 1767: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(

1763: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1764: 'PERMIT'),1,12) permit,
1765: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1766: 'TAX_REF'),1,3) tax_dist,
1767: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
1768: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref, --4011263
1769: effective_date end_year,
1770: business_group_id,
1771: ltrim(substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

Line 1771: ltrim(substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

1767: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
1768: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref, --4011263
1769: effective_date end_year,
1770: business_group_id,
1771: ltrim(substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1772: 'ASG_SET'),1,80)) asg_set
1773: FROM pay_payroll_actions
1774: WHERE payroll_action_id = p_payroll_action_id;
1775: --

Line 1805: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

1801: from per_all_assignments_f paf2
1802: where paf2.assignment_id = paf.assignment_id
1803: AND paf2.effective_end_date > paf.effective_end_date
1804: AND paf2.effective_end_date >=
1805: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
1806: (pactid, p_start_year_eid,to_char(paf2.payroll_id)))
1807: AND paf2.effective_start_date <=
1808: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
1809: (pactid, p_payroll_end_year_eid, to_char(paf2.payroll_id))));

Line 1808: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

1804: AND paf2.effective_end_date >=
1805: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
1806: (pactid, p_start_year_eid,to_char(paf2.payroll_id)))
1807: AND paf2.effective_start_date <=
1808: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
1809: (pactid, p_payroll_end_year_eid, to_char(paf2.payroll_id))));
1810: --
1811: cursor csr_assignments ( p_min_start_year_date DATE,
1812: p_max_end_year_date DATE,

Line 1849: pay_gb_eoy_archive.get_agg_active_start(asg.assignment_id, flex.segment1, p_end_date) agg_active_start,

1845: asg.effective_start_date,
1846: asg.effective_end_date,
1847: asg.person_id,
1848: asg.period_of_service_id, -- added for bug 3784871
1849: pay_gb_eoy_archive.get_agg_active_start(asg.assignment_id, flex.segment1, p_end_date) agg_active_start,
1850: pay_gb_eoy_archive.get_agg_active_end(asg.assignment_id, flex.segment1, p_end_date) agg_active_end,
1851: asg.payroll_id,
1852: substr(ltrim(substr(org_information1,4,11),'/') ,1,10) tax_ref, -- 4011263
1853: decode(per.per_information9,'Y','Y',NULL) multiple_asg_flag,

Line 1850: pay_gb_eoy_archive.get_agg_active_end(asg.assignment_id, flex.segment1, p_end_date) agg_active_end,

1846: asg.effective_end_date,
1847: asg.person_id,
1848: asg.period_of_service_id, -- added for bug 3784871
1849: pay_gb_eoy_archive.get_agg_active_start(asg.assignment_id, flex.segment1, p_end_date) agg_active_start,
1850: pay_gb_eoy_archive.get_agg_active_end(asg.assignment_id, flex.segment1, p_end_date) agg_active_end,
1851: asg.payroll_id,
1852: substr(ltrim(substr(org_information1,4,11),'/') ,1,10) tax_ref, -- 4011263
1853: decode(per.per_information9,'Y','Y',NULL) multiple_asg_flag,
1854: rowidtochar(asg.ROWID) charrowid,

Line 1928: pay_gb_eoy_archive.get_agg_active_start(pass.assignment_id, pflex.segment1, p_end_date) agg_active_start,

1924: pass.effective_start_date,
1925: pass.effective_end_date,
1926: pass.person_id,
1927: pass.period_of_service_id, -- added for bug 3784871
1928: pay_gb_eoy_archive.get_agg_active_start(pass.assignment_id, pflex.segment1, p_end_date) agg_active_start,
1929: pay_gb_eoy_archive.get_agg_active_end(pass.assignment_id, pflex.segment1, p_end_date) agg_active_end,
1930: pass.payroll_id,
1931: substr(ltrim(substr(pflex.segment1,4,11),'/') ,1,10) tax_ref, -- 4011263
1932: decode(per.per_information9,'Y','Y',NULL) multiple_asg_flag,

Line 1929: pay_gb_eoy_archive.get_agg_active_end(pass.assignment_id, pflex.segment1, p_end_date) agg_active_end,

1925: pass.effective_end_date,
1926: pass.person_id,
1927: pass.period_of_service_id, -- added for bug 3784871
1928: pay_gb_eoy_archive.get_agg_active_start(pass.assignment_id, pflex.segment1, p_end_date) agg_active_start,
1929: pay_gb_eoy_archive.get_agg_active_end(pass.assignment_id, pflex.segment1, p_end_date) agg_active_end,
1930: pass.payroll_id,
1931: substr(ltrim(substr(pflex.segment1,4,11),'/') ,1,10) tax_ref, -- 4011263
1932: decode(per.per_information9,'Y','Y',NULL) multiple_asg_flag,
1933: rowidtochar(pass.rowid) charrowid,

Line 2091: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value

2087: hr_utility.trace(l_proc||' Fetched assignment_id='||
2088: rec_assignment.assignment_id||', g_asg_set_id='||g_asg_set_id);
2089: l_process_asg := FALSE;
2090: l_payroll_start_date :=
2091: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
2092: (pactid,'X_START_YEAR',
2093: to_char(rec_assignment.payroll_id)));
2094: hr_utility.trace(l_proc||' l_payroll_start_date='||fnd_date.date_to_displaydate(l_payroll_start_date));
2095: l_payroll_end_date :=

Line 2096: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value

2092: (pactid,'X_START_YEAR',
2093: to_char(rec_assignment.payroll_id)));
2094: hr_utility.trace(l_proc||' l_payroll_start_date='||fnd_date.date_to_displaydate(l_payroll_start_date));
2095: l_payroll_end_date :=
2096: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
2097: (pactid,'X_END_YEAR',
2098: to_char(rec_assignment.payroll_id)));
2099: hr_utility.trace(l_proc||' l_payroll_end_date='||fnd_date.date_to_displaydate(l_payroll_end_date));
2100: hr_utility.trace(l_proc||' tax_ref_xfer='||rec_assignment.tax_ref_xfer);

Line 2282: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

2278: -- End of BUG 5671777-5
2279: start_year,
2280: effective_date end_year,
2281: business_group_id,
2282: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2283: 'PERMIT'),1,12) permit,
2284: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2285: 'TAX_REF'),1,3) tax_dist,
2286: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(

Line 2284: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

2280: effective_date end_year,
2281: business_group_id,
2282: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2283: 'PERMIT'),1,12) permit,
2284: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2285: 'TAX_REF'),1,3) tax_dist,
2286: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
2287: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref --4011263
2288: FROM pay_payroll_actions

Line 2286: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(

2282: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2283: 'PERMIT'),1,12) permit,
2284: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2285: 'TAX_REF'),1,3) tax_dist,
2286: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
2287: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref --4011263
2288: FROM pay_payroll_actions
2289: WHERE payroll_action_id = p_payroll_action_id;
2290: --

Line 2307: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str(fai.context1,

2303: cursor csr_payroll_info(p_pactid NUMBER) IS
2304: SELECT
2305: to_number(aic.context) payroll_id,
2306: fnd_date.canonical_to_date(fai.VALUE) start_year,
2307: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str(fai.context1,
2308: g_payroll_end_year_eid,
2309: aic.context)) end_year,
2310: pay_gb_eoy_archive.get_arch_str(fai.context1,g_payroll_period_type_eid,
2311: aic.context) period_type,

Line 2310: pay_gb_eoy_archive.get_arch_str(fai.context1,g_payroll_period_type_eid,

2306: fnd_date.canonical_to_date(fai.VALUE) start_year,
2307: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str(fai.context1,
2308: g_payroll_end_year_eid,
2309: aic.context)) end_year,
2310: pay_gb_eoy_archive.get_arch_str(fai.context1,g_payroll_period_type_eid,
2311: aic.context) period_type,
2312: to_number(pay_gb_eoy_archive.get_arch_str(fai.context1,
2313: g_max_period_number_eid, aic.context)) max_period_number,
2314: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_ref_eid,

Line 2312: to_number(pay_gb_eoy_archive.get_arch_str(fai.context1,

2308: g_payroll_end_year_eid,
2309: aic.context)) end_year,
2310: pay_gb_eoy_archive.get_arch_str(fai.context1,g_payroll_period_type_eid,
2311: aic.context) period_type,
2312: to_number(pay_gb_eoy_archive.get_arch_str(fai.context1,
2313: g_max_period_number_eid, aic.context)) max_period_number,
2314: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_ref_eid,
2315: aic.context) tax_ref,
2316: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_dist_ref_eid,

Line 2314: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_ref_eid,

2310: pay_gb_eoy_archive.get_arch_str(fai.context1,g_payroll_period_type_eid,
2311: aic.context) period_type,
2312: to_number(pay_gb_eoy_archive.get_arch_str(fai.context1,
2313: g_max_period_number_eid, aic.context)) max_period_number,
2314: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_ref_eid,
2315: aic.context) tax_ref,
2316: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_dist_ref_eid,
2317: aic.context) tax_dist
2318: FROM ff_archive_item_contexts aic, /* payrolls */

Line 2316: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_dist_ref_eid,

2312: to_number(pay_gb_eoy_archive.get_arch_str(fai.context1,
2313: g_max_period_number_eid, aic.context)) max_period_number,
2314: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_ref_eid,
2315: aic.context) tax_ref,
2316: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_dist_ref_eid,
2317: aic.context) tax_dist
2318: FROM ff_archive_item_contexts aic, /* payrolls */
2319: ff_archive_items fai, /* X_START_YEAR */
2320: ff_user_entities fue,

Line 3275: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

3271: ASG_ACTION_ERROR EXCEPTION;
3272: --
3273: cursor csr_asg_act_info(p_asgactid NUMBER) IS
3274: SELECT act.assignment_id,
3275: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3276: (act.assignment_action_id,
3277: g_effective_end_date_eid)) end_date,
3278: nvl(pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,
3279: g_tax_ref_transfer_eid),'N') tax_ref_transfer,

Line 3278: nvl(pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,

3274: SELECT act.assignment_id,
3275: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3276: (act.assignment_action_id,
3277: g_effective_end_date_eid)) end_date,
3278: nvl(pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,
3279: g_tax_ref_transfer_eid),'N') tax_ref_transfer,
3280: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3281: (act.assignment_action_id,
3282: g_agg_active_start_eid)), hr_api.g_sot) agg_active_start,

Line 3280: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

3276: (act.assignment_action_id,
3277: g_effective_end_date_eid)) end_date,
3278: nvl(pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,
3279: g_tax_ref_transfer_eid),'N') tax_ref_transfer,
3280: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3281: (act.assignment_action_id,
3282: g_agg_active_start_eid)), hr_api.g_sot) agg_active_start,
3283: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3284: (act.assignment_action_id,

Line 3283: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

3279: g_tax_ref_transfer_eid),'N') tax_ref_transfer,
3280: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3281: (act.assignment_action_id,
3282: g_agg_active_start_eid)), hr_api.g_sot) agg_active_start,
3283: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3284: (act.assignment_action_id,
3285: g_agg_active_end_eid)), hr_api.g_eot) agg_active_end
3286: FROM pay_assignment_actions act
3287: WHERE act.assignment_action_id = p_asgactid;

Line 3376: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value

3372: AND nroll.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
3373: AND ass.assignment_id = pass.assignment_id
3374: AND pass.effective_end_date = (ass.effective_start_date - 1)
3375: AND pass.effective_end_date >=
3376: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
3377: (g_payroll_action_id, 'X_START_YEAR', to_char(pass.payroll_id)))
3378: AND pass.effective_start_date <=
3379: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
3380: (g_payroll_action_id, 'X_END_YEAR', to_char(pass.payroll_id)))

Line 3379: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value

3375: AND pass.effective_end_date >=
3376: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
3377: (g_payroll_action_id, 'X_START_YEAR', to_char(pass.payroll_id)))
3378: AND pass.effective_start_date <=
3379: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
3380: (g_payroll_action_id, 'X_END_YEAR', to_char(pass.payroll_id)))
3381: AND proll.payroll_id = pass.payroll_id
3382: AND pass.payroll_id <> ass.payroll_id
3383: AND ass.effective_start_date BETWEEN

Line 3521: pay_gb_eoy_archive.get_nearest_scon(

3517: substr(hr_general.decode_lookup('GB_SCON',
3518: decode(substr(bal.balance_name,4,1),
3519: 'F',nvl(max(decode(ev_cat.screen_entry_value,
3520: 'F',ev_scon.screen_entry_value)),
3521: pay_gb_eoy_archive.get_nearest_scon(
3522: max(ev_scon.element_entry_id), cp_l_asg_id,
3523: 'F',max(pact.effective_date))),
3524: 'G',nvl(max(decode(ev_cat.screen_entry_value,
3525: 'G',ev_scon.screen_entry_value)),

Line 3526: pay_gb_eoy_archive.get_nearest_scon(

3522: max(ev_scon.element_entry_id), cp_l_asg_id,
3523: 'F',max(pact.effective_date))),
3524: 'G',nvl(max(decode(ev_cat.screen_entry_value,
3525: 'G',ev_scon.screen_entry_value)),
3526: pay_gb_eoy_archive.get_nearest_scon(
3527: max(ev_scon.element_entry_id), cp_l_asg_id,
3528: 'G',max(pact.effective_date))),
3529: 'S',nvl(max(decode(ev_cat.screen_entry_value,
3530: 'S',ev_scon.screen_entry_value)),

Line 3531: pay_gb_eoy_archive.get_nearest_scon(

3527: max(ev_scon.element_entry_id), cp_l_asg_id,
3528: 'G',max(pact.effective_date))),
3529: 'S',nvl(max(decode(ev_cat.screen_entry_value,
3530: 'S',ev_scon.screen_entry_value)),
3531: pay_gb_eoy_archive.get_nearest_scon(
3532: max(ev_scon.element_entry_id), cp_l_asg_id,
3533: 'S',max(pact.effective_date))),
3534: NULL)),1,9) scon,
3535: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able',

Line 3738: (pay_gb_eoy_archive.get_arch_str(

3734: AND assact2.action_status in ('C','S') --Modified for the bug 10066755
3735: AND pact.effective_date BETWEEN
3736: g_start_year AND g_end_year
3737: /* Bug 4278570 fnd_date.canonical_to_date
3738: (pay_gb_eoy_archive.get_arch_str(
3739: g_payroll_action_id,
3740: g_payroll_start_year_eid,
3741: to_char(pact.payroll_id)))
3742: AND fnd_date.canonical_to_date

Line 3743: (pay_gb_eoy_archive.get_arch_str(

3739: g_payroll_action_id,
3740: g_payroll_start_year_eid,
3741: to_char(pact.payroll_id)))
3742: AND fnd_date.canonical_to_date
3743: (pay_gb_eoy_archive.get_arch_str(
3744: g_payroll_action_id,
3745: g_payroll_end_year_eid,
3746: to_char(pact.payroll_id)))
3747: */

Line 3787: (pay_gb_eoy_archive.get_arch_str(

3783: AND assact2.action_status in ('C','S') --Modified for the bug 10066755
3784: AND pact.effective_date BETWEEN
3785: g_start_year AND g_end_year
3786: /* Bug 4278570 fnd_date.canonical_to_date
3787: (pay_gb_eoy_archive.get_arch_str(
3788: g_payroll_action_id,
3789: g_payroll_start_year_eid,
3790: to_char(pact.payroll_id)))
3791: AND fnd_date.canonical_to_date

Line 3792: (pay_gb_eoy_archive.get_arch_str(

3788: g_payroll_action_id,
3789: g_payroll_start_year_eid,
3790: to_char(pact.payroll_id)))
3791: AND fnd_date.canonical_to_date
3792: (pay_gb_eoy_archive.get_arch_str(
3793: g_payroll_action_id,
3794: g_payroll_end_year_eid,
3795: to_char(pact.payroll_id)))
3796: */

Line 3882: AND p_tax_ref = pay_gb_eoy_archive.get_cached_value(

3878: WHERE asg.person_id = p_person_id
3879: AND asg.effective_start_date < p_year_end
3880: AND asg.effective_end_date >= p_year_start
3881: AND asg.payroll_id <> p_payroll_id
3882: AND p_tax_ref = pay_gb_eoy_archive.get_cached_value(
3883: g_payroll_action_id,'X_TAX_REFERENCE_NUMBER',
3884: to_char(asg.payroll_id))
3885: AND g_permit_number <> nvl(pay_gb_eoy_archive.get_cached_value(
3886: g_payroll_action_id,'X_PERMIT_NUMBER',

Line 3885: AND g_permit_number <> nvl(pay_gb_eoy_archive.get_cached_value(

3881: AND asg.payroll_id <> p_payroll_id
3882: AND p_tax_ref = pay_gb_eoy_archive.get_cached_value(
3883: g_payroll_action_id,'X_TAX_REFERENCE_NUMBER',
3884: to_char(asg.payroll_id))
3885: AND g_permit_number <> nvl(pay_gb_eoy_archive.get_cached_value(
3886: g_payroll_action_id,'X_PERMIT_NUMBER',
3887: to_char(asg.payroll_id)),'?');
3888: --
3889: -- Start of BUG 5671777-1

Line 3981: hr_utility.trace('Entering pay_gb_eoy_archive.archive_ni_values');

3977: -- p_actid may be given to archive the value against a different assignment
3978: -- action to that currently being processed. This is utilised by the
3979: -- Multiple Assignment Logic Pt. III
3980: BEGIN
3981: hr_utility.trace('Entering pay_gb_eoy_archive.archive_ni_values');
3982: hr_utility.trace('p_user_entity_id='||p_user_entity_id);
3983: hr_utility.trace('p_value='||p_value);
3984: hr_utility.trace('p_reportable='||p_reportable);
3985: hr_utility.trace('p_ni_cat='||p_ni_cat);

Line 4322: l_proc VARCHAR2(100) := 'pay_gb_eoy_archive.remove_null_address_lines';

4318: --
4319: TYPE t_lines IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
4320: l_lines t_lines;
4321: l_dummy VARCHAR2(1000);
4322: l_proc VARCHAR2(100) := 'pay_gb_eoy_archive.remove_null_address_lines';
4323: --
4324: BEGIN
4325: hr_utility.set_location('Entering: '||l_proc,1);
4326: hr_utility.trace('p_address_line1='||p_address_line1);

Line 6054: IF pay_gb_eoy_archive.get_arch_str(p_assactid,

6050: -- Do Multiple Assignment Logic Part IV
6051: -- Bug 1261138 - split MA logic III into III and IV to ensure that
6052: -- pl/sql tbl is flushed to DB even if last asg was not processed, but
6053: -- only if at least one asg was processed
6054: IF pay_gb_eoy_archive.get_arch_str(p_assactid,
6055: g_last_multi_asg_eid) = 'Y'
6056: THEN
6057: -- This is the last asg for the person in this tax ref
6058: -- archive the primary assignment flag against the primary action

Line 6431: END pay_gb_eoy_archive;

6427: hr_utility.raise_error;
6428: --
6429: END extract_item_report_format;
6430: --
6431: END pay_gb_eoy_archive;