eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_API_GRP dependencies on GME_BATCH_HEADER

Line 180: l_batch_header_rec GME_BATCH_HEADER%ROWTYPE;

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;
184:

Line 239: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN

235: END IF;
236:
237: /* Retrieve batch header row */
238: l_batch_header_rec.batch_id := p_supply_demand_header_id;
239: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
240: IF g_debug <= gme_debug.g_log_statement THEN
241: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
242: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);
243: END IF;

Line 242: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);

238: l_batch_header_rec.batch_id := p_supply_demand_header_id;
239: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
240: IF g_debug <= gme_debug.g_log_statement THEN
241: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
242: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);
243: END IF;
244: RAISE fetch_failure;
245: END IF;
246: IF g_debug <= gme_debug.g_log_statement THEN

Line 425: l_batch_header_rec GME_BATCH_HEADER%ROWTYPE;

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;
429:

Line 487: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN

483: END IF;
484:
485: /* Retrieve batch header */
486: l_batch_header_rec.batch_id := p_supply_demand_header_id;
487: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
488: IF g_debug <= gme_debug.g_log_statement THEN
489: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
490: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);
491: END IF;

Line 490: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);

486: l_batch_header_rec.batch_id := p_supply_demand_header_id;
487: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
488: IF g_debug <= gme_debug.g_log_statement THEN
489: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
490: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);
491: END IF;
492: RAISE fetch_failure;
493: END IF;
494:

Line 808: ,p_batch_header_rec IN gme_batch_header%rowtype

804: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
805: ,x_message_count OUT NOCOPY NUMBER
806: ,x_message_list OUT NOCOPY VARCHAR2
807: ,x_return_status OUT NOCOPY VARCHAR2
808: ,p_batch_header_rec IN gme_batch_header%rowtype
809: ,p_formula_dtl_tbl IN gmdfmval_pub.formula_detail_tbl
810: ,p_recipe_rout_tbl IN gmd_recipe_fetch_pub.recipe_rout_tbl
811: ,p_recipe_step_tbl IN gmd_recipe_fetch_pub.recipe_step_tbl
812: ,p_routing_depd_tbl IN gmd_recipe_fetch_pub.routing_depd_tbl

Line 818: ,x_batch_header_rec OUT NOCOPY gme_batch_header%rowtype

814: ,p_oprn_resc_tbl IN gmd_recipe_fetch_pub.oprn_resc_tbl
815: ,p_proc_param_tbl IN gmd_recipe_fetch_pub.recp_resc_proc_param_tbl
816: ,p_use_workday_cal IN VARCHAR2 DEFAULT FND_API.G_TRUE
817: ,p_contiguity_override IN VARCHAR2 DEFAULT FND_API.G_TRUE
818: ,x_batch_header_rec OUT NOCOPY gme_batch_header%rowtype
819: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
820: ) IS
821:
822: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_LCF_BATCH';

Line 1156: FROM gme_material_details m, gme_batch_header h, mtl_system_items_kfv i

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

Line 1192: l_batch_header_rec gme_batch_header%ROWTYPE;

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;
1193: l_old_item_rec item_master_cursor%ROWTYPE;
1194: l_new_item_rec item_master_cursor%ROWTYPE;
1195: l_batchstep_rec gme_batch_steps%ROWTYPE;
1196: x_batchstep_rec gme_batch_steps%ROWTYPE;

Line 1307: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN

1303:
1304: --fetch batch header record
1305: l_batch_header_rec.batch_id := rec.batch_id;
1306:
1307: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
1308: l_oneitem_error := TRUE;
1309: gme_common_pvt.count_and_get (x_count => l_message_count,
1310: p_encoded => fnd_api.g_false,
1311: x_data => l_message_list

Line 2076: FROM gmd_recipe_validity_rules vr, gme_material_details gm, gme_batch_header bh

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 */

Line 2352: FUNCTION get_ingr_sub_date (p_batch_id IN gme_batch_header.batch_id%TYPE,

2348: -- HISTORY:
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

Line 2356: p_batch_id IN gme_batch_header.batch_id%TYPE

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
2358: SELECT plan_start_date,plan_cmplt_date
2359: FROM gme_batch_header
2360: WHERE batch_id = p_batch_id;

Line 2359: FROM gme_batch_header

2355: CURSOR cur_get_start_end_Date(
2356: p_batch_id IN gme_batch_header.batch_id%TYPE
2357: ) IS
2358: SELECT plan_start_date,plan_cmplt_date
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

Line 2750: l_batch_header_rec gme_batch_header%ROWTYPE;

2746: l_usage_time NUMBER;
2747: l_txn_usage NUMBER;
2748: l_rsrc_trans_count NUMBER;
2749: l_trans_date DATE;
2750: l_batch_header_rec gme_batch_header%ROWTYPE;
2751: l_rsrc_txn_gtmp_rec gme_resource_txns_gtmp%ROWTYPE;
2752: l_step_resources gme_batch_step_resources%ROWTYPE;
2753: setup_failed EXCEPTION;
2754: create_txn_fail EXCEPTION;

Line 2873: l_batch_header_rec gme_batch_header%ROWTYPE;

2869: l_reason_id NUMBER;
2870: l_step_status NUMBER;
2871: l_rsrc_trans_count NUMBER;
2872: l_trans_date DATE;
2873: l_batch_header_rec gme_batch_header%ROWTYPE;
2874: l_step_resources gme_batch_step_resources%ROWTYPE;
2875: l_new_step_resources gme_batch_step_resources%ROWTYPE;
2876: error_load_trans EXCEPTION;
2877: setup_failed EXCEPTION;

Line 2973: FROM gme_batch_steps s, gme_batch_step_activities a, gme_batch_step_resources r, gme_batch_header h

2969: l_new_step_resources gme_batch_step_resources%ROWTYPE;
2970: l_rsrc_txn_gtmp_rec gme_resource_txns_gtmp%ROWTYPE;
2971: CURSOR Cur_get_step(v_line_id NUMBER) IS
2972: SELECT s.step_status, h.automatic_step_calculation
2973: FROM gme_batch_steps s, gme_batch_step_activities a, gme_batch_step_resources r, gme_batch_header h
2974: WHERE r.batchstep_resource_id = v_line_id
2975: AND a.batchstep_activity_id = r.batchstep_activity_id
2976: AND s.batchstep_id = a.batchstep_id
2977: AND h.batch_id = s.batch_id;