APPS.GMS_AWARD_DIST_ENG dependencies on PA_TRANSACTION_INTERFACE_ALL

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