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.PSP_SUM_TRANS dependencies on GMS_TRANSACTION_INTERFACE_ALL

Line 3739: gms_rec gms_transaction_interface_all%ROWTYPE;

3735: l_product VARCHAR2(3);
3736: l_value VARCHAR2(200);
3737: l_table VARCHAR2(100);
3738: -- Populate the GMS_TRANSACTION_INTERFACE table also.
3739: gms_rec gms_transaction_interface_all%ROWTYPE;
3740: l_gms_transaction_source VARCHAR2(20);
3741: l_txn_source VARCHAR2(30);
3742: -- l_org_id NUMBER(15); -- Commented for R12 MOAC uptake
3743: l_txn_interface_id NUMBER(15);

Line 4583: delete from gms_transaction_interface_all

4579: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from pa_transaction_interface_all count:'||sql%rowcount);
4580:
4581:
4582: if p_txn_source = 'GOLD' then
4583: delete from gms_transaction_interface_all
4584: where batch_name = p_gms_batch_name
4585: and transaction_source = 'GOLD';
4586:
4587: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from gms_transaction_interface_all count:'||sql%rowcount);

Line 4587: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from gms_transaction_interface_all count:'||sql%rowcount);

4583: delete from gms_transaction_interface_all
4584: where batch_name = p_gms_batch_name
4585: and transaction_source = 'GOLD';
4586:
4587: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from gms_transaction_interface_all count:'||sql%rowcount);
4588:
4589: end if;
4590:
4591: delete from psp_summary_lines

Line 5126: DELETE gms_transaction_interface_all

5122: AND batch_name = p_gms_batch_name;
5123: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from pa_transaction_interface_all count: '||sql%rowcount);
5124:
5125:
5126: DELETE gms_transaction_interface_all
5127: WHERE transaction_source = p_txn_source
5128: AND batch_name = p_gms_batch_name;
5129: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from gms_transaction_interface_all count: '||sql%rowcount);
5130:

Line 5129: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from gms_transaction_interface_all count: '||sql%rowcount);

5125:
5126: DELETE gms_transaction_interface_all
5127: WHERE transaction_source = p_txn_source
5128: AND batch_name = p_gms_batch_name;
5129: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from gms_transaction_interface_all count: '||sql%rowcount);
5130:
5131: -- End of bug fix 2643228
5132: IF l_suspense_ac_failed = 'Y' or
5133: nvl(l_auto_status,'X') in ('AUTO_POP_NA_ERROR', 'AUTO_POP_EXP_ERROR', 'AUTO_POP_NO_VALUE') then

Line 5445: DELETE gms_transaction_interface_all

5441: AND batch_name = p_gms_batch_name;
5442: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' delete from pa_transaction_interface_all for batch_name: '||p_gms_batch_name);
5443:
5444:
5445: DELETE gms_transaction_interface_all
5446: WHERE transaction_source = p_txn_source
5447: AND batch_name = p_gms_batch_name;
5448:
5449: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' delete from gms_transaction_interface_all for batch_name: '||p_gms_batch_name);

Line 5449: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' delete from gms_transaction_interface_all for batch_name: '||p_gms_batch_name);

5445: DELETE gms_transaction_interface_all
5446: WHERE transaction_source = p_txn_source
5447: AND batch_name = p_gms_batch_name;
5448:
5449: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' delete from gms_transaction_interface_all for batch_name: '||p_gms_batch_name);
5450:
5451: -- End of bug fix 2643228
5452: END IF;
5453: /***** Commented for bug fix 2643228

Line 5459: delete gms_transaction_interface_all

5455: delete pa_transaction_interface_all
5456: where transaction_source = p_txn_source
5457: and batch_name = p_gms_batch_name;
5458:
5459: delete gms_transaction_interface_all
5460: where transaction_source = p_txn_source
5461: and batch_name = p_gms_batch_name;
5462: End of bug fix 2643228 *****/
5463: p_return_status := fnd_api.g_ret_sts_success;