[Home] [Help]
1312: --
1313: -- Bug 3221039 : Modified the following insert to populate award number and not
1314: -- to populate obsolete columns.
1315:
1316: INSERT into GMS_TRANSACTION_INTERFACE_ALL
1317: (
1318: --TASK_NUMBER ,
1319: AWARD_ID ,
1320: AWARD_NUMBER ,
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
1907: AND TXN.batch_name = current_batch
1908: AND TXN.transaction_status_code = 'P'
2484: --
2485: -- Bug 3221039 : Modified the below code to distribute based on default Award id/
2486: -- Award number and to populate both award id and award number .
2487:
2488: update gms_transaction_interface_all A
2489: set (a.award_id,a.award_number) = ( select B.award_id,GA.award_number -- Bug 3221039
2490: from gms_distribution_details B,
2491: gms_awards_all GA
2492: where a.txn_interface_id = b.document_distribution_id
2504: where C.document_header_id = P_xface_id
2505: and C.distribution_number= 1
2506: and C.document_type = 'EXP' );
2507:
2508: pa_cc_utils.log_message('Update award_id in gms_transaction_interface_all count :'||to_char(SQL%ROWCOUNT));
2509:
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.
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,
2567: p_batch ,