APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on PON_ITEM_PRICES_INTERFACE

Line 409: pon_item_prices_interface ip,

405: pet.enabled_flag selected_enabled_flag
406:
407: FROM
408: pon_auc_price_elements_int pape,
409: pon_item_prices_interface ip,
410: pon_price_element_types pet
411:
412: WHERE
413: pape.batch_id = p_batch_id

Line 1221: pon_item_prices_interface ip

1217: pon_price_elements pe,
1218: pon_price_element_types pet,
1219: pon_price_element_types_tl petl,
1220: fnd_lookups fl,
1221: pon_item_prices_interface ip
1222: where
1223: ip.batch_id = p_batch_id
1224: and pe.auction_header_id = p_auction_template_id
1225: and pe.price_element_type_id = pet.price_element_type_id

Line 1314: pon_item_prices_interface ip

1310: att.attr_group_seq_number,
1311: att.attr_disp_seq_number
1312: from
1313: pon_auction_attributes att,
1314: pon_item_prices_interface ip
1315: where
1316: ip.batch_id = p_batch_id
1317: and att.line_number <> -1
1318: and ip.group_type <> 'GROUP'

Line 1541: FROM pon_item_prices_interface

1537: l_max_ip_seq_num NUMBER;
1538:
1539: CURSOR lines IS
1540: SELECT interface_line_id, auction_header_id, auction_line_number, ip_category_id
1541: FROM pon_item_prices_interface
1542: WHERE batch_id = p_batch_id and
1543: nvl(action, '+') = '+';
1544:
1545:

Line 1635: FROM pon_item_prices_interface

1631: -- updated lines where the ip category has changed and is not null;
1632:
1633: CURSOR lines IS
1634: SELECT interface_line_id, auction_header_id, auction_line_number, ip_category_id
1635: FROM pon_item_prices_interface
1636: WHERE batch_id = p_batch_id and
1637: nvl(action, '+') = '#' and
1638: auction_line_number in (select paip.line_number
1639: from pon_item_prices_interface p1,

Line 1639: from pon_item_prices_interface p1,

1635: FROM pon_item_prices_interface
1636: WHERE batch_id = p_batch_id and
1637: nvl(action, '+') = '#' and
1638: auction_line_number in (select paip.line_number
1639: from pon_item_prices_interface p1,
1640: pon_auction_item_prices_all paip
1641: where p1.batch_id = p_batch_id and
1642: nvl(p1.action, '+') = '#' and
1643: p1.auction_header_id = paip.auction_header_id and

Line 1655: from pon_item_prices_interface p1,

1651: delete from
1652: (select *
1653: from pon_auc_attributes_interface
1654: where auction_line_number in (select paip.line_number
1655: from pon_item_prices_interface p1,
1656: pon_auction_item_prices_all paip
1657: where p1.batch_id = p_batch_id and
1658: nvl(p1.action, '+') = '#' and
1659: p1.auction_header_id = paip.auction_header_id and