eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_ENC_LIQ_TRAN dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 5382: INSERT INTO pa_transaction_interface_all

5378:
5379: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated GMS Override Date');
5380:
5381: FORALL recno IN 1..r_interface.txn_interface_id.COUNT
5382: INSERT INTO pa_transaction_interface_all
5383: (txn_interface_id, transaction_source,
5384: batch_name, expenditure_ending_date,
5385: employee_number, organization_name,
5386: expenditure_item_date, project_number,

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

5408: r_interface.attribute7(recno), r_interface.attribute8(recno),
5409: r_interface.attribute9(recno), r_interface.attribute10(recno),
5410: g_bg_id);
5411:
5412: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted into pa_transaction_interface_all');
5413:
5414: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' r_interface.txn_interface_id.COUNT: ' || r_interface.txn_interface_id.COUNT);
5415:
5416: FOR recno IN 1..r_interface.txn_interface_id.COUNT

Line 5863: FROM pa_transaction_interface_all ptxn

5859: SET (pesl.expenditure_id, pesl.expenditure_item_id, pesl.expenditure_ending_date,
5860: pesl.txn_interface_id, pesl.interface_id) =
5861: (SELECT ptxn.expenditure_id, ptxn.expenditure_item_id, ptxn.expenditure_ending_date,
5862: ptxn.txn_interface_id, ptxn.interface_id
5863: FROM pa_transaction_interface_all ptxn
5864: WHERE ptxn.transaction_source = 'GOLDE'
5865: AND ptxn.batch_name = r_gms_batch.gms_batch_name(recno)
5866: AND ptxn.orig_transaction_reference = 'E:' || TO_CHAR(pesl.enc_summary_line_id))
5867: WHERE pesl.gms_batch_name = r_gms_batch.gms_batch_name(recno);

Line 5870: DELETE pa_transaction_interface_all

5866: AND ptxn.orig_transaction_reference = 'E:' || TO_CHAR(pesl.enc_summary_line_id))
5867: WHERE pesl.gms_batch_name = r_gms_batch.gms_batch_name(recno);
5868:
5869: FORALL recno IN 1..r_gms_batch.gms_batch_name.COUNT
5870: DELETE pa_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

Line 5949: FROM pa_transaction_interface_all

5945: CURSOR gms_tie_back_reject_cur IS
5946: SELECT nvl(transaction_rejection_code,'P'),
5947: TO_NUMBER(SUBSTR(orig_transaction_reference, 3)), -- Introuduced TO_NUMBER and SUBSTR for bug fix 4625734
5948: transaction_status_code
5949: FROM pa_transaction_interface_all
5950: WHERE transaction_source = 'GOLDE'
5951: AND batch_name = p_gms_batch_name;
5952: /***** Commented the following condition as Tie Back is by per gms batch and not by enc_control_id (for bug fix 4625734)
5953: AND orig_transaction_reference IN (SELECT 'E:' || enc_summary_line_id -- Introduced for bug fix 3953230

Line 6117: FROM pa_transaction_interface_all

6113:
6114: -- Introduced the following for bug fix 4625734
6115: CURSOR txn_interface_count_cur IS
6116: SELECT COUNT(1)
6117: FROM pa_transaction_interface_all
6118: WHERE transaction_source = 'GOLDE'
6119: AND batch_name = p_gms_batch_name
6120: AND transaction_status_code in ('R', 'PI', 'PO', 'PR');
6121:

Line 6175: FROM pa_transaction_interface_all

6171:
6172: CURSOR transaction_status_cur IS
6173: SELECT COUNT(*),
6174: transaction_status_code
6175: FROM pa_transaction_interface_all
6176: WHERE transaction_source='GOLDE'
6177: AND batch_name = p_gms_batch_name
6178: AND transaction_Status_code in ('P','I')
6179: GROUP BY transaction_status_code;

Line 6186: from pa_transaction_interface_all

6182: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering GMS_ENC_TIE_BACK.PROCESS_COMPLETE');
6183: /*
6184: select count(*), transaction_status_code
6185: into l_cnt, l_status
6186: from pa_transaction_interface_all
6187: where transaction_source = 'GOLDE'
6188: and batch_name = (select distinct gms_batch_name
6189: from psp_enc_summary_lines
6190: where enc_control_id = p_enc_control_id

Line 6198: pa_transaction_interface_all where transaction_source='GOLDE' and

6194: */
6195:
6196: /**** Converted the following code in CURSOR for bug fix 4625734
6197: select count(*), transaction_status_code into l_cnt,l_status from
6198: pa_transaction_interface_all where transaction_source='GOLDE' and
6199: batch_name=p_gms_batch_name and transaction_Status_code in ('P','I')
6200: group by transaction_status_code;
6201: End of comment for bug fix 4625734 *****/
6202:

Line 6223: delete from pa_transaction_interface_all

6219: -- If transaction_status_code = 'P' then the transaction import process did not kick off
6220: -- for some reason. Return 'NOT_RUN' in this case. So cleanup the tables and try to transfer
6221: -- again after summarization in the second pass.
6222: -- -------------------------------------------------------------------------------------------
6223: delete from pa_transaction_interface_all
6224: where transaction_source = 'GOLDE'
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');

Line 6312: FROM pa_transaction_interface_all

6308: if (PROCESS_COMPLETE) then
6309: /***** Changed the following SELECT into CURSOR for bug fix 4625734
6310: SELECT count(*)
6311: INTO l_cnt_gms_interface
6312: FROM pa_transaction_interface_all
6313: WHERE transaction_source = 'GOLDE'
6314: AND batch_name = p_gms_batch_name
6315: AND transaction_status_code in ('R', 'PI', 'PO', 'PR');
6316: End of comment for bug fix 4625734 *****/

Line 6448: DELETE from pa_transaction_interface_all

6444: if sql%notfound then null;
6445: end if;
6446: / ************************************************************************************************************
6447: For Bug 2290051 : Interface Lines shall not be deleted for accepeted summary lines
6448: DELETE from pa_transaction_interface_all
6449: where transaction_source = 'GOLDE'
6450: and batch_name = p_gms_batch_name
6451: and transaction_status_code = 'A'
6452: and orig_transaction_reference = l_enc_ref;

Line 6772: DELETE from pa_transaction_interface_all

6768:
6769: / ************************************************************************************************************
6770: For Bug 2290051 : Interface Lines shall not be deleted for accepeted summary lines
6771:
6772: DELETE from pa_transaction_interface_all
6773: where transaction_source = 'GOLDE'
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);