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 5470: INSERT INTO pa_transaction_interface_all

5466: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated GMS Override Date count: '||g_bulk_row_count);
5467:
5468:
5469: FORALL recno IN 1..r_interface.txn_interface_id.COUNT
5470: INSERT INTO pa_transaction_interface_all
5471: (txn_interface_id, transaction_source,
5472: batch_name, expenditure_ending_date,
5473: employee_number, organization_name,
5474: expenditure_item_date, project_number,

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

5501: FOR bulk_idx IN 1..r_interface.txn_interface_id.COUNT
5502: loop
5503: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
5504: end loop;
5505: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted into pa_transaction_interface_all count: '||g_bulk_row_count);
5506:
5507:
5508: 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);
5509:

Line 5968: FROM pa_transaction_interface_all ptxn

5964: SET (pesl.expenditure_id, pesl.expenditure_item_id, pesl.expenditure_ending_date,
5965: pesl.txn_interface_id, pesl.interface_id) =
5966: (SELECT ptxn.expenditure_id, ptxn.expenditure_item_id, ptxn.expenditure_ending_date,
5967: ptxn.txn_interface_id, ptxn.interface_id
5968: FROM pa_transaction_interface_all ptxn
5969: WHERE ptxn.transaction_source = 'GOLDE'
5970: AND ptxn.batch_name = r_gms_batch.gms_batch_name(recno)
5971: AND ptxn.orig_transaction_reference = 'E:' || TO_CHAR(pesl.enc_summary_line_id))
5972: WHERE pesl.gms_batch_name = r_gms_batch.gms_batch_name(recno);

Line 5985: DELETE pa_transaction_interface_all

5981: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_enc_summary_lines setting expenditure_item_id count'||g_bulk_row_count);
5982:
5983:
5984: FORALL recno IN 1..r_gms_batch.gms_batch_name.COUNT
5985: DELETE pa_transaction_interface_all
5986: WHERE batch_name = r_gms_batch.gms_batch_name(recno)
5987: AND transaction_source = 'GOLDE';
5988:
5989: g_bulk_row_count :=0;

Line 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);

5990: FOR bulk_idx IN 1..r_gms_batch.gms_batch_name.COUNT
5991: loop
5992: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
5993: end loop;
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

Line 6082: FROM pa_transaction_interface_all

6078: CURSOR gms_tie_back_reject_cur IS
6079: SELECT nvl(transaction_rejection_code,'P'),
6080: TO_NUMBER(SUBSTR(orig_transaction_reference, 3)), -- Introuduced TO_NUMBER and SUBSTR for bug fix 4625734
6081: transaction_status_code
6082: FROM pa_transaction_interface_all
6083: WHERE transaction_source = 'GOLDE'
6084: AND batch_name = p_gms_batch_name;
6085: /***** Commented the following condition as Tie Back is by per gms batch and not by enc_control_id (for bug fix 4625734)
6086: AND orig_transaction_reference IN (SELECT 'E:' || enc_summary_line_id -- Introduced for bug fix 3953230

Line 6250: FROM pa_transaction_interface_all

6246:
6247: -- Introduced the following for bug fix 4625734
6248: CURSOR txn_interface_count_cur IS
6249: SELECT COUNT(1)
6250: FROM pa_transaction_interface_all
6251: WHERE transaction_source = 'GOLDE'
6252: AND batch_name = p_gms_batch_name
6253: AND transaction_status_code in ('R', 'PI', 'PO', 'PR');
6254:

Line 6295: from pa_transaction_interface_all

6291: FROM psp_enc_summary_lines
6292: WHERE enc_summary_line_id in
6293: (
6294: select to_number(substr(ORIG_TRANSACTION_REFERENCE,3))
6295: from pa_transaction_interface_all
6296: WHERE batch_name = p_gms_batch_name
6297: AND transaction_status_code = 'P'
6298: )
6299: AND gms_batch_name = p_gms_batch_name;

Line 6314: from pa_transaction_interface_all

6310: FROM psp_enc_summary_lines
6311: WHERE enc_summary_line_id in
6312: (
6313: select to_number(substr(ORIG_TRANSACTION_REFERENCE,3))
6314: from pa_transaction_interface_all
6315: WHERE batch_name = p_gms_batch_name
6316: AND transaction_status_code = 'P'
6317: )
6318: AND gms_batch_name = p_gms_batch_name;

Line 6324: FROM pa_transaction_interface_all

6320:
6321: CURSOR transaction_status_cur IS
6322: SELECT COUNT(*),
6323: transaction_status_code
6324: FROM pa_transaction_interface_all
6325: WHERE transaction_source='GOLDE'
6326: AND batch_name = p_gms_batch_name
6327: AND transaction_Status_code in ('P','I')
6328: GROUP BY transaction_status_code;

Line 6335: from pa_transaction_interface_all

6331: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering GMS_ENC_TIE_BACK.PROCESS_COMPLETE');
6332: /*
6333: select count(*), transaction_status_code
6334: into l_cnt, l_status
6335: from pa_transaction_interface_all
6336: where transaction_source = 'GOLDE'
6337: and batch_name = (select distinct gms_batch_name
6338: from psp_enc_summary_lines
6339: where enc_control_id = p_enc_control_id

Line 6347: pa_transaction_interface_all where transaction_source='GOLDE' and

6343: */
6344:
6345: /**** Converted the following code in CURSOR for bug fix 4625734
6346: select count(*), transaction_status_code into l_cnt,l_status from
6347: pa_transaction_interface_all where transaction_source='GOLDE' and
6348: batch_name=p_gms_batch_name and transaction_Status_code in ('P','I')
6349: group by transaction_status_code;
6350: End of comment for bug fix 4625734 *****/
6351:

Line 6375: delete from pa_transaction_interface_all

6371: -- -------------------------------------------------------------------------------------------
6372:
6373: --Commented the following for the bug 13391191
6374: /***
6375: delete from pa_transaction_interface_all
6376: where transaction_source = 'GOLDE'
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);

Line 6428: from pa_transaction_interface_all

6424: delete from psp_enc_summary_lines
6425: where enc_summary_line_id in
6426: (
6427: select to_number(substr(ORIG_TRANSACTION_REFERENCE,3))
6428: from pa_transaction_interface_all
6429: WHERE batch_name = p_gms_batch_name
6430: AND transaction_status_code = 'P'
6431: )
6432: AND gms_batch_name = p_gms_batch_name;

Line 6460: delete from pa_transaction_interface_all

6456: g_liq_has_failed_transactions := TRUE;
6457: -- End of changes for bug fix 4625734
6458:
6459: --Bug 13391191
6460: delete from pa_transaction_interface_all
6461: where transaction_source = 'GOLDE'
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);

Line 6501: FROM pa_transaction_interface_all

6497: if (PROCESS_COMPLETE) then
6498: /***** Changed the following SELECT into CURSOR for bug fix 4625734
6499: SELECT count(*)
6500: INTO l_cnt_gms_interface
6501: FROM pa_transaction_interface_all
6502: WHERE transaction_source = 'GOLDE'
6503: AND batch_name = p_gms_batch_name
6504: AND transaction_status_code in ('R', 'PI', 'PO', 'PR');
6505: End of comment for bug fix 4625734 *****/

Line 6665: DELETE from pa_transaction_interface_all

6661: if sql%notfound then null;
6662: end if;
6663: / ************************************************************************************************************
6664: For Bug 2290051 : Interface Lines shall not be deleted for accepeted summary lines
6665: DELETE from pa_transaction_interface_all
6666: where transaction_source = 'GOLDE'
6667: and batch_name = p_gms_batch_name
6668: and transaction_status_code = 'A'
6669: and orig_transaction_reference = l_enc_ref;

Line 7009: DELETE from pa_transaction_interface_all

7005:
7006: / ************************************************************************************************************
7007: For Bug 2290051 : Interface Lines shall not be deleted for accepeted summary lines
7008:
7009: DELETE from pa_transaction_interface_all
7010: where transaction_source = 'GOLDE'
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);