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 1639: pa_transaction_interface_all txn

1635: txn.transaction_source transaction_source,
1636: txn.batch_name batch_name,
1637: GTXN.txn_interface_id txn_interface_id
1638: FROM gms_transaction_interface_all Gtxn,
1639: pa_transaction_interface_all txn
1640: WHERE txn.txn_interface_id = X_txn_interface_id
1641: AND txn.txn_interface_id = Gtxn.txn_interface_id (+) ;
1642:
1643: txn_rec c_txn_rec%ROWTYPE ;

Line 2046: UPDATE PA_TRANSACTION_INTERFACE_ALL

2042: BEGIN
2043: IF NVL(x_calling_source,'X') = 'GMS_TXN_INTERFACE_AIT1' OR
2044: NVL(x_calling_source,'X') = 'GMS_TXN_INTERFACE_AIT2' THEN --bug 2305262
2045:
2046: UPDATE PA_TRANSACTION_INTERFACE_ALL
2047: SET transaction_rejection_code = X_status ,
2048: transaction_status_code = 'PR'
2049: where TXN_INTERFACE_ID = x_txn_interface_id
2050: and batch_name = X_batch_name

Line 2054: UPDATE PA_TRANSACTION_INTERFACE_ALL

2050: and batch_name = X_batch_name
2051: and transaction_source=x_txn_source ;
2052:
2053: ELSE
2054: UPDATE PA_TRANSACTION_INTERFACE_ALL
2055: SET transaction_rejection_code = X_status ,
2056: transaction_status_code = 'R'
2057: where TXN_INTERFACE_ID = x_txn_interface_id
2058: and batch_name = X_batch_name

Line 2211: l_system_linkage pa_transaction_interface_all.system_linkage%TYPE ;

2207: l_sponsored_flag varchar2(1);
2208: l_award_id number;
2209: l_stage varchar2(10);
2210: l_transaction_source pa_transaction_sources.transaction_source%TYPE ;
2211: l_system_linkage pa_transaction_interface_all.system_linkage%TYPE ;
2212: l_system_reference2 pa_transaction_interface_all.cdl_system_reference2%TYPE ;
2213: l_system_reference3 pa_transaction_interface_all.cdl_system_reference3%TYPE ;
2214: --
2215: --BUG 5620362 R12.PJ:XB13:ST3:QA:BC:SYSTEM SHOWS AN ERROR WHEN NR TAX IS INTERFACED TO GRANTS

Line 2212: l_system_reference2 pa_transaction_interface_all.cdl_system_reference2%TYPE ;

2208: l_award_id number;
2209: l_stage varchar2(10);
2210: l_transaction_source pa_transaction_sources.transaction_source%TYPE ;
2211: l_system_linkage pa_transaction_interface_all.system_linkage%TYPE ;
2212: l_system_reference2 pa_transaction_interface_all.cdl_system_reference2%TYPE ;
2213: l_system_reference3 pa_transaction_interface_all.cdl_system_reference3%TYPE ;
2214: --
2215: --BUG 5620362 R12.PJ:XB13:ST3:QA:BC:SYSTEM SHOWS AN ERROR WHEN NR TAX IS INTERFACED TO GRANTS
2216: --

Line 2213: l_system_reference3 pa_transaction_interface_all.cdl_system_reference3%TYPE ;

2209: l_stage varchar2(10);
2210: l_transaction_source pa_transaction_sources.transaction_source%TYPE ;
2211: l_system_linkage pa_transaction_interface_all.system_linkage%TYPE ;
2212: l_system_reference2 pa_transaction_interface_all.cdl_system_reference2%TYPE ;
2213: l_system_reference3 pa_transaction_interface_all.cdl_system_reference3%TYPE ;
2214: --
2215: --BUG 5620362 R12.PJ:XB13:ST3:QA:BC:SYSTEM SHOWS AN ERROR WHEN NR TAX IS INTERFACED TO GRANTS
2216: --
2217: l_system_reference5 pa_transaction_interface_all.cdl_system_reference5%TYPE ;

Line 2217: l_system_reference5 pa_transaction_interface_all.cdl_system_reference5%TYPE ;

2213: l_system_reference3 pa_transaction_interface_all.cdl_system_reference3%TYPE ;
2214: --
2215: --BUG 5620362 R12.PJ:XB13:ST3:QA:BC:SYSTEM SHOWS AN ERROR WHEN NR TAX IS INTERFACED TO GRANTS
2216: --
2217: l_system_reference5 pa_transaction_interface_all.cdl_system_reference5%TYPE ;
2218:
2219: l_predefined_flag pa_transaction_sources.predefined_flag%TYPE ;
2220: BEGIN
2221: x_sch_fixed_date := NULL;

Line 2268: from pa_transaction_interface_all pti,

2264: l_system_reference2,
2265: l_system_reference3,
2266: l_system_reference5,
2267: l_predefined_flag
2268: from pa_transaction_interface_all pti,
2269: pa_transaction_sources pts
2270: where pti.txn_interface_id = p_tran_item_id
2271: and pti.transaction_source = pts.transaction_source ;
2272: --