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_BATCH_HEADER

Line 27: p_batch_header_rec IN gme_batch_header%ROWTYPE

23: E - Error
24: U - Unexpected error
25: ***********************************************************************************/
26: PROCEDURE reschedule_batch (
27: p_batch_header_rec IN gme_batch_header%ROWTYPE
28: ,p_use_workday_cal IN VARCHAR2
29: ,p_contiguity_override IN VARCHAR2
30: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
31: ,x_return_status OUT NOCOPY VARCHAR2)

Line 30: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

26: PROCEDURE reschedule_batch (
27: p_batch_header_rec IN gme_batch_header%ROWTYPE
28: ,p_use_workday_cal IN VARCHAR2
29: ,p_contiguity_override IN VARCHAR2
30: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
31: ,x_return_status OUT NOCOPY VARCHAR2)
32: IS
33: l_api_name CONSTANT VARCHAR2 (30) := 'RESCHEDULE_BATCH';
34:

Line 44: l_batch_header_rec gme_batch_header%ROWTYPE;

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 */
47: l_return_status VARCHAR2 (1);
48: l_rsrc_trans_count NUMBER := 0;

Line 45: l_in_batch_header_rec gme_batch_header%ROWTYPE;

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 */
47: l_return_status VARCHAR2 (1);
48: l_rsrc_trans_count NUMBER := 0;
49: max_cmplt_date DATE;

Line 124: p_recipe_validity_rule_id gme_batch_header.recipe_validity_rule_id%TYPE)

120: WHERE batch_id = v_batch_id
121: AND (plan_cmplt_date + l_diff) > v_plan_cmplt_date;
122:
123: CURSOR recipe_validity_rule_cursor (
124: p_recipe_validity_rule_id gme_batch_header.recipe_validity_rule_id%TYPE)
125: IS
126: SELECT *
127: FROM gmd_recipe_validity_rules
128: WHERE recipe_validity_rule_id = NVL (p_recipe_validity_rule_id, -1);

Line 137: v_batch_id gme_batch_header.batch_id%TYPE

133: FROM wip_entities
134: WHERE wip_entity_id = v_batch_id;
135:
136: CURSOR get_prim_prod (
137: v_batch_id gme_batch_header.batch_id%TYPE
138: ,v_item_id gme_material_details.inventory_item_id%TYPE)
139: IS
140: SELECT plan_qty, dtl_um
141: FROM gme_material_details

Line 219: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec

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
220: ,x_batch_header_rec) ) THEN
221: RAISE batch_header_fetch_error;
222: END IF;
223:

Line 348: (p_gme_batch_header_rec => l_batch_header_rec

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
349: ,p_use_workday_cal => p_use_workday_cal
350: ,p_contiguity_override => p_contiguity_override
351: ,p_return_status => l_return_status);
352:

Line 359: (p_gme_batch_header_rec => l_batch_header_rec

355: END IF;
356: ELSIF (p_batch_header_rec.plan_cmplt_date IS NOT NULL)
357: AND (p_batch_header_rec.plan_start_date IS NULL) THEN
358: gme_create_step_pvt.calc_dates
359: (p_gme_batch_header_rec => l_batch_header_rec
360: ,p_use_workday_cal => p_use_workday_cal
361: ,p_contiguity_override => p_contiguity_override
362: ,p_return_status => l_return_status);
363:

Line 372: (p_gme_batch_header_rec => l_batch_header_rec

368:
369: IF ( (p_batch_header_rec.plan_start_date IS NOT NULL)
370: AND (p_batch_header_rec.plan_cmplt_date IS NOT NULL) ) THEN
371: gme_create_step_pvt.calc_dates
372: (p_gme_batch_header_rec => l_batch_header_rec
373: ,p_use_workday_cal => p_use_workday_cal
374: ,p_contiguity_override => p_contiguity_override
375: ,p_return_status => l_return_status);
376:

Line 390: -- (p_gme_batch_header_rec => p_batch_header_rec

386: -- Bug 9244927 - We want dates to work off of new plan cmplt date.
387: l_batch_header_rec.plan_start_date := NULL;
388:
389: gme_create_step_pvt.calc_dates
390: -- (p_gme_batch_header_rec => p_batch_header_rec
391: (p_gme_batch_header_rec => l_batch_header_rec
392: ,p_use_workday_cal => p_use_workday_cal
393: ,p_contiguity_override => p_contiguity_override
394: ,p_return_status => l_return_status);

Line 391: (p_gme_batch_header_rec => l_batch_header_rec

387: l_batch_header_rec.plan_start_date := NULL;
388:
389: gme_create_step_pvt.calc_dates
390: -- (p_gme_batch_header_rec => p_batch_header_rec
391: (p_gme_batch_header_rec => l_batch_header_rec
392: ,p_use_workday_cal => p_use_workday_cal
393: ,p_contiguity_override => p_contiguity_override
394: ,p_return_status => l_return_status);
395:

Line 402: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec

398: END IF;
399: END IF; /*plan_cmpt_date is not null*/
400: END IF; /* batch_status = 2*/
401:
402: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec
403: ,x_batch_header_rec) ) THEN
404: RAISE batch_header_fetch_error;
405: END IF;
406: ELSE /* no routing */

Line 677: gme_debug.put_line ('Update gme_batch_header.');

673: END IF; /* l_no_prod_found*/
674:
675: IF (NVL (g_debug, 0) IN
676: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
677: gme_debug.put_line ('Update gme_batch_header.');
678: END IF;
679:
680: UPDATE gme_batch_header
681: SET plan_start_date = x_batch_header_rec.plan_start_date

Line 680: UPDATE gme_batch_header

676: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
677: gme_debug.put_line ('Update gme_batch_header.');
678: END IF;
679:
680: UPDATE gme_batch_header
681: SET plan_start_date = x_batch_header_rec.plan_start_date
682: ,plan_cmplt_date = x_batch_header_rec.plan_cmplt_date
683: ,due_date =
684: NVL (x_batch_header_rec.due_date

Line 694: ( ' After update gme_batch_header. Final plan_start_date '

690: END IF;
691:
692: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
693: gme_debug.put_line
694: ( ' After update gme_batch_header. Final plan_start_date '
695: || TO_CHAR (x_batch_header_rec.plan_start_date
696: ,'yyyy/mon/dd hh24:mi:ss')
697: || ' Final plan_cmplt_date '
698: || TO_CHAR (x_batch_header_rec.plan_cmplt_date

Line 782: UPDATE gme_batch_header

778: gme_debug.put_line
779: ('User supplied plan completion date is greater than what system calculated User wants to leave gaps.');
780: END IF;
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

Line 792: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec

788: WHERE batch_id = x_batch_header_rec.batch_id;
789: END IF; /* max_cmplt_date */
790: END IF; /* dates not null */
791:
792: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec
793: ,x_batch_header_rec) ) THEN
794: RAISE batch_header_fetch_error;
795: END IF;
796:

Line 1032: UPDATE gme_batch_header

1028: CLOSE cur_is_charge_associated;
1029: END IF;
1030: --Susruth Bug#5359091 Finite Scheduled indicator is set back to 0 once the batch is rescheduled. START
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

Line 1142: p_batch_header_rec IN gme_batch_header%ROWTYPE

1138: "AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id)" for
1139: steps,activities,resources and resource transactions.
1140: ***********************************************************************************/
1141: PROCEDURE truncate_date (
1142: p_batch_header_rec IN gme_batch_header%ROWTYPE
1143: ,p_date IN NUMBER
1144: ,p_batchstep_id IN gme_batch_steps.batchstep_id%TYPE
1145: DEFAULT NULL
1146: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1174: UPDATE gme_batch_header

1170:
1171: IF p_date = 0 THEN
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

Line 1182: UPDATE gme_batch_header

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
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

Line 1191: UPDATE gme_batch_header

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
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

Line 1302: UPDATE gme_batch_header

1298: AND trans_date < p_batch_header_rec.plan_start_date;
1299: ELSE
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

Line 1310: UPDATE gme_batch_header

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
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

Line 1322: UPDATE gme_batch_header

1318: --update batch due date
1319: -- Bug 4416538( front bug of 4200964)
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