APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_AUCTION_ATTRIBUTES

Line 2966: FROM PON_AUCTION_ATTRIBUTES,

2962:
2963: (SELECT COUNT(ATTRIBUTE_NAME) C2,
2964: AUCTION_HEADER_ID,
2965: LINE_NUMBER
2966: FROM PON_AUCTION_ATTRIBUTES,
2967: FND_LOOKUP_VALUES
2968: WHERE
2969: LOOKUP_TYPE = 'PON_LINE_ATTRIBUTE_GROUPS'
2970: AND (ENABLED_FLAG = 'N'

Line 3321: from pon_auction_attributes

3317: p_source_doctype_id <> p_doctype_id) THEN
3318:
3319: select decode(count(attribute_name), 0, 'N', 'Y')
3320: into l_has_descriptors
3321: from pon_auction_attributes
3322: where auction_header_id = p_source_auction_header_id and
3323: line_number = l_line_number(x) and
3324: ip_category_id is not null and
3325: rownum = 1;

Line 3910: FROM PON_AUCTION_ATTRIBUTES P

3906: 'N' AS IS_OBSOLETE_ATTRIBUTE,
3907: P.SECTION_NAME,
3908: P.KNOCKOUT_SCORE,
3909: P.SCORING_METHOD
3910: FROM PON_AUCTION_ATTRIBUTES P
3911: WHERE P.AUCTION_HEADER_ID = p_source_auction_header_id
3912: AND P.ATTR_LEVEL = 'HEADER'
3913: AND g_neg_style_control.hdr_attribute_enabled_flag = 'Y'
3914: --copy the header attributes only once

Line 3949: INTO PON_AUCTION_ATTRIBUTES

3945: END LOOP;
3946:
3947: FORALL x IN 1..l_attribute_name.COUNT
3948: INSERT
3949: INTO PON_AUCTION_ATTRIBUTES
3950: (AUCTION_HEADER_ID,
3951: LINE_NUMBER,
3952: ATTRIBUTE_NAME,
3953: DESCRIPTION,

Line 4255: FROM PON_AUCTION_ATTRIBUTES P,

4251: DECODE(NVL(COUNT(LOOKUP_CODE),0),0,'N','Y') IS_OBSOLETE_ATTRIBUTE,
4252: P.SECTION_NAME,
4253: P.KNOCKOUT_SCORE,
4254: P.SCORING_METHOD
4255: FROM PON_AUCTION_ATTRIBUTES P,
4256: (SELECT LOOKUP_CODE
4257: FROM FND_LOOKUPS
4258: WHERE LOOKUP_TYPE = 'PON_LINE_ATTRIBUTE_GROUPS'
4259: AND (ENABLED_FLAG = 'N'

Line 4347: INTO PON_AUCTION_ATTRIBUTES

4343: END LOOP;
4344:
4345: FORALL x IN 1..l_attribute_name.COUNT
4346: INSERT
4347: INTO PON_AUCTION_ATTRIBUTES
4348: (AUCTION_HEADER_ID,
4349: LINE_NUMBER,
4350: ATTRIBUTE_NAME,
4351: DESCRIPTION,

Line 4431: DELETE FROM pon_auction_attributes paa

4427: p_copy_type in (g_active_neg_copy, g_draft_neg_copy) and
4428: p_doctype_id <> g_rfi_doctype_id) THEN
4429:
4430:
4431: DELETE FROM pon_auction_attributes paa
4432: WHERE paa.auction_header_id = p_auction_header_id and
4433: paa.attr_level = 'LINE' and
4434: paa.ip_category_id is not null and
4435: not exists (select null

Line 4442: UPDATE pon_auction_attributes paa

4438: attribute_id = paa.ip_descriptor_id and
4439: language = userenv('LANG'));
4440:
4441:
4442: UPDATE pon_auction_attributes paa
4443: SET attribute_name = (select attribute_name
4444: from icx_cat_agreement_attrs_v
4445: where rt_category_id = paa.ip_category_id and
4446: attribute_id = paa.ip_descriptor_id and

Line 4512: PON_AUCTION_ATTRIBUTES paa

4508: p_user_id, -- CREATED_BY
4509: SYSDATE, -- LAST_UPDATE_DATE
4510: p_user_id -- LAST_UPDATED_BY
4511: FROM PON_ATTRIBUTE_SCORES pas,
4512: PON_AUCTION_ATTRIBUTES paa
4513: WHERE pas.AUCTION_HEADER_ID = p_source_auction_header_id
4514: AND pas.auction_header_id = paa.auction_header_id
4515: AND pas.line_number = paa.line_number
4516: AND paa.attr_level = 'HEADER'

Line 4592: PON_AUCTION_ATTRIBUTES paa

4588: p_user_id, -- CREATED_BY
4589: SYSDATE, -- LAST_UPDATE_DATE
4590: p_user_id -- LAST_UPDATED_BY
4591: FROM PON_ATTRIBUTE_SCORES pas,
4592: PON_AUCTION_ATTRIBUTES paa
4593: WHERE pas.AUCTION_HEADER_ID = p_source_auction_header_id
4594: AND pas.auction_header_id = paa.auction_header_id
4595: AND pas.line_number = paa.line_number
4596: AND paa.attr_level = 'LINE'

Line 9097: from pon_auction_attributes

9093:
9094: DELETE FROM pon_attribute_scores pas
9095: WHERE pas.auction_header_id = l_auction_header_id and
9096: not exists (select null
9097: from pon_auction_attributes
9098: where auction_header_id = pas.auction_header_id and
9099: line_number = pas.line_number and
9100: sequence_number = pas.attribute_sequence_number);
9101:

Line 10824: delete from pon_auction_attributes

10820: if (l_delete_count > 0) then -- {
10821:
10822: g_line_deleted := 'Y';
10823:
10824: delete from pon_auction_attributes
10825: where auction_header_id = p_auction_header_id
10826: and line_number in
10827: (select ip.line_number
10828: from pon_auction_item_prices_all ip