126: and line_type <> -1
127: ;
128: Cursor get_new_batch_cmpt_date (p_batch_id IN NUMBER) is
129: Select plan_cmplt_date
130: From gme_batch_header
131: where batch_id = p_batch_id;
132:
133: BEGIN
134: x_return_status := FND_API.G_RET_STS_SUCCESS;
997: and reserved_qty <> 0;
998:
999: CURSOR Get_batch_type(p_batch_id IN NUMBER) IS
1000: SELECT batch_type
1001: FROM gme_batch_header
1002: WHERE batch_id = p_batch_id;
1003:
1004:
1005: CURSOR So_line_id_for_batch_line(p_batch_line_id IN NUMBER) Is
1011:
1012: CURSOR get_batch_id_for_line(p_batch_line_id IN NUMBER) Is
1013: SELECT gl.batch_id,gh.batch_type
1014: FROM gme_material_details gl,
1015: gme_batch_header gh
1016: WHERE gl.material_detail_id = p_batch_line_id
1017: and gl.batch_id = gh.batch_id;
1018:
1019: