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: IF p_batch_header_rec.plan_cmplt_date <

Line 242: gme_common_pvt.log_message

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

Line 265: IF NOT gme_common_pvt.check_validity_rule_dates

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

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

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

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

376: END IF;
377: END IF; /* both date not null*/
378: END IF; /* batch_status = 1*/
379:
380: IF (x_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip) THEN
381: IF (p_batch_header_rec.plan_cmplt_date IS NOT NULL) THEN
382: gme_create_step_pvt.calc_dates
383: (p_gme_batch_header_rec => p_batch_header_rec
384: ,p_use_workday_cal => p_use_workday_cal

Line 468: IF gme_common_pvt.calc_date_from_prod_rule

464: ELSE
465: l_date := p_batch_header_rec.plan_start_date;
466: END IF;
467:
468: IF gme_common_pvt.calc_date_from_prod_rule
469: (p_organization_id => x_batch_header_rec.organization_id
470: ,p_inventory_item_id => l_recipe_validity_rule_rec.inventory_item_id
471: ,p_item_qty => l_temp_qty
472: ,p_start_date => l_date

Line 481: gme_common_pvt.g_batch_wip THEN

477: l_no_prod_rule_found := FALSE;
478:
479: /* IF batch is WIP then disregard calculated plan_start_date */
480: IF x_batch_header_rec.batch_status =
481: gme_common_pvt.g_batch_wip THEN
482: x_batch_header_rec.plan_start_date :=
483: p_batch_header_rec.plan_start_date;
484: END IF;
485: ELSE

Line 513: gme_common_pvt.g_timestamp;

509: p_batch_header_rec.plan_cmplt_date;
510: ELSIF p_batch_header_rec.plan_start_date IS NULL
511: AND p_batch_header_rec.plan_cmplt_date IS NULL THEN
512: x_batch_header_rec.plan_start_date :=
513: gme_common_pvt.g_timestamp;
514: x_batch_header_rec.plan_cmplt_date :=
515: gme_common_pvt.g_timestamp;
516: ELSIF p_batch_header_rec.plan_start_date IS NOT NULL
517: AND p_batch_header_rec.plan_cmplt_date IS NOT NULL THEN

Line 515: gme_common_pvt.g_timestamp;

511: AND p_batch_header_rec.plan_cmplt_date IS NULL THEN
512: x_batch_header_rec.plan_start_date :=
513: gme_common_pvt.g_timestamp;
514: x_batch_header_rec.plan_cmplt_date :=
515: gme_common_pvt.g_timestamp;
516: ELSIF p_batch_header_rec.plan_start_date IS NOT NULL
517: AND p_batch_header_rec.plan_cmplt_date IS NOT NULL THEN
518: x_batch_header_rec.plan_start_date :=
519: p_batch_header_rec.plan_start_date;

Line 678: ,last_updated_by = gme_common_pvt.g_user_ident

674: ,plan_cmplt_date = x_batch_header_rec.plan_cmplt_date
675: ,due_date =
676: NVL (x_batch_header_rec.due_date
677: ,x_batch_header_rec.plan_cmplt_date)
678: ,last_updated_by = gme_common_pvt.g_user_ident
679: ,last_update_date = gme_common_pvt.g_timestamp
680: ,last_update_login = gme_common_pvt.g_login_id
681: WHERE batch_id = x_batch_header_rec.batch_id;
682: END IF;

Line 679: ,last_update_date = gme_common_pvt.g_timestamp

675: ,due_date =
676: NVL (x_batch_header_rec.due_date
677: ,x_batch_header_rec.plan_cmplt_date)
678: ,last_updated_by = gme_common_pvt.g_user_ident
679: ,last_update_date = gme_common_pvt.g_timestamp
680: ,last_update_login = gme_common_pvt.g_login_id
681: WHERE batch_id = x_batch_header_rec.batch_id;
682: END IF;
683:

Line 680: ,last_update_login = gme_common_pvt.g_login_id

676: NVL (x_batch_header_rec.due_date
677: ,x_batch_header_rec.plan_cmplt_date)
678: ,last_updated_by = gme_common_pvt.g_user_ident
679: ,last_update_date = gme_common_pvt.g_timestamp
680: ,last_update_login = gme_common_pvt.g_login_id
681: WHERE batch_id = x_batch_header_rec.batch_id;
682: END IF;
683:
684: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 798: IF NOT gme_common_pvt.check_validity_rule_dates

794: END IF;
795:
796: /* If not LCF batch then check validity rule dates */
797: IF l_batch_header_rec.recipe_validity_rule_id IS NOT NULL THEN
798: IF NOT gme_common_pvt.check_validity_rule_dates
799: (l_batch_header_rec.recipe_validity_rule_id
800: ,x_batch_header_rec.plan_start_date
801: ,x_batch_header_rec.plan_cmplt_date
802: ,l_batch_header_rec) THEN

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

892: l_material_detail_ids (i);
893: -- Stamp manual and incremental with step dates also
894: -- Pawan Kumar bug 5499499 added code for step dates.
895: l_rel_type :=
896: gme_common_pvt.is_material_auto_release (l_material_detail_ids (i));
897:
898: IF ( l_rel_type = 3 OR
899: ( gme_common_pvt.is_material_assoc_to_step(l_material_detail_ids(i)) = TRUE
900: AND l_rel_type IN (1, 2))

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

895: l_rel_type :=
896: gme_common_pvt.is_material_auto_release (l_material_detail_ids (i));
897:
898: IF ( l_rel_type = 3 OR
899: ( gme_common_pvt.is_material_assoc_to_step(l_material_detail_ids(i)) = TRUE
900: AND l_rel_type IN (1, 2))
901: ) THEN
902: SELECT plan_start_date, plan_cmplt_date
903: INTO l_start_date, l_cmplt_date

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

912: ELSE /* NOT ASSOCIATED TO STEP */
913: l_start_date := x_batch_header_rec.plan_start_date;
914: l_cmplt_date := x_batch_header_rec.plan_cmplt_date;
915:
916: END IF; /* IF l_rel_type = gme_common_pvt.g_mtl_autobystep_release */
917:
918: -- Navin Added as part of Reschedule Batch/Step Build.
919: IF l_line_type_tbl (i) = gme_common_pvt.g_line_type_ing THEN
920: -- Update the material_required_date with the associated plan_start_Date;

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

915:
916: END IF; /* IF l_rel_type = gme_common_pvt.g_mtl_autobystep_release */
917:
918: -- Navin Added as part of Reschedule Batch/Step Build.
919: IF l_line_type_tbl (i) = gme_common_pvt.g_line_type_ing THEN
920: -- Update the material_required_date with the associated plan_start_Date;
921: l_material_date := l_start_date;
922: ELSE
923: -- Update the material required date with the associated plan cmplt Date;

Line 938: gme_common_pvt.material_date_change

934: ||l_material_date
935: );
936: END IF;
937:
938: gme_common_pvt.material_date_change
939: (p_material_detail_id => l_material_detail_ids
940: (i)
941: ,p_material_date => l_material_date
942: ,x_return_status => l_return_status);

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

976:
977: --FPBug#4585491 Begin
978: IF (l_B_count > 0) OR (l_R_count > 0 AND l_M_count > 0) THEN
979: --atleast for one material line MO allocations and reservations are deleted
980: gme_common_pvt.log_message('GME_EXPIRED_RESERV_MO_DELETED');
981: ELSIF l_R_count > 0 THEN
982: ----atleast for one material line reservations are deleted
983: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');
984: ELSIF l_M_count > 0 THEN

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

979: --atleast for one material line MO allocations and reservations are deleted
980: gme_common_pvt.log_message('GME_EXPIRED_RESERV_MO_DELETED');
981: ELSIF l_R_count > 0 THEN
982: ----atleast for one material line reservations are deleted
983: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');
984: ELSIF l_M_count > 0 THEN
985: ----atleast for one material line MO allocations are deleted
986: gme_common_pvt.log_message('GME_EXPIRED_MO_DELETED');
987: END IF;

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

982: ----atleast for one material line reservations are deleted
983: gme_common_pvt.log_message('GME_EXPIRED_RESERV_DELETED');
984: ELSIF l_M_count > 0 THEN
985: ----atleast for one material line MO allocations are deleted
986: gme_common_pvt.log_message('GME_EXPIRED_MO_DELETED');
987: END IF;
988: x_return_status := fnd_api.g_ret_sts_success;
989: --FPBug#4585491 End
990:

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

1017: END IF;
1018:
1019: -- Bug#5359091 end
1020: /* Update the row who columns */
1021: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
1022: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
1023: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
1024:
1025: IF (NVL (g_debug, 0) IN

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

1018:
1019: -- Bug#5359091 end
1020: /* Update the row who columns */
1021: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
1022: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
1023: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
1024:
1025: IF (NVL (g_debug, 0) IN
1026: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

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

1019: -- Bug#5359091 end
1020: /* Update the row who columns */
1021: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
1022: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
1023: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
1024:
1025: IF (NVL (g_debug, 0) IN
1026: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
1027: gme_debug.put_line ( g_pkg_name

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

1033: END IF;
1034: EXCEPTION
1035: WHEN invalid_batch THEN
1036: x_return_status := fnd_api.g_ret_sts_error;
1037: gme_common_pvt.log_message ('GME_API_INV_BATCH_RESCHED');
1038: WHEN null_dates THEN
1039: x_return_status := fnd_api.g_ret_sts_error;
1040: gme_common_pvt.log_message ('GME_API_RESCH_NO_DATES_PASSED');
1041: WHEN date_exceed_validity_rule THEN

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

1036: x_return_status := fnd_api.g_ret_sts_error;
1037: gme_common_pvt.log_message ('GME_API_INV_BATCH_RESCHED');
1038: WHEN null_dates THEN
1039: x_return_status := fnd_api.g_ret_sts_error;
1040: gme_common_pvt.log_message ('GME_API_RESCH_NO_DATES_PASSED');
1041: WHEN date_exceed_validity_rule THEN
1042: x_return_status := fnd_api.g_ret_sts_error;
1043: WHEN invalid_validity_rule THEN
1044: x_return_status := fnd_api.g_ret_sts_error;

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

1060: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1061: gme_debug.put_line ('Contiguity period ... not found');
1062: END IF;
1063:
1064: gme_common_pvt.log_message ('GME_NON_CONTIGUOUS_TIME');
1065: x_return_status := 'C';
1066: WHEN conversion_failure THEN
1067: IF l_item_no IS NULL THEN
1068: OPEN cur_item_no (l_item_id, p_batch_header_rec.organization_id);

Line 1153: ,last_updated_by = gme_common_pvt.g_user_ident

1149: --update batch start date
1150: IF (p_batchstep_id IS NULL) THEN
1151: UPDATE gme_batch_header
1152: SET plan_start_date = p_batch_header_rec.plan_start_date
1153: ,last_updated_by = gme_common_pvt.g_user_ident
1154: ,last_update_date = gme_common_pvt.g_timestamp
1155: ,last_update_login = gme_common_pvt.g_login_id
1156: WHERE batch_id = l_batch_id;
1157:

Line 1154: ,last_update_date = gme_common_pvt.g_timestamp

1150: IF (p_batchstep_id IS NULL) THEN
1151: UPDATE gme_batch_header
1152: SET plan_start_date = p_batch_header_rec.plan_start_date
1153: ,last_updated_by = gme_common_pvt.g_user_ident
1154: ,last_update_date = gme_common_pvt.g_timestamp
1155: ,last_update_login = gme_common_pvt.g_login_id
1156: WHERE batch_id = l_batch_id;
1157:
1158: --update batch end date

Line 1155: ,last_update_login = gme_common_pvt.g_login_id

1151: UPDATE gme_batch_header
1152: SET plan_start_date = p_batch_header_rec.plan_start_date
1153: ,last_updated_by = gme_common_pvt.g_user_ident
1154: ,last_update_date = gme_common_pvt.g_timestamp
1155: ,last_update_login = gme_common_pvt.g_login_id
1156: WHERE batch_id = l_batch_id;
1157:
1158: --update batch end date
1159: UPDATE gme_batch_header

Line 1161: ,last_updated_by = gme_common_pvt.g_user_ident

1157:
1158: --update batch end date
1159: UPDATE gme_batch_header
1160: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1161: ,last_updated_by = gme_common_pvt.g_user_ident
1162: ,last_update_date = gme_common_pvt.g_timestamp
1163: ,last_update_login = gme_common_pvt.g_login_id
1164: WHERE batch_id = l_batch_id
1165: AND plan_cmplt_date < p_batch_header_rec.plan_start_date;

Line 1162: ,last_update_date = gme_common_pvt.g_timestamp

1158: --update batch end date
1159: UPDATE gme_batch_header
1160: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1161: ,last_updated_by = gme_common_pvt.g_user_ident
1162: ,last_update_date = gme_common_pvt.g_timestamp
1163: ,last_update_login = gme_common_pvt.g_login_id
1164: WHERE batch_id = l_batch_id
1165: AND plan_cmplt_date < p_batch_header_rec.plan_start_date;
1166:

Line 1163: ,last_update_login = gme_common_pvt.g_login_id

1159: UPDATE gme_batch_header
1160: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1161: ,last_updated_by = gme_common_pvt.g_user_ident
1162: ,last_update_date = gme_common_pvt.g_timestamp
1163: ,last_update_login = gme_common_pvt.g_login_id
1164: WHERE batch_id = l_batch_id
1165: AND plan_cmplt_date < p_batch_header_rec.plan_start_date;
1166:
1167: --update batch due date

Line 1170: ,last_updated_by = gme_common_pvt.g_user_ident

1166:
1167: --update batch due date
1168: UPDATE gme_batch_header
1169: SET due_date = p_batch_header_rec.plan_start_date
1170: ,last_updated_by = gme_common_pvt.g_user_ident
1171: ,last_update_date = gme_common_pvt.g_timestamp
1172: ,last_update_login = gme_common_pvt.g_login_id
1173: WHERE batch_id = l_batch_id
1174: AND due_date < p_batch_header_rec.plan_start_date;

Line 1171: ,last_update_date = gme_common_pvt.g_timestamp

1167: --update batch due date
1168: UPDATE gme_batch_header
1169: SET due_date = p_batch_header_rec.plan_start_date
1170: ,last_updated_by = gme_common_pvt.g_user_ident
1171: ,last_update_date = gme_common_pvt.g_timestamp
1172: ,last_update_login = gme_common_pvt.g_login_id
1173: WHERE batch_id = l_batch_id
1174: AND due_date < p_batch_header_rec.plan_start_date;
1175: END IF;

Line 1172: ,last_update_login = gme_common_pvt.g_login_id

1168: UPDATE gme_batch_header
1169: SET due_date = p_batch_header_rec.plan_start_date
1170: ,last_updated_by = gme_common_pvt.g_user_ident
1171: ,last_update_date = gme_common_pvt.g_timestamp
1172: ,last_update_login = gme_common_pvt.g_login_id
1173: WHERE batch_id = l_batch_id
1174: AND due_date < p_batch_header_rec.plan_start_date;
1175: END IF;
1176:

Line 1180: ,last_updated_by = gme_common_pvt.g_user_ident

1176:
1177: -- update batch steps start date
1178: UPDATE gme_batch_steps
1179: SET plan_start_date = p_batch_header_rec.plan_start_date
1180: ,last_updated_by = gme_common_pvt.g_user_ident
1181: ,last_update_date = gme_common_pvt.g_timestamp
1182: ,last_update_login = gme_common_pvt.g_login_id
1183: WHERE batch_id = l_batch_id
1184: AND plan_start_date < p_batch_header_rec.plan_start_date

Line 1181: ,last_update_date = gme_common_pvt.g_timestamp

1177: -- update batch steps start date
1178: UPDATE gme_batch_steps
1179: SET plan_start_date = p_batch_header_rec.plan_start_date
1180: ,last_updated_by = gme_common_pvt.g_user_ident
1181: ,last_update_date = gme_common_pvt.g_timestamp
1182: ,last_update_login = gme_common_pvt.g_login_id
1183: WHERE batch_id = l_batch_id
1184: AND plan_start_date < p_batch_header_rec.plan_start_date
1185: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1182: ,last_update_login = gme_common_pvt.g_login_id

1178: UPDATE gme_batch_steps
1179: SET plan_start_date = p_batch_header_rec.plan_start_date
1180: ,last_updated_by = gme_common_pvt.g_user_ident
1181: ,last_update_date = gme_common_pvt.g_timestamp
1182: ,last_update_login = gme_common_pvt.g_login_id
1183: WHERE batch_id = l_batch_id
1184: AND plan_start_date < p_batch_header_rec.plan_start_date
1185: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1186:

Line 1190: ,last_updated_by = gme_common_pvt.g_user_ident

1186:
1187: -- update batch steps end date
1188: UPDATE gme_batch_steps
1189: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1190: ,last_updated_by = gme_common_pvt.g_user_ident
1191: ,last_update_date = gme_common_pvt.g_timestamp
1192: ,last_update_login = gme_common_pvt.g_login_id
1193: WHERE batch_id = l_batch_id
1194: AND plan_cmplt_date < p_batch_header_rec.plan_start_date

Line 1191: ,last_update_date = gme_common_pvt.g_timestamp

1187: -- update batch steps end date
1188: UPDATE gme_batch_steps
1189: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1190: ,last_updated_by = gme_common_pvt.g_user_ident
1191: ,last_update_date = gme_common_pvt.g_timestamp
1192: ,last_update_login = gme_common_pvt.g_login_id
1193: WHERE batch_id = l_batch_id
1194: AND plan_cmplt_date < p_batch_header_rec.plan_start_date
1195: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1192: ,last_update_login = gme_common_pvt.g_login_id

1188: UPDATE gme_batch_steps
1189: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1190: ,last_updated_by = gme_common_pvt.g_user_ident
1191: ,last_update_date = gme_common_pvt.g_timestamp
1192: ,last_update_login = gme_common_pvt.g_login_id
1193: WHERE batch_id = l_batch_id
1194: AND plan_cmplt_date < p_batch_header_rec.plan_start_date
1195: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1196:

Line 1200: ,last_updated_by = gme_common_pvt.g_user_ident

1196:
1197: -- update batch steps due date
1198: UPDATE gme_batch_steps
1199: SET due_date = p_batch_header_rec.plan_start_date
1200: ,last_updated_by = gme_common_pvt.g_user_ident
1201: ,last_update_date = gme_common_pvt.g_timestamp
1202: ,last_update_login = gme_common_pvt.g_login_id
1203: WHERE batch_id = l_batch_id
1204: AND due_date < p_batch_header_rec.plan_start_date

Line 1201: ,last_update_date = gme_common_pvt.g_timestamp

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

Line 1202: ,last_update_login = gme_common_pvt.g_login_id

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

Line 1210: ,last_updated_by = gme_common_pvt.g_user_ident

1206:
1207: -- update batch activity start date
1208: UPDATE gme_batch_step_activities
1209: SET plan_start_date = p_batch_header_rec.plan_start_date
1210: ,last_updated_by = gme_common_pvt.g_user_ident
1211: ,last_update_date = gme_common_pvt.g_timestamp
1212: ,last_update_login = gme_common_pvt.g_login_id
1213: WHERE batch_id = l_batch_id
1214: AND plan_start_date < p_batch_header_rec.plan_start_date

Line 1211: ,last_update_date = gme_common_pvt.g_timestamp

1207: -- update batch activity start date
1208: UPDATE gme_batch_step_activities
1209: SET plan_start_date = p_batch_header_rec.plan_start_date
1210: ,last_updated_by = gme_common_pvt.g_user_ident
1211: ,last_update_date = gme_common_pvt.g_timestamp
1212: ,last_update_login = gme_common_pvt.g_login_id
1213: WHERE batch_id = l_batch_id
1214: AND plan_start_date < p_batch_header_rec.plan_start_date
1215: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1212: ,last_update_login = gme_common_pvt.g_login_id

1208: UPDATE gme_batch_step_activities
1209: SET plan_start_date = p_batch_header_rec.plan_start_date
1210: ,last_updated_by = gme_common_pvt.g_user_ident
1211: ,last_update_date = gme_common_pvt.g_timestamp
1212: ,last_update_login = gme_common_pvt.g_login_id
1213: WHERE batch_id = l_batch_id
1214: AND plan_start_date < p_batch_header_rec.plan_start_date
1215: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1216:

Line 1220: ,last_updated_by = gme_common_pvt.g_user_ident

1216:
1217: -- update batch activity end date
1218: UPDATE gme_batch_step_activities
1219: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1220: ,last_updated_by = gme_common_pvt.g_user_ident
1221: ,last_update_date = gme_common_pvt.g_timestamp
1222: ,last_update_login = gme_common_pvt.g_login_id
1223: WHERE batch_id = l_batch_id
1224: AND plan_cmplt_date < p_batch_header_rec.plan_start_date

Line 1221: ,last_update_date = gme_common_pvt.g_timestamp

1217: -- update batch activity end date
1218: UPDATE gme_batch_step_activities
1219: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1220: ,last_updated_by = gme_common_pvt.g_user_ident
1221: ,last_update_date = gme_common_pvt.g_timestamp
1222: ,last_update_login = gme_common_pvt.g_login_id
1223: WHERE batch_id = l_batch_id
1224: AND plan_cmplt_date < p_batch_header_rec.plan_start_date
1225: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1222: ,last_update_login = gme_common_pvt.g_login_id

1218: UPDATE gme_batch_step_activities
1219: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1220: ,last_updated_by = gme_common_pvt.g_user_ident
1221: ,last_update_date = gme_common_pvt.g_timestamp
1222: ,last_update_login = gme_common_pvt.g_login_id
1223: WHERE batch_id = l_batch_id
1224: AND plan_cmplt_date < p_batch_header_rec.plan_start_date
1225: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1226:

Line 1230: ,last_updated_by = gme_common_pvt.g_user_ident

1226:
1227: -- update batch resources start date
1228: UPDATE gme_batch_step_resources
1229: SET plan_start_date = p_batch_header_rec.plan_start_date
1230: ,last_updated_by = gme_common_pvt.g_user_ident
1231: ,last_update_date = gme_common_pvt.g_timestamp
1232: ,last_update_login = gme_common_pvt.g_login_id
1233: WHERE batch_id = l_batch_id
1234: AND plan_start_date < p_batch_header_rec.plan_start_date

Line 1231: ,last_update_date = gme_common_pvt.g_timestamp

1227: -- update batch resources start date
1228: UPDATE gme_batch_step_resources
1229: SET plan_start_date = p_batch_header_rec.plan_start_date
1230: ,last_updated_by = gme_common_pvt.g_user_ident
1231: ,last_update_date = gme_common_pvt.g_timestamp
1232: ,last_update_login = gme_common_pvt.g_login_id
1233: WHERE batch_id = l_batch_id
1234: AND plan_start_date < p_batch_header_rec.plan_start_date
1235: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1232: ,last_update_login = gme_common_pvt.g_login_id

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

Line 1240: ,last_updated_by = gme_common_pvt.g_user_ident

1236:
1237: -- update batch resources end date
1238: UPDATE gme_batch_step_resources
1239: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1240: ,last_updated_by = gme_common_pvt.g_user_ident
1241: ,last_update_date = gme_common_pvt.g_timestamp
1242: ,last_update_login = gme_common_pvt.g_login_id
1243: WHERE batch_id = l_batch_id
1244: AND plan_cmplt_date < p_batch_header_rec.plan_start_date

Line 1241: ,last_update_date = gme_common_pvt.g_timestamp

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

Line 1242: ,last_update_login = gme_common_pvt.g_login_id

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

Line 1250: ,last_updated_by = gme_common_pvt.g_user_ident

1246:
1247: -- update batch resources txns start date
1248: UPDATE gme_resource_txns
1249: SET start_date = p_batch_header_rec.plan_start_date
1250: ,last_updated_by = gme_common_pvt.g_user_ident
1251: ,last_update_date = gme_common_pvt.g_timestamp
1252: ,last_update_login = gme_common_pvt.g_login_id
1253: WHERE doc_id = l_batch_id
1254: AND doc_type = l_doc_type

Line 1251: ,last_update_date = gme_common_pvt.g_timestamp

1247: -- update batch resources txns start date
1248: UPDATE gme_resource_txns
1249: SET start_date = p_batch_header_rec.plan_start_date
1250: ,last_updated_by = gme_common_pvt.g_user_ident
1251: ,last_update_date = gme_common_pvt.g_timestamp
1252: ,last_update_login = gme_common_pvt.g_login_id
1253: WHERE doc_id = l_batch_id
1254: AND doc_type = l_doc_type
1255: AND start_date < p_batch_header_rec.plan_start_date;

Line 1252: ,last_update_login = gme_common_pvt.g_login_id

1248: UPDATE gme_resource_txns
1249: SET start_date = p_batch_header_rec.plan_start_date
1250: ,last_updated_by = gme_common_pvt.g_user_ident
1251: ,last_update_date = gme_common_pvt.g_timestamp
1252: ,last_update_login = gme_common_pvt.g_login_id
1253: WHERE doc_id = l_batch_id
1254: AND doc_type = l_doc_type
1255: AND start_date < p_batch_header_rec.plan_start_date;
1256:

Line 1260: ,last_updated_by = gme_common_pvt.g_user_ident

1256:
1257: -- update batch resources txns end date
1258: UPDATE gme_resource_txns
1259: SET end_date = p_batch_header_rec.plan_start_date
1260: ,last_updated_by = gme_common_pvt.g_user_ident
1261: ,last_update_date = gme_common_pvt.g_timestamp
1262: ,last_update_login = gme_common_pvt.g_login_id
1263: WHERE doc_id = l_batch_id
1264: AND doc_type = l_doc_type

Line 1261: ,last_update_date = gme_common_pvt.g_timestamp

1257: -- update batch resources txns end date
1258: UPDATE gme_resource_txns
1259: SET end_date = p_batch_header_rec.plan_start_date
1260: ,last_updated_by = gme_common_pvt.g_user_ident
1261: ,last_update_date = gme_common_pvt.g_timestamp
1262: ,last_update_login = gme_common_pvt.g_login_id
1263: WHERE doc_id = l_batch_id
1264: AND doc_type = l_doc_type
1265: AND end_date < p_batch_header_rec.plan_start_date;

Line 1262: ,last_update_login = gme_common_pvt.g_login_id

1258: UPDATE gme_resource_txns
1259: SET end_date = p_batch_header_rec.plan_start_date
1260: ,last_updated_by = gme_common_pvt.g_user_ident
1261: ,last_update_date = gme_common_pvt.g_timestamp
1262: ,last_update_login = gme_common_pvt.g_login_id
1263: WHERE doc_id = l_batch_id
1264: AND doc_type = l_doc_type
1265: AND end_date < p_batch_header_rec.plan_start_date;
1266:

Line 1270: ,last_updated_by = gme_common_pvt.g_user_ident

1266:
1267: -- update batch resources txns trans date
1268: UPDATE gme_resource_txns
1269: SET trans_date = p_batch_header_rec.plan_start_date
1270: ,last_updated_by = gme_common_pvt.g_user_ident
1271: ,last_update_date = gme_common_pvt.g_timestamp
1272: ,last_update_login = gme_common_pvt.g_login_id
1273: WHERE doc_id = l_batch_id
1274: AND doc_type = l_doc_type

Line 1271: ,last_update_date = gme_common_pvt.g_timestamp

1267: -- update batch resources txns trans date
1268: UPDATE gme_resource_txns
1269: SET trans_date = p_batch_header_rec.plan_start_date
1270: ,last_updated_by = gme_common_pvt.g_user_ident
1271: ,last_update_date = gme_common_pvt.g_timestamp
1272: ,last_update_login = gme_common_pvt.g_login_id
1273: WHERE doc_id = l_batch_id
1274: AND doc_type = l_doc_type
1275: AND trans_date < p_batch_header_rec.plan_start_date;

Line 1272: ,last_update_login = gme_common_pvt.g_login_id

1268: UPDATE gme_resource_txns
1269: SET trans_date = p_batch_header_rec.plan_start_date
1270: ,last_updated_by = gme_common_pvt.g_user_ident
1271: ,last_update_date = gme_common_pvt.g_timestamp
1272: ,last_update_login = gme_common_pvt.g_login_id
1273: WHERE doc_id = l_batch_id
1274: AND doc_type = l_doc_type
1275: AND trans_date < p_batch_header_rec.plan_start_date;
1276: ELSE

Line 1281: ,last_updated_by = gme_common_pvt.g_user_ident

1277: --update batch start date
1278: IF (p_batchstep_id IS NULL) THEN
1279: UPDATE gme_batch_header
1280: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1281: ,last_updated_by = gme_common_pvt.g_user_ident
1282: ,last_update_date = gme_common_pvt.g_timestamp
1283: ,last_update_login = gme_common_pvt.g_login_id
1284: WHERE batch_id = l_batch_id;
1285:

Line 1282: ,last_update_date = gme_common_pvt.g_timestamp

1278: IF (p_batchstep_id IS NULL) THEN
1279: UPDATE gme_batch_header
1280: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1281: ,last_updated_by = gme_common_pvt.g_user_ident
1282: ,last_update_date = gme_common_pvt.g_timestamp
1283: ,last_update_login = gme_common_pvt.g_login_id
1284: WHERE batch_id = l_batch_id;
1285:
1286: --update batch end date

Line 1283: ,last_update_login = gme_common_pvt.g_login_id

1279: UPDATE gme_batch_header
1280: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1281: ,last_updated_by = gme_common_pvt.g_user_ident
1282: ,last_update_date = gme_common_pvt.g_timestamp
1283: ,last_update_login = gme_common_pvt.g_login_id
1284: WHERE batch_id = l_batch_id;
1285:
1286: --update batch end date
1287: UPDATE gme_batch_header

Line 1289: ,last_updated_by = gme_common_pvt.g_user_ident

1285:
1286: --update batch end date
1287: UPDATE gme_batch_header
1288: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1289: ,last_updated_by = gme_common_pvt.g_user_ident
1290: ,last_update_date = gme_common_pvt.g_timestamp
1291: ,last_update_login = gme_common_pvt.g_login_id
1292: WHERE batch_id = l_batch_id
1293: AND plan_start_date > p_batch_header_rec.plan_cmplt_date;

Line 1290: ,last_update_date = gme_common_pvt.g_timestamp

1286: --update batch end date
1287: UPDATE gme_batch_header
1288: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1289: ,last_updated_by = gme_common_pvt.g_user_ident
1290: ,last_update_date = gme_common_pvt.g_timestamp
1291: ,last_update_login = gme_common_pvt.g_login_id
1292: WHERE batch_id = l_batch_id
1293: AND plan_start_date > p_batch_header_rec.plan_cmplt_date;
1294:

Line 1291: ,last_update_login = gme_common_pvt.g_login_id

1287: UPDATE gme_batch_header
1288: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1289: ,last_updated_by = gme_common_pvt.g_user_ident
1290: ,last_update_date = gme_common_pvt.g_timestamp
1291: ,last_update_login = gme_common_pvt.g_login_id
1292: WHERE batch_id = l_batch_id
1293: AND plan_start_date > p_batch_header_rec.plan_cmplt_date;
1294:
1295: --update batch due date

Line 1301: ,last_updated_by = gme_common_pvt.g_user_ident

1297: -- The due date which was getting updated with the planned
1298: -- completion date is changed to be updated with the same due date.
1299: UPDATE gme_batch_header
1300: SET due_date = p_batch_header_rec.due_date
1301: ,last_updated_by = gme_common_pvt.g_user_ident
1302: ,last_update_date = gme_common_pvt.g_timestamp
1303: ,last_update_login = gme_common_pvt.g_login_id
1304: WHERE batch_id = l_batch_id
1305: AND due_date > p_batch_header_rec.plan_cmplt_date;

Line 1302: ,last_update_date = gme_common_pvt.g_timestamp

1298: -- completion date is changed to be updated with the same due date.
1299: UPDATE gme_batch_header
1300: SET due_date = p_batch_header_rec.due_date
1301: ,last_updated_by = gme_common_pvt.g_user_ident
1302: ,last_update_date = gme_common_pvt.g_timestamp
1303: ,last_update_login = gme_common_pvt.g_login_id
1304: WHERE batch_id = l_batch_id
1305: AND due_date > p_batch_header_rec.plan_cmplt_date;
1306: END IF;

Line 1303: ,last_update_login = gme_common_pvt.g_login_id

1299: UPDATE gme_batch_header
1300: SET due_date = p_batch_header_rec.due_date
1301: ,last_updated_by = gme_common_pvt.g_user_ident
1302: ,last_update_date = gme_common_pvt.g_timestamp
1303: ,last_update_login = gme_common_pvt.g_login_id
1304: WHERE batch_id = l_batch_id
1305: AND due_date > p_batch_header_rec.plan_cmplt_date;
1306: END IF;
1307:

Line 1311: ,last_updated_by = gme_common_pvt.g_user_ident

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

Line 1312: ,last_update_date = gme_common_pvt.g_timestamp

1308: -- update batch steps start date
1309: UPDATE gme_batch_steps
1310: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1311: ,last_updated_by = gme_common_pvt.g_user_ident
1312: ,last_update_date = gme_common_pvt.g_timestamp
1313: ,last_update_login = gme_common_pvt.g_login_id
1314: WHERE batch_id = l_batch_id
1315: AND plan_start_date > p_batch_header_rec.plan_cmplt_date
1316: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1313: ,last_update_login = gme_common_pvt.g_login_id

1309: UPDATE gme_batch_steps
1310: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1311: ,last_updated_by = gme_common_pvt.g_user_ident
1312: ,last_update_date = gme_common_pvt.g_timestamp
1313: ,last_update_login = gme_common_pvt.g_login_id
1314: WHERE batch_id = l_batch_id
1315: AND plan_start_date > p_batch_header_rec.plan_cmplt_date
1316: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1317:

Line 1321: ,last_updated_by = gme_common_pvt.g_user_ident

1317:
1318: -- update batch steps end date
1319: UPDATE gme_batch_steps
1320: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1321: ,last_updated_by = gme_common_pvt.g_user_ident
1322: ,last_update_date = gme_common_pvt.g_timestamp
1323: ,last_update_login = gme_common_pvt.g_login_id
1324: WHERE batch_id = l_batch_id
1325: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date

Line 1322: ,last_update_date = gme_common_pvt.g_timestamp

1318: -- update batch steps end date
1319: UPDATE gme_batch_steps
1320: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1321: ,last_updated_by = gme_common_pvt.g_user_ident
1322: ,last_update_date = gme_common_pvt.g_timestamp
1323: ,last_update_login = gme_common_pvt.g_login_id
1324: WHERE batch_id = l_batch_id
1325: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date
1326: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1323: ,last_update_login = gme_common_pvt.g_login_id

1319: UPDATE gme_batch_steps
1320: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1321: ,last_updated_by = gme_common_pvt.g_user_ident
1322: ,last_update_date = gme_common_pvt.g_timestamp
1323: ,last_update_login = gme_common_pvt.g_login_id
1324: WHERE batch_id = l_batch_id
1325: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date
1326: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1327:

Line 1331: ,last_updated_by = gme_common_pvt.g_user_ident

1327:
1328: -- update batch steps due date
1329: UPDATE gme_batch_steps
1330: SET due_date = p_batch_header_rec.plan_cmplt_date
1331: ,last_updated_by = gme_common_pvt.g_user_ident
1332: ,last_update_date = gme_common_pvt.g_timestamp
1333: ,last_update_login = gme_common_pvt.g_login_id
1334: WHERE batch_id = l_batch_id
1335: AND due_date > p_batch_header_rec.plan_cmplt_date

Line 1332: ,last_update_date = gme_common_pvt.g_timestamp

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

Line 1333: ,last_update_login = gme_common_pvt.g_login_id

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

Line 1341: ,last_updated_by = gme_common_pvt.g_user_ident

1337:
1338: -- update batch activity start date
1339: UPDATE gme_batch_step_activities
1340: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1341: ,last_updated_by = gme_common_pvt.g_user_ident
1342: ,last_update_date = gme_common_pvt.g_timestamp
1343: ,last_update_login = gme_common_pvt.g_login_id
1344: WHERE batch_id = l_batch_id
1345: AND plan_start_date > p_batch_header_rec.plan_cmplt_date

Line 1342: ,last_update_date = gme_common_pvt.g_timestamp

1338: -- update batch activity start date
1339: UPDATE gme_batch_step_activities
1340: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1341: ,last_updated_by = gme_common_pvt.g_user_ident
1342: ,last_update_date = gme_common_pvt.g_timestamp
1343: ,last_update_login = gme_common_pvt.g_login_id
1344: WHERE batch_id = l_batch_id
1345: AND plan_start_date > p_batch_header_rec.plan_cmplt_date
1346: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1343: ,last_update_login = gme_common_pvt.g_login_id

1339: UPDATE gme_batch_step_activities
1340: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1341: ,last_updated_by = gme_common_pvt.g_user_ident
1342: ,last_update_date = gme_common_pvt.g_timestamp
1343: ,last_update_login = gme_common_pvt.g_login_id
1344: WHERE batch_id = l_batch_id
1345: AND plan_start_date > p_batch_header_rec.plan_cmplt_date
1346: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1347:

Line 1351: ,last_updated_by = gme_common_pvt.g_user_ident

1347:
1348: -- update batch activity end date
1349: UPDATE gme_batch_step_activities
1350: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1351: ,last_updated_by = gme_common_pvt.g_user_ident
1352: ,last_update_date = gme_common_pvt.g_timestamp
1353: ,last_update_login = gme_common_pvt.g_login_id
1354: WHERE batch_id = l_batch_id
1355: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date

Line 1352: ,last_update_date = gme_common_pvt.g_timestamp

1348: -- update batch activity end date
1349: UPDATE gme_batch_step_activities
1350: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1351: ,last_updated_by = gme_common_pvt.g_user_ident
1352: ,last_update_date = gme_common_pvt.g_timestamp
1353: ,last_update_login = gme_common_pvt.g_login_id
1354: WHERE batch_id = l_batch_id
1355: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date
1356: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1353: ,last_update_login = gme_common_pvt.g_login_id

1349: UPDATE gme_batch_step_activities
1350: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1351: ,last_updated_by = gme_common_pvt.g_user_ident
1352: ,last_update_date = gme_common_pvt.g_timestamp
1353: ,last_update_login = gme_common_pvt.g_login_id
1354: WHERE batch_id = l_batch_id
1355: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date
1356: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1357:

Line 1361: ,last_updated_by = gme_common_pvt.g_user_ident

1357:
1358: -- update batch resources start date
1359: UPDATE gme_batch_step_resources
1360: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1361: ,last_updated_by = gme_common_pvt.g_user_ident
1362: ,last_update_date = gme_common_pvt.g_timestamp
1363: ,last_update_login = gme_common_pvt.g_login_id
1364: WHERE batch_id = l_batch_id
1365: AND plan_start_date > p_batch_header_rec.plan_cmplt_date

Line 1362: ,last_update_date = gme_common_pvt.g_timestamp

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

Line 1363: ,last_update_login = gme_common_pvt.g_login_id

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

Line 1371: ,last_updated_by = gme_common_pvt.g_user_ident

1367:
1368: -- update batch resources end date
1369: UPDATE gme_batch_step_resources
1370: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1371: ,last_updated_by = gme_common_pvt.g_user_ident
1372: ,last_update_date = gme_common_pvt.g_timestamp
1373: ,last_update_login = gme_common_pvt.g_login_id
1374: WHERE batch_id = l_batch_id
1375: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date

Line 1372: ,last_update_date = gme_common_pvt.g_timestamp

1368: -- update batch resources end date
1369: UPDATE gme_batch_step_resources
1370: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1371: ,last_updated_by = gme_common_pvt.g_user_ident
1372: ,last_update_date = gme_common_pvt.g_timestamp
1373: ,last_update_login = gme_common_pvt.g_login_id
1374: WHERE batch_id = l_batch_id
1375: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date
1376: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);

Line 1373: ,last_update_login = gme_common_pvt.g_login_id

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

Line 1381: ,last_updated_by = gme_common_pvt.g_user_ident

1377:
1378: -- update batch resources txns start date
1379: UPDATE gme_resource_txns
1380: SET start_date = p_batch_header_rec.plan_cmplt_date
1381: ,last_updated_by = gme_common_pvt.g_user_ident
1382: ,last_update_date = gme_common_pvt.g_timestamp
1383: ,last_update_login = gme_common_pvt.g_login_id
1384: WHERE doc_id = l_batch_id
1385: AND doc_type = l_doc_type

Line 1382: ,last_update_date = gme_common_pvt.g_timestamp

1378: -- update batch resources txns start date
1379: UPDATE gme_resource_txns
1380: SET start_date = p_batch_header_rec.plan_cmplt_date
1381: ,last_updated_by = gme_common_pvt.g_user_ident
1382: ,last_update_date = gme_common_pvt.g_timestamp
1383: ,last_update_login = gme_common_pvt.g_login_id
1384: WHERE doc_id = l_batch_id
1385: AND doc_type = l_doc_type
1386: AND start_date > p_batch_header_rec.plan_cmplt_date;

Line 1383: ,last_update_login = gme_common_pvt.g_login_id

1379: UPDATE gme_resource_txns
1380: SET start_date = p_batch_header_rec.plan_cmplt_date
1381: ,last_updated_by = gme_common_pvt.g_user_ident
1382: ,last_update_date = gme_common_pvt.g_timestamp
1383: ,last_update_login = gme_common_pvt.g_login_id
1384: WHERE doc_id = l_batch_id
1385: AND doc_type = l_doc_type
1386: AND start_date > p_batch_header_rec.plan_cmplt_date;
1387:

Line 1391: ,last_updated_by = gme_common_pvt.g_user_ident

1387:
1388: -- update batch resources txns end date
1389: UPDATE gme_resource_txns
1390: SET end_date = p_batch_header_rec.plan_cmplt_date
1391: ,last_updated_by = gme_common_pvt.g_user_ident
1392: ,last_update_date = gme_common_pvt.g_timestamp
1393: ,last_update_login = gme_common_pvt.g_login_id
1394: WHERE doc_id = l_batch_id
1395: AND doc_type = l_doc_type

Line 1392: ,last_update_date = gme_common_pvt.g_timestamp

1388: -- update batch resources txns end date
1389: UPDATE gme_resource_txns
1390: SET end_date = p_batch_header_rec.plan_cmplt_date
1391: ,last_updated_by = gme_common_pvt.g_user_ident
1392: ,last_update_date = gme_common_pvt.g_timestamp
1393: ,last_update_login = gme_common_pvt.g_login_id
1394: WHERE doc_id = l_batch_id
1395: AND doc_type = l_doc_type
1396: AND end_date > p_batch_header_rec.plan_cmplt_date;

Line 1393: ,last_update_login = gme_common_pvt.g_login_id

1389: UPDATE gme_resource_txns
1390: SET end_date = p_batch_header_rec.plan_cmplt_date
1391: ,last_updated_by = gme_common_pvt.g_user_ident
1392: ,last_update_date = gme_common_pvt.g_timestamp
1393: ,last_update_login = gme_common_pvt.g_login_id
1394: WHERE doc_id = l_batch_id
1395: AND doc_type = l_doc_type
1396: AND end_date > p_batch_header_rec.plan_cmplt_date;
1397:

Line 1401: ,last_updated_by = gme_common_pvt.g_user_ident

1397:
1398: -- update batch resources txns trans date
1399: UPDATE gme_resource_txns
1400: SET trans_date = p_batch_header_rec.plan_cmplt_date
1401: ,last_updated_by = gme_common_pvt.g_user_ident
1402: ,last_update_date = gme_common_pvt.g_timestamp
1403: ,last_update_login = gme_common_pvt.g_login_id
1404: WHERE doc_id = l_batch_id
1405: AND doc_type = l_doc_type

Line 1402: ,last_update_date = gme_common_pvt.g_timestamp

1398: -- update batch resources txns trans date
1399: UPDATE gme_resource_txns
1400: SET trans_date = p_batch_header_rec.plan_cmplt_date
1401: ,last_updated_by = gme_common_pvt.g_user_ident
1402: ,last_update_date = gme_common_pvt.g_timestamp
1403: ,last_update_login = gme_common_pvt.g_login_id
1404: WHERE doc_id = l_batch_id
1405: AND doc_type = l_doc_type
1406: AND trans_date > p_batch_header_rec.plan_cmplt_date;

Line 1403: ,last_update_login = gme_common_pvt.g_login_id

1399: UPDATE gme_resource_txns
1400: SET trans_date = p_batch_header_rec.plan_cmplt_date
1401: ,last_updated_by = gme_common_pvt.g_user_ident
1402: ,last_update_date = gme_common_pvt.g_timestamp
1403: ,last_update_login = gme_common_pvt.g_login_id
1404: WHERE doc_id = l_batch_id
1405: AND doc_type = l_doc_type
1406: AND trans_date > p_batch_header_rec.plan_cmplt_date;
1407: END IF;