APPS.PON_CLO_RENUMBER_PKG dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 392: lines_tbl_name := 'PON_AUCTION_ITEM_PRICES_ALL';

388: IS
389:
390: BEGIN
391: IF product = 'PON' THEN
392: lines_tbl_name := 'PON_AUCTION_ITEM_PRICES_ALL';
393: header_col := 'AUCTION_HEADER_ID';
394: lineid_col := 'LINE_NUMBER';
395: exhibit_col := 'EXHIBIT_NUMBER';
396: RETURN;

Line 541: pon_auction_item_prices_all where auction_header_id = p_Document_ID

537: INTO lineNumber
538: FROM
539: (SELECT pon_clo_renumber_pkg.ELIN_TO_DECIMAL(SubStr(line_num_display,exhibit_len+1,4-exhibit_len)) elin_decimal
540: FROM
541: pon_auction_item_prices_all where auction_header_id = p_Document_ID
542: and exhibit_number = p_exhibit_number AND line_num_display IS NOT null order by elin_decimal)
543: WHERE ELIN_DECIMAL=rownum;
544:
545:

Line 1222: from pon_auction_item_prices_all

1218: l_clinNum Number;
1219: begin
1220:
1221: select nvl(clm_info_flag,'N'),group_line_id into l_infoFlag,l_clinNum
1222: from pon_auction_item_prices_all
1223: where auction_header_id = p_auction_header_id
1224: and line_number = p_line_number;
1225:
1226: if ( l_clinNum is not null ) then

Line 1229: from pon_auction_item_prices_all

1225:
1226: if ( l_clinNum is not null ) then
1227:
1228: select line_num_display into l_clinNumDsp
1229: from pon_auction_item_prices_all
1230: where auction_header_id = p_auction_header_id
1231: and line_number = l_clinNum;
1232:
1233: l_lineNum := getnextslinnumber('PON',p_auction_header_id,l_clinNumDsp,l_infoFlag);

Line 1235: update pon_auction_item_prices_all

1231: and line_number = l_clinNum;
1232:
1233: l_lineNum := getnextslinnumber('PON',p_auction_header_id,l_clinNumDsp,l_infoFlag);
1234:
1235: update pon_auction_item_prices_all
1236: set line_num_display = l_lineNum
1237: where auction_header_id = p_auction_header_id
1238: and line_number = p_line_number;
1239:

Line 1425: ' FROM pon_auction_item_prices_all WHERE AUCTION_HEADER_ID = '|| p_auction_id ||

1421: || ' where group_line_id is null and ' || doc_id_col || ' = ' || p_bid_number
1422: || ' and auction_line_number = -1 ' || ' union ' ||
1423: ' SELECT LPad(To_Char(LEVEL),4,0) FROM dual '||
1424: ' CONNECT BY LEVEL <= (SELECT to_NUMBER(Max(line_num_display)) '||
1425: ' FROM pon_auction_item_prices_all WHERE AUCTION_HEADER_ID = '|| p_auction_id ||
1426: ' AND GROUP_LINE_ID is null and exhibit_number is null)' ;
1427:
1428: EXECUTE IMMEDIATE line_num_tbl_qry BULK COLLECT INTO tbl;
1429: