APPS.POS_CLM_UTIL_PKG dependencies on PO_LINES_DRAFT_ALL

Line 117: FROM po_lines_draft_all

113: BEGIN
114: IF p_product = 'PO' THEN
115: SELECT Nvl(clm_info_flag,'N'),clm_funded_flag
116: INTO x_clm_info_flag, x_clm_funded_flag
117: FROM po_lines_draft_all
118: WHERE po_line_id = p_line_id;
119: ELSIF p_product = 'ICX' THEN
120: SELECT Nvl(clm_info_flag,'N'),clm_funded_flag
121: INTO x_clm_info_flag, x_clm_funded_flag

Line 156: FROM po_lines_draft_all

152: BEGIN
153: IF p_product = 'PO' THEN
154: SELECT LINE_NUM --line_num_display
155: INTO l_line_num
156: FROM po_lines_draft_all
157: WHERE po_line_id = p_line_id;
158: ELSIF p_product = 'ICX' THEN
159: SELECT LINE_NUM
160: INTO l_line_num

Line 201: FROM po_lines_draft_all

197: SELECT 'Y'
198: INTO l_flag
199: FROM dual
200: WHERE EXISTS (SELECT 'x'
201: FROM po_lines_draft_all
202: WHERE CLM_BASE_LINE_NUM = p_line_id
203: AND PO_HEADER_ID=Nvl(p_document_id,PO_HEADER_ID));
204:
205: ELSIF p_product = 'ICX' THEN

Line 259: FROM po_lines_draft_all

255: SELECT 'Y'
256: INTO l_flag
257: FROM dual
258: WHERE NOT EXISTS (SELECT 'x'
259: FROM po_lines_draft_all
260: WHERE group_line_id = p_line_id);
261:
262:
263: ELSIF p_product = 'ICX' THEN

Line 316: FROM po_lines_draft_all

312: BEGIN
313: IF p_product = 'PO' THEN
314: SELECT group_line_id
315: INTO l_group_line_id
316: FROM po_lines_draft_all
317: WHERE po_line_id = p_group_line_id;
318: ELSIF p_product = 'ICX' THEN
319: SELECT group_line_id
320: INTO l_group_line_id