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 477: l_batch_status gme_batch_header.batch_status%TYPE;

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

Line 492: FROM gme_batch_header

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

Line 1889: l_batch_status gme_batch_header.batch_status%TYPE;

1885: v.finalize_ind = 1 AND
1886: v.consume_layer_id IS NOT NULL
1887: GROUP BY v.consume_layer_id, v.line_type;
1888:
1889: l_batch_status gme_batch_header.batch_status%TYPE;
1890: prev_prod_material_detail_id NUMBER;
1891: l_total_cost_alloc NUMBER;
1892: l_pseudo_prod_layer_id NUMBER;
1893: l_last_prod_layer c_last_prod_yield%ROWTYPE;

Line 1922: FROM gme_batch_header

1918: -- Validate batch_id
1919: BEGIN
1920: SELECT batch_status, last_updated_by, batch_close_date
1921: INTO l_batch_status, l_user_id, l_batch_close_date
1922: FROM gme_batch_header
1923: WHERE batch_id = p_batch_id;
1924:
1925: IF l_batch_status <> 4 THEN
1926: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 2561: FROM gme_batch_header

2557: -- Validate batch_id
2558: BEGIN
2559: SELECT batch_status
2560: INTO l_batch_status
2561: FROM gme_batch_header
2562: WHERE batch_id = p_batch_id;
2563:
2564: IF l_batch_status = 4 THEN
2565: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 2690: gme_batch_header hdr,

2686: il.final_cost_ind, il.gl_posted_ind,
2687: hdr.batch_id,
2688: RANK() OVER(partition by hdr.batch_id ORDER BY hdr.batch_id, il.layer_date desc, il.layer_id desc) layer_rank
2689: FROM
2690: gme_batch_header hdr,
2691: sy_orgn_mst orgn,
2692: gmf_incoming_material_layers il,
2693: ic_tran_pnd pnd
2694: WHERE