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 1364: FROM PA_TRANSACTION_INTERFACE_ALL TXN,

1360: --TXN.TRANSACTION_SOURCE ,
1361: --TXN.EXPENDITURE_ENDING_DATE ,
1362: --TXN.EXPENDITURE_ITEM_DATE ,
1363: --TXN.PROJECT_NUMBER
1364: FROM PA_TRANSACTION_INTERFACE_ALL TXN,
1365: GMS_DISTRIBUTION_DETAILS GTN,
1366: GMS_AWARDS_ALL GA -- Bug 3221039
1367: WHERE GTN.document_header_id = p_xface_id
1368: AND GA.award_id = GTN.award_id -- Bug 3221039

Line 1381: INSERT into PA_TRANSACTION_INTERFACE_ALL

1377: -- 3466152
1378: -- import process award distributions doesn't work when batch name is not supplied.
1379: -- addaed transaction source in the where clause to have better performance.
1380: --
1381: INSERT into PA_TRANSACTION_INTERFACE_ALL
1382: ( RECEIPT_CURRENCY_AMOUNT ,
1383: RECEIPT_CURRENCY_CODE ,
1384: RECEIPT_EXCHANGE_RATE ,
1385: DENOM_CURRENCY_CODE ,

Line 1590: FROM PA_TRANSACTION_INTERFACE_ALL TXN,

1586: TXN.PO_LINE_NUM ,
1587: TXN.PO_LINE_ID ,
1588: TXN.PERSON_TYPE ,
1589: TXN.PO_PRICE_TYPE
1590: FROM PA_TRANSACTION_INTERFACE_ALL TXN,
1591: GMS_DISTRIBUTION_DETAILS GTN
1592: WHERE GTN.document_header_id = p_xface_id
1593: AND GTN.document_type = 'EXP'
1594: AND TXN.transaction_source = P_transaction_source

Line 1902: FROM pa_transaction_interface TXN,

1898: , TXN.po_price_type
1899: , TXN.wip_resource_id
1900: , TXN.inventory_item_id
1901: , TXN.unit_of_measure
1902: FROM pa_transaction_interface TXN,
1903: pa_transaction_sources TS,
1904: GMS_transaction_interface_all GMS1
1905: WHERE TXN.transaction_source = X_transaction_source
1906: and ts.transaction_source = TXN.transaction_source

Line 1981: UPDATE pa_transaction_interface

1977: , eachGroup.system_linkage_function );
1978: IF ( dummy <> 0 ) THEN
1979: pa_cc_utils.log_message(eachGroup.batch_name||' : All records rejected because of :'||'LOCK_'||eachGroup.batch_name||'_FAILED');
1980:
1981: UPDATE pa_transaction_interface
1982: SET transaction_rejection_code = 'LOCK_'||eachGroup.batch_name||'_FAILED'
1983: , transaction_status_code = 'PR'
1984: WHERE transaction_source = eachGroup.transaction_source
1985: AND batch_name = eachGroup.batch_name

Line 2334: UPDATE pa_transaction_interface

2330: pa_debug.G_err_stage := 'Updating txn interface table for txn'||
2331: ' rejected by validateitem';
2332: pa_cc_utils.log_message(pa_debug.G_err_stage);
2333:
2334: UPDATE pa_transaction_interface
2335: SET transaction_rejection_code = X_status ,
2336: interface_id = P_xface_id ,
2337: transaction_status_code = 'PR'
2338: WHERE CURRENT OF TrxRecs;

Line 2514: update PA_transaction_interface_all A

2510: -- 3466152
2511: -- import process award distributions doesn't work when batch name is not supplied.
2512: -- removed batch name criteria . Its not needed since txn_interface_id is available.
2513: --
2514: update PA_transaction_interface_all A
2515: set ( quantity, raw_cost, burdened_cost, denom_raw_cost, denom_burdened_cost, acct_raw_cost, acct_burdened_cost, receipt_currency_amount ) =
2516: ( select B.quantity_distributed,
2517: B.amount_distributed,
2518: B.burdened_cost,

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

2533: WHERE C.document_header_id = P_xface_id
2534: and C.distribution_number= 1
2535: and C.document_type = 'EXP' );
2536:
2537: pa_cc_utils.log_message('Update ( quantity, raw_cost ) in pa_transaction_interface_all count :'||
2538: to_char(SQL%ROWCOUNT));
2539: -- 3466152
2540: -- import process award distributions doesn't work when batch name is not supplied.
2541: -- removed batch name criteria . Its not needed since txn_interface_id is available.

Line 2548: UPDATE pa_transaction_interface A

2544: -- 3466152
2545: -- import process award distributions doesn't work when batch name is not supplied.
2546: -- removed batch name criteria . Its not needed since txn_interface_id is available.
2547: --
2548: UPDATE pa_transaction_interface A
2549: SET transaction_rejection_code = 'AWARD_DISTRIBUTION_FAILED' ,
2550: interface_id = P_xface_id ,
2551: transaction_status_code = 'PR'
2552: WHERE A.transaction_source = P_transaction_source

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

2556: WHERE B.document_header_id = P_Xface_id
2557: and B.document_type = 'EXP'
2558: and NVL(B.dist_status,'X') <> 'FABA' ) ;
2559:
2560: pa_cc_utils.log_message('Update distribution recject in pa_transaction_interface_all count :'||to_char(SQL%ROWCOUNT));
2561: -- ===================================================================
2562: -- Insert distributed records into PA_transaction_interface_all and
2563: -- gms_transaction_interface_all. Update the count in
2564: -- pa_transaction_xface_ctrl_all

Line 2562: -- Insert distributed records into PA_transaction_interface_all and

2558: and NVL(B.dist_status,'X') <> 'FABA' ) ;
2559:
2560: pa_cc_utils.log_message('Update distribution recject in pa_transaction_interface_all count :'||to_char(SQL%ROWCOUNT));
2561: -- ===================================================================
2562: -- Insert distributed records into PA_transaction_interface_all and
2563: -- gms_transaction_interface_all. Update the count in
2564: -- pa_transaction_xface_ctrl_all
2565: -- ==================================================================
2566: PROC_INSERT_TRANS( P_transaction_source,