APPS.PSP_ENC_SUM_TRAN dependencies on GMS_TRANSACTION_INTERFACE_ALL

Line 4652: gms_rec gms_transaction_interface_all%ROWTYPE;

4648:
4649: TYPE GMS_TIE_TABTYPE IS TABLE OF GMS_TIE_REC%TYPE INDEX BY BINARY_INTEGER;
4650:
4651: GMS_TIE_TAB GMS_TIE_TABTYPE;
4652: gms_rec gms_transaction_interface_all%ROWTYPE;
4653: l_txn_source varchar2(30);
4654: l_gms_transaction_source VARCHAR2(30);
4655: l_org_id NUMBER(15);
4656: l_txn_interface_id NUMBER;

Line 5031: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted into gms_transaction_interface_all by calling gms_transactions_pub.LOAD_GMS_XFACE_API');

5027: fnd_msg_pub.add;
5028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5029: END IF;
5030: END LOOP;
5031: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted into gms_transaction_interface_all by calling gms_transactions_pub.LOAD_GMS_XFACE_API');
5032: IF r_interface.txn_interface_id.COUNT > 0 THEN
5033:
5034: FOR request_counter IN 1..org_id_tab.count
5035: LOOP

Line 5159: DELETE gms_transaction_interface_all

5155:
5156:
5157:
5158: FORALL recno IN 1..r_gms_batch.gms_batch_name.COUNT
5159: DELETE gms_transaction_interface_all
5160: WHERE batch_name = r_gms_batch.gms_batch_name(recno)
5161: AND transaction_source = 'GOLDE';
5162:
5163: g_bulk_row_count :=0;

Line 5169: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'delete from gms_transaction_interface_all count:'||g_bulk_row_count);

5165: loop
5166: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
5167: end loop;
5168:
5169: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'delete from gms_transaction_interface_all count:'||g_bulk_row_count);
5170:
5171:
5172:
5173: FORALL recno IN 1..r_gms_batch.gms_batch_name.COUNT

Line 5432: delete from gms_transaction_interface_all

5428: delete from pa_transaction_interface_all
5429: where transaction_source = 'GOLDE'
5430: and batch_name = p_gms_batch_name;
5431:
5432: delete from gms_transaction_interface_all
5433: where transaction_source = 'GOLDE'
5434: and batch_name = p_gms_batch_name;
5435:
5436: delete from psp_enc_summary_lines

Line 5572: DELETE from gms_transaction_interface_all

5568: and batch_name = p_gms_batch_name
5569: and transaction_status_code = 'A'
5570: and orig_transaction_reference = l_enc_ref;
5571:
5572: DELETE from gms_transaction_interface_all
5573: where transaction_source = 'GOLDE'
5574: and batch_name = p_gms_batch_name
5575: and transaction_status_code = 'A'
5576: and orig_transaction_reference = l_enc_ref;

Line 5860: DELETE from gms_transaction_interface_all

5856: and batch_name = p_gms_batch_name
5857: and transaction_status_code = 'A'
5858: and orig_transaction_reference = 'E:' || to_char(l_enc_summary_line_id);
5859:
5860: DELETE from gms_transaction_interface_all
5861: where transaction_source = 'GOLDE'
5862: and batch_name = p_gms_batch_name
5863: and transaction_status_code = 'A'
5864: and orig_transaction_reference = 'E:' || to_char(l_enc_summary_line_id); * /

Line 6167: DELETE FROM gms_transaction_interface_all

6163: WHERE transaction_source = 'GOLDE'
6164: AND batch_name = p_gms_batch_name;
6165: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from pa_trancsaction_interface_all count: '||sql%rowcount);
6166:
6167: DELETE FROM gms_transaction_interface_all
6168: WHERE transaction_source = 'GOLDE'
6169: AND batch_name = p_gms_batch_name;
6170: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from gms_trancsaction_interface_all count: '||sql%rowcount);
6171: DELETE FROM psp_enc_summary_lines