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.

[Home] [Help]

APPS.PSP_SUM_ADJ dependencies on GMS_TRANSACTION_INTERFACE_ALL

Line 453: delete from gms_transaction_interface_all

449: ---AND transaction_status_code = 'A' delete 'R' also, for 2445196
450: AND transaction_source in ('OLD', 'GOLD');
451:
452: -- introduced following stmnt for 2445196
453: delete from gms_transaction_interface_all
454: -- where batch_name = g_gms_batch_name
455: WHERE batch_name IN (SELECT GMS_BATCH_NAME
456: FROM psp_summary_lines
457: WHERE PAYROLL_CONTROL_ID IN(SELECT payroll_control_id

Line 2790: gms_rec gms_transaction_interface_all%ROWTYPE;

2786: l_batch_cnt NUMBER(9) := 0;
2787: l_org_id NUMBER(15);
2788: l_gms_transaction_source VARCHAR2(30);
2789: l_txn_source VARCHAR2(30);
2790: gms_rec gms_transaction_interface_all%ROWTYPE;
2791: l_txn_interface_id number(15);
2792: l_person_name VARCHAR2(240); -- Included for bug fix 1828519
2793: l_gms_install BOOLEAN DEFAULT gms_install.enabled; -- Introduced for bug fix 2908859
2794:

Line 3546: delete from gms_transaction_interface_all

3542: where batch_name = to_char(l_gms_batch_name)
3543: and transaction_source = l_txn_source;
3544:
3545: if (l_txn_source = 'GOLD') then
3546: delete from gms_transaction_interface_all
3547: where batch_name = to_char(l_gms_batch_name)
3548: and transaction_source = 'GOLD';
3549: end if;
3550:

Line 3605: delete gms_transaction_interface_all

3601: where expenditure_group = l_exp_group_name;
3602: end if;
3603:
3604: if (l_txn_source = 'GOLD') then
3605: delete gms_transaction_interface_all
3606: where transaction_source in ('GOLD') and
3607: batch_name = l_gms_batch_name;
3608: end if;
3609:

Line 4099: delete gms_transaction_interface_all

4095: and source_type='A')); --Added for bug 1685685
4096:
4097: /***********************************************************************
4098: BUG 2290051 : Commenting the following -purging of Interface lines
4099: delete gms_transaction_interface_all
4100: where transaction_source in ('GOLD') and
4101: batch_name = g_gms_batch_name and
4102: orig_transaction_reference in
4103: (select to_char(summary_line_id)

Line 4373: delete from gms_transaction_interface_all

4369: delete from pa_transaction_interface_all
4370: where batch_name = to_char(l_gms_batch_name)
4371: and transaction_source in ('GOLD', 'OLD');
4372:
4373: delete from gms_transaction_interface_all
4374: where batch_name = to_char(l_gms_batch_name)
4375: and transaction_source = 'GOLD';
4376:
4377: delete from psp_summary_lines