[Home] [Help]
680: -- with the date value passed in by the user or sysdate if it is later than the start date of the resource.
681:
682: -- Bug 8751983 - Added DEL action to where clause so we stamp reversals also.
683: -- Transaction engine will decide whether to keep this date or not.
684: update gme_resource_txns_gtmp
685: set trans_date = p_trans_date
686: where poc_trans_id in
687: (select t.poc_trans_id
688: FROM gme_batch_steps s, gme_batch_step_activities a, gme_batch_step_resources r, gme_resource_txns_gtmp t
684: update gme_resource_txns_gtmp
685: set trans_date = p_trans_date
686: where poc_trans_id in
687: (select t.poc_trans_id
688: FROM gme_batch_steps s, gme_batch_step_activities a, gme_batch_step_resources r, gme_resource_txns_gtmp t
689: WHERE s.batch_id = l_batch_header_rec.batch_id
690: -- Comment out following update as original fix was just for one step.
691: -- AND a.batchstep_id = l_in_batch_step_rec.batchstep_id
692: AND a.batchstep_id = s.batchstep_id
698:
699: -- Bug 8751983 - We do not want to stamp new transactions caused by negative IB at this time.
700: -- New transaction should maintain original trans date being reversed, unless it is in a closed period.
701: IF gme_common_pvt.g_ib_timestamp_set = 1 THEN
702: update gme_resource_txns_gtmp
703: set trans_date = p_trans_date
704: where poc_trans_id in
705: (select t.poc_trans_id
706: FROM gme_batch_steps s, gme_batch_step_activities a, gme_batch_step_resources r, gme_resource_txns_gtmp t
702: update gme_resource_txns_gtmp
703: set trans_date = p_trans_date
704: where poc_trans_id in
705: (select t.poc_trans_id
706: FROM gme_batch_steps s, gme_batch_step_activities a, gme_batch_step_resources r, gme_resource_txns_gtmp t
707: WHERE s.batch_id = l_batch_header_rec.batch_id
708: -- Comment out following update as original fix was just for one step.
709: -- AND a.batchstep_id = l_in_batch_step_rec.batchstep_id
710: AND a.batchstep_id = s.batchstep_id