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_SUM_TRAN dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 4964: INSERT INTO pa_transaction_interface_all

4960:
4961: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated GMS Override Date count: '||g_bulk_row_count);
4962:
4963: FORALL recno IN 1..r_interface.txn_interface_id.COUNT
4964: INSERT INTO pa_transaction_interface_all
4965: (txn_interface_id, transaction_source,
4966: batch_name, expenditure_ending_date,
4967: employee_number, organization_name,
4968: expenditure_item_date, project_number,

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

4996: loop
4997: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
4998: end loop;
4999:
5000: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted into pa_transaction_interface_all '||g_bulk_row_count);
5001:
5002: FOR recno IN 1..r_interface.txn_interface_id.COUNT
5003: LOOP
5004: GMS_REC.TXN_INTERFACE_ID := r_interface.txn_interface_id(recno);

Line 5128: FROM pa_transaction_interface_all ptxn

5124: SET (pesl.expenditure_id, pesl.expenditure_item_id, pesl.expenditure_ending_date,
5125: pesl.txn_interface_id, pesl.interface_id) =
5126: (SELECT ptxn.expenditure_id, ptxn.expenditure_item_id, ptxn.expenditure_ending_date,
5127: ptxn.txn_interface_id, ptxn.interface_id
5128: FROM pa_transaction_interface_all ptxn
5129: WHERE ptxn.transaction_source = 'GOLDE'
5130: AND ptxn.batch_name = r_gms_batch.gms_batch_name(recno)
5131: AND ptxn.orig_transaction_reference = 'E:' || TO_CHAR(pesl.enc_summary_line_id))
5132: WHERE pesl.gms_batch_name = r_gms_batch.gms_batch_name(recno);

Line 5144: DELETE pa_transaction_interface_all

5140: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'update psp_enc_summary_lines setting encumbrance_item_id count: '||g_bulk_row_count);
5141:
5142:
5143: FORALL recno IN 1..r_gms_batch.gms_batch_name.COUNT
5144: DELETE pa_transaction_interface_all
5145: WHERE batch_name = r_gms_batch.gms_batch_name(recno)
5146: AND transaction_source = 'GOLDE';
5147:
5148: g_bulk_row_count :=0;

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

5150: loop
5151: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
5152: end loop;
5153:
5154: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'delete from pa_transaction_interface_all count:'||g_bulk_row_count);
5155:
5156:
5157:
5158: FORALL recno IN 1..r_gms_batch.gms_batch_name.COUNT

Line 5239: FROM pa_transaction_interface_all

5235: CURSOR gms_tie_back_reject_cur IS
5236: SELECT nvl(transaction_rejection_code,'P'),
5237: orig_transaction_reference,
5238: transaction_status_code
5239: FROM pa_transaction_interface_all
5240: WHERE transaction_source = 'GOLDE'
5241: AND batch_name = p_gms_batch_name
5242: AND orig_transaction_reference IN (SELECT 'E:' || enc_summary_line_id --added subqry for 3953230
5243: FROM psp_enc_summary_lines pesl

Line 5408: from pa_transaction_interface_all

5404: begin
5405:
5406: select count(*), transaction_status_code
5407: into l_cnt, l_status
5408: from pa_transaction_interface_all
5409: where transaction_source = 'GOLDE'
5410: and batch_name = (select distinct gms_batch_name
5411: from psp_enc_summary_lines
5412: where enc_control_id = p_enc_control_id

Line 5428: delete from pa_transaction_interface_all

5424: -- for some reason. Return 'NOT_RUN' in this case. So cleanup the tables and try to transfer
5425: -- again after summarization in the second pass.
5426: -- -------------------------------------------------------------------------------------------
5427:
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

Line 5466: FROM pa_transaction_interface_all

5462: if (PROCESS_COMPLETE not in ('NOT_COMPLETE', 'NOT_RUN')) then
5463:
5464: SELECT count(*)
5465: INTO l_cnt_gms_interface
5466: FROM pa_transaction_interface_all
5467: WHERE transaction_source = 'GOLDE'
5468: AND batch_name = p_gms_batch_name
5469: AND transaction_status_code in ('R', 'PI', 'PR', 'PO');
5470:

Line 5566: DELETE from pa_transaction_interface_all

5562: / **************************************************************************************
5563: For Bug 2290051 - Commenting out purging of Interface tables for accepted Summary Lines
5564: -- purge the interface tables for Accepted summary lines
5565:
5566: DELETE from pa_transaction_interface_all
5567: where transaction_source = 'GOLDE'
5568: and batch_name = p_gms_batch_name
5569: and transaction_status_code = 'A'
5570: and orig_transaction_reference = l_enc_ref;

Line 5854: / * DELETE from pa_transaction_interface_all

5850: AND enc_summary_line_id = l_enc_summary_line_id
5851: AND enc_control_id = p_enc_control_id;
5852:
5853: -- commented For Bug 2290051
5854: / * DELETE from pa_transaction_interface_all
5855: where transaction_source = 'GOLDE'
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);

Line 5933: FROM pa_transaction_interface_all

5929: CURSOR gms_tie_back_reject_cur IS
5930: SELECT NVL(transaction_rejection_code,'P'),
5931: TO_NUMBER(SUBSTR(orig_transaction_reference, 3)),
5932: transaction_status_code
5933: FROM pa_transaction_interface_all
5934: WHERE transaction_source = 'GOLDE'
5935: AND batch_name = p_gms_batch_name;
5936:
5937: CURSOR assign_susp_ac_cur IS

Line 6014: FROM pa_transaction_interface_all

6010: WHERE organization_account_id = p_organization_account_id;
6011:
6012: CURSOR txn_interface_count_cur IS
6013: SELECT COUNT(1)
6014: FROM pa_transaction_interface_all
6015: WHERE transaction_source = 'GOLDE'
6016: AND batch_name = p_gms_batch_name
6017: AND transaction_status_code in ('R', 'PI', 'PO', 'PR');
6018:

Line 6140: FROM pa_transaction_interface_all

6136:
6137: CURSOR transaction_status_cur IS
6138: SELECT COUNT(*),
6139: transaction_status_code
6140: FROM pa_transaction_interface_all
6141: WHERE transaction_source='GOLDE'
6142: AND batch_name = p_gms_batch_name
6143: AND transaction_Status_code in ('P','I')
6144: GROUP BY transaction_status_code;

Line 6162: DELETE FROM pa_transaction_interface_all

6158: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK.PROCESS_COMPLETE');
6159: RETURN TRUE;
6160: ELSIF l_cnt > 0 THEN
6161: IF l_status = 'P' THEN
6162: DELETE FROM pa_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: