APPS.GMD_OPTIMIZE_FETCH_PKG dependencies on GMD_OPTIMIZER_HDR_GTMP

Line 48: DELETE FROM gmd_optimizer_hdr_gtmp;

44: AND a.line_id = V_line_id;
45: l_value_rec Cur_get_value%ROWTYPE;
46: BEGIN
47: /* Inserting the product data to optimize temp tables */
48: DELETE FROM gmd_optimizer_hdr_gtmp;
49: DELETE FROM gmd_optimizer_prm_gtmp;
50: DELETE FROM gmd_optimizer_line_gtmp;
51: DELETE FROM gmd_optimizer_value_gtmp;
52: OPEN Cur_get_prod;

Line 55: INSERT INTO GMD_OPTIMIZER_HDR_GTMP

51: DELETE FROM gmd_optimizer_value_gtmp;
52: OPEN Cur_get_prod;
53: FETCH Cur_get_prod INTO l_prod_rec;
54: CLOSE Cur_get_prod;
55: INSERT INTO GMD_OPTIMIZER_HDR_GTMP
56: (ENTITY_ID,MAINTAIN_TYPE,YIELD,INVENTORY_ITEM_ID,PRODUCT_QTY,PRODUCT_UOM)
57: VALUES (V_entity_id,NVL(V_maintain_type,0),100,l_prod_rec.inventory_item_id,l_prod_rec.qty,l_prod_rec.detail_uom);
58:
59: OPEN Cur_get_prod_param(l_prod_rec.line_id);