APPS.GMF_VIB dependencies on GME_BATCH_HEADER

Line 344: l_batch_status gme_batch_header.batch_status%TYPE;

340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,
342: x_msg_data OUT NOCOPY VARCHAR2) IS
343:
344: l_batch_status gme_batch_header.batch_status%TYPE;
345: l_api_name VARCHAR2(30) := 'Delete_Batch_Requirements';
346: BEGIN
347: x_return_status := FND_API.G_RET_STS_SUCCESS ;
348:

Line 357: FROM gme_batch_header

353: -- Validate batch_id
354: BEGIN
355: SELECT batch_status
356: INTO l_batch_status
357: FROM gme_batch_header
358: WHERE batch_id = p_batch_id;
359:
360: IF l_batch_status <> 1 THEN
361: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 478: l_batch_status gme_batch_header.batch_status%TYPE;

474: WHERE batch_id = c_batch_id
475: GROUP BY ing_material_detail_id, batchstep_resource_id;
476:
477:
478: l_batch_status gme_batch_header.batch_status%TYPE;
479: l_use_item_step_dep VARCHAR2(30);
480: l_vib_profile_value VARCHAR2(30);
481: l_api_name VARCHAR2(30) := 'Create_Temp_Batch_Requirements';
482: BEGIN

Line 493: FROM gme_batch_header

489: -- Validate batch_id
490: BEGIN
491: SELECT batch_status
492: INTO l_batch_status
493: FROM gme_batch_header
494: WHERE batch_id = p_batch_id;
495:
496: /* Bug 5491419. Added status 4.
497: IF l_batch_status not in (2, 3) THEN

Line 1952: l_batch_status gme_batch_header.batch_status%TYPE;

1948: v.finalize_ind = 1 AND
1949: v.consume_layer_id IS NOT NULL
1950: GROUP BY v.consume_layer_id, v.line_type;
1951:
1952: l_batch_status gme_batch_header.batch_status%TYPE;
1953: prev_prod_material_detail_id NUMBER;
1954: l_total_cost_alloc NUMBER;
1955: l_pseudo_prod_layer_id NUMBER;
1956: l_last_prod_layer c_last_prod_yield%ROWTYPE;

Line 1985: FROM gme_batch_header

1981: -- Validate batch_id
1982: BEGIN
1983: SELECT batch_status, last_updated_by, batch_close_date
1984: INTO l_batch_status, l_user_id, l_batch_close_date
1985: FROM gme_batch_header
1986: WHERE batch_id = p_batch_id;
1987:
1988: IF l_batch_status <> 4 THEN
1989: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 2645: FROM gme_batch_header

2641: -- Validate batch_id
2642: BEGIN
2643: SELECT batch_status
2644: INTO l_batch_status
2645: FROM gme_batch_header
2646: WHERE batch_id = p_batch_id;
2647:
2648: IF l_batch_status = 4 THEN
2649: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 2865: gme_batch_header hdr,

2861: il.final_cost_ind, il.gl_posted_ind,
2862: hdr.batch_id,
2863: RANK() OVER(partition by hdr.batch_id ORDER BY hdr.batch_id, il.layer_date desc, il.layer_id desc) layer_rank
2864: FROM
2865: gme_batch_header hdr,
2866: sy_orgn_mst orgn,
2867: gmf_incoming_material_layers il,
2868: ic_tran_pnd pnd
2869: WHERE