eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_RESCHEDULE_BATCH_PVT dependencies on GME_COMMON_PVT

Line 42: l_material_detail_ids gme_common_pvt.number_tab;

38:
39: l_line_type_tbl l_line_type_tbl_typ;
40: l_material_date DATE;
41: l_loop_count_get_material NUMBER;
42: l_material_detail_ids gme_common_pvt.number_tab;
43: l_material_detail_rec gme_material_details%ROWTYPE;
44: l_batch_header_rec gme_batch_header%ROWTYPE;
45: l_in_batch_header_rec gme_batch_header%ROWTYPE;
46: /* Local variables */

Line 215: gme_common_pvt.log_message ('PM_PLAN_END_DATE_ERR');

211: END IF;
212:
213: IF p_batch_header_rec.plan_cmplt_date <
214: p_batch_header_rec.plan_start_date THEN
215: gme_common_pvt.log_message ('PM_PLAN_END_DATE_ERR');
216: RAISE cmplt_less_start;
217: END IF;
218:
219: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec

Line 230: l_calendar_code := gme_common_pvt.g_calendar_code;

226: IF (x_batch_header_rec.batch_status NOT IN (1, 2) ) THEN
227: RAISE invalid_batch;
228: END IF;
229:
230: l_calendar_code := gme_common_pvt.g_calendar_code;
231:
232: IF x_batch_header_rec.batch_status = 2 THEN /* Batch is already WIP */
233: IF p_batch_header_rec.plan_start_date <>
234: x_batch_header_rec.plan_start_date THEN

Line 235: gme_common_pvt.log_message ('GME_CANT_RESCH_START');

231:
232: IF x_batch_header_rec.batch_status = 2 THEN /* Batch is already WIP */
233: IF p_batch_header_rec.plan_start_date <>
234: x_batch_header_rec.plan_start_date THEN
235: gme_common_pvt.log_message ('GME_CANT_RESCH_START');
236: RAISE cannot_reschedule_start;
237: END IF;
238:
239: -- Bug 11874223 - Following check is invalid.

Line 244: gme_common_pvt.log_message

240: /*
241: IF p_batch_header_rec.plan_cmplt_date <
242: x_batch_header_rec.actual_start_date THEN
243: -- Updated the DATE1 as plan_cmplt_date and DATE2 as actual_start_date
244: gme_common_pvt.log_message
245: ('GME_INVALID_DATE_RANGE'
246: ,'DATE1'
247: ,fnd_date.date_to_displaydt (p_batch_header_rec.plan_cmplt_date)
248: ,'DATE2'

Line 268: IF NOT gme_common_pvt.check_validity_rule_dates

264: || 'Calling Check Validity Rule Dates');
265: END IF;
266:
267: /* Check wether the dates requested for rescheduling are within the ranges of the recipe validity rule */
268: IF NOT gme_common_pvt.check_validity_rule_dates
269: (x_batch_header_rec.recipe_validity_rule_id
270: ,p_batch_header_rec.plan_start_date
271: ,p_batch_header_rec.plan_cmplt_date
272: ,x_batch_header_rec) THEN

Line 344: IF (x_batch_header_rec.batch_status = gme_common_pvt.g_batch_pending) THEN

340: /* Whenever the batch is created with the routing, the poc_ind is set to 'Y'
341: and set to 'N' when there is no routing. So the below code is replaced with
342: the check so that this code works fine for the migrated batches from old gme code */
343: IF l_batch_header_rec.poc_ind = 'Y' THEN
344: IF (x_batch_header_rec.batch_status = gme_common_pvt.g_batch_pending) THEN
345: IF (p_batch_header_rec.plan_start_date IS NOT NULL)
346: AND (p_batch_header_rec.plan_cmplt_date IS NULL) THEN
347: gme_create_step_pvt.calc_dates
348: (p_gme_batch_header_rec => l_batch_header_rec

Line 383: IF (x_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip) THEN

379: END IF;
380: END IF; /* both date not null*/
381: END IF; /* batch_status = 1*/
382:
383: IF (x_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip) THEN
384: IF (p_batch_header_rec.plan_cmplt_date IS NOT NULL) THEN
385:
386: -- Bug 9244927 - We want dates to work off of new plan cmplt date.
387: l_batch_header_rec.plan_start_date := NULL;

Line 476: IF gme_common_pvt.calc_date_from_prod_rule

472: ELSE
473: l_date := p_batch_header_rec.plan_start_date;
474: END IF;
475:
476: IF gme_common_pvt.calc_date_from_prod_rule
477: (p_organization_id => x_batch_header_rec.organization_id
478: ,p_inventory_item_id => l_recipe_validity_rule_rec.inventory_item_id
479: ,p_item_qty => l_temp_qty
480: ,p_start_date => l_date

Line 489: gme_common_pvt.g_batch_wip THEN

485: l_no_prod_rule_found := FALSE;
486:
487: /* IF batch is WIP then disregard calculated plan_start_date */
488: IF x_batch_header_rec.batch_status =
489: gme_common_pvt.g_batch_wip THEN
490: x_batch_header_rec.plan_start_date :=
491: p_batch_header_rec.plan_start_date;
492: END IF;
493: ELSE

Line 521: gme_common_pvt.g_timestamp;

517: p_batch_header_rec.plan_cmplt_date;
518: ELSIF p_batch_header_rec.plan_start_date IS NULL
519: AND p_batch_header_rec.plan_cmplt_date IS NULL THEN
520: x_batch_header_rec.plan_start_date :=
521: gme_common_pvt.g_timestamp;
522: x_batch_header_rec.plan_cmplt_date :=
523: gme_common_pvt.g_timestamp;
524: ELSIF p_batch_header_rec.plan_start_date IS NOT NULL
525: AND p_batch_header_rec.plan_cmplt_date IS NOT NULL THEN

Line 523: gme_common_pvt.g_timestamp;

519: AND p_batch_header_rec.plan_cmplt_date IS NULL THEN
520: x_batch_header_rec.plan_start_date :=
521: gme_common_pvt.g_timestamp;
522: x_batch_header_rec.plan_cmplt_date :=
523: gme_common_pvt.g_timestamp;
524: ELSIF p_batch_header_rec.plan_start_date IS NOT NULL
525: AND p_batch_header_rec.plan_cmplt_date IS NOT NULL THEN
526: x_batch_header_rec.plan_start_date :=
527: p_batch_header_rec.plan_start_date;

Line 686: ,last_updated_by = gme_common_pvt.g_user_ident

682: ,plan_cmplt_date = x_batch_header_rec.plan_cmplt_date
683: ,due_date =
684: NVL (x_batch_header_rec.due_date
685: ,x_batch_header_rec.plan_cmplt_date)
686: ,last_updated_by = gme_common_pvt.g_user_ident
687: ,last_update_date = gme_common_pvt.g_timestamp
688: ,last_update_login = gme_common_pvt.g_login_id
689: WHERE batch_id = x_batch_header_rec.batch_id;
690: END IF;

Line 687: ,last_update_date = gme_common_pvt.g_timestamp

683: ,due_date =
684: NVL (x_batch_header_rec.due_date
685: ,x_batch_header_rec.plan_cmplt_date)
686: ,last_updated_by = gme_common_pvt.g_user_ident
687: ,last_update_date = gme_common_pvt.g_timestamp
688: ,last_update_login = gme_common_pvt.g_login_id
689: WHERE batch_id = x_batch_header_rec.batch_id;
690: END IF;
691:

Line 688: ,last_update_login = gme_common_pvt.g_login_id

684: NVL (x_batch_header_rec.due_date
685: ,x_batch_header_rec.plan_cmplt_date)
686: ,last_updated_by = gme_common_pvt.g_user_ident
687: ,last_update_date = gme_common_pvt.g_timestamp
688: ,last_update_login = gme_common_pvt.g_login_id
689: WHERE batch_id = x_batch_header_rec.batch_id;
690: END IF;
691:
692: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 785: ,last_updated_by = gme_common_pvt.g_user_ident

781:
782: UPDATE gme_batch_header
783: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
784: --Bug 13256866
785: ,last_updated_by = gme_common_pvt.g_user_ident
786: ,last_update_date = gme_common_pvt.g_timestamp
787: ,last_update_login = gme_common_pvt.g_login_id
788: WHERE batch_id = x_batch_header_rec.batch_id;
789: END IF; /* max_cmplt_date */

Line 786: ,last_update_date = gme_common_pvt.g_timestamp

782: UPDATE gme_batch_header
783: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
784: --Bug 13256866
785: ,last_updated_by = gme_common_pvt.g_user_ident
786: ,last_update_date = gme_common_pvt.g_timestamp
787: ,last_update_login = gme_common_pvt.g_login_id
788: WHERE batch_id = x_batch_header_rec.batch_id;
789: END IF; /* max_cmplt_date */
790: END IF; /* dates not null */

Line 787: ,last_update_login = gme_common_pvt.g_login_id

783: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
784: --Bug 13256866
785: ,last_updated_by = gme_common_pvt.g_user_ident
786: ,last_update_date = gme_common_pvt.g_timestamp
787: ,last_update_login = gme_common_pvt.g_login_id
788: WHERE batch_id = x_batch_header_rec.batch_id;
789: END IF; /* max_cmplt_date */
790: END IF; /* dates not null */
791:

Line 810: IF NOT gme_common_pvt.check_validity_rule_dates

806: END IF;
807:
808: /* If not LCF batch then check validity rule dates */
809: IF l_batch_header_rec.recipe_validity_rule_id IS NOT NULL THEN
810: IF NOT gme_common_pvt.check_validity_rule_dates
811: (l_batch_header_rec.recipe_validity_rule_id
812: ,x_batch_header_rec.plan_start_date
813: ,x_batch_header_rec.plan_cmplt_date
814: ,l_batch_header_rec) THEN

Line 909: gme_common_pvt.is_material_auto_release (l_material_detail_ids (i));

905: l_material_detail_ids (i);
906: -- Stamp manual and incremental with step dates also
907: -- Pawan Kumar bug 5499499 added code for step dates.
908: l_rel_type :=
909: gme_common_pvt.is_material_auto_release (l_material_detail_ids (i));
910:
911: IF ( l_rel_type = 3 OR
912: ( gme_common_pvt.is_material_assoc_to_step(l_material_detail_ids(i)) = TRUE
913: AND l_rel_type IN (1, 2))

Line 912: ( gme_common_pvt.is_material_assoc_to_step(l_material_detail_ids(i)) = TRUE

908: l_rel_type :=
909: gme_common_pvt.is_material_auto_release (l_material_detail_ids (i));
910:
911: IF ( l_rel_type = 3 OR
912: ( gme_common_pvt.is_material_assoc_to_step(l_material_detail_ids(i)) = TRUE
913: AND l_rel_type IN (1, 2))
914: ) THEN
915: SELECT plan_start_date, plan_cmplt_date
916: INTO l_start_date, l_cmplt_date

Line 929: IF (x_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip) THEN

925: ELSE /* NOT ASSOCIATED TO STEP */
926: l_start_date := x_batch_header_rec.plan_start_date;
927:
928: -- Bug 9244927 - We want dates to work off of actual start date for ingredients in a WIP batch.
929: IF (x_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip) THEN
930: l_start_date := x_batch_header_rec.actual_start_date;
931: END IF;
932:
933: l_cmplt_date := x_batch_header_rec.plan_cmplt_date;

Line 935: END IF; /* IF l_rel_type = gme_common_pvt.g_mtl_autobystep_release */

931: END IF;
932:
933: l_cmplt_date := x_batch_header_rec.plan_cmplt_date;
934:
935: END IF; /* IF l_rel_type = gme_common_pvt.g_mtl_autobystep_release */
936:
937: -- Navin Added as part of Reschedule Batch/Step Build.
938: IF l_line_type_tbl (i) = gme_common_pvt.g_line_type_ing THEN
939: -- Update the material_required_date with the associated plan_start_Date;

Line 938: IF l_line_type_tbl (i) = gme_common_pvt.g_line_type_ing THEN

934:
935: END IF; /* IF l_rel_type = gme_common_pvt.g_mtl_autobystep_release */
936:
937: -- Navin Added as part of Reschedule Batch/Step Build.
938: IF l_line_type_tbl (i) = gme_common_pvt.g_line_type_ing THEN
939: -- Update the material_required_date with the associated plan_start_Date;
940: l_material_date := l_start_date;
941: ELSE
942: -- Update the material required date with the associated plan cmplt Date;

Line 957: gme_common_pvt.material_date_change

953: ||l_material_date
954: );
955: END IF;
956:
957: gme_common_pvt.material_date_change
958: (p_material_detail_id => l_material_detail_ids
959: (i)
960: ,p_material_date => l_material_date
961: ,x_return_status => l_return_status);

Line 999: gme_common_pvt.log_message('GME_EXPIRED_RESERV_MO_DELETED');

995:
996: --FPBug#4585491 Begin
997: IF (l_B_count > 0) OR (l_R_count > 0 AND l_M_count > 0) THEN
998: --atleast for one material line MO allocations and reservations are deleted
999: gme_common_pvt.log_message('GME_EXPIRED_RESERV_MO_DELETED');
1000: ELSIF l_R_count > 0 THEN
1001: ----atleast for one material line reservations are deleted
1002: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');
1003: ELSIF l_M_count > 0 THEN

Line 1002: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');

998: --atleast for one material line MO allocations and reservations are deleted
999: gme_common_pvt.log_message('GME_EXPIRED_RESERV_MO_DELETED');
1000: ELSIF l_R_count > 0 THEN
1001: ----atleast for one material line reservations are deleted
1002: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');
1003: ELSIF l_M_count > 0 THEN
1004: ----atleast for one material line MO allocations are deleted
1005: gme_common_pvt.log_message('GME_EXPIRED_MO_DELETED');
1006: END IF;

Line 1005: gme_common_pvt.log_message('GME_EXPIRED_MO_DELETED');

1001: ----atleast for one material line reservations are deleted
1002: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');
1003: ELSIF l_M_count > 0 THEN
1004: ----atleast for one material line MO allocations are deleted
1005: gme_common_pvt.log_message('GME_EXPIRED_MO_DELETED');
1006: END IF;
1007: x_return_status := fnd_api.g_ret_sts_success;
1008: --FPBug#4585491 End
1009:

Line 1035: ,last_updated_by = gme_common_pvt.g_user_ident

1031: IF x_batch_header_rec.FINITE_SCHEDULED_IND = 1 THEN
1032: UPDATE gme_batch_header
1033: SET FINITE_SCHEDULED_IND = 0
1034: --Bug 13256866
1035: ,last_updated_by = gme_common_pvt.g_user_ident
1036: ,last_update_date = gme_common_pvt.g_timestamp
1037: ,last_update_login = gme_common_pvt.g_login_id
1038: WHERE batch_id = x_batch_header_rec.batch_id;
1039: x_batch_header_rec.FINITE_SCHEDULED_IND := 0;

Line 1036: ,last_update_date = gme_common_pvt.g_timestamp

1032: UPDATE gme_batch_header
1033: SET FINITE_SCHEDULED_IND = 0
1034: --Bug 13256866
1035: ,last_updated_by = gme_common_pvt.g_user_ident
1036: ,last_update_date = gme_common_pvt.g_timestamp
1037: ,last_update_login = gme_common_pvt.g_login_id
1038: WHERE batch_id = x_batch_header_rec.batch_id;
1039: x_batch_header_rec.FINITE_SCHEDULED_IND := 0;
1040: END IF;

Line 1037: ,last_update_login = gme_common_pvt.g_login_id

1033: SET FINITE_SCHEDULED_IND = 0
1034: --Bug 13256866
1035: ,last_updated_by = gme_common_pvt.g_user_ident
1036: ,last_update_date = gme_common_pvt.g_timestamp
1037: ,last_update_login = gme_common_pvt.g_login_id
1038: WHERE batch_id = x_batch_header_rec.batch_id;
1039: x_batch_header_rec.FINITE_SCHEDULED_IND := 0;
1040: END IF;
1041:

Line 1044: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;

1040: END IF;
1041:
1042: -- Bug#5359091 end
1043: /* Update the row who columns */
1044: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
1045: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
1046: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
1047:
1048: IF (NVL (g_debug, 0) IN

Line 1045: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;

1041:
1042: -- Bug#5359091 end
1043: /* Update the row who columns */
1044: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
1045: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
1046: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
1047:
1048: IF (NVL (g_debug, 0) IN
1049: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

Line 1046: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;

1042: -- Bug#5359091 end
1043: /* Update the row who columns */
1044: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
1045: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
1046: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
1047:
1048: IF (NVL (g_debug, 0) IN
1049: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
1050: gme_debug.put_line ( g_pkg_name

Line 1060: gme_common_pvt.log_message ('GME_API_INV_BATCH_RESCHED');

1056: END IF;
1057: EXCEPTION
1058: WHEN invalid_batch THEN
1059: x_return_status := fnd_api.g_ret_sts_error;
1060: gme_common_pvt.log_message ('GME_API_INV_BATCH_RESCHED');
1061: WHEN null_dates THEN
1062: x_return_status := fnd_api.g_ret_sts_error;
1063: gme_common_pvt.log_message ('GME_API_RESCH_NO_DATES_PASSED');
1064: WHEN date_exceed_validity_rule THEN

Line 1063: gme_common_pvt.log_message ('GME_API_RESCH_NO_DATES_PASSED');

1059: x_return_status := fnd_api.g_ret_sts_error;
1060: gme_common_pvt.log_message ('GME_API_INV_BATCH_RESCHED');
1061: WHEN null_dates THEN
1062: x_return_status := fnd_api.g_ret_sts_error;
1063: gme_common_pvt.log_message ('GME_API_RESCH_NO_DATES_PASSED');
1064: WHEN date_exceed_validity_rule THEN
1065: x_return_status := fnd_api.g_ret_sts_error;
1066: WHEN invalid_validity_rule THEN
1067: x_return_status := fnd_api.g_ret_sts_error;

Line 1087: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');

1083: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1084: gme_debug.put_line ('Contiguity period ... not found');
1085: END IF;
1086:
1087: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');
1088: x_return_status := 'C';
1089: WHEN conversion_failure THEN
1090: IF l_item_no IS NULL THEN
1091: OPEN cur_item_no (l_item_id, p_batch_header_rec.organization_id);

Line 1176: ,last_updated_by = gme_common_pvt.g_user_ident

1172: --update batch start date
1173: IF (p_batchstep_id IS NULL) THEN
1174: UPDATE gme_batch_header
1175: SET plan_start_date = p_batch_header_rec.plan_start_date
1176: ,last_updated_by = gme_common_pvt.g_user_ident
1177: ,last_update_date = gme_common_pvt.g_timestamp
1178: ,last_update_login = gme_common_pvt.g_login_id
1179: WHERE batch_id = l_batch_id;
1180:

Line 1177: ,last_update_date = gme_common_pvt.g_timestamp

1173: IF (p_batchstep_id IS NULL) THEN
1174: UPDATE gme_batch_header
1175: SET plan_start_date = p_batch_header_rec.plan_start_date
1176: ,last_updated_by = gme_common_pvt.g_user_ident
1177: ,last_update_date = gme_common_pvt.g_timestamp
1178: ,last_update_login = gme_common_pvt.g_login_id
1179: WHERE batch_id = l_batch_id;
1180:
1181: --update batch end date

Line 1178: ,last_update_login = gme_common_pvt.g_login_id

1174: UPDATE gme_batch_header
1175: SET plan_start_date = p_batch_header_rec.plan_start_date
1176: ,last_updated_by = gme_common_pvt.g_user_ident
1177: ,last_update_date = gme_common_pvt.g_timestamp
1178: ,last_update_login = gme_common_pvt.g_login_id
1179: WHERE batch_id = l_batch_id;
1180:
1181: --update batch end date
1182: UPDATE gme_batch_header

Line 1184: ,last_updated_by = gme_common_pvt.g_user_ident

1180:
1181: --update batch end date
1182: UPDATE gme_batch_header
1183: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1184: ,last_updated_by = gme_common_pvt.g_user_ident
1185: ,last_update_date = gme_common_pvt.g_timestamp
1186: ,last_update_login = gme_common_pvt.g_login_id
1187: WHERE batch_id = l_batch_id
1188: AND plan_cmplt_date < p_batch_header_rec.plan_start_date;

Line 1185: ,last_update_date = gme_common_pvt.g_timestamp

1181: --update batch end date
1182: UPDATE gme_batch_header
1183: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1184: ,last_updated_by = gme_common_pvt.g_user_ident
1185: ,last_update_date = gme_common_pvt.g_timestamp
1186: ,last_update_login = gme_common_pvt.g_login_id
1187: WHERE batch_id = l_batch_id
1188: AND plan_cmplt_date < p_batch_header_rec.plan_start_date;
1189:

Line 1186: ,last_update_login = gme_common_pvt.g_login_id

1182: UPDATE gme_batch_header
1183: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1184: ,last_updated_by = gme_common_pvt.g_user_ident
1185: ,last_update_date = gme_common_pvt.g_timestamp
1186: ,last_update_login = gme_common_pvt.g_login_id
1187: WHERE batch_id = l_batch_id
1188: AND plan_cmplt_date < p_batch_header_rec.plan_start_date;
1189:
1190: --update batch due date

Line 1193: ,last_updated_by = gme_common_pvt.g_user_ident

1189:
1190: --update batch due date
1191: UPDATE gme_batch_header
1192: SET due_date = p_batch_header_rec.plan_start_date
1193: ,last_updated_by = gme_common_pvt.g_user_ident
1194: ,last_update_date = gme_common_pvt.g_timestamp
1195: ,last_update_login = gme_common_pvt.g_login_id
1196: WHERE batch_id = l_batch_id
1197: AND due_date < p_batch_header_rec.plan_start_date;

Line 1194: ,last_update_date = gme_common_pvt.g_timestamp

1190: --update batch due date
1191: UPDATE gme_batch_header
1192: SET due_date = p_batch_header_rec.plan_start_date
1193: ,last_updated_by = gme_common_pvt.g_user_ident
1194: ,last_update_date = gme_common_pvt.g_timestamp
1195: ,last_update_login = gme_common_pvt.g_login_id
1196: WHERE batch_id = l_batch_id
1197: AND due_date < p_batch_header_rec.plan_start_date;
1198: END IF;

Line 1195: ,last_update_login = gme_common_pvt.g_login_id

1191: UPDATE gme_batch_header
1192: SET due_date = p_batch_header_rec.plan_start_date
1193: ,last_updated_by = gme_common_pvt.g_user_ident
1194: ,last_update_date = gme_common_pvt.g_timestamp
1195: ,last_update_login = gme_common_pvt.g_login_id
1196: WHERE batch_id = l_batch_id
1197: AND due_date < p_batch_header_rec.plan_start_date;
1198: END IF;
1199:

Line 1203: ,last_updated_by = gme_common_pvt.g_user_ident

1199:
1200: -- update batch steps start date
1201: UPDATE gme_batch_steps
1202: SET plan_start_date = p_batch_header_rec.plan_start_date
1203: ,last_updated_by = gme_common_pvt.g_user_ident
1204: ,last_update_date = gme_common_pvt.g_timestamp
1205: ,last_update_login = gme_common_pvt.g_login_id
1206: WHERE batch_id = l_batch_id
1207: AND plan_start_date < p_batch_header_rec.plan_start_date

Line 1204: ,last_update_date = gme_common_pvt.g_timestamp

1200: -- update batch steps start date
1201: UPDATE gme_batch_steps
1202: SET plan_start_date = p_batch_header_rec.plan_start_date
1203: ,last_updated_by = gme_common_pvt.g_user_ident
1204: ,last_update_date = gme_common_pvt.g_timestamp
1205: ,last_update_login = gme_common_pvt.g_login_id
1206: WHERE batch_id = l_batch_id
1207: AND plan_start_date < p_batch_header_rec.plan_start_date
1208: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1205: ,last_update_login = gme_common_pvt.g_login_id

1201: UPDATE gme_batch_steps
1202: SET plan_start_date = p_batch_header_rec.plan_start_date
1203: ,last_updated_by = gme_common_pvt.g_user_ident
1204: ,last_update_date = gme_common_pvt.g_timestamp
1205: ,last_update_login = gme_common_pvt.g_login_id
1206: WHERE batch_id = l_batch_id
1207: AND plan_start_date < p_batch_header_rec.plan_start_date
1208: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1209:

Line 1213: ,last_updated_by = gme_common_pvt.g_user_ident

1209:
1210: -- update batch steps end date
1211: UPDATE gme_batch_steps
1212: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1213: ,last_updated_by = gme_common_pvt.g_user_ident
1214: ,last_update_date = gme_common_pvt.g_timestamp
1215: ,last_update_login = gme_common_pvt.g_login_id
1216: WHERE batch_id = l_batch_id
1217: AND plan_cmplt_date < p_batch_header_rec.plan_start_date

Line 1214: ,last_update_date = gme_common_pvt.g_timestamp

1210: -- update batch steps end date
1211: UPDATE gme_batch_steps
1212: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1213: ,last_updated_by = gme_common_pvt.g_user_ident
1214: ,last_update_date = gme_common_pvt.g_timestamp
1215: ,last_update_login = gme_common_pvt.g_login_id
1216: WHERE batch_id = l_batch_id
1217: AND plan_cmplt_date < p_batch_header_rec.plan_start_date
1218: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1215: ,last_update_login = gme_common_pvt.g_login_id

1211: UPDATE gme_batch_steps
1212: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1213: ,last_updated_by = gme_common_pvt.g_user_ident
1214: ,last_update_date = gme_common_pvt.g_timestamp
1215: ,last_update_login = gme_common_pvt.g_login_id
1216: WHERE batch_id = l_batch_id
1217: AND plan_cmplt_date < p_batch_header_rec.plan_start_date
1218: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1219:

Line 1223: ,last_updated_by = gme_common_pvt.g_user_ident

1219:
1220: -- update batch steps due date
1221: UPDATE gme_batch_steps
1222: SET due_date = p_batch_header_rec.plan_start_date
1223: ,last_updated_by = gme_common_pvt.g_user_ident
1224: ,last_update_date = gme_common_pvt.g_timestamp
1225: ,last_update_login = gme_common_pvt.g_login_id
1226: WHERE batch_id = l_batch_id
1227: AND due_date < p_batch_header_rec.plan_start_date

Line 1224: ,last_update_date = gme_common_pvt.g_timestamp

1220: -- update batch steps due date
1221: UPDATE gme_batch_steps
1222: SET due_date = p_batch_header_rec.plan_start_date
1223: ,last_updated_by = gme_common_pvt.g_user_ident
1224: ,last_update_date = gme_common_pvt.g_timestamp
1225: ,last_update_login = gme_common_pvt.g_login_id
1226: WHERE batch_id = l_batch_id
1227: AND due_date < p_batch_header_rec.plan_start_date
1228: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1225: ,last_update_login = gme_common_pvt.g_login_id

1221: UPDATE gme_batch_steps
1222: SET due_date = p_batch_header_rec.plan_start_date
1223: ,last_updated_by = gme_common_pvt.g_user_ident
1224: ,last_update_date = gme_common_pvt.g_timestamp
1225: ,last_update_login = gme_common_pvt.g_login_id
1226: WHERE batch_id = l_batch_id
1227: AND due_date < p_batch_header_rec.plan_start_date
1228: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1229:

Line 1233: ,last_updated_by = gme_common_pvt.g_user_ident

1229:
1230: -- update batch activity start date
1231: UPDATE gme_batch_step_activities
1232: SET plan_start_date = p_batch_header_rec.plan_start_date
1233: ,last_updated_by = gme_common_pvt.g_user_ident
1234: ,last_update_date = gme_common_pvt.g_timestamp
1235: ,last_update_login = gme_common_pvt.g_login_id
1236: WHERE batch_id = l_batch_id
1237: AND plan_start_date < p_batch_header_rec.plan_start_date

Line 1234: ,last_update_date = gme_common_pvt.g_timestamp

1230: -- update batch activity start date
1231: UPDATE gme_batch_step_activities
1232: SET plan_start_date = p_batch_header_rec.plan_start_date
1233: ,last_updated_by = gme_common_pvt.g_user_ident
1234: ,last_update_date = gme_common_pvt.g_timestamp
1235: ,last_update_login = gme_common_pvt.g_login_id
1236: WHERE batch_id = l_batch_id
1237: AND plan_start_date < p_batch_header_rec.plan_start_date
1238: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1235: ,last_update_login = gme_common_pvt.g_login_id

1231: UPDATE gme_batch_step_activities
1232: SET plan_start_date = p_batch_header_rec.plan_start_date
1233: ,last_updated_by = gme_common_pvt.g_user_ident
1234: ,last_update_date = gme_common_pvt.g_timestamp
1235: ,last_update_login = gme_common_pvt.g_login_id
1236: WHERE batch_id = l_batch_id
1237: AND plan_start_date < p_batch_header_rec.plan_start_date
1238: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1239:

Line 1243: ,last_updated_by = gme_common_pvt.g_user_ident

1239:
1240: -- update batch activity end date
1241: UPDATE gme_batch_step_activities
1242: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1243: ,last_updated_by = gme_common_pvt.g_user_ident
1244: ,last_update_date = gme_common_pvt.g_timestamp
1245: ,last_update_login = gme_common_pvt.g_login_id
1246: WHERE batch_id = l_batch_id
1247: AND plan_cmplt_date < p_batch_header_rec.plan_start_date

Line 1244: ,last_update_date = gme_common_pvt.g_timestamp

1240: -- update batch activity end date
1241: UPDATE gme_batch_step_activities
1242: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1243: ,last_updated_by = gme_common_pvt.g_user_ident
1244: ,last_update_date = gme_common_pvt.g_timestamp
1245: ,last_update_login = gme_common_pvt.g_login_id
1246: WHERE batch_id = l_batch_id
1247: AND plan_cmplt_date < p_batch_header_rec.plan_start_date
1248: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1245: ,last_update_login = gme_common_pvt.g_login_id

1241: UPDATE gme_batch_step_activities
1242: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1243: ,last_updated_by = gme_common_pvt.g_user_ident
1244: ,last_update_date = gme_common_pvt.g_timestamp
1245: ,last_update_login = gme_common_pvt.g_login_id
1246: WHERE batch_id = l_batch_id
1247: AND plan_cmplt_date < p_batch_header_rec.plan_start_date
1248: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1249:

Line 1253: ,last_updated_by = gme_common_pvt.g_user_ident

1249:
1250: -- update batch resources start date
1251: UPDATE gme_batch_step_resources
1252: SET plan_start_date = p_batch_header_rec.plan_start_date
1253: ,last_updated_by = gme_common_pvt.g_user_ident
1254: ,last_update_date = gme_common_pvt.g_timestamp
1255: ,last_update_login = gme_common_pvt.g_login_id
1256: WHERE batch_id = l_batch_id
1257: AND plan_start_date < p_batch_header_rec.plan_start_date

Line 1254: ,last_update_date = gme_common_pvt.g_timestamp

1250: -- update batch resources start date
1251: UPDATE gme_batch_step_resources
1252: SET plan_start_date = p_batch_header_rec.plan_start_date
1253: ,last_updated_by = gme_common_pvt.g_user_ident
1254: ,last_update_date = gme_common_pvt.g_timestamp
1255: ,last_update_login = gme_common_pvt.g_login_id
1256: WHERE batch_id = l_batch_id
1257: AND plan_start_date < p_batch_header_rec.plan_start_date
1258: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1255: ,last_update_login = gme_common_pvt.g_login_id

1251: UPDATE gme_batch_step_resources
1252: SET plan_start_date = p_batch_header_rec.plan_start_date
1253: ,last_updated_by = gme_common_pvt.g_user_ident
1254: ,last_update_date = gme_common_pvt.g_timestamp
1255: ,last_update_login = gme_common_pvt.g_login_id
1256: WHERE batch_id = l_batch_id
1257: AND plan_start_date < p_batch_header_rec.plan_start_date
1258: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1259:

Line 1263: ,last_updated_by = gme_common_pvt.g_user_ident

1259:
1260: -- update batch resources end date
1261: UPDATE gme_batch_step_resources
1262: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1263: ,last_updated_by = gme_common_pvt.g_user_ident
1264: ,last_update_date = gme_common_pvt.g_timestamp
1265: ,last_update_login = gme_common_pvt.g_login_id
1266: WHERE batch_id = l_batch_id
1267: AND plan_cmplt_date < p_batch_header_rec.plan_start_date

Line 1264: ,last_update_date = gme_common_pvt.g_timestamp

1260: -- update batch resources end date
1261: UPDATE gme_batch_step_resources
1262: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1263: ,last_updated_by = gme_common_pvt.g_user_ident
1264: ,last_update_date = gme_common_pvt.g_timestamp
1265: ,last_update_login = gme_common_pvt.g_login_id
1266: WHERE batch_id = l_batch_id
1267: AND plan_cmplt_date < p_batch_header_rec.plan_start_date
1268: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1265: ,last_update_login = gme_common_pvt.g_login_id

1261: UPDATE gme_batch_step_resources
1262: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1263: ,last_updated_by = gme_common_pvt.g_user_ident
1264: ,last_update_date = gme_common_pvt.g_timestamp
1265: ,last_update_login = gme_common_pvt.g_login_id
1266: WHERE batch_id = l_batch_id
1267: AND plan_cmplt_date < p_batch_header_rec.plan_start_date
1268: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1269:

Line 1273: ,last_updated_by = gme_common_pvt.g_user_ident

1269:
1270: -- update batch resources txns start date
1271: UPDATE gme_resource_txns
1272: SET start_date = p_batch_header_rec.plan_start_date
1273: ,last_updated_by = gme_common_pvt.g_user_ident
1274: ,last_update_date = gme_common_pvt.g_timestamp
1275: ,last_update_login = gme_common_pvt.g_login_id
1276: WHERE doc_id = l_batch_id
1277: AND doc_type = l_doc_type

Line 1274: ,last_update_date = gme_common_pvt.g_timestamp

1270: -- update batch resources txns start date
1271: UPDATE gme_resource_txns
1272: SET start_date = p_batch_header_rec.plan_start_date
1273: ,last_updated_by = gme_common_pvt.g_user_ident
1274: ,last_update_date = gme_common_pvt.g_timestamp
1275: ,last_update_login = gme_common_pvt.g_login_id
1276: WHERE doc_id = l_batch_id
1277: AND doc_type = l_doc_type
1278: AND start_date < p_batch_header_rec.plan_start_date;

Line 1275: ,last_update_login = gme_common_pvt.g_login_id

1271: UPDATE gme_resource_txns
1272: SET start_date = p_batch_header_rec.plan_start_date
1273: ,last_updated_by = gme_common_pvt.g_user_ident
1274: ,last_update_date = gme_common_pvt.g_timestamp
1275: ,last_update_login = gme_common_pvt.g_login_id
1276: WHERE doc_id = l_batch_id
1277: AND doc_type = l_doc_type
1278: AND start_date < p_batch_header_rec.plan_start_date;
1279:

Line 1283: ,last_updated_by = gme_common_pvt.g_user_ident

1279:
1280: -- update batch resources txns end date
1281: UPDATE gme_resource_txns
1282: SET end_date = p_batch_header_rec.plan_start_date
1283: ,last_updated_by = gme_common_pvt.g_user_ident
1284: ,last_update_date = gme_common_pvt.g_timestamp
1285: ,last_update_login = gme_common_pvt.g_login_id
1286: WHERE doc_id = l_batch_id
1287: AND doc_type = l_doc_type

Line 1284: ,last_update_date = gme_common_pvt.g_timestamp

1280: -- update batch resources txns end date
1281: UPDATE gme_resource_txns
1282: SET end_date = p_batch_header_rec.plan_start_date
1283: ,last_updated_by = gme_common_pvt.g_user_ident
1284: ,last_update_date = gme_common_pvt.g_timestamp
1285: ,last_update_login = gme_common_pvt.g_login_id
1286: WHERE doc_id = l_batch_id
1287: AND doc_type = l_doc_type
1288: AND end_date < p_batch_header_rec.plan_start_date;

Line 1285: ,last_update_login = gme_common_pvt.g_login_id

1281: UPDATE gme_resource_txns
1282: SET end_date = p_batch_header_rec.plan_start_date
1283: ,last_updated_by = gme_common_pvt.g_user_ident
1284: ,last_update_date = gme_common_pvt.g_timestamp
1285: ,last_update_login = gme_common_pvt.g_login_id
1286: WHERE doc_id = l_batch_id
1287: AND doc_type = l_doc_type
1288: AND end_date < p_batch_header_rec.plan_start_date;
1289:

Line 1293: ,last_updated_by = gme_common_pvt.g_user_ident

1289:
1290: -- update batch resources txns trans date
1291: UPDATE gme_resource_txns
1292: SET trans_date = p_batch_header_rec.plan_start_date
1293: ,last_updated_by = gme_common_pvt.g_user_ident
1294: ,last_update_date = gme_common_pvt.g_timestamp
1295: ,last_update_login = gme_common_pvt.g_login_id
1296: WHERE doc_id = l_batch_id
1297: AND doc_type = l_doc_type

Line 1294: ,last_update_date = gme_common_pvt.g_timestamp

1290: -- update batch resources txns trans date
1291: UPDATE gme_resource_txns
1292: SET trans_date = p_batch_header_rec.plan_start_date
1293: ,last_updated_by = gme_common_pvt.g_user_ident
1294: ,last_update_date = gme_common_pvt.g_timestamp
1295: ,last_update_login = gme_common_pvt.g_login_id
1296: WHERE doc_id = l_batch_id
1297: AND doc_type = l_doc_type
1298: AND trans_date < p_batch_header_rec.plan_start_date;

Line 1295: ,last_update_login = gme_common_pvt.g_login_id

1291: UPDATE gme_resource_txns
1292: SET trans_date = p_batch_header_rec.plan_start_date
1293: ,last_updated_by = gme_common_pvt.g_user_ident
1294: ,last_update_date = gme_common_pvt.g_timestamp
1295: ,last_update_login = gme_common_pvt.g_login_id
1296: WHERE doc_id = l_batch_id
1297: AND doc_type = l_doc_type
1298: AND trans_date < p_batch_header_rec.plan_start_date;
1299: ELSE

Line 1304: ,last_updated_by = gme_common_pvt.g_user_ident

1300: --update batch start date
1301: IF (p_batchstep_id IS NULL) THEN
1302: UPDATE gme_batch_header
1303: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1304: ,last_updated_by = gme_common_pvt.g_user_ident
1305: ,last_update_date = gme_common_pvt.g_timestamp
1306: ,last_update_login = gme_common_pvt.g_login_id
1307: WHERE batch_id = l_batch_id;
1308:

Line 1305: ,last_update_date = gme_common_pvt.g_timestamp

1301: IF (p_batchstep_id IS NULL) THEN
1302: UPDATE gme_batch_header
1303: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1304: ,last_updated_by = gme_common_pvt.g_user_ident
1305: ,last_update_date = gme_common_pvt.g_timestamp
1306: ,last_update_login = gme_common_pvt.g_login_id
1307: WHERE batch_id = l_batch_id;
1308:
1309: --update batch end date

Line 1306: ,last_update_login = gme_common_pvt.g_login_id

1302: UPDATE gme_batch_header
1303: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1304: ,last_updated_by = gme_common_pvt.g_user_ident
1305: ,last_update_date = gme_common_pvt.g_timestamp
1306: ,last_update_login = gme_common_pvt.g_login_id
1307: WHERE batch_id = l_batch_id;
1308:
1309: --update batch end date
1310: UPDATE gme_batch_header

Line 1312: ,last_updated_by = gme_common_pvt.g_user_ident

1308:
1309: --update batch end date
1310: UPDATE gme_batch_header
1311: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1312: ,last_updated_by = gme_common_pvt.g_user_ident
1313: ,last_update_date = gme_common_pvt.g_timestamp
1314: ,last_update_login = gme_common_pvt.g_login_id
1315: WHERE batch_id = l_batch_id
1316: AND plan_start_date > p_batch_header_rec.plan_cmplt_date;

Line 1313: ,last_update_date = gme_common_pvt.g_timestamp

1309: --update batch end date
1310: UPDATE gme_batch_header
1311: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1312: ,last_updated_by = gme_common_pvt.g_user_ident
1313: ,last_update_date = gme_common_pvt.g_timestamp
1314: ,last_update_login = gme_common_pvt.g_login_id
1315: WHERE batch_id = l_batch_id
1316: AND plan_start_date > p_batch_header_rec.plan_cmplt_date;
1317:

Line 1314: ,last_update_login = gme_common_pvt.g_login_id

1310: UPDATE gme_batch_header
1311: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1312: ,last_updated_by = gme_common_pvt.g_user_ident
1313: ,last_update_date = gme_common_pvt.g_timestamp
1314: ,last_update_login = gme_common_pvt.g_login_id
1315: WHERE batch_id = l_batch_id
1316: AND plan_start_date > p_batch_header_rec.plan_cmplt_date;
1317:
1318: --update batch due date

Line 1324: ,last_updated_by = gme_common_pvt.g_user_ident

1320: -- The due date which was getting updated with the planned
1321: -- completion date is changed to be updated with the same due date.
1322: UPDATE gme_batch_header
1323: SET due_date = p_batch_header_rec.due_date
1324: ,last_updated_by = gme_common_pvt.g_user_ident
1325: ,last_update_date = gme_common_pvt.g_timestamp
1326: ,last_update_login = gme_common_pvt.g_login_id
1327: WHERE batch_id = l_batch_id
1328: AND due_date > p_batch_header_rec.plan_cmplt_date;

Line 1325: ,last_update_date = gme_common_pvt.g_timestamp

1321: -- completion date is changed to be updated with the same due date.
1322: UPDATE gme_batch_header
1323: SET due_date = p_batch_header_rec.due_date
1324: ,last_updated_by = gme_common_pvt.g_user_ident
1325: ,last_update_date = gme_common_pvt.g_timestamp
1326: ,last_update_login = gme_common_pvt.g_login_id
1327: WHERE batch_id = l_batch_id
1328: AND due_date > p_batch_header_rec.plan_cmplt_date;
1329: END IF;

Line 1326: ,last_update_login = gme_common_pvt.g_login_id

1322: UPDATE gme_batch_header
1323: SET due_date = p_batch_header_rec.due_date
1324: ,last_updated_by = gme_common_pvt.g_user_ident
1325: ,last_update_date = gme_common_pvt.g_timestamp
1326: ,last_update_login = gme_common_pvt.g_login_id
1327: WHERE batch_id = l_batch_id
1328: AND due_date > p_batch_header_rec.plan_cmplt_date;
1329: END IF;
1330:

Line 1334: ,last_updated_by = gme_common_pvt.g_user_ident

1330:
1331: -- update batch steps start date
1332: UPDATE gme_batch_steps
1333: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1334: ,last_updated_by = gme_common_pvt.g_user_ident
1335: ,last_update_date = gme_common_pvt.g_timestamp
1336: ,last_update_login = gme_common_pvt.g_login_id
1337: WHERE batch_id = l_batch_id
1338: AND plan_start_date > p_batch_header_rec.plan_cmplt_date

Line 1335: ,last_update_date = gme_common_pvt.g_timestamp

1331: -- update batch steps start date
1332: UPDATE gme_batch_steps
1333: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1334: ,last_updated_by = gme_common_pvt.g_user_ident
1335: ,last_update_date = gme_common_pvt.g_timestamp
1336: ,last_update_login = gme_common_pvt.g_login_id
1337: WHERE batch_id = l_batch_id
1338: AND plan_start_date > p_batch_header_rec.plan_cmplt_date
1339: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1336: ,last_update_login = gme_common_pvt.g_login_id

1332: UPDATE gme_batch_steps
1333: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1334: ,last_updated_by = gme_common_pvt.g_user_ident
1335: ,last_update_date = gme_common_pvt.g_timestamp
1336: ,last_update_login = gme_common_pvt.g_login_id
1337: WHERE batch_id = l_batch_id
1338: AND plan_start_date > p_batch_header_rec.plan_cmplt_date
1339: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1340:

Line 1344: ,last_updated_by = gme_common_pvt.g_user_ident

1340:
1341: -- update batch steps end date
1342: UPDATE gme_batch_steps
1343: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1344: ,last_updated_by = gme_common_pvt.g_user_ident
1345: ,last_update_date = gme_common_pvt.g_timestamp
1346: ,last_update_login = gme_common_pvt.g_login_id
1347: WHERE batch_id = l_batch_id
1348: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date

Line 1345: ,last_update_date = gme_common_pvt.g_timestamp

1341: -- update batch steps end date
1342: UPDATE gme_batch_steps
1343: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1344: ,last_updated_by = gme_common_pvt.g_user_ident
1345: ,last_update_date = gme_common_pvt.g_timestamp
1346: ,last_update_login = gme_common_pvt.g_login_id
1347: WHERE batch_id = l_batch_id
1348: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date
1349: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1346: ,last_update_login = gme_common_pvt.g_login_id

1342: UPDATE gme_batch_steps
1343: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1344: ,last_updated_by = gme_common_pvt.g_user_ident
1345: ,last_update_date = gme_common_pvt.g_timestamp
1346: ,last_update_login = gme_common_pvt.g_login_id
1347: WHERE batch_id = l_batch_id
1348: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date
1349: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1350:

Line 1354: ,last_updated_by = gme_common_pvt.g_user_ident

1350:
1351: -- update batch steps due date
1352: UPDATE gme_batch_steps
1353: SET due_date = p_batch_header_rec.plan_cmplt_date
1354: ,last_updated_by = gme_common_pvt.g_user_ident
1355: ,last_update_date = gme_common_pvt.g_timestamp
1356: ,last_update_login = gme_common_pvt.g_login_id
1357: WHERE batch_id = l_batch_id
1358: AND due_date > p_batch_header_rec.plan_cmplt_date

Line 1355: ,last_update_date = gme_common_pvt.g_timestamp

1351: -- update batch steps due date
1352: UPDATE gme_batch_steps
1353: SET due_date = p_batch_header_rec.plan_cmplt_date
1354: ,last_updated_by = gme_common_pvt.g_user_ident
1355: ,last_update_date = gme_common_pvt.g_timestamp
1356: ,last_update_login = gme_common_pvt.g_login_id
1357: WHERE batch_id = l_batch_id
1358: AND due_date > p_batch_header_rec.plan_cmplt_date
1359: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1356: ,last_update_login = gme_common_pvt.g_login_id

1352: UPDATE gme_batch_steps
1353: SET due_date = p_batch_header_rec.plan_cmplt_date
1354: ,last_updated_by = gme_common_pvt.g_user_ident
1355: ,last_update_date = gme_common_pvt.g_timestamp
1356: ,last_update_login = gme_common_pvt.g_login_id
1357: WHERE batch_id = l_batch_id
1358: AND due_date > p_batch_header_rec.plan_cmplt_date
1359: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1360:

Line 1364: ,last_updated_by = gme_common_pvt.g_user_ident

1360:
1361: -- update batch activity start date
1362: UPDATE gme_batch_step_activities
1363: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1364: ,last_updated_by = gme_common_pvt.g_user_ident
1365: ,last_update_date = gme_common_pvt.g_timestamp
1366: ,last_update_login = gme_common_pvt.g_login_id
1367: WHERE batch_id = l_batch_id
1368: AND plan_start_date > p_batch_header_rec.plan_cmplt_date

Line 1365: ,last_update_date = gme_common_pvt.g_timestamp

1361: -- update batch activity start date
1362: UPDATE gme_batch_step_activities
1363: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1364: ,last_updated_by = gme_common_pvt.g_user_ident
1365: ,last_update_date = gme_common_pvt.g_timestamp
1366: ,last_update_login = gme_common_pvt.g_login_id
1367: WHERE batch_id = l_batch_id
1368: AND plan_start_date > p_batch_header_rec.plan_cmplt_date
1369: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1366: ,last_update_login = gme_common_pvt.g_login_id

1362: UPDATE gme_batch_step_activities
1363: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1364: ,last_updated_by = gme_common_pvt.g_user_ident
1365: ,last_update_date = gme_common_pvt.g_timestamp
1366: ,last_update_login = gme_common_pvt.g_login_id
1367: WHERE batch_id = l_batch_id
1368: AND plan_start_date > p_batch_header_rec.plan_cmplt_date
1369: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1370:

Line 1374: ,last_updated_by = gme_common_pvt.g_user_ident

1370:
1371: -- update batch activity end date
1372: UPDATE gme_batch_step_activities
1373: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1374: ,last_updated_by = gme_common_pvt.g_user_ident
1375: ,last_update_date = gme_common_pvt.g_timestamp
1376: ,last_update_login = gme_common_pvt.g_login_id
1377: WHERE batch_id = l_batch_id
1378: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date

Line 1375: ,last_update_date = gme_common_pvt.g_timestamp

1371: -- update batch activity end date
1372: UPDATE gme_batch_step_activities
1373: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1374: ,last_updated_by = gme_common_pvt.g_user_ident
1375: ,last_update_date = gme_common_pvt.g_timestamp
1376: ,last_update_login = gme_common_pvt.g_login_id
1377: WHERE batch_id = l_batch_id
1378: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date
1379: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1376: ,last_update_login = gme_common_pvt.g_login_id

1372: UPDATE gme_batch_step_activities
1373: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1374: ,last_updated_by = gme_common_pvt.g_user_ident
1375: ,last_update_date = gme_common_pvt.g_timestamp
1376: ,last_update_login = gme_common_pvt.g_login_id
1377: WHERE batch_id = l_batch_id
1378: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date
1379: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1380:

Line 1384: ,last_updated_by = gme_common_pvt.g_user_ident

1380:
1381: -- update batch resources start date
1382: UPDATE gme_batch_step_resources
1383: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1384: ,last_updated_by = gme_common_pvt.g_user_ident
1385: ,last_update_date = gme_common_pvt.g_timestamp
1386: ,last_update_login = gme_common_pvt.g_login_id
1387: WHERE batch_id = l_batch_id
1388: AND plan_start_date > p_batch_header_rec.plan_cmplt_date

Line 1385: ,last_update_date = gme_common_pvt.g_timestamp

1381: -- update batch resources start date
1382: UPDATE gme_batch_step_resources
1383: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1384: ,last_updated_by = gme_common_pvt.g_user_ident
1385: ,last_update_date = gme_common_pvt.g_timestamp
1386: ,last_update_login = gme_common_pvt.g_login_id
1387: WHERE batch_id = l_batch_id
1388: AND plan_start_date > p_batch_header_rec.plan_cmplt_date
1389: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1386: ,last_update_login = gme_common_pvt.g_login_id

1382: UPDATE gme_batch_step_resources
1383: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1384: ,last_updated_by = gme_common_pvt.g_user_ident
1385: ,last_update_date = gme_common_pvt.g_timestamp
1386: ,last_update_login = gme_common_pvt.g_login_id
1387: WHERE batch_id = l_batch_id
1388: AND plan_start_date > p_batch_header_rec.plan_cmplt_date
1389: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1390:

Line 1394: ,last_updated_by = gme_common_pvt.g_user_ident

1390:
1391: -- update batch resources end date
1392: UPDATE gme_batch_step_resources
1393: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1394: ,last_updated_by = gme_common_pvt.g_user_ident
1395: ,last_update_date = gme_common_pvt.g_timestamp
1396: ,last_update_login = gme_common_pvt.g_login_id
1397: WHERE batch_id = l_batch_id
1398: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date

Line 1395: ,last_update_date = gme_common_pvt.g_timestamp

1391: -- update batch resources end date
1392: UPDATE gme_batch_step_resources
1393: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1394: ,last_updated_by = gme_common_pvt.g_user_ident
1395: ,last_update_date = gme_common_pvt.g_timestamp
1396: ,last_update_login = gme_common_pvt.g_login_id
1397: WHERE batch_id = l_batch_id
1398: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date
1399: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1396: ,last_update_login = gme_common_pvt.g_login_id

1392: UPDATE gme_batch_step_resources
1393: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1394: ,last_updated_by = gme_common_pvt.g_user_ident
1395: ,last_update_date = gme_common_pvt.g_timestamp
1396: ,last_update_login = gme_common_pvt.g_login_id
1397: WHERE batch_id = l_batch_id
1398: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date
1399: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1400:

Line 1404: ,last_updated_by = gme_common_pvt.g_user_ident

1400:
1401: -- update batch resources txns start date
1402: UPDATE gme_resource_txns
1403: SET start_date = p_batch_header_rec.plan_cmplt_date
1404: ,last_updated_by = gme_common_pvt.g_user_ident
1405: ,last_update_date = gme_common_pvt.g_timestamp
1406: ,last_update_login = gme_common_pvt.g_login_id
1407: WHERE doc_id = l_batch_id
1408: AND doc_type = l_doc_type

Line 1405: ,last_update_date = gme_common_pvt.g_timestamp

1401: -- update batch resources txns start date
1402: UPDATE gme_resource_txns
1403: SET start_date = p_batch_header_rec.plan_cmplt_date
1404: ,last_updated_by = gme_common_pvt.g_user_ident
1405: ,last_update_date = gme_common_pvt.g_timestamp
1406: ,last_update_login = gme_common_pvt.g_login_id
1407: WHERE doc_id = l_batch_id
1408: AND doc_type = l_doc_type
1409: AND start_date > p_batch_header_rec.plan_cmplt_date;

Line 1406: ,last_update_login = gme_common_pvt.g_login_id

1402: UPDATE gme_resource_txns
1403: SET start_date = p_batch_header_rec.plan_cmplt_date
1404: ,last_updated_by = gme_common_pvt.g_user_ident
1405: ,last_update_date = gme_common_pvt.g_timestamp
1406: ,last_update_login = gme_common_pvt.g_login_id
1407: WHERE doc_id = l_batch_id
1408: AND doc_type = l_doc_type
1409: AND start_date > p_batch_header_rec.plan_cmplt_date;
1410:

Line 1414: ,last_updated_by = gme_common_pvt.g_user_ident

1410:
1411: -- update batch resources txns end date
1412: UPDATE gme_resource_txns
1413: SET end_date = p_batch_header_rec.plan_cmplt_date
1414: ,last_updated_by = gme_common_pvt.g_user_ident
1415: ,last_update_date = gme_common_pvt.g_timestamp
1416: ,last_update_login = gme_common_pvt.g_login_id
1417: WHERE doc_id = l_batch_id
1418: AND doc_type = l_doc_type

Line 1415: ,last_update_date = gme_common_pvt.g_timestamp

1411: -- update batch resources txns end date
1412: UPDATE gme_resource_txns
1413: SET end_date = p_batch_header_rec.plan_cmplt_date
1414: ,last_updated_by = gme_common_pvt.g_user_ident
1415: ,last_update_date = gme_common_pvt.g_timestamp
1416: ,last_update_login = gme_common_pvt.g_login_id
1417: WHERE doc_id = l_batch_id
1418: AND doc_type = l_doc_type
1419: AND end_date > p_batch_header_rec.plan_cmplt_date;

Line 1416: ,last_update_login = gme_common_pvt.g_login_id

1412: UPDATE gme_resource_txns
1413: SET end_date = p_batch_header_rec.plan_cmplt_date
1414: ,last_updated_by = gme_common_pvt.g_user_ident
1415: ,last_update_date = gme_common_pvt.g_timestamp
1416: ,last_update_login = gme_common_pvt.g_login_id
1417: WHERE doc_id = l_batch_id
1418: AND doc_type = l_doc_type
1419: AND end_date > p_batch_header_rec.plan_cmplt_date;
1420:

Line 1424: ,last_updated_by = gme_common_pvt.g_user_ident

1420:
1421: -- update batch resources txns trans date
1422: UPDATE gme_resource_txns
1423: SET trans_date = p_batch_header_rec.plan_cmplt_date
1424: ,last_updated_by = gme_common_pvt.g_user_ident
1425: ,last_update_date = gme_common_pvt.g_timestamp
1426: ,last_update_login = gme_common_pvt.g_login_id
1427: WHERE doc_id = l_batch_id
1428: AND doc_type = l_doc_type

Line 1425: ,last_update_date = gme_common_pvt.g_timestamp

1421: -- update batch resources txns trans date
1422: UPDATE gme_resource_txns
1423: SET trans_date = p_batch_header_rec.plan_cmplt_date
1424: ,last_updated_by = gme_common_pvt.g_user_ident
1425: ,last_update_date = gme_common_pvt.g_timestamp
1426: ,last_update_login = gme_common_pvt.g_login_id
1427: WHERE doc_id = l_batch_id
1428: AND doc_type = l_doc_type
1429: AND trans_date > p_batch_header_rec.plan_cmplt_date;

Line 1426: ,last_update_login = gme_common_pvt.g_login_id

1422: UPDATE gme_resource_txns
1423: SET trans_date = p_batch_header_rec.plan_cmplt_date
1424: ,last_updated_by = gme_common_pvt.g_user_ident
1425: ,last_update_date = gme_common_pvt.g_timestamp
1426: ,last_update_login = gme_common_pvt.g_login_id
1427: WHERE doc_id = l_batch_id
1428: AND doc_type = l_doc_type
1429: AND trans_date > p_batch_header_rec.plan_cmplt_date;
1430: END IF;