APPS.GME_SUPPLY_RES_PVT dependencies on GME_BATCH_HEADER

Line 127: From gme_batch_header

123: and line_type <> -1
124: ;
125: Cursor get_new_batch_cmpt_date (p_batch_id IN NUMBER) is
126: Select plan_cmplt_date
127: From gme_batch_header
128: where batch_id = p_batch_id;
129:
130: BEGIN
131: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 384: FROM gme_batch_header

380: and reservation_quantity <> 0;
381:
382: CURSOR Get_batch_type(p_batch_id IN NUMBER) IS
383: SELECT batch_type
384: FROM gme_batch_header
385: WHERE batch_id = p_batch_id;
386:
387:
388: CURSOR So_line_id_for_batch_line(p_batch_line_id IN NUMBER) Is

Line 399: gme_batch_header gh

395:
396: CURSOR get_batch_id_for_line(p_batch_line_id IN NUMBER) Is
397: SELECT gl.batch_id,gh.batch_type
398: FROM gme_material_details gl,
399: gme_batch_header gh
400: WHERE gl.material_detail_id = p_batch_line_id
401: and gl.batch_id = gh.batch_id;
402:
403: CURSOR CSR_for_so_line(p_so_line_id IN NUMBER) IS

Line 433: FROM mtl_reservations mr, gme_batch_header gbh

429: */
430: Cursor check_mul_line_id1 (p_user_id IN number
431: , p_batch_id IN NUMBER) IS
432: SELECT DISTINCT orig_demand_source_line_id
433: FROM mtl_reservations mr, gme_batch_header gbh
434: WHERE mr.created_by = p_user_id
435: AND mr.orig_supply_source_header_id = p_batch_id
436: AND mr.orig_supply_source_header_id = gbh.batch_id
437: AND mr.organization_id = gbh.organization_id

Line 1894: p_batch_header_rec IN gme_batch_header%ROWTYPE

1890:
1891: END delete_prod_supply_resv;
1892:
1893: PROCEDURE delete_batch_prod_supply_resv (
1894: p_batch_header_rec IN gme_batch_header%ROWTYPE
1895: ,x_msg_count OUT NOCOPY NUMBER
1896: ,x_msg_data OUT NOCOPY VARCHAR2
1897: ,x_return_status OUT NOCOPY VARCHAR2)
1898: IS