DBA Data[Home] [Help]

APPS.PON_UNSOL_CREATE_PO_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 198: l_language_code pon_auction_headers_all.language_code%TYPE;

194: l_cur_item_description pon_auction_item_prices_all.item_description%TYPE;
195: l_cur_ip_category_id NUMBER;
196: l_cur_item_id NUMBER;
197: l_cur_org_id NUMBER;
198: l_language_code pon_auction_headers_all.language_code%TYPE;
199:
200: l_po_attr_values_stmt VARCHAR2(32767);
201: l_po_attr_values_tlp_stmt VARCHAR2(32767);
202:

Line 224: pon_auction_headers_all pah,

220: icx.stored_in_column,
221: pbav.value,
222: paa.attribute_name
223: FROM pon_bid_item_prices pbip,
224: pon_auction_headers_all pah,
225: po_lines_interface pli,
226: pon_bid_attribute_values pbav,
227: pon_auction_attributes paa,
228: icx_cat_agreement_attrs_v icx

Line 259: from pon_auction_headers_all

255: BEGIN
256:
257: select language_code
258: into l_language_code
259: from pon_auction_headers_all
260: where auction_header_id = p_auction_header_id;
261:
262:
263: l_cursorName := DBMS_SQL.Open_Cursor;