[Home] [Help]
517:
518: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' delete from pa_transaction_interface_all count : '||sql%rowcount);
519:
520: -- introduced following stmnt for 2445196
521: delete from gms_transaction_interface_all
522: -- where batch_name = g_gms_batch_name
523: WHERE batch_name IN (SELECT GMS_BATCH_NAME
524: FROM psp_summary_lines
525: WHERE PAYROLL_CONTROL_ID IN(SELECT payroll_control_id
526: FROM psp_payroll_controls
527: WHERE adj_sum_batch_name =p_adj_sum_batch_name))
528: and transaction_source = 'GOLD';
529:
530: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' delete from gms_transaction_interface_all count : '||sql%rowcount);
531:
532: OPEN pc_batch_cur;
533: LOOP
534: FETCH pc_batch_cur into pc_batch_rec;
2930: l_batch_cnt NUMBER(9) := 0;
2931: l_org_id NUMBER(15);
2932: l_gms_transaction_source VARCHAR2(30);
2933: l_txn_source VARCHAR2(30);
2934: gms_rec gms_transaction_interface_all%ROWTYPE;
2935: l_txn_interface_id number(15);
2936: l_person_name VARCHAR2(240); -- Included for bug fix 1828519
2937: l_gms_install BOOLEAN DEFAULT gms_install.enabled; -- Introduced for bug fix 2908859
2938:
3908: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' deleted from pa_transaction_interface_all count: '||sql%rowcount);
3909:
3910:
3911: if (l_txn_source = 'GOLD') then
3912: delete from gms_transaction_interface_all
3913: where batch_name = to_char(l_gms_batch_name)
3914: and transaction_source = 'GOLD';
3915: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' deleted from gms_transaction_interface_all count: '||sql%rowcount);
3916:
3911: if (l_txn_source = 'GOLD') then
3912: delete from gms_transaction_interface_all
3913: where batch_name = to_char(l_gms_batch_name)
3914: and transaction_source = 'GOLD';
3915: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' deleted from gms_transaction_interface_all count: '||sql%rowcount);
3916:
3917: end if;
3918:
3919: /* Commented for 2133056, Let recover start from Import and not Summarize
3981:
3982: end if;
3983:
3984: if (l_txn_source = 'GOLD') then
3985: delete gms_transaction_interface_all
3986: where transaction_source in ('GOLD') and
3987: batch_name = l_gms_batch_name;
3988: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' deleted from gms_transaction_interface_all count: '||sql%rowcount);
3989:
3984: if (l_txn_source = 'GOLD') then
3985: delete gms_transaction_interface_all
3986: where transaction_source in ('GOLD') and
3987: batch_name = l_gms_batch_name;
3988: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' deleted from gms_transaction_interface_all count: '||sql%rowcount);
3989:
3990: end if;
3991:
3992: delete pa_transaction_interface_all
4526: and source_type='A')); --Added for bug 1685685
4527:
4528: /***********************************************************************
4529: BUG 2290051 : Commenting the following -purging of Interface lines
4530: delete gms_transaction_interface_all
4531: where transaction_source in ('GOLD') and
4532: batch_name = g_gms_batch_name and
4533: orig_transaction_reference in
4534: (select to_char(summary_line_id)
4800: delete from pa_transaction_interface_all
4801: where batch_name = to_char(l_gms_batch_name)
4802: and transaction_source in ('GOLD', 'OLD');
4803:
4804: delete from gms_transaction_interface_all
4805: where batch_name = to_char(l_gms_batch_name)
4806: and transaction_source = 'GOLD';
4807:
4808: delete from psp_summary_lines