APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PON_AUCTION_ATTRIBUTES

Line 2072: PON_AUCTION_ATTRIBUTES

2068: p_bid_ranking = 'MULTI_ATTRIBUTE_SCORING' AND
2069: EXISTS(
2070: SELECT 1
2071: FROM
2072: PON_AUCTION_ATTRIBUTES
2073: WHERE
2074: AUCTION_HEADER_ID = p_auction_header_id
2075: AND LINE_NUMBER = sel_line_number
2076: AND (NVL (SCORING_TYPE,g_invalid_string)='RANGE' OR NVL (SCORING_TYPE,g_invalid_string)='LOV')

Line 2082: PON_AUCTION_ATTRIBUTES

2078: (
2079: SELECT
2080: SUM(weight)
2081: FROM
2082: PON_AUCTION_ATTRIBUTES
2083: WHERE
2084: AUCTION_HEADER_ID = p_auction_header_id
2085: AND LINE_NUMBER = sel_line_number) <> 100
2086: )

Line 3165: PON_AUCTION_ATTRIBUTES PAA,

3161: PAIP.DOCUMENT_DISP_LINE_NUMBER sel_document_disp_line_number,
3162: PAA.SCORING_TYPE sel_scoring_type,
3163: PAIP.LINE_NUM_DISPLAY sel_clm_line_num_display
3164: FROM
3165: PON_AUCTION_ATTRIBUTES PAA,
3166: PON_AUCTION_ITEM_PRICES_ALL PAIP
3167: WHERE
3168: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
3169: PAA.AUCTION_HEADER_ID = p_auction_header_id AND

Line 3228: PON_AUCTION_ATTRIBUTES

3224: p_user_id, -- LAST_UPDATED_BY
3225: sysdate, -- LAST_UPDATE_DATE
3226: p_login_id -- LAST_UPDATE_LOGIN
3227: FROM
3228: PON_AUCTION_ATTRIBUTES
3229: WHERE
3230: ATTR_LEVEL='LINE' AND
3231: AUCTION_HEADER_ID=p_auction_header_id
3232: GROUP by AUCTION_HEADER_ID, LINE_NUMBER, attribute_name

Line 7181: FROM PON_AUCTION_ATTRIBUTES

7177: PON_AUCTION_ITEM_PRICES_ALL PAIP
7178: SET
7179: HAS_ATTRIBUTES_FLAG = NVL(
7180: (SELECT 'Y'
7181: FROM PON_AUCTION_ATTRIBUTES
7182: WHERE AUCTION_HEADER_ID = p_auction_header_id
7183: AND LINE_NUMBER = PAIP.LINE_NUMBER
7184: AND ROWNUM = 1), 'N'),
7185: HAS_SHIPMENTS_FLAG = NVL (

Line 7959: FROM PON_AUCTION_ATTRIBUTES

7955:
7956: -- If the line has any attributes this flag will be Y else N
7957: has_attributes_flag = NVL(
7958: (SELECT 'Y'
7959: FROM PON_AUCTION_ATTRIBUTES
7960: WHERE AUCTION_HEADER_ID = p_auction_header_id
7961: AND LINE_NUMBER = PAIP.LINE_NUMBER
7962: AND ROWNUM = 1), 'N'),
7963:

Line 8020: FROM PON_AUCTION_ATTRIBUTES

8016: -- Is quantity scored flag is set to Y in case quantity there is a line
8017: -- attribute for quantity (sequence_number = QUANTITY_SEQ_NUMBER
8018: is_quantity_scored = NVL (
8019: (SELECT 'Y'
8020: FROM PON_AUCTION_ATTRIBUTES
8021: WHERE AUCTION_HEADER_ID = p_auction_header_id
8022: AND LINE_NUMBER = PAIP.LINE_NUMBER
8023: AND SEQUENCE_NUMBER = -20
8024: AND ROWNUM = 1), 'N'),

Line 8030: FROM PON_AUCTION_ATTRIBUTES

8026: -- Is quantity need by date scored flag is set to Y in case there is a line
8027: -- attribute for need by date (sequence_number = NEED_BY_DATE_SEQ_NUMBER
8028: is_need_by_date_scored = NVL (
8029: (SELECT 'Y'
8030: FROM PON_AUCTION_ATTRIBUTES
8031: WHERE AUCTION_HEADER_ID = p_auction_header_id
8032: AND LINE_NUMBER = PAIP.LINE_NUMBER
8033: AND SEQUENCE_NUMBER = -10
8034: AND ROWNUM = 1), 'N'),

Line 8573: FROM PON_AUCTION_ATTRIBUTES

8569: --HAS_ATTRIBUTES_FLAG, HAS_PRICE_ELEMENTS_FLAG, HAS_PE_FOR_ALL_ITEMS
8570: BEGIN
8571: SELECT 'YES'
8572: INTO l_attributes_exist
8573: FROM PON_AUCTION_ATTRIBUTES
8574: WHERE AUCTION_HEADER_ID = p_auction_header_id
8575: AND ROWNUM = 1;
8576:
8577: EXCEPTION WHEN NO_DATA_FOUND THEN --{

Line 8585: FROM PON_AUCTION_ATTRIBUTES

8581: IF (l_attributes_exist = 'YES') THEN --{
8582: BEGIN
8583: SELECT 'BOTH'
8584: INTO l_attributes_exist
8585: FROM PON_AUCTION_ATTRIBUTES
8586: WHERE AUCTION_HEADER_ID = p_auction_header_id
8587: AND MANDATORY_FLAG = 'Y'
8588: AND ROWNUM = 1;
8589: