APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_AUCTION_ATTRIBUTES

Line 3856: FROM PON_AUCTION_ATTRIBUTES,

3852:
3853: (SELECT COUNT(ATTRIBUTE_NAME) C2,
3854: AUCTION_HEADER_ID,
3855: LINE_NUMBER
3856: FROM PON_AUCTION_ATTRIBUTES,
3857: FND_LOOKUP_VALUES
3858: WHERE
3859: LOOKUP_TYPE = 'PON_LINE_ATTRIBUTE_GROUPS'
3860: AND (ENABLED_FLAG = 'N'

Line 4220: from pon_auction_attributes

4216: p_source_doctype_id <> p_doctype_id) THEN
4217:
4218: select decode(count(attribute_name), 0, 'N', 'Y')
4219: into l_has_descriptors
4220: from pon_auction_attributes
4221: where auction_header_id = p_source_auction_header_id and
4222: line_number = l_line_number(x) and
4223: ip_category_id is not null and
4224: rownum = 1;

Line 4957: FROM PON_AUCTION_ATTRIBUTES P

4953: 'N' AS IS_OBSOLETE_ATTRIBUTE,
4954: P.SECTION_NAME,
4955: P.KNOCKOUT_SCORE,
4956: P.SCORING_METHOD
4957: FROM PON_AUCTION_ATTRIBUTES P
4958: WHERE P.AUCTION_HEADER_ID = p_source_auction_header_id
4959: AND P.ATTR_LEVEL = 'HEADER'
4960: AND g_neg_style_control.hdr_attribute_enabled_flag = 'Y'
4961: --copy the header attributes only once

Line 4996: INTO PON_AUCTION_ATTRIBUTES

4992: END LOOP;
4993:
4994: FORALL x IN 1..l_attribute_name.COUNT
4995: INSERT
4996: INTO PON_AUCTION_ATTRIBUTES
4997: (AUCTION_HEADER_ID,
4998: LINE_NUMBER,
4999: ATTRIBUTE_NAME,
5000: DESCRIPTION,

Line 5302: FROM PON_AUCTION_ATTRIBUTES P,

5298: DECODE(NVL(COUNT(LOOKUP_CODE),0),0,'N','Y') IS_OBSOLETE_ATTRIBUTE,
5299: P.SECTION_NAME,
5300: P.KNOCKOUT_SCORE,
5301: P.SCORING_METHOD
5302: FROM PON_AUCTION_ATTRIBUTES P,
5303: (SELECT LOOKUP_CODE
5304: FROM FND_LOOKUPS
5305: WHERE LOOKUP_TYPE = 'PON_LINE_ATTRIBUTE_GROUPS'
5306: AND (ENABLED_FLAG = 'N'

Line 5394: INTO PON_AUCTION_ATTRIBUTES

5390: END LOOP;
5391:
5392: FORALL x IN 1..l_attribute_name.COUNT
5393: INSERT
5394: INTO PON_AUCTION_ATTRIBUTES
5395: (AUCTION_HEADER_ID,
5396: LINE_NUMBER,
5397: ATTRIBUTE_NAME,
5398: DESCRIPTION,

Line 5478: DELETE FROM pon_auction_attributes paa

5474: p_copy_type in (g_active_neg_copy, g_draft_neg_copy) and
5475: p_doctype_id <> g_rfi_doctype_id) THEN
5476:
5477:
5478: DELETE FROM pon_auction_attributes paa
5479: WHERE paa.auction_header_id = p_auction_header_id and
5480: paa.attr_level = 'LINE' and
5481: paa.ip_category_id is not null and
5482: not exists (select null

Line 5489: UPDATE pon_auction_attributes paa

5485: attribute_id = paa.ip_descriptor_id and
5486: language = userenv('LANG'));
5487:
5488:
5489: UPDATE pon_auction_attributes paa
5490: SET attribute_name = (select attribute_name
5491: from icx_cat_agreement_attrs_v
5492: where rt_category_id = paa.ip_category_id and
5493: attribute_id = paa.ip_descriptor_id and

Line 5559: PON_AUCTION_ATTRIBUTES paa

5555: p_user_id, -- CREATED_BY
5556: SYSDATE, -- LAST_UPDATE_DATE
5557: p_user_id -- LAST_UPDATED_BY
5558: FROM PON_ATTRIBUTE_SCORES pas,
5559: PON_AUCTION_ATTRIBUTES paa
5560: WHERE pas.AUCTION_HEADER_ID = p_source_auction_header_id
5561: AND pas.auction_header_id = paa.auction_header_id
5562: AND pas.line_number = paa.line_number
5563: AND paa.attr_level = 'HEADER'

Line 5639: PON_AUCTION_ATTRIBUTES paa

5635: p_user_id, -- CREATED_BY
5636: SYSDATE, -- LAST_UPDATE_DATE
5637: p_user_id -- LAST_UPDATED_BY
5638: FROM PON_ATTRIBUTE_SCORES pas,
5639: PON_AUCTION_ATTRIBUTES paa
5640: WHERE pas.AUCTION_HEADER_ID = p_source_auction_header_id
5641: AND pas.auction_header_id = paa.auction_header_id
5642: AND pas.line_number = paa.line_number
5643: AND paa.attr_level = 'LINE'

Line 10294: from pon_auction_attributes

10290:
10291: DELETE FROM pon_attribute_scores pas
10292: WHERE pas.auction_header_id = l_auction_header_id and
10293: not exists (select null
10294: from pon_auction_attributes
10295: where auction_header_id = pas.auction_header_id and
10296: line_number = pas.line_number and
10297: sequence_number = pas.attribute_sequence_number);
10298:

Line 12265: delete from pon_auction_attributes

12261: if (l_delete_count > 0) then -- {
12262:
12263: g_line_deleted := 'Y';
12264:
12265: delete from pon_auction_attributes
12266: where auction_header_id = p_auction_header_id
12267: and line_number in
12268: (select ip.line_number
12269: from pon_auction_item_prices_all ip