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

4830:
4831: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated GMS Override Date');
4832:
4833: FORALL recno IN 1..r_interface.txn_interface_id.COUNT
4834: INSERT INTO pa_transaction_interface_all
4835: (txn_interface_id, transaction_source,
4836: batch_name, expenditure_ending_date,
4837: employee_number, organization_name,
4838: expenditure_item_date, project_number,

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

4860: r_interface.attribute7(recno), r_interface.attribute8(recno),
4861: r_interface.attribute9(recno), r_interface.attribute10(recno),
4862: g_business_group_id,r_interface.unmatched_nve_txn_flag(recno));
4863:
4864: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted into pa_transaction_interface_all');
4865:
4866: FOR recno IN 1..r_interface.txn_interface_id.COUNT
4867: LOOP
4868: GMS_REC.TXN_INTERFACE_ID := r_interface.txn_interface_id(recno);

Line 4986: FROM pa_transaction_interface_all ptxn

4982: SET (pesl.expenditure_id, pesl.expenditure_item_id, pesl.expenditure_ending_date,
4983: pesl.txn_interface_id, pesl.interface_id) =
4984: (SELECT ptxn.expenditure_id, ptxn.expenditure_item_id, ptxn.expenditure_ending_date,
4985: ptxn.txn_interface_id, ptxn.interface_id
4986: FROM pa_transaction_interface_all ptxn
4987: WHERE ptxn.transaction_source = 'GOLDE'
4988: AND ptxn.batch_name = r_gms_batch.gms_batch_name(recno)
4989: AND ptxn.orig_transaction_reference = 'E:' || TO_CHAR(pesl.enc_summary_line_id))
4990: WHERE pesl.gms_batch_name = r_gms_batch.gms_batch_name(recno);

Line 4993: DELETE pa_transaction_interface_all

4989: AND ptxn.orig_transaction_reference = 'E:' || TO_CHAR(pesl.enc_summary_line_id))
4990: WHERE pesl.gms_batch_name = r_gms_batch.gms_batch_name(recno);
4991:
4992: FORALL recno IN 1..r_gms_batch.gms_batch_name.COUNT
4993: DELETE pa_transaction_interface_all
4994: WHERE batch_name = r_gms_batch.gms_batch_name(recno)
4995: AND transaction_source = 'GOLDE';
4996:
4997: FORALL recno IN 1..r_gms_batch.gms_batch_name.COUNT

Line 5056: FROM pa_transaction_interface_all

5052: CURSOR gms_tie_back_reject_cur IS
5053: SELECT nvl(transaction_rejection_code,'P'),
5054: orig_transaction_reference,
5055: transaction_status_code
5056: FROM pa_transaction_interface_all
5057: WHERE transaction_source = 'GOLDE'
5058: AND batch_name = p_gms_batch_name
5059: AND orig_transaction_reference IN (SELECT 'E:' || enc_summary_line_id --added subqry for 3953230
5060: FROM psp_enc_summary_lines pesl

Line 5225: from pa_transaction_interface_all

5221: begin
5222:
5223: select count(*), transaction_status_code
5224: into l_cnt, l_status
5225: from pa_transaction_interface_all
5226: where transaction_source = 'GOLDE'
5227: and batch_name = (select distinct gms_batch_name
5228: from psp_enc_summary_lines
5229: where enc_control_id = p_enc_control_id

Line 5245: delete from pa_transaction_interface_all

5241: -- for some reason. Return 'NOT_RUN' in this case. So cleanup the tables and try to transfer
5242: -- again after summarization in the second pass.
5243: -- -------------------------------------------------------------------------------------------
5244:
5245: delete from pa_transaction_interface_all
5246: where transaction_source = 'GOLDE'
5247: and batch_name = p_gms_batch_name;
5248:
5249: delete from gms_transaction_interface_all

Line 5283: FROM pa_transaction_interface_all

5279: if (PROCESS_COMPLETE not in ('NOT_COMPLETE', 'NOT_RUN')) then
5280:
5281: SELECT count(*)
5282: INTO l_cnt_gms_interface
5283: FROM pa_transaction_interface_all
5284: WHERE transaction_source = 'GOLDE'
5285: AND batch_name = p_gms_batch_name
5286: AND transaction_status_code in ('R', 'PI', 'PR', 'PO');
5287:

Line 5383: DELETE from pa_transaction_interface_all

5379: / **************************************************************************************
5380: For Bug 2290051 - Commenting out purging of Interface tables for accepted Summary Lines
5381: -- purge the interface tables for Accepted summary lines
5382:
5383: DELETE from pa_transaction_interface_all
5384: where transaction_source = 'GOLDE'
5385: and batch_name = p_gms_batch_name
5386: and transaction_status_code = 'A'
5387: and orig_transaction_reference = l_enc_ref;

Line 5671: / * DELETE from pa_transaction_interface_all

5667: AND enc_summary_line_id = l_enc_summary_line_id
5668: AND enc_control_id = p_enc_control_id;
5669:
5670: -- commented For Bug 2290051
5671: / * DELETE from pa_transaction_interface_all
5672: where transaction_source = 'GOLDE'
5673: and batch_name = p_gms_batch_name
5674: and transaction_status_code = 'A'
5675: and orig_transaction_reference = 'E:' || to_char(l_enc_summary_line_id);

Line 5750: FROM pa_transaction_interface_all

5746: CURSOR gms_tie_back_reject_cur IS
5747: SELECT NVL(transaction_rejection_code,'P'),
5748: TO_NUMBER(SUBSTR(orig_transaction_reference, 3)),
5749: transaction_status_code
5750: FROM pa_transaction_interface_all
5751: WHERE transaction_source = 'GOLDE'
5752: AND batch_name = p_gms_batch_name;
5753:
5754: CURSOR assign_susp_ac_cur IS

Line 5831: FROM pa_transaction_interface_all

5827: WHERE organization_account_id = p_organization_account_id;
5828:
5829: CURSOR txn_interface_count_cur IS
5830: SELECT COUNT(1)
5831: FROM pa_transaction_interface_all
5832: WHERE transaction_source = 'GOLDE'
5833: AND batch_name = p_gms_batch_name
5834: AND transaction_status_code in ('R', 'PI', 'PO', 'PR');
5835:

Line 5957: FROM pa_transaction_interface_all

5953:
5954: CURSOR transaction_status_cur IS
5955: SELECT COUNT(*),
5956: transaction_status_code
5957: FROM pa_transaction_interface_all
5958: WHERE transaction_source='GOLDE'
5959: AND batch_name = p_gms_batch_name
5960: AND transaction_Status_code in ('P','I')
5961: GROUP BY transaction_status_code;

Line 5979: DELETE FROM pa_transaction_interface_all

5975: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK.PROCESS_COMPLETE');
5976: RETURN TRUE;
5977: ELSIF l_cnt > 0 THEN
5978: IF l_status = 'P' THEN
5979: DELETE FROM pa_transaction_interface_all
5980: WHERE transaction_source = 'GOLDE'
5981: AND batch_name = p_gms_batch_name;
5982: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from pa_trancsaction_interface_all');
5983: