[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.
303: hr_utility.trace('location='||l_location_code);
304: hr_utility.trace('Cash Value ='||l_cash_value);
305: end if;
306: else
307: insert into pay_us_rpt_totals
308: (tax_unit_id,
309: gre_name,
310: organization_name,
311: location_name,
504: hr_utility.trace('location='||l_location_code);
505: hr_utility.trace('Cash Value ='||l_cash_value);
506: end if;
507: else
508: insert into pay_us_rpt_totals
509: (tax_unit_id,
510: gre_name,
511: organization_name,
512: location_name,
579: loop
580: fetch ee_earn into ee_earn_rec;
581: hr_utility.trace('Number of Earnings Records fetched = '||to_char(ee_earn%ROWCOUNT));
582: exit when ee_earn%notfound;
583: insert into pay_us_rpt_totals
584: (tax_unit_id, gre_name, organization_name, location_name,
585: attribute1,
586: value1,
587: attribute2,
995: hr_utility.trace('org name='||l_org_name);
996: hr_utility.trace('location='||l_location_code);
997: hr_utility.trace('Cash Value ='||l_run_val);
998: else
999: hr_utility.trace('Direct Insert into pay_us_rpt_totals');
1000: insert into pay_us_rpt_totals
1001: (tax_unit_id, gre_name, organization_name, location_name,
1002: attribute1,
1003: value1,
996: hr_utility.trace('location='||l_location_code);
997: hr_utility.trace('Cash Value ='||l_run_val);
998: else
999: hr_utility.trace('Direct Insert into pay_us_rpt_totals');
1000: insert into pay_us_rpt_totals
1001: (tax_unit_id, gre_name, organization_name, location_name,
1002: attribute1,
1003: value1,
1004: attribute2,
1209: hr_utility.trace('location='||l_location_code);
1210: hr_utility.trace('Cash Value ='||l_run_val);
1211: end if;
1212: else
1213: insert into pay_us_rpt_totals
1214: ( tax_unit_id, gre_name, organization_name, location_name,
1215: attribute1,
1216: value1,
1217: attribute2,
1373: hr_utility.trace('org name='||l_org_name);
1374: hr_utility.trace('location='||l_location_code);
1375: hr_utility.trace('Cash Value ='||l_run_val);
1376: else
1377: insert into pay_us_rpt_totals
1378: (tax_unit_id, gre_name, organization_name, location_name,
1379: attribute1,
1380: value1,
1381: attribute2,
1569: hr_utility.trace('gre name='||l_gre_name);
1570: hr_utility.trace('org name='||l_org_name);
1571: hr_utility.trace('loc name='||l_location_code);
1572: else
1573: insert into pay_us_rpt_totals
1574: (tax_unit_id, gre_name, organization_name, location_name,
1575: attribute1,
1576: value1,
1577: attribute2,
1784: hr_utility.trace('org name='||l_org_name);
1785: hr_utility.trace('location='||l_location_code);
1786: hr_utility.trace('Cash Value ='||l_bal_value);
1787: else
1788: insert into pay_us_rpt_totals
1789: (tax_unit_id, gre_name, organization_name, location_name,
1790: attribute1,
1791: value1,
1792: attribute2,
1936: BEGIN
1937:
1938: SELECT 'X'
1939: INTO l_dummy_var
1940: from pay_us_rpt_totals
1941: where location_id = l_ppp_pre_payment_id
1942: and tax_unit_id = t_payroll_action_id
1943: and attribute4 = 'Unpaid Payments' ;
1944:
1946:
1947: WHEN NO_DATA_FOUND THEN
1948:
1949:
1950: insert into pay_us_rpt_totals
1951: (tax_unit_id, gre_name, organization_name, location_name,
1952: attribute1,
1953: value1,
1954: attribute2,
2008: EXCEPTION
2009:
2010: WHEN NO_DATA_FOUND THEN
2011:
2012: insert into pay_us_rpt_totals
2013: (tax_unit_id, gre_name, organization_name, location_name,
2014: attribute1,
2015: value1,
2016: attribute2,
2149: BEGIN
2150:
2151: SELECT 'X'
2152: INTO l_dummy_val
2153: FROM pay_us_rpt_totals
2154: where location_id = l_pre_pay_id
2155: and tax_unit_id = t_payroll_action_id
2156: and attribute4 = 'Disbursements';
2157:
2156: and attribute4 = 'Disbursements';
2157:
2158: EXCEPTION
2159: WHEN NO_DATA_FOUND THEN
2160: insert into pay_us_rpt_totals
2161: (tax_unit_id, gre_name, organization_name, location_name,
2162: attribute1,
2163: value1,
2164: attribute2,
2206: l_reverse_amt := nvl(pay_balance_pkg.get_value(
2207: p_defined_balance_id => l_defined_balance_id,
2208: p_assignment_action_id => l_assignment_action_id),0);
2209:
2210: insert into pay_us_rpt_totals
2211: (tax_unit_id, gre_name, organization_name, location_name,
2212: attribute1,
2213: value1,
2214: attribute2,
2470: hr_utility.trace('org name='||l_org_name);
2471: hr_utility.trace('location='||l_location_code);
2472: hr_utility.trace('Cash Value ='||l_bal_value);
2473: else
2474: insert into pay_us_rpt_totals
2475: (tax_unit_id, gre_name, organization_name, location_name,
2476: attribute1,
2477: value1,
2478: attribute2,
2630:
2631: -- #3270485: moved to range_cursor procedure.
2632: --
2633: -- if chnkno = 1 then
2634: -- insert into pay_us_rpt_totals (tax_unit_id,attribute1,organization_id,
2635: -- attribute2,attribute3,attribute4,attribute5)
2636: -- values (pactid,'GTN',ppa_finder,
2637: -- l_leg_param, l_business_group_id,
2638: -- to_char(l_leg_start_date,'MM/DD/YYYY'),
2751: hr_utility.trace('End of LOAD DATA');
2752: close sel_aaid;
2753: if (l_index <>0) then
2754: for x in g_totals_table.first..g_totals_table.last LOOP
2755: INSERT INTO pay_us_rpt_totals(tax_unit_id, gre_name,
2756: organization_name, location_name,
2757: attribute1,
2758: attribute2,
2759: attribute3,
2773: g_totals_table(x).value3
2774: );
2775: END LOOP;
2776: /*forall x in g_totals_table.first..g_totals_table.last
2777: insert into pay_us_rpt_totals
2778: values
2779: g_totals_table(x);*/
2780: l_index :=0;
2781: g_totals_table.DELETE;
2908:
2909: -- #3270485: moved to range_cursor procedure.
2910: --
2911: -- if chnkno = 1 then
2912: -- insert into pay_us_rpt_totals (tax_unit_id,attribute1,organization_id,
2913: -- attribute2,attribute3,attribute4,attribute5)
2914: -- values (pactid,'GTN',ppa_finder,
2915: -- l_leg_param, l_business_group_id,
2916: -- to_char(l_leg_start_date,'MM/DD/YYYY'),
3051: hr_utility.trace('End of LOAD DATA');
3052: close sel_aaid;
3053: if (l_index <>0) then
3054: for x in g_totals_table.first..g_totals_table.last LOOP
3055: INSERT INTO pay_us_rpt_totals(tax_unit_id, gre_name,
3056: organization_name, location_name,
3057: attribute1,
3058: attribute2,
3059: attribute3,
3073: g_totals_table(x).value3
3074: );
3075: END LOOP;
3076: /*forall x in g_totals_table.first..g_totals_table.last
3077: insert into pay_us_rpt_totals
3078: values
3079: g_totals_table(x);*/
3080: commit;
3081: l_index :=0;