DBA Data[Home] [Help]

APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on PON_AUCTION_ATTRIBUTES

Line 1148: pon_auction_attributes paa

1144: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
1145: 'PON_REQUIREMENT_DUPLICATE_ATT',
1146: pai1.attribute_name
1147: from pon_auc_attributes_interface pai1,
1148: pon_auction_attributes paa
1149: where pai1.batch_id = p_batch_id
1150: and paa.auction_header_id = pai1.auction_header_id
1151: and pai1.auction_line_number = -1
1152: and paa.line_number = pai1.auction_line_number

Line 1313: pon_auction_attributes att,

1309: att.scoring_type,
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

Line 1498: l_default_attr_group pon_auction_attributes.attr_group%TYPE;

1494:
1495: l_tp_id NUMBER;
1496: l_auction_round_number NUMBER;
1497: l_amendment_number NUMBER;
1498: l_default_attr_group pon_auction_attributes.attr_group%TYPE;
1499: l_ip_attr_default_option VARCHAR2(10);
1500:
1501: BEGIN
1502:

Line 1665: from pon_auction_attributes paa

1661: paip.ip_category_id is not null and
1662: nvl(p1.ip_category_id, -1) <> nvl(paip.ip_category_id, -1))) paai
1663: where batch_id = p_batch_id and
1664: exists (select null
1665: from pon_auction_attributes paa
1666: where paa.auction_header_id = paai.auction_header_id and
1667: paa.line_number = paai.auction_line_number and
1668: upper(paa.attribute_name) = upper(paai.attribute_name) and
1669: paa.ip_category_id is not null and