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_AWARD_DIST_ENG dependencies on PA_TRANSACTION_INTERFACE

Line 1230: FROM PA_TRANSACTION_INTERFACE_ALL TXN,

1226: --TXN.TRANSACTION_SOURCE ,
1227: --TXN.EXPENDITURE_ENDING_DATE ,
1228: --TXN.EXPENDITURE_ITEM_DATE ,
1229: --TXN.PROJECT_NUMBER
1230: FROM PA_TRANSACTION_INTERFACE_ALL TXN,
1231: GMS_DISTRIBUTION_DETAILS GTN,
1232: GMS_AWARDS_ALL GA -- Bug 3221039
1233: WHERE GTN.document_header_id = p_xface_id
1234: AND GA.award_id = GTN.award_id -- Bug 3221039

Line 1247: INSERT into PA_TRANSACTION_INTERFACE_ALL

1243: -- 3466152
1244: -- import process award distributions doesn't work when batch name is not supplied.
1245: -- addaed transaction source in the where clause to have better performance.
1246: --
1247: INSERT into PA_TRANSACTION_INTERFACE_ALL
1248: ( RECEIPT_CURRENCY_AMOUNT ,
1249: RECEIPT_CURRENCY_CODE ,
1250: RECEIPT_EXCHANGE_RATE ,
1251: DENOM_CURRENCY_CODE ,

Line 1456: FROM PA_TRANSACTION_INTERFACE_ALL TXN,

1452: TXN.PO_LINE_NUM ,
1453: TXN.PO_LINE_ID ,
1454: TXN.PERSON_TYPE ,
1455: TXN.PO_PRICE_TYPE
1456: FROM PA_TRANSACTION_INTERFACE_ALL TXN,
1457: GMS_DISTRIBUTION_DETAILS GTN
1458: WHERE GTN.document_header_id = p_xface_id
1459: AND GTN.document_type = 'EXP'
1460: AND TXN.transaction_source = P_transaction_source

Line 1768: FROM pa_transaction_interface TXN,

1764: , TXN.po_price_type
1765: , TXN.wip_resource_id
1766: , TXN.inventory_item_id
1767: , TXN.unit_of_measure
1768: FROM pa_transaction_interface TXN,
1769: pa_transaction_sources TS,
1770: GMS_transaction_interface_all GMS1
1771: WHERE TXN.transaction_source = X_transaction_source
1772: and ts.transaction_source = TXN.transaction_source

Line 1847: UPDATE pa_transaction_interface

1843: , eachGroup.system_linkage_function );
1844: IF ( dummy <> 0 ) THEN
1845: pa_cc_utils.log_message(eachGroup.batch_name||' : All records rejected because of :'||'LOCK_'||eachGroup.batch_name||'_FAILED');
1846:
1847: UPDATE pa_transaction_interface
1848: SET transaction_rejection_code = 'LOCK_'||eachGroup.batch_name||'_FAILED'
1849: , transaction_status_code = 'PR'
1850: WHERE transaction_source = eachGroup.transaction_source
1851: AND batch_name = eachGroup.batch_name

Line 2200: UPDATE pa_transaction_interface

2196: pa_debug.G_err_stage := 'Updating txn interface table for txn'||
2197: ' rejected by validateitem';
2198: pa_cc_utils.log_message(pa_debug.G_err_stage);
2199:
2200: UPDATE pa_transaction_interface
2201: SET transaction_rejection_code = X_status ,
2202: interface_id = P_xface_id ,
2203: transaction_status_code = 'PR'
2204: WHERE CURRENT OF TrxRecs;

Line 2380: update PA_transaction_interface_all A

2376: -- 3466152
2377: -- import process award distributions doesn't work when batch name is not supplied.
2378: -- removed batch name criteria . Its not needed since txn_interface_id is available.
2379: --
2380: update PA_transaction_interface_all A
2381: set ( quantity, raw_cost, burdened_cost, denom_raw_cost, denom_burdened_cost, acct_raw_cost, acct_burdened_cost, receipt_currency_amount ) =
2382: ( select B.quantity_distributed,
2383: B.amount_distributed,
2384: B.burdened_cost,

Line 2403: pa_cc_utils.log_message('Update ( quantity, raw_cost ) in pa_transaction_interface_all count :'||

2399: WHERE C.document_header_id = P_xface_id
2400: and C.distribution_number= 1
2401: and C.document_type = 'EXP' );
2402:
2403: pa_cc_utils.log_message('Update ( quantity, raw_cost ) in pa_transaction_interface_all count :'||
2404: to_char(SQL%ROWCOUNT));
2405: -- 3466152
2406: -- import process award distributions doesn't work when batch name is not supplied.
2407: -- removed batch name criteria . Its not needed since txn_interface_id is available.

Line 2414: UPDATE pa_transaction_interface A

2410: -- 3466152
2411: -- import process award distributions doesn't work when batch name is not supplied.
2412: -- removed batch name criteria . Its not needed since txn_interface_id is available.
2413: --
2414: UPDATE pa_transaction_interface A
2415: SET transaction_rejection_code = 'AWARD_DISTRIBUTION_FAILED' ,
2416: interface_id = P_xface_id ,
2417: transaction_status_code = 'PR'
2418: WHERE A.transaction_source = P_transaction_source

Line 2426: pa_cc_utils.log_message('Update distribution recject in pa_transaction_interface_all count :'||to_char(SQL%ROWCOUNT));

2422: WHERE B.document_header_id = P_Xface_id
2423: and B.document_type = 'EXP'
2424: and NVL(B.dist_status,'X') <> 'FABA' ) ;
2425:
2426: pa_cc_utils.log_message('Update distribution recject in pa_transaction_interface_all count :'||to_char(SQL%ROWCOUNT));
2427: -- ===================================================================
2428: -- Insert distributed records into PA_transaction_interface_all and
2429: -- gms_transaction_interface_all. Update the count in
2430: -- pa_transaction_xface_ctrl_all

Line 2428: -- Insert distributed records into PA_transaction_interface_all and

2424: and NVL(B.dist_status,'X') <> 'FABA' ) ;
2425:
2426: pa_cc_utils.log_message('Update distribution recject in pa_transaction_interface_all count :'||to_char(SQL%ROWCOUNT));
2427: -- ===================================================================
2428: -- Insert distributed records into PA_transaction_interface_all and
2429: -- gms_transaction_interface_all. Update the count in
2430: -- pa_transaction_xface_ctrl_all
2431: -- ==================================================================
2432: PROC_INSERT_TRANS( P_transaction_source,