APPS.GME_SCALE_BATCH_PVT dependencies on GME_MATERIAL_DETAILS

Line 46: FROM gme_material_details

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

Line 66: FROM gme_material_details

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

Line 284: FROM gme_material_details

280:
281: CURSOR cur_get_matl (v_batch_id NUMBER)
282: IS
283: SELECT *
284: FROM gme_material_details
285: WHERE batch_id = v_batch_id
286: ORDER BY line_no;
287:
288: CURSOR cur_item_step_asso (v_batch_id NUMBER)

Line 597: IF NOT (gme_material_details_dbl.update_row

593: RAISE reduce_reservation_fail;
594: END IF;
595: END IF;
596: -- 4944024 END
597: IF NOT (gme_material_details_dbl.update_row
598: (x_material_tbl (l_row_number) ) ) THEN
599: RAISE material_save_failed;
600: ELSE
601: x_material_tbl (l_row_number).last_update_date :=

Line 990: l_rec gme_material_details%ROWTYPE;

986: ,x_return_status OUT NOCOPY VARCHAR2)
987: IS
988: /* Buffers for database reads/writes */
989: l_api_name CONSTANT VARCHAR2 (30) := 'THEORETICAL_YIELD_BATCH';
990: l_rec gme_material_details%ROWTYPE;
991: l_material_details gme_common_pvt.material_details_tab;
992: l_material_detail_ids gme_common_pvt.number_tab;
993: l_scale_tab gmd_common_scale.scale_tab;
994: l_in_scale_tab gmd_common_scale.scale_tab;

Line 1018: FROM gme_material_details

1014:
1015: CURSOR cur_batch_materials (v_batch_id NUMBER)
1016: IS
1017: SELECT material_detail_id
1018: FROM gme_material_details
1019: WHERE batch_id = v_batch_id
1020: ORDER BY line_no;
1021:
1022: CURSOR cur_item_step_asso (v_batch_id NUMBER)

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

1069:
1070: FOR i IN 1 .. l_material_detail_ids.COUNT LOOP
1071: l_rec.material_detail_id := l_material_detail_ids (i);
1072:
1073: IF (NOT gme_material_details_dbl.fetch_row (l_rec, l_rec) ) THEN
1074: RAISE material_fetch_err;
1075: END IF;
1076:
1077: /* Protect the user from performing theoretical yield */

Line 1140: IF NOT (gme_material_details_dbl.update_row

1136: ELSE
1137: x_material_details (i).wip_plan_qty := l_scale_tab (i).qty;
1138: END IF;
1139:
1140: IF NOT (gme_material_details_dbl.update_row
1141: (x_material_details (i) ) ) THEN
1142: RAISE material_save_failed;
1143: ELSE
1144: x_material_details (i).last_update_date :=