123: WHERE requisition_line_id = p_line_id;
124: ELSIF p_product ='PON' THEN
125: SELECT Nvl(clm_info_flag,'N'),clm_funded_flag
126: INTO x_clm_info_flag, x_clm_funded_flag
127: FROM pon_auction_item_prices_all
128: WHERE line_number = p_line_id
129: AND auction_header_id = p_document_id;
130:
131:
162: WHERE requisition_line_id = p_line_id;
163: ELSIF p_product ='PON' THEN
164: /*SELECT LINE_NUM_DISPLAY
165: INTO l_line_num
166: FROM pon_auction_item_prices_all
167: WHERE line_number = p_line_id
168: AND auction_header_id = p_document_id;*/
169: l_line_num := p_line_id;
170:
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
223: AND auction_header_id = p_document_id);
224:
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);
282:
283:
322: WHERE requisition_line_id = p_group_line_id;
323: ELSIF p_product = 'PON' THEN
324: SELECT group_line_id
325: INTO l_group_line_id
326: FROM pon_auction_item_prices_all
327: WHERE auction_header_id = p_document_id
328: AND line_number = p_group_line_id;
329: ELSIF p_product = 'PON BID' THEN
330: SELECT group_line_id