APPS.POS_CLM_UTIL_PKG dependencies on DUAL

Line 199: FROM dual

195: -- l_line_num:= getlinenum(p_product,p_document_id,p_line_id);
196: IF p_product = 'PO' THEN
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));

Line 209: FROM dual

205: ELSIF p_product = 'ICX' THEN
206:
207: SELECT 'Y'
208: INTO l_flag
209: FROM dual
210: WHERE EXISTS (SELECT 'x'
211: FROM po_requisition_lines_all
212: WHERE CLM_BASE_LINE_NUM = p_line_id
213: AND REQUISITION_HEADER_ID=Nvl(p_document_id,REQUISITION_HEADER_ID));

Line 218: FROM dual

214:
215: ELSIF p_product = 'PON' THEN
216: SELECT 'Y'
217: INTO l_flag
218: FROM dual
219: WHERE EXISTS (SELECT 'x'
220: FROM pon_auction_item_prices_all
221: WHERE 1=1
222: AND CLM_BASE_LINE_NUM = p_line_id

Line 228: FROM dual

224:
225: ELSIF p_product = 'PON BID' THEN
226: SELECT 'Y'
227: INTO l_flag
228: FROM dual
229: WHERE EXISTS (SELECT 'x'
230: FROM pon_bid_item_prices
231: WHERE CLM_BASE_LINE_NUM = p_line_id
232: AND auction_header_id = p_document_id);

Line 257: FROM dual

253: BEGIN
254: IF p_product = 'PO' THEN
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:

Line 266: FROM dual

262:
263: ELSIF p_product = 'ICX' THEN
264: SELECT 'Y'
265: INTO l_flag
266: FROM dual
267: WHERE NOT EXISTS (SELECT 'x'
268: FROM po_requisition_lines_all
269: WHERE group_line_id = p_line_id);
270:

Line 277: FROM dual

273:
274: ELSIF p_product = 'PON' THEN
275: SELECT 'Y'
276: INTO l_flag
277: FROM dual
278: WHERE NOT EXISTS (SELECT 'x'
279: FROM pon_auction_item_prices_all
280: WHERE group_line_id = p_line_id
281: AND auction_header_id = p_document_id);

Line 288: FROM dual

284:
285: ELSIF p_product = 'PON BID' THEN
286: SELECT 'Y'
287: INTO l_flag
288: FROM dual
289: WHERE NOT EXISTS (SELECT 'x'
290: FROM pon_bid_item_prices
291: WHERE group_line_id = p_line_id
292: AND auction_header_id = p_document_id);

Line 609: FROM dual;

605: SELECT PO_CLM_CP_LABEL_EXT.getHintLabel(p_matching_basis,
606: p_contract_type,
607: p_idc_type)
608: INTO x_ext_price_label
609: FROM dual;
610: EXCEPTION WHEN OTHERS THEN
611: x_ext_price_label := NULL;
612: END;
613: