[Home] [Help]
1178: --
1179: -- Bug 3221039 : Modified the following insert to populate award number and not
1180: -- to populate obsolete columns.
1181:
1182: INSERT into GMS_TRANSACTION_INTERFACE_ALL
1183: (
1184: --TASK_NUMBER ,
1185: AWARD_ID ,
1186: AWARD_NUMBER ,
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
1773: AND TXN.batch_name = current_batch
1774: AND TXN.transaction_status_code = 'P'
2350: --
2351: -- Bug 3221039 : Modified the below code to distribute based on default Award id/
2352: -- Award number and to populate both award id and award number .
2353:
2354: update gms_transaction_interface_all A
2355: set (a.award_id,a.award_number) = ( select B.award_id,GA.award_number -- Bug 3221039
2356: from gms_distribution_details B,
2357: gms_awards_all GA
2358: where a.txn_interface_id = b.document_distribution_id
2370: where C.document_header_id = P_xface_id
2371: and C.distribution_number= 1
2372: and C.document_type = 'EXP' );
2373:
2374: pa_cc_utils.log_message('Update award_id in gms_transaction_interface_all count :'||to_char(SQL%ROWCOUNT));
2375:
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.
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,
2433: p_batch ,