APPS.GME_SCALE_BATCH_PVT dependencies on GME_MATERIAL_DETAILS

Line 43: FROM gme_material_details

39: IS
40: CURSOR cur_get_matl (v_batch_id NUMBER)
41: IS
42: SELECT *
43: FROM gme_material_details
44: WHERE batch_id = v_batch_id
45: ORDER BY line_no;
46:
47: CURSOR cur_get_batch_status (v_batch_id NUMBER)

Line 63: FROM gme_material_details

59:
60: CURSOR cur_check_zero_qty_line (v_batch_id NUMBER, v_batch_status NUMBER)
61: IS
62: SELECT 1
63: FROM gme_material_details
64: WHERE batch_id = v_batch_id
65: GROUP BY line_type
66: HAVING SUM (DECODE (v_batch_status, 1, plan_qty, 2, wip_plan_qty) ) =
67: 0

Line 278: FROM gme_material_details

274:
275: CURSOR cur_get_matl (v_batch_id NUMBER)
276: IS
277: SELECT *
278: FROM gme_material_details
279: WHERE batch_id = v_batch_id
280: ORDER BY line_no;
281:
282: CURSOR cur_item_step_asso (v_batch_id NUMBER)

Line 591: IF NOT (gme_material_details_dbl.update_row

587: RAISE reduce_reservation_fail;
588: END IF;
589: END IF;
590: -- 4944024 END
591: IF NOT (gme_material_details_dbl.update_row
592: (x_material_tbl (l_row_number) ) ) THEN
593: RAISE material_save_failed;
594: ELSE
595: x_material_tbl (l_row_number).last_update_date :=

Line 980: l_rec gme_material_details%ROWTYPE;

976: ,x_return_status OUT NOCOPY VARCHAR2)
977: IS
978: /* Buffers for database reads/writes */
979: l_api_name CONSTANT VARCHAR2 (30) := 'THEORETICAL_YIELD_BATCH';
980: l_rec gme_material_details%ROWTYPE;
981: l_material_details gme_common_pvt.material_details_tab;
982: l_material_detail_ids gme_common_pvt.number_tab;
983: l_scale_tab gmd_common_scale.scale_tab;
984: l_in_scale_tab gmd_common_scale.scale_tab;

Line 1008: FROM gme_material_details

1004:
1005: CURSOR cur_batch_materials (v_batch_id NUMBER)
1006: IS
1007: SELECT material_detail_id
1008: FROM gme_material_details
1009: WHERE batch_id = v_batch_id
1010: ORDER BY line_no;
1011:
1012: CURSOR cur_item_step_asso (v_batch_id NUMBER)

Line 1063: IF (NOT gme_material_details_dbl.fetch_row (l_rec, l_rec) ) THEN

1059:
1060: FOR i IN 1 .. l_material_detail_ids.COUNT LOOP
1061: l_rec.material_detail_id := l_material_detail_ids (i);
1062:
1063: IF (NOT gme_material_details_dbl.fetch_row (l_rec, l_rec) ) THEN
1064: RAISE material_fetch_err;
1065: END IF;
1066:
1067: /* Protect the user from performing theoretical yield */

Line 1130: IF NOT (gme_material_details_dbl.update_row

1126: ELSE
1127: x_material_details (i).wip_plan_qty := l_scale_tab (i).qty;
1128: END IF;
1129:
1130: IF NOT (gme_material_details_dbl.update_row
1131: (x_material_details (i) ) ) THEN
1132: RAISE material_save_failed;
1133: ELSE
1134: x_material_details (i).last_update_date :=