APPS.GMS_AWARD_DIST_ENG dependencies on PA_TRANSACTION_INTERFACE_ALL

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 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 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,