APPS.PSP_SUM_TRANS dependencies on GMS_TRANSACTION_INTERFACE_ALL

Line 3548: gms_rec gms_transaction_interface_all%ROWTYPE;

3544: l_product VARCHAR2(3);
3545: l_value VARCHAR2(200);
3546: l_table VARCHAR2(100);
3547: -- Populate the GMS_TRANSACTION_INTERFACE table also.
3548: gms_rec gms_transaction_interface_all%ROWTYPE;
3549: l_gms_transaction_source VARCHAR2(20);
3550: l_txn_source VARCHAR2(30);
3551: -- l_org_id NUMBER(15); -- Commented for R12 MOAC uptake
3552: l_txn_interface_id NUMBER(15);

Line 4313: delete from gms_transaction_interface_all

4309: where batch_name = p_gms_batch_name
4310: and transaction_source = p_txn_source;
4311:
4312: if p_txn_source = 'GOLD' then
4313: delete from gms_transaction_interface_all
4314: where batch_name = p_gms_batch_name
4315: and transaction_source = 'GOLD';
4316: end if;
4317:

Line 4774: DELETE gms_transaction_interface_all

4770: DELETE pa_transaction_interface_all
4771: WHERE transaction_source = p_txn_source
4772: AND batch_name = p_gms_batch_name;
4773:
4774: DELETE gms_transaction_interface_all
4775: WHERE transaction_source = p_txn_source
4776: AND batch_name = p_gms_batch_name;
4777: -- End of bug fix 2643228
4778: IF l_suspense_ac_failed = 'Y' or

Line 5039: DELETE gms_transaction_interface_all

5035: DELETE pa_transaction_interface_all
5036: WHERE transaction_source = p_txn_source
5037: AND batch_name = p_gms_batch_name;
5038:
5039: DELETE gms_transaction_interface_all
5040: WHERE transaction_source = p_txn_source
5041: AND batch_name = p_gms_batch_name;
5042: -- End of bug fix 2643228
5043: END IF;

Line 5050: delete gms_transaction_interface_all

5046: delete pa_transaction_interface_all
5047: where transaction_source = p_txn_source
5048: and batch_name = p_gms_batch_name;
5049:
5050: delete gms_transaction_interface_all
5051: where transaction_source = p_txn_source
5052: and batch_name = p_gms_batch_name;
5053: End of bug fix 2643228 *****/
5054: p_return_status := fnd_api.g_ret_sts_success;