[Home] [Help]
169: ) IS
170: l_api_name CONSTANT VARCHAR2 (30) := 'VALIDATE_SUPPLY_DEMAND';
171:
172: l_material_details_rec GME_MATERIAL_DETAILS%ROWTYPE;
173: l_batch_header_rec GME_BATCH_HEADER%ROWTYPE;
174: l_step_status NUMBER;
175: l_mat_status NUMBER;
176: l_step_id NUMBER;
177:
228: END IF;
229:
230: /* Retrieve batch header row */
231: l_batch_header_rec.batch_id := p_supply_demand_header_id;
232: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
233: IF g_debug <= gme_debug.g_log_statement THEN
234: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
235: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);
236: END IF;
231: l_batch_header_rec.batch_id := p_supply_demand_header_id;
232: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
233: IF g_debug <= gme_debug.g_log_statement THEN
234: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
235: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);
236: END IF;
237: RAISE fetch_failure;
238: END IF;
239: IF g_debug <= gme_debug.g_log_statement THEN
400: ) IS
401: l_api_name CONSTANT VARCHAR2 (30) := 'GET_AVAILABLE_SUPPLY_DEMAND';
402:
403: l_material_details_rec GME_MATERIAL_DETAILS%ROWTYPE;
404: l_batch_header_rec GME_BATCH_HEADER%ROWTYPE;
405: l_step_status NUMBER(5);
406: l_primary_uom_code VARCHAR2(3);
407: l_available_quantity NUMBER;
408:
462: END IF;
463:
464: /* Retrieve batch header */
465: l_batch_header_rec.batch_id := p_supply_demand_header_id;
466: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
467: IF g_debug <= gme_debug.g_log_statement THEN
468: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
469: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);
470: END IF;
465: l_batch_header_rec.batch_id := p_supply_demand_header_id;
466: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
467: IF g_debug <= gme_debug.g_log_statement THEN
468: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
469: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);
470: END IF;
471: RAISE fetch_failure;
472: END IF;
473:
780: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
781: ,x_message_count OUT NOCOPY NUMBER
782: ,x_message_list OUT NOCOPY VARCHAR2
783: ,x_return_status OUT NOCOPY VARCHAR2
784: ,p_batch_header_rec IN gme_batch_header%rowtype
785: ,p_formula_dtl_tbl IN gmdfmval_pub.formula_detail_tbl
786: ,p_recipe_rout_tbl IN gmd_recipe_fetch_pub.recipe_rout_tbl
787: ,p_recipe_step_tbl IN gmd_recipe_fetch_pub.recipe_step_tbl
788: ,p_routing_depd_tbl IN gmd_recipe_fetch_pub.routing_depd_tbl
790: ,p_oprn_resc_tbl IN gmd_recipe_fetch_pub.oprn_resc_tbl
791: ,p_proc_param_tbl IN gmd_recipe_fetch_pub.recp_resc_proc_param_tbl
792: ,p_use_workday_cal IN VARCHAR2 DEFAULT FND_API.G_TRUE
793: ,p_contiguity_override IN VARCHAR2 DEFAULT FND_API.G_TRUE
794: ,x_batch_header_rec OUT NOCOPY gme_batch_header%rowtype
795: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
796: ) IS
797:
798: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_LCF_BATCH';
1123: ) IS
1124: SELECT m.material_detail_id, m.batch_id, h.batch_no, m.material_requirement_date, m.line_no,
1125: m.formulaline_id, m.plan_qty, m.dtl_um, m.scale_multiple, h.formula_id,
1126: m.inventory_item_id, m.move_order_line_id, i.concatenated_segments item_no, h.organization_id, h.batch_type
1127: FROM gme_material_details m, gme_batch_header h, mtl_system_items_kfv i
1128: WHERE m.batch_id = h.batch_id
1129: AND h.organization_id = v_org_id
1130: AND h.batch_status = 1
1131: AND m.material_requirement_date >= v_start_date
1159: l_material_detail_rec gme_material_details%ROWTYPE;
1160: l_return BOOLEAN;
1161: l_return_status VARCHAR2 (1);
1162: x_return_status VARCHAR2 (1);
1163: l_batch_header_rec gme_batch_header%ROWTYPE;
1164: l_old_item_rec item_master_cursor%ROWTYPE;
1165: l_new_item_rec item_master_cursor%ROWTYPE;
1166: l_batchstep_rec gme_batch_steps%ROWTYPE;
1167: x_batchstep_rec gme_batch_steps%ROWTYPE;
1274:
1275: --fetch batch header record
1276: l_batch_header_rec.batch_id := rec.batch_id;
1277:
1278: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
1279: l_oneitem_error := TRUE;
1280: gme_common_pvt.count_and_get (x_count => l_message_count,
1281: p_encoded => fnd_api.g_false,
1282: x_data => l_message_list
1999: x_return_status OUT NOCOPY VARCHAR2)
2000: IS
2001: CURSOR get_primary_product_uom ( v_batch_id IN NUMBER )IS
2002: SELECT gm.dtl_um
2003: FROM gmd_recipe_validity_rules vr, gme_material_details gm, gme_batch_header bh
2004: WHERE bh.recipe_validity_rule_id = vr.recipe_validity_rule_id
2005: AND bh.batch_id = gm.batch_id
2006: AND vr.inventory_item_id = gm.inventory_item_id
2007: AND gm.line_type = 1 /*FPBug# 4684029 rework */
2263: -- HISTORY:
2264: -- Namit S. 27-NOV-2006 bug#5674398
2265: ======================================================================*/
2266:
2267: FUNCTION get_ingr_sub_date (p_batch_id IN gme_batch_header.batch_id%TYPE,
2268: p_material_detail_id IN gme_material_details.material_detail_id%TYPE) RETURN DATE
2269: IS
2270: CURSOR cur_get_start_end_Date(
2271: p_batch_id IN gme_batch_header.batch_id%TYPE
2267: FUNCTION get_ingr_sub_date (p_batch_id IN gme_batch_header.batch_id%TYPE,
2268: p_material_detail_id IN gme_material_details.material_detail_id%TYPE) RETURN DATE
2269: IS
2270: CURSOR cur_get_start_end_Date(
2271: p_batch_id IN gme_batch_header.batch_id%TYPE
2272: ) IS
2273: SELECT plan_start_date,plan_cmplt_date
2274: FROM gme_batch_header
2275: WHERE batch_id = p_batch_id;
2270: CURSOR cur_get_start_end_Date(
2271: p_batch_id IN gme_batch_header.batch_id%TYPE
2272: ) IS
2273: SELECT plan_start_date,plan_cmplt_date
2274: FROM gme_batch_header
2275: WHERE batch_id = p_batch_id;
2276:
2277: CURSOR cur_get_matl_requirement_dt(
2278: p_material_detail_id gme_material_details.material_detail_id%TYPE
2661: l_usage_time NUMBER;
2662: l_txn_usage NUMBER;
2663: l_rsrc_trans_count NUMBER;
2664: l_trans_date DATE;
2665: l_batch_header_rec gme_batch_header%ROWTYPE;
2666: l_rsrc_txn_gtmp_rec gme_resource_txns_gtmp%ROWTYPE;
2667: l_step_resources gme_batch_step_resources%ROWTYPE;
2668: setup_failed EXCEPTION;
2669: create_txn_fail EXCEPTION;
2784: l_reason_id NUMBER;
2785: l_step_status NUMBER;
2786: l_rsrc_trans_count NUMBER;
2787: l_trans_date DATE;
2788: l_batch_header_rec gme_batch_header%ROWTYPE;
2789: l_step_resources gme_batch_step_resources%ROWTYPE;
2790: l_new_step_resources gme_batch_step_resources%ROWTYPE;
2791: error_load_trans EXCEPTION;
2792: setup_failed EXCEPTION;
2884: l_new_step_resources gme_batch_step_resources%ROWTYPE;
2885: l_rsrc_txn_gtmp_rec gme_resource_txns_gtmp%ROWTYPE;
2886: CURSOR Cur_get_step(v_line_id NUMBER) IS
2887: SELECT s.step_status, h.automatic_step_calculation
2888: FROM gme_batch_steps s, gme_batch_step_activities a, gme_batch_step_resources r, gme_batch_header h
2889: WHERE r.batchstep_resource_id = v_line_id
2890: AND a.batchstep_activity_id = r.batchstep_activity_id
2891: AND s.batchstep_id = a.batchstep_id
2892: AND h.batch_id = s.batch_id;