[Home] [Help]
175: , p_init_msg_lst IN VARCHAR2 DEFAULT FND_API.G_FALSE
176: ) IS
177: l_api_name CONSTANT VARCHAR2 (30) := 'VALIDATE_SUPPLY_DEMAND';
178:
179: l_material_details_rec GME_MATERIAL_DETAILS%ROWTYPE;
180: l_batch_header_rec GME_BATCH_HEADER%ROWTYPE;
181: l_step_status NUMBER;
182: l_mat_status NUMBER;
183: l_step_id NUMBER;
274: END IF;
275:
276: /* Retrieve material details record */
277: l_material_details_rec.material_detail_id := p_supply_demand_line_id;
278: IF (NOT(gme_material_details_dbl.fetch_row(l_material_details_rec, l_material_details_rec))) THEN
279: IF g_debug <= gme_debug.g_log_statement THEN
280: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
281: 'Fetch failure against gme_material_details using id of '||p_supply_demand_line_id);
282: END IF;
277: l_material_details_rec.material_detail_id := p_supply_demand_line_id;
278: IF (NOT(gme_material_details_dbl.fetch_row(l_material_details_rec, l_material_details_rec))) THEN
279: IF g_debug <= gme_debug.g_log_statement THEN
280: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
281: 'Fetch failure against gme_material_details using id of '||p_supply_demand_line_id);
282: END IF;
283: RAISE fetch_failure;
284: END IF;
285:
420: , p_init_msg_lst IN VARCHAR2 DEFAULT FND_API.G_FALSE
421: ) IS
422: l_api_name CONSTANT VARCHAR2 (30) := 'GET_AVAILABLE_SUPPLY_DEMAND';
423:
424: l_material_details_rec GME_MATERIAL_DETAILS%ROWTYPE;
425: l_batch_header_rec GME_BATCH_HEADER%ROWTYPE;
426: l_step_status NUMBER(5);
427: l_primary_uom_code VARCHAR2(3);
428: l_available_quantity NUMBER;
503: END IF;
504:
505: /* Retrieve material details record */
506: l_material_details_rec.material_detail_id := p_supply_demand_line_id;
507: IF (NOT(gme_material_details_dbl.fetch_row(l_material_details_rec, l_material_details_rec))) THEN
508: IF g_debug <= gme_debug.g_log_statement THEN
509: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
510: 'Fetch failure against gme_material_details using id of '||p_supply_demand_line_id);
511: END IF;
506: l_material_details_rec.material_detail_id := p_supply_demand_line_id;
507: IF (NOT(gme_material_details_dbl.fetch_row(l_material_details_rec, l_material_details_rec))) THEN
508: IF g_debug <= gme_debug.g_log_statement THEN
509: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
510: 'Fetch failure against gme_material_details using id of '||p_supply_demand_line_id);
511: END IF;
512: RAISE fetch_failure;
513: END IF;
514:
933: IS
934: l_api_name CONSTANT VARCHAR2 (30) := 'get_planning_open_qty';
935: l_open_qty NUMBER := 0;
936: l_return_status VARCHAR2 (1);
937: l_mtl_dtl_rec gme_material_details%ROWTYPE;
938: BEGIN
939: IF g_debug <= gme_debug.g_log_procedure THEN
940: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
941: || l_api_name);
1152: ) IS
1153: SELECT m.material_detail_id, m.batch_id, h.batch_no, m.material_requirement_date, m.line_no,
1154: m.formulaline_id, m.plan_qty, m.dtl_um, m.scale_multiple, h.formula_id,
1155: m.inventory_item_id, m.move_order_line_id, i.concatenated_segments item_no, h.organization_id, h.batch_type
1156: FROM gme_material_details m, gme_batch_header h, mtl_system_items_kfv i
1157: WHERE m.batch_id = h.batch_id
1158: AND h.organization_id = v_org_id
1159: AND h.batch_status = 1
1160: AND m.material_requirement_date >= v_start_date
1184: l_formula_tbl gmdfmval_pub.formula_detail_tbl;
1185: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1186: l_material_details_tbl gme_common_pvt.material_details_tab;
1187: l_material_details_tbl_out gme_common_pvt.material_details_tab;
1188: l_material_detail_rec gme_material_details%ROWTYPE;
1189: l_return BOOLEAN;
1190: l_return_status VARCHAR2 (1);
1191: x_return_status VARCHAR2 (1);
1192: l_batch_header_rec gme_batch_header%ROWTYPE;
1315:
1316: -- Fetch material record for the rec.material_detail_id;
1317: l_material_detail_rec.material_detail_id := rec.material_detail_id;
1318:
1319: IF NOT gme_material_details_dbl.fetch_row (p_material_detail => l_material_detail_rec,
1320: x_material_detail => l_material_detail_rec
1321: ) THEN
1322: l_oneitem_error := TRUE;
1323: gme_common_pvt.count_and_get (x_count => l_message_count,
1638: END IF; --IF l_new_item_rec.mtl_transactions_enabled_flag = 'Y'
1639: END IF; -- IF l_batch_header_rec.update_inventory_ind = 'Y' THEN
1640:
1641: --Call material_line_dbl.update_rec
1642: l_return := gme_material_details_dbl.update_row (l_material_detail_rec);
1643:
1644: IF (l_return = FALSE) THEN
1645: gme_common_pvt.count_and_get (x_count => l_message_count,
1646: p_encoded => fnd_api.g_false,
1688: FETCH c_batchsteps INTO l_batchstep_rec;
1689: CLOSE c_batchsteps;
1690:
1691: /* FPBug#4351032 update original primary qty field as this field dont get updated
1692: using gme_material_details_dbl.update_row procedure */
1693: UPDATE gme_material_details
1694: SET original_primary_qty = l_material_detail_rec.original_primary_qty
1695: WHERE material_detail_id = l_material_detail_rec.material_detail_id;
1696:
1689: CLOSE c_batchsteps;
1690:
1691: /* FPBug#4351032 update original primary qty field as this field dont get updated
1692: using gme_material_details_dbl.update_row procedure */
1693: UPDATE gme_material_details
1694: SET original_primary_qty = l_material_detail_rec.original_primary_qty
1695: WHERE material_detail_id = l_material_detail_rec.material_detail_id;
1696:
1697: l_material_detail_rec.last_update_date := gme_common_pvt.get_timestamp;
2072: x_return_status OUT NOCOPY VARCHAR2)
2073: IS
2074: CURSOR get_primary_product_uom ( v_batch_id IN NUMBER )IS
2075: SELECT gm.dtl_um
2076: FROM gmd_recipe_validity_rules vr, gme_material_details gm, gme_batch_header bh
2077: WHERE bh.recipe_validity_rule_id = vr.recipe_validity_rule_id
2078: AND bh.batch_id = gm.batch_id
2079: AND vr.inventory_item_id = gm.inventory_item_id
2080: AND gm.line_type = 1 /*FPBug# 4684029 rework */
2082: AND rownum = 1 ;
2083:
2084: CURSOR get_quantities ( v_batch_id IN NUMBER, v_line_type IN NUMBER )IS
2085: SELECT inventory_item_id, plan_qty, wip_plan_qty, actual_qty, dtl_um
2086: FROM gme_material_details
2087: WHERE batch_id = v_batch_id
2088: AND line_type = v_line_type;
2089:
2090: l_api_name VARCHAR2 (30):= 'get_total_quantity';
2349: -- Namit S. 27-NOV-2006 bug#5674398
2350: ======================================================================*/
2351:
2352: FUNCTION get_ingr_sub_date (p_batch_id IN gme_batch_header.batch_id%TYPE,
2353: p_material_detail_id IN gme_material_details.material_detail_id%TYPE) RETURN DATE
2354: IS
2355: CURSOR cur_get_start_end_Date(
2356: p_batch_id IN gme_batch_header.batch_id%TYPE
2357: ) IS
2359: FROM gme_batch_header
2360: WHERE batch_id = p_batch_id;
2361:
2362: CURSOR cur_get_matl_requirement_dt(
2363: p_material_detail_id gme_material_details.material_detail_id%TYPE
2364: ) IS
2365: SELECT material_requirement_date
2366: FROM gme_material_details
2367: WHERE material_detail_id = p_material_detail_id;
2362: CURSOR cur_get_matl_requirement_dt(
2363: p_material_detail_id gme_material_details.material_detail_id%TYPE
2364: ) IS
2365: SELECT material_requirement_date
2366: FROM gme_material_details
2367: WHERE material_detail_id = p_material_detail_id;
2368:
2369: l_plan_start_date DATE;
2370: l_plan_cmplt_date DATE;