eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_CONTERMS_UTL_GRP dependencies on PON_AUCTION_ITEM_PRICES_ALL

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

1186: l_api_version NUMBER := 1;
1187: l_api_name VARCHAR2(30) := 'GET_ITEM_CATEGORY';
1188: l_auction_header_id pon_auction_headers_all.auction_header_id%type;
1189: l_index NUMBER;
1190: TYPE category_tbl IS TABLE OF pon_auction_item_prices_all.category_name%TYPE;
1191: l_category_tbl category_tbl;
1192: TYPE item_tbl IS TABLE OF pon_auction_item_prices_all.item_number%TYPE;
1193: l_item_tbl item_tbl;
1194: BEGIN

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

1188: l_auction_header_id pon_auction_headers_all.auction_header_id%type;
1189: l_index NUMBER;
1190: TYPE category_tbl IS TABLE OF pon_auction_item_prices_all.category_name%TYPE;
1191: l_category_tbl category_tbl;
1192: TYPE item_tbl IS TABLE OF pon_auction_item_prices_all.item_number%TYPE;
1193: l_item_tbl item_tbl;
1194: BEGIN
1195: -- Initialize API return status to unexpected error
1196: x_category_tbl.delete();

Line 1232: pon_auction_item_prices_all paip

1228: paip.category_name
1229: bulk collect into
1230: l_category_tbl
1231: from
1232: pon_auction_item_prices_all paip
1233: where
1234: paip.auction_header_id = l_auction_header_id
1235: and paip.category_name is not null;
1236: exception

Line 1260: pon_auction_item_prices_all paip

1256: paip.item_number
1257: bulk collect into
1258: l_item_tbl
1259: from
1260: pon_auction_item_prices_all paip
1261: where
1262: paip.auction_header_id = l_auction_header_id
1263: and paip.item_number is not null;
1264: exception