APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on PON_AUCTION_ATTRIBUTES

Line 1153: pon_auction_attributes paa

1149: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
1150: 'PON_REQUIREMENT_DUPLICATE_ATT',
1151: pai1.attribute_name
1152: from pon_auc_attributes_interface pai1,
1153: pon_auction_attributes paa
1154: where pai1.batch_id = p_batch_id
1155: and paa.auction_header_id = pai1.auction_header_id
1156: and pai1.auction_line_number = -1
1157: and paa.line_number = pai1.auction_line_number

Line 1318: pon_auction_attributes att,

1314: att.scoring_type,
1315: att.attr_group_seq_number,
1316: att.attr_disp_seq_number
1317: from
1318: pon_auction_attributes att,
1319: pon_item_prices_interface ip
1320: where
1321: ip.batch_id = p_batch_id
1322: and att.line_number <> -1

Line 1503: l_default_attr_group pon_auction_attributes.attr_group%TYPE;

1499:
1500: l_tp_id NUMBER;
1501: l_auction_round_number NUMBER;
1502: l_amendment_number NUMBER;
1503: l_default_attr_group pon_auction_attributes.attr_group%TYPE;
1504: l_ip_attr_default_option VARCHAR2(10);
1505:
1506: BEGIN
1507:

Line 1670: from pon_auction_attributes paa

1666: paip.ip_category_id is not null and
1667: nvl(p1.ip_category_id, -1) <> nvl(paip.ip_category_id, -1))) paai
1668: where batch_id = p_batch_id and
1669: exists (select null
1670: from pon_auction_attributes paa
1671: where paa.auction_header_id = paai.auction_header_id and
1672: paa.line_number = paai.auction_line_number and
1673: upper(paa.attribute_name) = upper(paai.attribute_name) and
1674: paa.ip_category_id is not null and

Line 2540: pon_auction_attributes paa

2536: fnd_message.get_string('PON','PON_AUC_REQUIREMENT'),
2537: 'PON_REQUIREMENT_DUPLICATE_ATT',
2538: pai1.attribute_name
2539: from pon_auc_attributes_interface pai1,
2540: pon_auction_attributes paa
2541: where pai1.batch_id = p_batch_id
2542: and paa.auction_header_id = pai1.auction_header_id
2543: and pai1.auction_line_number = -1
2544: and paa.line_number = pai1.auction_line_number

Line 2624: --p_in_rec.l_SCORING_METHOD PON_AUCTION_ATTRIBUTES.SCORING_METHOD%TYPE,

2620: p_source VARCHAR2,
2621: p_batch_id NUMBER,
2622: p_party_id NUMBER,
2623: p_in_rec IN ATTRIBUTES_VALUES_VALIDATION,
2624: --p_in_rec.l_SCORING_METHOD PON_AUCTION_ATTRIBUTES.SCORING_METHOD%TYPE,
2625: x_return_status OUT NOCOPY VARCHAR
2626: )
2627: IS
2628: l_TABLE_NAME PON_INTERFACE_ERRORS.TABLE_NAME%TYPE :='PON_AUC_ATTRIBUTES_INTERFACE';

Line 2629: --p_in_rec.l_KNOCKOUT_SCORE PON_AUCTION_ATTRIBUTES.KNOCKOUT_SCORE%TYPE:=NULL;

2625: x_return_status OUT NOCOPY VARCHAR
2626: )
2627: IS
2628: l_TABLE_NAME PON_INTERFACE_ERRORS.TABLE_NAME%TYPE :='PON_AUC_ATTRIBUTES_INTERFACE';
2629: --p_in_rec.l_KNOCKOUT_SCORE PON_AUCTION_ATTRIBUTES.KNOCKOUT_SCORE%TYPE:=NULL;
2630: l_status NUMBER;
2631: BEGIN
2632: x_return_status := 'Y';
2633: /* If response type is optional we can allow only Manual or None scoring methods */