APPS.PON_CONTERMS_UTL_GRP dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 1212: TYPE category_tbl IS TABLE OF pon_auction_item_prices_all.category_name%TYPE;

1208: l_api_version NUMBER := 1;
1209: l_api_name VARCHAR2(30) := 'GET_ITEM_CATEGORY';
1210: l_auction_header_id pon_auction_headers_all.auction_header_id%type;
1211: l_index NUMBER;
1212: TYPE category_tbl IS TABLE OF pon_auction_item_prices_all.category_name%TYPE;
1213: l_category_tbl category_tbl;
1214: TYPE item_tbl IS TABLE OF pon_auction_item_prices_all.item_number%TYPE;
1215: l_item_tbl item_tbl;
1216: BEGIN

Line 1214: TYPE item_tbl IS TABLE OF pon_auction_item_prices_all.item_number%TYPE;

1210: l_auction_header_id pon_auction_headers_all.auction_header_id%type;
1211: l_index NUMBER;
1212: TYPE category_tbl IS TABLE OF pon_auction_item_prices_all.category_name%TYPE;
1213: l_category_tbl category_tbl;
1214: TYPE item_tbl IS TABLE OF pon_auction_item_prices_all.item_number%TYPE;
1215: l_item_tbl item_tbl;
1216: BEGIN
1217: -- Initialize API return status to unexpected error
1218: x_category_tbl.delete();

Line 1254: pon_auction_item_prices_all paip

1250: paip.category_name
1251: bulk collect into
1252: l_category_tbl
1253: from
1254: pon_auction_item_prices_all paip
1255: where
1256: paip.auction_header_id = l_auction_header_id
1257: and paip.category_name is not null;
1258: exception

Line 1282: pon_auction_item_prices_all paip

1278: paip.item_number
1279: bulk collect into
1280: l_item_tbl
1281: from
1282: pon_auction_item_prices_all paip
1283: where
1284: paip.auction_header_id = l_auction_header_id
1285: and paip.item_number is not null;
1286: exception