APPS.PSP_ENC_LIQ_TRAN dependencies on GMS_TRANSACTION_INTERFACE_ALL

Line 5061: gms_rec gms_transaction_interface_all%ROWTYPE;

5057: TYPE GMS_TIE_TABTYPE IS TABLE OF GMS_TIE_REC%TYPE
5058: INDEX BY BINARY_INTEGER;
5059:
5060: GMS_TIE_TAB GMS_TIE_TABTYPE;
5061: gms_rec gms_transaction_interface_all%ROWTYPE;
5062: l_txn_source varchar2(30);
5063: l_gms_transaction_source VARCHAR2(30);
5064: l_org_id NUMBER(15);
5065: l_txn_interface_id NUMBER;

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

5448: fnd_msg_pub.add;
5449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5450: END IF;
5451: END LOOP;
5452: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted into gms_transaction_interface_all');
5453:
5454: /***** Commented the following for bug fix 4625734
5455: LOOP
5456: FETCH enc_control_cur INTO enc_control_rec;

Line 5875: DELETE gms_transaction_interface_all

5871: WHERE batch_name = r_gms_batch.gms_batch_name(recno)
5872: AND transaction_source = 'GOLDE';
5873:
5874: FORALL recno IN 1..r_gms_batch.gms_batch_name.COUNT
5875: DELETE gms_transaction_interface_all
5876: WHERE batch_name = r_gms_batch.gms_batch_name(recno)
5877: AND transaction_source = 'GOLDE';
5878: -- End of changes for bug fix 4625734
5879:

Line 6229: delete from gms_transaction_interface_all

6225: and batch_name = p_gms_batch_name;
6226:
6227: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from pa_trancsaction_interface_all');
6228:
6229: delete from gms_transaction_interface_all
6230: where transaction_source = 'GOLDE'
6231: and batch_name = p_gms_batch_name;
6232:
6233: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from gms_trancsaction_interface_all');

Line 6457: DELETE from gms_transaction_interface_all

6453:
6454: if sql%notfound then null;
6455: end if;
6456:
6457: DELETE from gms_transaction_interface_all
6458: where batch_name = p_gms_batch_name
6459: and transaction_status_code = 'A'
6460: and orig_transaction_reference = l_enc_ref;
6461:

Line 6778: DELETE from gms_transaction_interface_all

6774: and batch_name = p_gms_batch_name
6775: and transaction_status_code = 'A'
6776: and orig_transaction_reference = 'E:' || to_char(l_enc_summary_line_id);
6777:
6778: DELETE from gms_transaction_interface_all
6779: where transaction_source = 'GOLDE'
6780: and batch_name = p_gms_batch_name
6781: and transaction_status_code = 'A'
6782: and orig_transaction_reference = 'E:' || to_char(l_enc_summary_line_id);