APPS.GMS_PA_COSTING_PKG dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 563: FROM pa_transaction_interface_all xface

559: AND Paydist1.invoice_distribution_id = g_xface_rec.invoice_distribution_id
560: and Paydist2.invoice_distribution_id = g_xface_rec.invoice_distribution_id
561: AND ( paydist1.pa_addition_flag = 'Y' OR --interfaced payments
562: PayDIST1.invoice_payment_id IN ( SELECT xface.cdl_system_reference4 -- Payments marked for interface in current run
563: FROM pa_transaction_interface_all xface
564: WHERE xface.transaction_source = G_txn_source
565: and xface.cdl_system_reference2 = g_xface_rec.invoice_id
566: and xface.cdl_system_reference5 = g_xface_rec.invoice_distribution_id
567: and xface.cdl_system_reference4 is not NULL

Line 1003: --Loop for all pa_transaction_interface_all records having same invoice_id,

999: l_adj_ei_populated := 'Y' ;
1000: END IF;
1001:
1002: --REL12 : AP lines uptake enhancement :
1003: --Loop for all pa_transaction_interface_all records having same invoice_id,
1004: --invoice distribution id and Invoice payment id
1005:
1006: FOR i in t_txn_interface_id.FIRST..t_txn_interface_id.LAST LOOP --REL12 :Ap lines Uptake enhancement
1007:

Line 2427: from pa_transaction_interface_all txn, gms_bc_packets gbc

2423: v_cdl_line_num tab_line_num;
2424:
2425: cursor get_xface_exp is
2426: select gbc.rowid, txn.expenditure_item_id
2427: from pa_transaction_interface_all txn, gms_bc_packets gbc
2428: where gbc.request_id = p_request_id
2429: and txn.txn_interface_id = gbc.document_header_id
2430: and nvl(txn.transaction_status_code, 'Z') <> 'R'
2431: and gbc.status_code = 'P'

Line 3174: from pa_transaction_interface_all xface,

3170:
3171: cursor get_failed_txns is
3172: select distinct gbp.packet_id,
3173: xface.transaction_rejection_code
3174: from pa_transaction_interface_all xface,
3175: gms_bc_packets gbp
3176: where to_number(gbp.gl_bc_packets_rowid) = xface.txn_interface_id
3177: and gbp.request_id = p_request_id
3178: and gbp.parent_bc_packet_id is null

Line 3282: pa_transaction_interface_all trx

3278: TO_CHAR(adl.invoice_id)||'|'||TO_CHAR(adl.invoice_distribution_id) IN
3279: (SELECT
3280: (trx.cdl_system_reference2)||'|'||TO_CHAR(trx.cdl_system_reference5)
3281: FROM gms_bc_packets pkt,
3282: pa_transaction_interface_all trx
3283: WHERE pkt.request_id=p_request_id
3284: AND pkt.txn_interface_id=trx.txn_interface_id
3285: AND substr(nvl(pkt.result_code,'P65'), 1, 1)='P'
3286: AND pkt.status_code='P'

Line 3428: from pa_transaction_interface_all txn,

3424: v_userid,
3425: v_userid,
3426: v_date,
3427: v_login
3428: from pa_transaction_interface_all txn,
3429: pa_expenditure_items_all ei,
3430: pa_cost_distribution_lines_all cdl,
3431: ap_invoice_distributions_all apd,
3432: gms_award_distributions adl