APPS.GME_SUPPLY_RES_PVT dependencies on GME_BATCH_HEADER

Line 143: From gme_batch_header

139: and line_type <> -1
140: ;
141: Cursor get_new_batch_cmpt_date (p_batch_id IN NUMBER) is
142: Select plan_cmplt_date
143: From gme_batch_header
144: where batch_id = p_batch_id;
145:
146: BEGIN
147: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 400: FROM gme_batch_header

396: and reservation_quantity <> 0;
397:
398: CURSOR Get_batch_type(p_batch_id IN NUMBER) IS
399: SELECT batch_type
400: FROM gme_batch_header
401: WHERE batch_id = p_batch_id;
402:
403:
404: CURSOR So_line_id_for_batch_line(p_batch_line_id IN NUMBER) Is

Line 415: gme_batch_header gh

411:
412: CURSOR get_batch_id_for_line(p_batch_line_id IN NUMBER) Is
413: SELECT gl.batch_id,gh.batch_type
414: FROM gme_material_details gl,
415: gme_batch_header gh
416: WHERE gl.material_detail_id = p_batch_line_id
417: and gl.batch_id = gh.batch_id;
418:
419: CURSOR CSR_for_so_line(p_so_line_id IN NUMBER) IS

Line 449: FROM mtl_reservations mr, gme_batch_header gbh

445: */
446: Cursor check_mul_line_id1 (p_user_id IN number
447: , p_batch_id IN NUMBER) IS
448: SELECT DISTINCT orig_demand_source_line_id
449: FROM mtl_reservations mr, gme_batch_header gbh
450: WHERE mr.created_by = p_user_id
451: AND mr.orig_supply_source_header_id = p_batch_id
452: AND mr.orig_supply_source_header_id = gbh.batch_id
453: AND mr.organization_id = gbh.organization_id

Line 1957: p_batch_header_rec IN gme_batch_header%ROWTYPE

1953:
1954: END delete_prod_supply_resv;
1955:
1956: PROCEDURE delete_batch_prod_supply_resv (
1957: p_batch_header_rec IN gme_batch_header%ROWTYPE
1958: ,x_msg_count OUT NOCOPY NUMBER
1959: ,x_msg_data OUT NOCOPY VARCHAR2
1960: ,x_return_status OUT NOCOPY VARCHAR2)
1961: IS