APPS.PSP_ENC_SUM_TRAN dependencies on GMS_TRANSACTION_INTERFACE_ALL

Line 4543: gms_rec gms_transaction_interface_all%ROWTYPE;

4539:
4540: TYPE GMS_TIE_TABTYPE IS TABLE OF GMS_TIE_REC%TYPE INDEX BY BINARY_INTEGER;
4541:
4542: GMS_TIE_TAB GMS_TIE_TABTYPE;
4543: gms_rec gms_transaction_interface_all%ROWTYPE;
4544: l_txn_source varchar2(30);
4545: l_gms_transaction_source VARCHAR2(30);
4546: l_org_id NUMBER(15);
4547: l_txn_interface_id NUMBER;

Line 4895: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted into gms_transaction_interface_all');

4891: fnd_msg_pub.add;
4892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4893: END IF;
4894: END LOOP;
4895: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted into gms_transaction_interface_all');
4896: IF r_interface.txn_interface_id.COUNT > 0 THEN
4897:
4898: FOR request_counter IN 1..org_id_tab.count
4899: LOOP

Line 4998: DELETE gms_transaction_interface_all

4994: WHERE batch_name = r_gms_batch.gms_batch_name(recno)
4995: AND transaction_source = 'GOLDE';
4996:
4997: FORALL recno IN 1..r_gms_batch.gms_batch_name.COUNT
4998: DELETE gms_transaction_interface_all
4999: WHERE batch_name = r_gms_batch.gms_batch_name(recno)
5000: AND transaction_source = 'GOLDE';
5001:
5002: FORALL recno IN 1..r_gms_batch.gms_batch_name.COUNT

Line 5249: delete from gms_transaction_interface_all

5245: delete from pa_transaction_interface_all
5246: where transaction_source = 'GOLDE'
5247: and batch_name = p_gms_batch_name;
5248:
5249: delete from gms_transaction_interface_all
5250: where transaction_source = 'GOLDE'
5251: and batch_name = p_gms_batch_name;
5252:
5253: delete from psp_enc_summary_lines

Line 5389: DELETE from gms_transaction_interface_all

5385: and batch_name = p_gms_batch_name
5386: and transaction_status_code = 'A'
5387: and orig_transaction_reference = l_enc_ref;
5388:
5389: DELETE from gms_transaction_interface_all
5390: where transaction_source = 'GOLDE'
5391: and batch_name = p_gms_batch_name
5392: and transaction_status_code = 'A'
5393: and orig_transaction_reference = l_enc_ref;

Line 5677: DELETE from gms_transaction_interface_all

5673: and batch_name = p_gms_batch_name
5674: and transaction_status_code = 'A'
5675: and orig_transaction_reference = 'E:' || to_char(l_enc_summary_line_id);
5676:
5677: DELETE from gms_transaction_interface_all
5678: where transaction_source = 'GOLDE'
5679: and batch_name = p_gms_batch_name
5680: and transaction_status_code = 'A'
5681: and orig_transaction_reference = 'E:' || to_char(l_enc_summary_line_id); * /

Line 5984: DELETE FROM gms_transaction_interface_all

5980: WHERE transaction_source = 'GOLDE'
5981: AND batch_name = p_gms_batch_name;
5982: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from pa_trancsaction_interface_all');
5983:
5984: DELETE FROM gms_transaction_interface_all
5985: WHERE transaction_source = 'GOLDE'
5986: AND batch_name = p_gms_batch_name;
5987: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from gms_trancsaction_interface_all');
5988: