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.GMS_PA_COSTING_PKG dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 146: TYPE tt_acct_raw_cost is table of pa_transaction_interface_all.acct_raw_cost%TYPE;

142: TYPE tt_adjusted_document_header_id is table of gms_bc_packets.adjusted_document_header_id%TYPE;
143: TYPE tt_award_set_id is table of gms_bc_packets.award_set_id%TYPE;
144: TYPE tt_transaction_source is table of gms_bc_packets.transaction_source%TYPE;
145: TYPE tt_burdenable_raw_cost is table of gms_award_distributions.burdenable_raw_cost%TYPE;
146: TYPE tt_acct_raw_cost is table of pa_transaction_interface_all.acct_raw_cost%TYPE;
147: TYPE tt_line_type_lookup is table of ap_invoice_distributions_all.line_type_lookup_code%TYPE;
148: TYPE tt_invoice_type_lookup is table of ap_invoices_all.invoice_type_lookup_code%TYPE;
149:
150: --REL12 : AP lines uptake enhancement : Added below plsql tables

Line 153: TYPE tt_sys_ref4 IS table of pa_transaction_interface_all.cdl_system_reference4%TYPE;

149:
150: --REL12 : AP lines uptake enhancement : Added below plsql tables
151: TYPE tt_invoice_id is table of ap_invoices_all.invoice_id%TYPE;
152: TYPE tt_invoice_distribution_id is table of ap_invoice_distributions_all.invoice_distribution_id%TYPE;
153: TYPE tt_sys_ref4 IS table of pa_transaction_interface_all.cdl_system_reference4%TYPE;
154: TYPE tt_bud_task_id is table of gms_bc_packets.bud_task_id%TYPE;
155: TYPE tt_txn_interface_id is table of pa_transaction_interface_all.txn_interface_id%TYPE;
156: Type tt_nz_adj_flag is table of pa_transaction_interface_all.net_zero_adjustment_flag%TYPE ;
157: --

Line 155: TYPE tt_txn_interface_id is table of pa_transaction_interface_all.txn_interface_id%TYPE;

151: TYPE tt_invoice_id is table of ap_invoices_all.invoice_id%TYPE;
152: TYPE tt_invoice_distribution_id is table of ap_invoice_distributions_all.invoice_distribution_id%TYPE;
153: TYPE tt_sys_ref4 IS table of pa_transaction_interface_all.cdl_system_reference4%TYPE;
154: TYPE tt_bud_task_id is table of gms_bc_packets.bud_task_id%TYPE;
155: TYPE tt_txn_interface_id is table of pa_transaction_interface_all.txn_interface_id%TYPE;
156: Type tt_nz_adj_flag is table of pa_transaction_interface_all.net_zero_adjustment_flag%TYPE ;
157: --
158:
159: cursor get_xface_cur is

Line 156: Type tt_nz_adj_flag is table of pa_transaction_interface_all.net_zero_adjustment_flag%TYPE ;

152: TYPE tt_invoice_distribution_id is table of ap_invoice_distributions_all.invoice_distribution_id%TYPE;
153: TYPE tt_sys_ref4 IS table of pa_transaction_interface_all.cdl_system_reference4%TYPE;
154: TYPE tt_bud_task_id is table of gms_bc_packets.bud_task_id%TYPE;
155: TYPE tt_txn_interface_id is table of pa_transaction_interface_all.txn_interface_id%TYPE;
156: Type tt_nz_adj_flag is table of pa_transaction_interface_all.net_zero_adjustment_flag%TYPE ;
157: --
158:
159: cursor get_xface_cur is
160: select xface.interface_id, -- Bug 5389130

Line 203: -- Cursor to fetch pa_transaction_interface_all records having same invoice_id ,invoice_distribution_id

199: and adl.document_type = 'AP'
200: and adl.adl_status = 'A';
201:
202: --REL12 : AP lines uptake enhancement
203: -- Cursor to fetch pa_transaction_interface_all records having same invoice_id ,invoice_distribution_id
204: -- and invoice_payment_id. These records correspond to adjusted/non adjusted expenditure items
205: -- associated with original invoice distribution.
206:
207: cursor c_txn_details (p_sys_ref2 VARCHAR2,