APPS.GME_CLOSE_BATCH_PVT dependencies on GME_MATERIAL_DETAILS

Line 97: l_material_details_rec gme_material_details%ROWTYPE;

93: gmf_cost_failure EXCEPTION;
94:
95: -- Bug 10100973
96: l_material_details_tab gme_common_pvt.material_details_tab;
97: l_material_details_rec gme_material_details%ROWTYPE;
98: material_details_fetch_err EXCEPTION;
99:
100: -- Bug 10161288
101: purge_exception_err EXCEPTION;

Line 107: FROM gme_material_details d, gme_batch_header h

103: /* Get only the phantom ingredients which are not close already */
104: CURSOR cur_get_phant
105: IS
106: SELECT phantom_id
107: FROM gme_material_details d, gme_batch_header h
108: WHERE d.batch_id = x_batch_header_rec.batch_id
109: AND phantom_id IS NOT NULL
110: AND h.batch_id = d.phantom_id
111: AND h.batch_status <> 4;

Line 116: FROM gme_material_details

112:
113: CURSOR cur_lock_material_lines (v_batch_id NUMBER)
114: IS
115: SELECT material_detail_id
116: FROM gme_material_details
117: WHERE batch_id = v_batch_id
118: FOR UPDATE OF actual_qty NOWAIT;
119:
120: CURSOR cur_gme_batch_steps

Line 130: FROM gme_material_details

126: /* siva FPbug#4684029 */
127: CURSOR cur_get_prod (v_batch_id NUMBER)
128: IS
129: SELECT *
130: FROM gme_material_details
131: WHERE batch_id = v_batch_id
132: AND line_type = 1;
133: BEGIN
134: IF g_debug <= gme_debug.g_log_procedure THEN

Line 216: IF NOT (gme_material_details_dbl.fetch_tab

212: CLOSE cur_lock_material_lines;
213:
214: -- Bug 10100973 - Let's remove Open orphan Move order records if they exist.
215: l_material_details_rec.batch_id := x_batch_header_rec.batch_id;
216: IF NOT (gme_material_details_dbl.fetch_tab
217: (p_material_detail => l_material_details_rec
218: ,x_material_detail => l_material_details_tab) ) THEN
219: RAISE material_details_fetch_err;
220: END IF;

Line 419: IF NOT gme_material_details_dbl.update_row(l_product_rec) THEN

415: /* dynamic cost factor is ratio of actual qty to total product qty */
416: l_product_rec.cost_alloc := l_qty/l_total_actual_output;
417:
418: /* updating the material detail record with new cost factor*/
419: IF NOT gme_material_details_dbl.update_row(l_product_rec) THEN
420: RAISE MATERIAL_DETAIL_UPD_ERR;
421: END IF;
422: END LOOP;
423: END IF;

Line 570: FROM gme_material_details

566: SELECT step_close_date
567: FROM gme_batch_steps
568: WHERE batch_id IN (
569: SELECT DISTINCT batch_id
570: FROM gme_material_details
571: START WITH batch_id =
572: p_batch_header_rec.batch_id
573: CONNECT BY batch_id = PRIOR phantom_id)
574: AND NVL (step_close_date, p_batch_header_rec.batch_close_date) >

Line 580: FROM gme_material_details

576:
577: CURSOR cur_get_batches (v_batch_id NUMBER)
578: IS
579: SELECT DISTINCT batch_id
580: FROM gme_material_details
581: START WITH batch_id = v_batch_id
582: CONNECT BY batch_id = PRIOR phantom_id;
583:
584: x_batch_tbl gme_common_pvt.number_tab;

Line 624: from gme_material_details

620: against the transactions of the materials in a batch */
621: CURSOR cur_get_materials(v_batch_id NUMBER)
622: IS
623: SELECT material_detail_id
624: from gme_material_details
625: WHERE batch_id = v_batch_id;
626:
627:
628: CURSOR cur_inventory_txns (v_mat_det_id NUMBER, v_batch_id NUMBER,

Line 652: FROM gme_material_details

648: SELECT actual_cmplt_date
649: FROM gme_batch_header
650: WHERE batch_id IN (
651: SELECT DISTINCT batch_id
652: FROM gme_material_details
653: START WITH batch_id =
654: p_batch_header_rec.batch_id
655: CONNECT BY batch_id = PRIOR phantom_id)
656: AND NVL (actual_cmplt_date, p_batch_header_rec.batch_close_date) >