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

Line 784: pa_transaction_interface_all pt,

780: pt.txn_interface_id TXN_INTERFACE_ID,
781: pt.accrual_flag period_end_accrual_flag,
782: pt.system_linkage system_linkage
783: FROM gms_transaction_interface_all gt,
784: pa_transaction_interface_all pt,
785: pa_expenditure_items_all ei
786: WHERE ei.expenditure_item_id = x_ei_id
787: AND ei.expenditure_id = x_exp_id
788: AND ei.transaction_source = x_trx_src

Line 1652: pa_transaction_interface_all txn

1648: txn.transaction_source transaction_source,
1649: txn.batch_name batch_name,
1650: GTXN.txn_interface_id txn_interface_id
1651: FROM gms_transaction_interface_all Gtxn,
1652: pa_transaction_interface_all txn
1653: WHERE txn.txn_interface_id = X_txn_interface_id
1654: AND txn.txn_interface_id = Gtxn.txn_interface_id (+) ;
1655:
1656: txn_rec c_txn_rec%ROWTYPE ;

Line 2059: UPDATE PA_TRANSACTION_INTERFACE_ALL

2055: BEGIN
2056: IF NVL(x_calling_source,'X') = 'GMS_TXN_INTERFACE_AIT1' OR
2057: NVL(x_calling_source,'X') = 'GMS_TXN_INTERFACE_AIT2' THEN --bug 2305262
2058:
2059: UPDATE PA_TRANSACTION_INTERFACE_ALL
2060: SET transaction_rejection_code = X_status ,
2061: transaction_status_code = 'PR'
2062: where TXN_INTERFACE_ID = x_txn_interface_id
2063: and batch_name = X_batch_name

Line 2067: UPDATE PA_TRANSACTION_INTERFACE_ALL

2063: and batch_name = X_batch_name
2064: and transaction_source=x_txn_source ;
2065:
2066: ELSE
2067: UPDATE PA_TRANSACTION_INTERFACE_ALL
2068: SET transaction_rejection_code = X_status ,
2069: transaction_status_code = 'R'
2070: where TXN_INTERFACE_ID = x_txn_interface_id
2071: and batch_name = X_batch_name

Line 2224: l_system_linkage pa_transaction_interface_all.system_linkage%TYPE ;

2220: l_sponsored_flag varchar2(1);
2221: l_award_id number;
2222: l_stage varchar2(10);
2223: l_transaction_source pa_transaction_sources.transaction_source%TYPE ;
2224: l_system_linkage pa_transaction_interface_all.system_linkage%TYPE ;
2225: l_system_reference2 pa_transaction_interface_all.cdl_system_reference2%TYPE ;
2226: l_system_reference3 pa_transaction_interface_all.cdl_system_reference3%TYPE ;
2227: --
2228: --BUG 5620362 R12.PJ:XB13:ST3:QA:BC:SYSTEM SHOWS AN ERROR WHEN NR TAX IS INTERFACED TO GRANTS

Line 2225: l_system_reference2 pa_transaction_interface_all.cdl_system_reference2%TYPE ;

2221: l_award_id number;
2222: l_stage varchar2(10);
2223: l_transaction_source pa_transaction_sources.transaction_source%TYPE ;
2224: l_system_linkage pa_transaction_interface_all.system_linkage%TYPE ;
2225: l_system_reference2 pa_transaction_interface_all.cdl_system_reference2%TYPE ;
2226: l_system_reference3 pa_transaction_interface_all.cdl_system_reference3%TYPE ;
2227: --
2228: --BUG 5620362 R12.PJ:XB13:ST3:QA:BC:SYSTEM SHOWS AN ERROR WHEN NR TAX IS INTERFACED TO GRANTS
2229: --

Line 2226: l_system_reference3 pa_transaction_interface_all.cdl_system_reference3%TYPE ;

2222: l_stage varchar2(10);
2223: l_transaction_source pa_transaction_sources.transaction_source%TYPE ;
2224: l_system_linkage pa_transaction_interface_all.system_linkage%TYPE ;
2225: l_system_reference2 pa_transaction_interface_all.cdl_system_reference2%TYPE ;
2226: l_system_reference3 pa_transaction_interface_all.cdl_system_reference3%TYPE ;
2227: --
2228: --BUG 5620362 R12.PJ:XB13:ST3:QA:BC:SYSTEM SHOWS AN ERROR WHEN NR TAX IS INTERFACED TO GRANTS
2229: --
2230: l_system_reference5 pa_transaction_interface_all.cdl_system_reference5%TYPE ;

Line 2230: l_system_reference5 pa_transaction_interface_all.cdl_system_reference5%TYPE ;

2226: l_system_reference3 pa_transaction_interface_all.cdl_system_reference3%TYPE ;
2227: --
2228: --BUG 5620362 R12.PJ:XB13:ST3:QA:BC:SYSTEM SHOWS AN ERROR WHEN NR TAX IS INTERFACED TO GRANTS
2229: --
2230: l_system_reference5 pa_transaction_interface_all.cdl_system_reference5%TYPE ;
2231:
2232: l_predefined_flag pa_transaction_sources.predefined_flag%TYPE ;
2233: BEGIN
2234: x_sch_fixed_date := NULL;

Line 2281: from pa_transaction_interface_all pti,

2277: l_system_reference2,
2278: l_system_reference3,
2279: l_system_reference5,
2280: l_predefined_flag
2281: from pa_transaction_interface_all pti,
2282: pa_transaction_sources pts
2283: where pti.txn_interface_id = p_tran_item_id
2284: and pti.transaction_source = pts.transaction_source ;
2285: --