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 345: (p_gme_batch_header_rec => l_batch_header_rec

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
346: ,p_use_workday_cal => p_use_workday_cal
347: ,p_contiguity_override => p_contiguity_override
348: ,p_return_status => l_return_status);
349:

Line 356: (p_gme_batch_header_rec => l_batch_header_rec

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

Line 369: (p_gme_batch_header_rec => l_batch_header_rec

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

Line 383: (p_gme_batch_header_rec => p_batch_header_rec

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
385: ,p_contiguity_override => p_contiguity_override
386: ,p_return_status => l_return_status);
387:

Line 394: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec

390: END IF;
391: END IF; /*plan_cmpt_date is not null*/
392: END IF; /* batch_status = 2*/
393:
394: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec
395: ,x_batch_header_rec) ) THEN
396: RAISE batch_header_fetch_error;
397: END IF;
398: ELSE /* no routing */

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

665: END IF; /* l_no_prod_found*/
666:
667: IF (NVL (g_debug, 0) IN
668: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
669: gme_debug.put_line ('Update gme_batch_header.');
670: END IF;
671:
672: UPDATE gme_batch_header
673: SET plan_start_date = x_batch_header_rec.plan_start_date

Line 672: UPDATE gme_batch_header

668: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
669: gme_debug.put_line ('Update gme_batch_header.');
670: END IF;
671:
672: UPDATE gme_batch_header
673: SET plan_start_date = x_batch_header_rec.plan_start_date
674: ,plan_cmplt_date = x_batch_header_rec.plan_cmplt_date
675: ,due_date =
676: NVL (x_batch_header_rec.due_date

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

682: END IF;
683:
684: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
685: gme_debug.put_line
686: ( ' After update gme_batch_header. Final plan_start_date '
687: || TO_CHAR (x_batch_header_rec.plan_start_date
688: ,'yyyy/mon/dd hh24:mi:ss')
689: || ' Final plan_cmplt_date '
690: || TO_CHAR (x_batch_header_rec.plan_cmplt_date

Line 774: UPDATE gme_batch_header

770: gme_debug.put_line
771: ('User supplied plan completion date is greater than what system calculated User wants to leave gaps.');
772: END IF;
773:
774: UPDATE gme_batch_header
775: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
776: WHERE batch_id = x_batch_header_rec.batch_id;
777: END IF; /* max_cmplt_date */
778: END IF; /* dates not null */

Line 780: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec

776: WHERE batch_id = x_batch_header_rec.batch_id;
777: END IF; /* max_cmplt_date */
778: END IF; /* dates not null */
779:
780: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec
781: ,x_batch_header_rec) ) THEN
782: RAISE batch_header_fetch_error;
783: END IF;
784:

Line 1013: UPDATE gme_batch_header

1009: CLOSE cur_is_charge_associated;
1010: END IF;
1011: --Susruth Bug#5359091 Finite Scheduled indicator is set back to 0 once the batch is rescheduled. START
1012: IF x_batch_header_rec.FINITE_SCHEDULED_IND = 1 THEN
1013: UPDATE gme_batch_header
1014: SET FINITE_SCHEDULED_IND = 0
1015: WHERE batch_id = x_batch_header_rec.batch_id;
1016: x_batch_header_rec.FINITE_SCHEDULED_IND := 0;
1017: END IF;

Line 1119: p_batch_header_rec IN gme_batch_header%ROWTYPE

1115: "AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id)" for
1116: steps,activities,resources and resource transactions.
1117: ***********************************************************************************/
1118: PROCEDURE truncate_date (
1119: p_batch_header_rec IN gme_batch_header%ROWTYPE
1120: ,p_date IN NUMBER
1121: ,p_batchstep_id IN gme_batch_steps.batchstep_id%TYPE
1122: DEFAULT NULL
1123: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1151: UPDATE gme_batch_header

1147:
1148: IF p_date = 0 THEN
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

Line 1159: UPDATE gme_batch_header

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

Line 1168: UPDATE gme_batch_header

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

Line 1279: UPDATE gme_batch_header

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

Line 1287: UPDATE gme_batch_header

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

Line 1299: UPDATE gme_batch_header

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