APPS.PSP_ENC_LIQ_TRAN dependencies on GMS_TRANSACTION_INTERFACE_ALL

Line 5126: gms_rec gms_transaction_interface_all%ROWTYPE;

5122: TYPE GMS_TIE_TABTYPE IS TABLE OF GMS_TIE_REC%TYPE
5123: INDEX BY BINARY_INTEGER;
5124:
5125: GMS_TIE_TAB GMS_TIE_TABTYPE;
5126: gms_rec gms_transaction_interface_all%ROWTYPE;
5127: l_txn_source varchar2(30);
5128: l_gms_transaction_source VARCHAR2(30);
5129: l_org_id NUMBER(15);
5130: l_txn_interface_id NUMBER;

Line 5547: 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');

5543: fnd_msg_pub.add;
5544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5545: END IF;
5546: END LOOP;
5547: 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');
5548:
5549: /***** Commented the following for bug fix 4625734
5550: LOOP
5551: FETCH enc_control_cur INTO enc_control_rec;

Line 5998: DELETE gms_transaction_interface_all

5994: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleting from pa_transaction_interface_all count'||g_bulk_row_count);
5995:
5996:
5997: FORALL recno IN 1..r_gms_batch.gms_batch_name.COUNT
5998: DELETE gms_transaction_interface_all
5999: WHERE batch_name = r_gms_batch.gms_batch_name(recno)
6000: AND transaction_source = 'GOLDE';
6001: -- End of changes for bug fix 4625734
6002:

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

6004: FOR bulk_idx IN 1..r_gms_batch.gms_batch_name.COUNT
6005: loop
6006: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
6007: end loop;
6008: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleting from gms_transaction_interface_all count'||g_bulk_row_count);
6009:
6010: /***** Commented the following as there will be distinct gms batch names (as part of bug fix 4625734)
6011: for k in 1..gms_tie_tab.count
6012: loop

Line 6381: delete from gms_transaction_interface_all

6377: and batch_name = p_gms_batch_name;
6378:
6379: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from pa_trancsaction_interface_all sql%rowcount'||sql%rowcount);
6380:
6381: delete from gms_transaction_interface_all
6382: where transaction_source = 'GOLDE'
6383: and batch_name = p_gms_batch_name;
6384:
6385: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from gms_trancsaction_interface_all sql%rowcount'||sql%rowcount);

Line 6466: delete from gms_transaction_interface_all

6462: and batch_name = p_gms_batch_name;
6463:
6464: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from pa_trancsaction_interface_all sql%rowcount'||sql%rowcount);
6465:
6466: delete from gms_transaction_interface_all
6467: where transaction_source = 'GOLDE'
6468: and batch_name = p_gms_batch_name;
6469:
6470: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from gms_trancsaction_interface_all sql%rowcount'||sql%rowcount);

Line 6674: DELETE from gms_transaction_interface_all

6670:
6671: if sql%notfound then null;
6672: end if;
6673:
6674: DELETE from gms_transaction_interface_all
6675: where batch_name = p_gms_batch_name
6676: and transaction_status_code = 'A'
6677: and orig_transaction_reference = l_enc_ref;
6678:

Line 7015: DELETE from gms_transaction_interface_all

7011: and batch_name = p_gms_batch_name
7012: and transaction_status_code = 'A'
7013: and orig_transaction_reference = 'E:' || to_char(l_enc_summary_line_id);
7014:
7015: DELETE from gms_transaction_interface_all
7016: where transaction_source = 'GOLDE'
7017: and batch_name = p_gms_batch_name
7018: and transaction_status_code = 'A'
7019: and orig_transaction_reference = 'E:' || to_char(l_enc_summary_line_id);