[Home] [Help]
39: removed the join with column paa_year_effective_date as
40: the view pay_us_local_taxes_v has been changed (removed the
41: inline view).
42: 10-JUL-2002 tclewis 115.12 modified load_prepay, when inserting data into
43: pay_us_rpt_totals also load pay_pre_payments.pre_payment_id
44: into the pay_us_rpt_totals.location_id (an indexed column).
45: New logic to look for the Pre_payment_id in the table
46: before inserting. This will eliminate duplicates.
47: added same functionality to load_mesg_line for the count
40: the view pay_us_local_taxes_v has been changed (removed the
41: inline view).
42: 10-JUL-2002 tclewis 115.12 modified load_prepay, when inserting data into
43: pay_us_rpt_totals also load pay_pre_payments.pre_payment_id
44: into the pay_us_rpt_totals.location_id (an indexed column).
45: New logic to look for the Pre_payment_id in the table
46: before inserting. This will eliminate duplicates.
47: added same functionality to load_mesg_line for the count
48: of unpaid pre-payments.
277: hr_utility.trace('location='||l_location_code);
278: hr_utility.trace('Cash Value ='||l_cash_value);
279: end if;
280: else
281: insert into pay_us_rpt_totals
282: (tax_unit_id,
283: gre_name,
284: organization_name,
285: location_name,
472: hr_utility.trace('location='||l_location_code);
473: hr_utility.trace('Cash Value ='||l_cash_value);
474: end if;
475: else
476: insert into pay_us_rpt_totals
477: (tax_unit_id,
478: gre_name,
479: organization_name,
480: location_name,
546: loop
547: fetch ee_earn into ee_earn_rec;
548: hr_utility.trace('Number of Earnings Records fetched = '||to_char(ee_earn%ROWCOUNT));
549: exit when ee_earn%notfound;
550: insert into pay_us_rpt_totals
551: (tax_unit_id, gre_name, organization_name, location_name,
552: attribute1,
553: value1,
554: attribute2,
827: hr_utility.trace('org name='||l_org_name);
828: hr_utility.trace('location='||l_location_code);
829: hr_utility.trace('Cash Value ='||l_run_val);
830: else
831: insert into pay_us_rpt_totals
832: (tax_unit_id, gre_name, organization_name, location_name,
833: attribute1,
834: value1,
835: attribute2,
1040: hr_utility.trace('location='||l_location_code);
1041: hr_utility.trace('Cash Value ='||l_run_val);
1042: end if;
1043: else
1044: insert into pay_us_rpt_totals
1045: ( tax_unit_id, gre_name, organization_name, location_name,
1046: attribute1,
1047: value1,
1048: attribute2,
1204: hr_utility.trace('org name='||l_org_name);
1205: hr_utility.trace('location='||l_location_code);
1206: hr_utility.trace('Cash Value ='||l_run_val);
1207: else
1208: insert into pay_us_rpt_totals
1209: (tax_unit_id, gre_name, organization_name, location_name,
1210: attribute1,
1211: value1,
1212: attribute2,
1394: hr_utility.trace('gre name='||l_gre_name);
1395: hr_utility.trace('org name='||l_org_name);
1396: hr_utility.trace('loc name='||l_location_code);
1397: else
1398: insert into pay_us_rpt_totals
1399: (tax_unit_id, gre_name, organization_name, location_name,
1400: attribute1,
1401: value1,
1402: attribute2,
1605: hr_utility.trace('org name='||l_org_name);
1606: hr_utility.trace('location='||l_location_code);
1607: hr_utility.trace('Cash Value ='||l_bal_value);
1608: else
1609: insert into pay_us_rpt_totals
1610: (tax_unit_id, gre_name, organization_name, location_name,
1611: attribute1,
1612: value1,
1613: attribute2,
1757: BEGIN
1758:
1759: SELECT 'X'
1760: INTO l_dummy_var
1761: from pay_us_rpt_totals
1762: where location_id = l_ppp_pre_payment_id
1763: and tax_unit_id = t_payroll_action_id
1764: and attribute4 = 'Unpaid Payments' ;
1765:
1767:
1768: WHEN NO_DATA_FOUND THEN
1769:
1770:
1771: insert into pay_us_rpt_totals
1772: (tax_unit_id, gre_name, organization_name, location_name,
1773: attribute1,
1774: value1,
1775: attribute2,
1829: EXCEPTION
1830:
1831: WHEN NO_DATA_FOUND THEN
1832:
1833: insert into pay_us_rpt_totals
1834: (tax_unit_id, gre_name, organization_name, location_name,
1835: attribute1,
1836: value1,
1837: attribute2,
1970: BEGIN
1971:
1972: SELECT 'X'
1973: INTO l_dummy_val
1974: FROM pay_us_rpt_totals
1975: where location_id = l_pre_pay_id
1976: and tax_unit_id = t_payroll_action_id
1977: and attribute4 = 'Disbursements';
1978:
1977: and attribute4 = 'Disbursements';
1978:
1979: EXCEPTION
1980: WHEN NO_DATA_FOUND THEN
1981: insert into pay_us_rpt_totals
1982: (tax_unit_id, gre_name, organization_name, location_name,
1983: attribute1,
1984: value1,
1985: attribute2,
2027: l_reverse_amt := nvl(pay_balance_pkg.get_value(
2028: p_defined_balance_id => l_defined_balance_id,
2029: p_assignment_action_id => l_assignment_action_id),0);
2030:
2031: insert into pay_us_rpt_totals
2032: (tax_unit_id, gre_name, organization_name, location_name,
2033: attribute1,
2034: value1,
2035: attribute2,
2287: hr_utility.trace('org name='||l_org_name);
2288: hr_utility.trace('location='||l_location_code);
2289: hr_utility.trace('Cash Value ='||l_bal_value);
2290: else
2291: insert into pay_us_rpt_totals
2292: (tax_unit_id, gre_name, organization_name, location_name,
2293: attribute1,
2294: value1,
2295: attribute2,
2435:
2436: -- #3270485: moved to range_cursor procedure.
2437: --
2438: -- if chnkno = 1 then
2439: -- insert into pay_us_rpt_totals (tax_unit_id,attribute1,organization_id,
2440: -- attribute2,attribute3,attribute4,attribute5)
2441: -- values (pactid,'GTN',ppa_finder,
2442: -- l_leg_param, l_business_group_id,
2443: -- to_char(l_leg_start_date,'MM/DD/YYYY'),
2539: hr_utility.trace('End of LOAD DATA');
2540: close sel_aaid;
2541: if (l_index <>0) then
2542: for x in g_totals_table.first..g_totals_table.last LOOP
2543: INSERT INTO pay_us_rpt_totals(tax_unit_id, gre_name,
2544: organization_name, location_name,
2545: attribute1,
2546: attribute2,
2547: attribute3,
2561: g_totals_table(x).value3
2562: );
2563: END LOOP;
2564: /*forall x in g_totals_table.first..g_totals_table.last
2565: insert into pay_us_rpt_totals
2566: values
2567: g_totals_table(x);*/
2568: l_index :=0;
2569: g_totals_table.DELETE;
2683:
2684: -- #3270485: moved to range_cursor procedure.
2685: --
2686: -- if chnkno = 1 then
2687: -- insert into pay_us_rpt_totals (tax_unit_id,attribute1,organization_id,
2688: -- attribute2,attribute3,attribute4,attribute5)
2689: -- values (pactid,'GTN',ppa_finder,
2690: -- l_leg_param, l_business_group_id,
2691: -- to_char(l_leg_start_date,'MM/DD/YYYY'),
2811: hr_utility.trace('End of LOAD DATA');
2812: close sel_aaid;
2813: if (l_index <>0) then
2814: for x in g_totals_table.first..g_totals_table.last LOOP
2815: INSERT INTO pay_us_rpt_totals(tax_unit_id, gre_name,
2816: organization_name, location_name,
2817: attribute1,
2818: attribute2,
2819: attribute3,
2833: g_totals_table(x).value3
2834: );
2835: END LOOP;
2836: /*forall x in g_totals_table.first..g_totals_table.last
2837: insert into pay_us_rpt_totals
2838: values
2839: g_totals_table(x);*/
2840: commit;
2841: l_index :=0;