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.22 2008/01/22 04:49:54 rlingama noship $ */
3: --
4: ------------------------------- GLOBALS -------------------------------------
5: --

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

2: /* $Header: pygbeoya.pkb 120.22 2008/01/22 04:49:54 rlingama noship $ */
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 506: l_arch_value := pay_gb_eoy_archive.get_arch_str(p_action_id,

502: FROM ff_user_entities fue
503: WHERE fue.user_entity_name = p_user_entity_name
504: AND fue.legislation_code= 'GB';
505: --
506: l_arch_value := pay_gb_eoy_archive.get_arch_str(p_action_id,
507: l_user_entity_id,
508: p_context_value1,
509: p_context_value2,
510: p_context_value3);

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

627: --
628: FOR payroll_rec in get_payroll_id(p_payroll_action_id,p_permit_ueid) LOOP
629: --
630: g_payroll_end_yr_tab(payroll_rec.payroll_id) :=
631: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,
632: p_user_entity_id => p_end_yr_ueid,
633: p_context_value1 => payroll_rec.payroll_id);
634: g_payroll_start_yr_tab(payroll_rec.payroll_id) :=
635: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,

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

631: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,
632: p_user_entity_id => p_end_yr_ueid,
633: p_context_value1 => payroll_rec.payroll_id);
634: g_payroll_start_yr_tab(payroll_rec.payroll_id) :=
635: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,
636: p_user_entity_id => p_start_yr_ueid,
637: p_context_value1 => payroll_rec.payroll_id);
638: g_payroll_tax_ref_tab(payroll_rec.payroll_id) :=
639: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,

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

635: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,
636: p_user_entity_id => p_start_yr_ueid,
637: p_context_value1 => payroll_rec.payroll_id);
638: g_payroll_tax_ref_tab(payroll_rec.payroll_id) :=
639: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,
640: p_user_entity_id => p_tax_ref_ueid,
641: p_context_value1 => payroll_rec.payroll_id);
642: g_payroll_tax_dist_tab(payroll_rec.payroll_id) :=
643: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,

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

639: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,
640: p_user_entity_id => p_tax_ref_ueid,
641: p_context_value1 => payroll_rec.payroll_id);
642: g_payroll_tax_dist_tab(payroll_rec.payroll_id) :=
643: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,
644: p_user_entity_id => p_tax_dist_ueid,
645: p_context_value1 => payroll_rec.payroll_id);
646: g_payroll_permit_no_tab(payroll_rec.payroll_id) :=
647: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,

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

643: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,
644: p_user_entity_id => p_tax_dist_ueid,
645: p_context_value1 => payroll_rec.payroll_id);
646: g_payroll_permit_no_tab(payroll_rec.payroll_id) :=
647: pay_gb_eoy_archive.get_arch_str(p_action_id => p_payroll_action_id,
648: p_user_entity_id => p_permit_ueid,
649: p_context_value1 => payroll_rec.payroll_id);
650: g_min_start_year :=
651: least(g_min_start_year,

Line 700: pay_gb_eoy_archive.get_arch_str

696: --
697: --RAISE; -- Initialisation in cache_archive_value must have failed.
698: --
699: l_return_value :=
700: pay_gb_eoy_archive.get_arch_str
701: (p_action_id => p_payroll_action_id,
702: p_user_entity_name => p_user_entity_name,
703: p_context_value1 => to_char(p_payroll_id));
704: --

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

827: AND p_proll_eff_date BETWEEN papf.effective_start_date and papf.effective_end_date
828: AND papf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
829: AND flex.segment1 = p_tax_ref;
830: --
831: l_proc VARCHAR2(100) := 'pay_gb_eoy_archive.get_agg_active_start';
832: BEGIN
833: -- Get first active or suspended status start date for the assignment
834: OPEN get_first_active_start;
835: FETCH get_first_active_start INTO l_min_active, l_person_id;

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

1028: AND p_proll_eff_date BETWEEN papf.effective_start_date and papf.effective_end_date
1029: AND papf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
1030: AND flex.segment1 = p_tax_ref;
1031: --
1032: l_proc VARCHAR2(100) := 'pay_gb_eoy_archive.get_agg_active_end';
1033: BEGIN
1034: -- Get first active or suspended status start date for the assignment
1035: OPEN get_last_active_end;
1036: FETCH get_last_active_end INTO l_max_active, l_person_id;

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

1113: --
1114: PROCEDURE write_output_header IS
1115: BEGIN
1116: --
1117: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 10);
1118: fnd_file.put_line(fnd_file.output, rpad(' ', 41)||
1119: 'End Of Year Process - Errors and Warnings Report'||
1120: rpad(' ', 30)||fnd_date.date_to_displaydate(sysdate));
1121: fnd_file.put_line(fnd_file.output, ' ');

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

1131: fnd_file.put_line(fnd_file.output, rpad('-', 14, '-') || ' ' ||
1132: rpad('-', 30, '-') || ' ' || rpad('-', 10, '-') || ' ' ||
1133: rpad('-', 75, '-'));
1134: g_output_header := FALSE;
1135: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 100);
1136: END write_output_header;
1137: --
1138: FUNCTION write_output(p_assignment_number IN VARCHAR2,
1139: p_full_name IN VARCHAR2,

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

1143: l_err_warn VARCHAR2(10);
1144: l_message VARCHAR2(250);
1145: BEGIN
1146: --
1147: hr_utility.set_location('pay_gb_eoy_archive.write_output', 1);
1148: hr_utility.trace('p_assignment_number='||p_assignment_number);
1149: hr_utility.trace('p_full_name='||p_full_name);
1150: hr_utility.trace('p_message_type='||p_message_type);
1151: hr_utility.trace('p_message='||p_message);

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

1155: --
1156: IF g_output_header THEN
1157: write_output_header;
1158: END IF;
1159: hr_utility.set_location('pay_gb_eoy_archive.write_output', 30);
1160: IF p_message_type = 'E' THEN
1161: l_err_warn := 'Error';
1162: fnd_file.put_line(fnd_file.log, 'An error encountered when processing assignment '||p_assignment_number||', please check output file for more details.');
1163: g_err_count := nvl(g_err_count, 0) + 1;

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

1165: l_err_warn := 'Warning';
1166: g_warn_count := nvl(g_warn_count, 0) + 1;
1167: END IF;
1168: --
1169: hr_utility.set_location('pay_gb_eoy_archive.write_output', 40);
1170: fnd_file.put_line(fnd_file.output, rpad(p_assignment_number, 14)||' '||
1171: rpad(p_full_name, 30)||' '||rpad(l_err_warn,10)||' '||
1172: rpad(l_message,75));
1173: --

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

1170: fnd_file.put_line(fnd_file.output, rpad(p_assignment_number, 14)||' '||
1171: rpad(p_full_name, 30)||' '||rpad(l_err_warn,10)||' '||
1172: rpad(l_message,75));
1173: --
1174: hr_utility.set_location('pay_gb_eoy_archive.write_output', 50);
1175: IF length(l_message) > 75 THEN
1176: fnd_file.put_line(fnd_file.output, rpad(' ', 57)||
1177: rpad(substr(l_message,76),75));
1178: END IF;

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

1176: fnd_file.put_line(fnd_file.output, rpad(' ', 57)||
1177: rpad(substr(l_message,76),75));
1178: END IF;
1179: --
1180: hr_utility.set_location('pay_gb_eoy_archive.write_output', 100);
1181: return 0;
1182: END write_output;
1183: --
1184: FUNCTION write_output_footer RETURN NUMBER IS

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

1182: END write_output;
1183: --
1184: FUNCTION write_output_footer RETURN NUMBER IS
1185: BEGIN
1186: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 1);
1187: --
1188: IF g_output_header THEN
1189: write_output_header;
1190: END IF;

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

1188: IF g_output_header THEN
1189: write_output_header;
1190: END IF;
1191: --
1192: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 10);
1193: fnd_file.put_line(fnd_file.output, ' ');
1194: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1195: 'Total Number of Errors = '||nvl(g_err_count,0));
1196: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||

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

1194: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1195: 'Total Number of Errors = '||nvl(g_err_count,0));
1196: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1197: 'Total Number of Warnings = '||nvl(g_warn_count,0));
1198: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 100);
1199: return 0;
1200: END write_output_footer;
1201: --
1202: PROCEDURE range_cursor (pactid IN NUMBER,

Line 1285: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

1281: -- End of BUG 5671777-5
1282: start_year,
1283: effective_date end_year,
1284: business_group_id,
1285: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1286: 'PERMIT'),1,12) permit,
1287: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1288: 'TAX_REF'),1,3) tax_dist,
1289: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(

Line 1287: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

1283: effective_date end_year,
1284: business_group_id,
1285: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1286: 'PERMIT'),1,12) permit,
1287: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1288: 'TAX_REF'),1,3) tax_dist,
1289: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
1290: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref, -- 4011263: tax ref can be 10 chars long
1291: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

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

1285: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1286: 'PERMIT'),1,12) permit,
1287: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1288: 'TAX_REF'),1,3) tax_dist,
1289: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
1290: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref, -- 4011263: tax ref can be 10 chars long
1291: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1292: 'TEST'),1,1) test_indicator,
1293: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

Line 1291: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

1287: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1288: 'TAX_REF'),1,3) tax_dist,
1289: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
1290: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref, -- 4011263: tax ref can be 10 chars long
1291: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1292: 'TEST'),1,1) test_indicator,
1293: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1294: 'UNIQUE_TEST_ID'),1,8) unique_test_id
1295: FROM pay_payroll_actions

Line 1293: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

1289: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
1290: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref, -- 4011263: tax ref can be 10 chars long
1291: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1292: 'TEST'),1,1) test_indicator,
1293: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1294: 'UNIQUE_TEST_ID'),1,8) unique_test_id
1295: FROM pay_payroll_actions
1296: WHERE payroll_action_id = p_pact_id;
1297: --

Line 1716: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

1712: l_process_asg BOOLEAN;
1713: --
1714: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
1715: SELECT
1716: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1717: 'PERMIT'),1,12) permit,
1718: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1719: 'TAX_REF'),1,3) tax_dist,
1720: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(

Line 1718: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

1714: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
1715: SELECT
1716: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1717: 'PERMIT'),1,12) permit,
1718: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1719: 'TAX_REF'),1,3) tax_dist,
1720: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
1721: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref, --4011263
1722: effective_date end_year,

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

1716: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1717: 'PERMIT'),1,12) permit,
1718: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1719: 'TAX_REF'),1,3) tax_dist,
1720: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
1721: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref, --4011263
1722: effective_date end_year,
1723: business_group_id,
1724: ltrim(substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

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

1720: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
1721: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref, --4011263
1722: effective_date end_year,
1723: business_group_id,
1724: ltrim(substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1725: 'ASG_SET'),1,80)) asg_set
1726: FROM pay_payroll_actions
1727: WHERE payroll_action_id = p_payroll_action_id;
1728: --

Line 1758: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

1754: from per_all_assignments_f paf2
1755: where paf2.assignment_id = paf.assignment_id
1756: AND paf2.effective_end_date > paf.effective_end_date
1757: AND paf2.effective_end_date >=
1758: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
1759: (pactid, p_start_year_eid,to_char(paf2.payroll_id)))
1760: AND paf2.effective_start_date <=
1761: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
1762: (pactid, p_payroll_end_year_eid, to_char(paf2.payroll_id))));

Line 1761: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

1757: AND paf2.effective_end_date >=
1758: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
1759: (pactid, p_start_year_eid,to_char(paf2.payroll_id)))
1760: AND paf2.effective_start_date <=
1761: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
1762: (pactid, p_payroll_end_year_eid, to_char(paf2.payroll_id))));
1763: --
1764: cursor csr_assignments ( p_min_start_year_date DATE,
1765: p_max_end_year_date DATE,

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

1798: asg.effective_start_date,
1799: asg.effective_end_date,
1800: asg.person_id,
1801: asg.period_of_service_id, -- added for bug 3784871
1802: pay_gb_eoy_archive.get_agg_active_start(asg.assignment_id, flex.segment1, p_end_date) agg_active_start,
1803: pay_gb_eoy_archive.get_agg_active_end(asg.assignment_id, flex.segment1, p_end_date) agg_active_end,
1804: asg.payroll_id,
1805: substr(ltrim(substr(org_information1,4,11),'/') ,1,10) tax_ref, -- 4011263
1806: decode(per.per_information9,'Y','Y',NULL) multiple_asg_flag,

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

1799: asg.effective_end_date,
1800: asg.person_id,
1801: asg.period_of_service_id, -- added for bug 3784871
1802: pay_gb_eoy_archive.get_agg_active_start(asg.assignment_id, flex.segment1, p_end_date) agg_active_start,
1803: pay_gb_eoy_archive.get_agg_active_end(asg.assignment_id, flex.segment1, p_end_date) agg_active_end,
1804: asg.payroll_id,
1805: substr(ltrim(substr(org_information1,4,11),'/') ,1,10) tax_ref, -- 4011263
1806: decode(per.per_information9,'Y','Y',NULL) multiple_asg_flag,
1807: rowidtochar(asg.ROWID) charrowid,

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

1876: pass.effective_start_date,
1877: pass.effective_end_date,
1878: pass.person_id,
1879: pass.period_of_service_id, -- added for bug 3784871
1880: pay_gb_eoy_archive.get_agg_active_start(pass.assignment_id, pflex.segment1, p_end_date) agg_active_start,
1881: pay_gb_eoy_archive.get_agg_active_end(pass.assignment_id, pflex.segment1, p_end_date) agg_active_end,
1882: pass.payroll_id,
1883: substr(ltrim(substr(pflex.segment1,4,11),'/') ,1,10) tax_ref, -- 4011263
1884: decode(per.per_information9,'Y','Y',NULL) multiple_asg_flag,

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

1877: pass.effective_end_date,
1878: pass.person_id,
1879: pass.period_of_service_id, -- added for bug 3784871
1880: pay_gb_eoy_archive.get_agg_active_start(pass.assignment_id, pflex.segment1, p_end_date) agg_active_start,
1881: pay_gb_eoy_archive.get_agg_active_end(pass.assignment_id, pflex.segment1, p_end_date) agg_active_end,
1882: pass.payroll_id,
1883: substr(ltrim(substr(pflex.segment1,4,11),'/') ,1,10) tax_ref, -- 4011263
1884: decode(per.per_information9,'Y','Y',NULL) multiple_asg_flag,
1885: rowidtochar(pass.rowid) charrowid,

Line 2042: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value

2038: hr_utility.trace(l_proc||' Fetched assignment_id='||
2039: rec_assignment.assignment_id||', g_asg_set_id='||g_asg_set_id);
2040: l_process_asg := FALSE;
2041: l_payroll_start_date :=
2042: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
2043: (pactid,'X_START_YEAR',
2044: to_char(rec_assignment.payroll_id)));
2045: hr_utility.trace(l_proc||' l_payroll_start_date='||fnd_date.date_to_displaydate(l_payroll_start_date));
2046: l_payroll_end_date :=

Line 2047: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value

2043: (pactid,'X_START_YEAR',
2044: to_char(rec_assignment.payroll_id)));
2045: hr_utility.trace(l_proc||' l_payroll_start_date='||fnd_date.date_to_displaydate(l_payroll_start_date));
2046: l_payroll_end_date :=
2047: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
2048: (pactid,'X_END_YEAR',
2049: to_char(rec_assignment.payroll_id)));
2050: hr_utility.trace(l_proc||' l_payroll_end_date='||fnd_date.date_to_displaydate(l_payroll_end_date));
2051: hr_utility.trace(l_proc||' tax_ref_xfer='||rec_assignment.tax_ref_xfer);

Line 2233: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

2229: -- End of BUG 5671777-5
2230: start_year,
2231: effective_date end_year,
2232: business_group_id,
2233: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2234: 'PERMIT'),1,12) permit,
2235: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2236: 'TAX_REF'),1,3) tax_dist,
2237: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(

Line 2235: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

2231: effective_date end_year,
2232: business_group_id,
2233: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2234: 'PERMIT'),1,12) permit,
2235: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2236: 'TAX_REF'),1,3) tax_dist,
2237: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
2238: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref --4011263
2239: FROM pay_payroll_actions

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

2233: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2234: 'PERMIT'),1,12) permit,
2235: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2236: 'TAX_REF'),1,3) tax_dist,
2237: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
2238: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref --4011263
2239: FROM pay_payroll_actions
2240: WHERE payroll_action_id = p_payroll_action_id;
2241: --

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

2254: cursor csr_payroll_info(p_pactid NUMBER) IS
2255: SELECT
2256: to_number(aic.context) payroll_id,
2257: fnd_date.canonical_to_date(fai.VALUE) start_year,
2258: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str(fai.context1,
2259: g_payroll_end_year_eid,
2260: aic.context)) end_year,
2261: pay_gb_eoy_archive.get_arch_str(fai.context1,g_payroll_period_type_eid,
2262: aic.context) period_type,

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

2257: fnd_date.canonical_to_date(fai.VALUE) start_year,
2258: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str(fai.context1,
2259: g_payroll_end_year_eid,
2260: aic.context)) end_year,
2261: pay_gb_eoy_archive.get_arch_str(fai.context1,g_payroll_period_type_eid,
2262: aic.context) period_type,
2263: to_number(pay_gb_eoy_archive.get_arch_str(fai.context1,
2264: g_max_period_number_eid, aic.context)) max_period_number,
2265: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_ref_eid,

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

2259: g_payroll_end_year_eid,
2260: aic.context)) end_year,
2261: pay_gb_eoy_archive.get_arch_str(fai.context1,g_payroll_period_type_eid,
2262: aic.context) period_type,
2263: to_number(pay_gb_eoy_archive.get_arch_str(fai.context1,
2264: g_max_period_number_eid, aic.context)) max_period_number,
2265: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_ref_eid,
2266: aic.context) tax_ref,
2267: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_dist_ref_eid,

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

2261: pay_gb_eoy_archive.get_arch_str(fai.context1,g_payroll_period_type_eid,
2262: aic.context) period_type,
2263: to_number(pay_gb_eoy_archive.get_arch_str(fai.context1,
2264: g_max_period_number_eid, aic.context)) max_period_number,
2265: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_ref_eid,
2266: aic.context) tax_ref,
2267: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_dist_ref_eid,
2268: aic.context) tax_dist
2269: FROM ff_archive_item_contexts aic, /* payrolls */

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

2263: to_number(pay_gb_eoy_archive.get_arch_str(fai.context1,
2264: g_max_period_number_eid, aic.context)) max_period_number,
2265: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_ref_eid,
2266: aic.context) tax_ref,
2267: pay_gb_eoy_archive.get_arch_str(fai.context1,g_tax_dist_ref_eid,
2268: aic.context) tax_dist
2269: FROM ff_archive_item_contexts aic, /* payrolls */
2270: ff_archive_items fai, /* X_START_YEAR */
2271: ff_user_entities fue,

Line 3148: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

3144: ASG_ACTION_ERROR EXCEPTION;
3145: --
3146: cursor csr_asg_act_info(p_asgactid NUMBER) IS
3147: SELECT act.assignment_id,
3148: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3149: (act.assignment_action_id,
3150: g_effective_end_date_eid)) end_date,
3151: nvl(pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,
3152: g_tax_ref_transfer_eid),'N') tax_ref_transfer,

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

3147: SELECT act.assignment_id,
3148: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3149: (act.assignment_action_id,
3150: g_effective_end_date_eid)) end_date,
3151: nvl(pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,
3152: g_tax_ref_transfer_eid),'N') tax_ref_transfer,
3153: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3154: (act.assignment_action_id,
3155: g_agg_active_start_eid)), hr_api.g_sot) agg_active_start,

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

3149: (act.assignment_action_id,
3150: g_effective_end_date_eid)) end_date,
3151: nvl(pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,
3152: g_tax_ref_transfer_eid),'N') tax_ref_transfer,
3153: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3154: (act.assignment_action_id,
3155: g_agg_active_start_eid)), hr_api.g_sot) agg_active_start,
3156: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3157: (act.assignment_action_id,

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

3152: g_tax_ref_transfer_eid),'N') tax_ref_transfer,
3153: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3154: (act.assignment_action_id,
3155: g_agg_active_start_eid)), hr_api.g_sot) agg_active_start,
3156: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3157: (act.assignment_action_id,
3158: g_agg_active_end_eid)), hr_api.g_eot) agg_active_end
3159: FROM pay_assignment_actions act
3160: WHERE act.assignment_action_id = p_asgactid;

Line 3249: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value

3245: AND nroll.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
3246: AND ass.assignment_id = pass.assignment_id
3247: AND pass.effective_end_date = (ass.effective_start_date - 1)
3248: AND pass.effective_end_date >=
3249: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
3250: (g_payroll_action_id, 'X_START_YEAR', to_char(pass.payroll_id)))
3251: AND pass.effective_start_date <=
3252: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
3253: (g_payroll_action_id, 'X_END_YEAR', to_char(pass.payroll_id)))

Line 3252: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value

3248: AND pass.effective_end_date >=
3249: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
3250: (g_payroll_action_id, 'X_START_YEAR', to_char(pass.payroll_id)))
3251: AND pass.effective_start_date <=
3252: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_cached_value
3253: (g_payroll_action_id, 'X_END_YEAR', to_char(pass.payroll_id)))
3254: AND proll.payroll_id = pass.payroll_id
3255: AND pass.payroll_id <> ass.payroll_id
3256: AND ass.effective_start_date BETWEEN

Line 3391: pay_gb_eoy_archive.get_nearest_scon(

3387: substr(hr_general.decode_lookup('GB_SCON',
3388: decode(substr(bal.balance_name,4,1),
3389: 'F',nvl(max(decode(ev_cat.screen_entry_value,
3390: 'F',ev_scon.screen_entry_value)),
3391: pay_gb_eoy_archive.get_nearest_scon(
3392: max(ev_scon.element_entry_id), cp_l_asg_id,
3393: 'F',max(pact.effective_date))),
3394: 'G',nvl(max(decode(ev_cat.screen_entry_value,
3395: 'G',ev_scon.screen_entry_value)),

Line 3396: pay_gb_eoy_archive.get_nearest_scon(

3392: max(ev_scon.element_entry_id), cp_l_asg_id,
3393: 'F',max(pact.effective_date))),
3394: 'G',nvl(max(decode(ev_cat.screen_entry_value,
3395: 'G',ev_scon.screen_entry_value)),
3396: pay_gb_eoy_archive.get_nearest_scon(
3397: max(ev_scon.element_entry_id), cp_l_asg_id,
3398: 'G',max(pact.effective_date))),
3399: 'S',nvl(max(decode(ev_cat.screen_entry_value,
3400: 'S',ev_scon.screen_entry_value)),

Line 3401: pay_gb_eoy_archive.get_nearest_scon(

3397: max(ev_scon.element_entry_id), cp_l_asg_id,
3398: 'G',max(pact.effective_date))),
3399: 'S',nvl(max(decode(ev_cat.screen_entry_value,
3400: 'S',ev_scon.screen_entry_value)),
3401: pay_gb_eoy_archive.get_nearest_scon(
3402: max(ev_scon.element_entry_id), cp_l_asg_id,
3403: 'S',max(pact.effective_date))),
3404: NULL)),1,9) scon,
3405: 100*nvl(sum(decode(substr(bal.balance_name,6),'Able',

Line 3598: (pay_gb_eoy_archive.get_arch_str(

3594: AND assact2.action_status = 'C'
3595: AND pact.effective_date BETWEEN
3596: g_start_year AND g_end_year
3597: /* Bug 4278570 fnd_date.canonical_to_date
3598: (pay_gb_eoy_archive.get_arch_str(
3599: g_payroll_action_id,
3600: g_payroll_start_year_eid,
3601: to_char(pact.payroll_id)))
3602: AND fnd_date.canonical_to_date

Line 3603: (pay_gb_eoy_archive.get_arch_str(

3599: g_payroll_action_id,
3600: g_payroll_start_year_eid,
3601: to_char(pact.payroll_id)))
3602: AND fnd_date.canonical_to_date
3603: (pay_gb_eoy_archive.get_arch_str(
3604: g_payroll_action_id,
3605: g_payroll_end_year_eid,
3606: to_char(pact.payroll_id)))
3607: */

Line 3646: (pay_gb_eoy_archive.get_arch_str(

3642: AND assact2.action_status = 'C'
3643: AND pact.effective_date BETWEEN
3644: g_start_year AND g_end_year
3645: /* Bug 4278570 fnd_date.canonical_to_date
3646: (pay_gb_eoy_archive.get_arch_str(
3647: g_payroll_action_id,
3648: g_payroll_start_year_eid,
3649: to_char(pact.payroll_id)))
3650: AND fnd_date.canonical_to_date

Line 3651: (pay_gb_eoy_archive.get_arch_str(

3647: g_payroll_action_id,
3648: g_payroll_start_year_eid,
3649: to_char(pact.payroll_id)))
3650: AND fnd_date.canonical_to_date
3651: (pay_gb_eoy_archive.get_arch_str(
3652: g_payroll_action_id,
3653: g_payroll_end_year_eid,
3654: to_char(pact.payroll_id)))
3655: */

Line 3741: AND p_tax_ref = pay_gb_eoy_archive.get_cached_value(

3737: WHERE asg.person_id = p_person_id
3738: AND asg.effective_start_date < p_year_end
3739: AND asg.effective_end_date >= p_year_start
3740: AND asg.payroll_id <> p_payroll_id
3741: AND p_tax_ref = pay_gb_eoy_archive.get_cached_value(
3742: g_payroll_action_id,'X_TAX_REFERENCE_NUMBER',
3743: to_char(asg.payroll_id))
3744: AND g_permit_number <> nvl(pay_gb_eoy_archive.get_cached_value(
3745: g_payroll_action_id,'X_PERMIT_NUMBER',

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

3740: AND asg.payroll_id <> p_payroll_id
3741: AND p_tax_ref = pay_gb_eoy_archive.get_cached_value(
3742: g_payroll_action_id,'X_TAX_REFERENCE_NUMBER',
3743: to_char(asg.payroll_id))
3744: AND g_permit_number <> nvl(pay_gb_eoy_archive.get_cached_value(
3745: g_payroll_action_id,'X_PERMIT_NUMBER',
3746: to_char(asg.payroll_id)),'?');
3747: --
3748: -- Start of BUG 5671777-1

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

3815: -- p_actid may be given to archive the value against a different assignment
3816: -- action to that currently being processed. This is utilised by the
3817: -- Multiple Assignment Logic Pt. III
3818: BEGIN
3819: hr_utility.trace('Entering pay_gb_eoy_archive.archive_ni_values');
3820: hr_utility.trace('p_user_entity_id='||p_user_entity_id);
3821: hr_utility.trace('p_value='||p_value);
3822: hr_utility.trace('p_reportable='||p_reportable);
3823: hr_utility.trace('p_ni_cat='||p_ni_cat);

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

4133: --
4134: TYPE t_lines IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
4135: l_lines t_lines;
4136: l_dummy VARCHAR2(1000);
4137: l_proc VARCHAR2(100) := 'pay_gb_eoy_archive.remove_null_address_lines';
4138: --
4139: BEGIN
4140: hr_utility.set_location('Entering: '||l_proc,1);
4141: hr_utility.trace('p_address_line1='||p_address_line1);

Line 5797: IF pay_gb_eoy_archive.get_arch_str(p_assactid,

5793: -- Do Multiple Assignment Logic Part IV
5794: -- Bug 1261138 - split MA logic III into III and IV to ensure that
5795: -- pl/sql tbl is flushed to DB even if last asg was not processed, but
5796: -- only if at least one asg was processed
5797: IF pay_gb_eoy_archive.get_arch_str(p_assactid,
5798: g_last_multi_asg_eid) = 'Y'
5799: THEN
5800: -- This is the last asg for the person in this tax ref
5801: -- archive the primary assignment flag against the primary action

Line 6147: END pay_gb_eoy_archive;

6143: hr_utility.raise_error;
6144: --
6145: END extract_item_report_format;
6146: --
6147: END pay_gb_eoy_archive;