APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PON_AUCTION_ATTRIBUTES

Line 1294: PON_AUCTION_ATTRIBUTES

1290: p_bid_ranking = 'MULTI_ATTRIBUTE_SCORING' AND
1291: EXISTS(
1292: SELECT 1
1293: FROM
1294: PON_AUCTION_ATTRIBUTES
1295: WHERE
1296: AUCTION_HEADER_ID = p_auction_header_id
1297: AND LINE_NUMBER = sel_line_number
1298: AND (NVL (SCORING_TYPE,g_invalid_string)='RANGE' OR NVL (SCORING_TYPE,g_invalid_string)='LOV')

Line 1304: PON_AUCTION_ATTRIBUTES

1300: (
1301: SELECT
1302: SUM(weight)
1303: FROM
1304: PON_AUCTION_ATTRIBUTES
1305: WHERE
1306: AUCTION_HEADER_ID = p_auction_header_id
1307: AND LINE_NUMBER = sel_line_number) <> 100
1308: )

Line 2328: PON_AUCTION_ATTRIBUTES PAA,

2324: TRUNC (PAA.ATTR_MAX_SCORE) sel_trunc_attr_max_score,
2325: PAIP.DOCUMENT_DISP_LINE_NUMBER sel_document_disp_line_number,
2326: PAA.SCORING_TYPE sel_scoring_type
2327: FROM
2328: PON_AUCTION_ATTRIBUTES PAA,
2329: PON_AUCTION_ITEM_PRICES_ALL PAIP
2330: WHERE
2331: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
2332: PAA.AUCTION_HEADER_ID = p_auction_header_id AND

Line 2391: PON_AUCTION_ATTRIBUTES

2387: p_user_id, -- LAST_UPDATED_BY
2388: sysdate, -- LAST_UPDATE_DATE
2389: p_login_id -- LAST_UPDATE_LOGIN
2390: FROM
2391: PON_AUCTION_ATTRIBUTES
2392: WHERE
2393: ATTR_LEVEL='LINE' AND
2394: AUCTION_HEADER_ID=p_auction_header_id
2395: GROUP by AUCTION_HEADER_ID, LINE_NUMBER, attribute_name

Line 6323: FROM PON_AUCTION_ATTRIBUTES

6319: PON_AUCTION_ITEM_PRICES_ALL PAIP
6320: SET
6321: HAS_ATTRIBUTES_FLAG = NVL(
6322: (SELECT 'Y'
6323: FROM PON_AUCTION_ATTRIBUTES
6324: WHERE AUCTION_HEADER_ID = p_auction_header_id
6325: AND LINE_NUMBER = PAIP.LINE_NUMBER
6326: AND ROWNUM = 1), 'N'),
6327: HAS_SHIPMENTS_FLAG = NVL (

Line 7068: FROM PON_AUCTION_ATTRIBUTES

7064:
7065: -- If the line has any attributes this flag will be Y else N
7066: has_attributes_flag = NVL(
7067: (SELECT 'Y'
7068: FROM PON_AUCTION_ATTRIBUTES
7069: WHERE AUCTION_HEADER_ID = p_auction_header_id
7070: AND LINE_NUMBER = PAIP.LINE_NUMBER
7071: AND ROWNUM = 1), 'N'),
7072:

Line 7129: FROM PON_AUCTION_ATTRIBUTES

7125: -- Is quantity scored flag is set to Y in case quantity there is a line
7126: -- attribute for quantity (sequence_number = QUANTITY_SEQ_NUMBER
7127: is_quantity_scored = NVL (
7128: (SELECT 'Y'
7129: FROM PON_AUCTION_ATTRIBUTES
7130: WHERE AUCTION_HEADER_ID = p_auction_header_id
7131: AND LINE_NUMBER = PAIP.LINE_NUMBER
7132: AND SEQUENCE_NUMBER = -20
7133: AND ROWNUM = 1), 'N'),

Line 7139: FROM PON_AUCTION_ATTRIBUTES

7135: -- Is quantity need by date scored flag is set to Y in case there is a line
7136: -- attribute for need by date (sequence_number = NEED_BY_DATE_SEQ_NUMBER
7137: is_need_by_date_scored = NVL (
7138: (SELECT 'Y'
7139: FROM PON_AUCTION_ATTRIBUTES
7140: WHERE AUCTION_HEADER_ID = p_auction_header_id
7141: AND LINE_NUMBER = PAIP.LINE_NUMBER
7142: AND SEQUENCE_NUMBER = -10
7143: AND ROWNUM = 1), 'N'),

Line 7682: FROM PON_AUCTION_ATTRIBUTES

7678: --HAS_ATTRIBUTES_FLAG, HAS_PRICE_ELEMENTS_FLAG, HAS_PE_FOR_ALL_ITEMS
7679: BEGIN
7680: SELECT 'YES'
7681: INTO l_attributes_exist
7682: FROM PON_AUCTION_ATTRIBUTES
7683: WHERE AUCTION_HEADER_ID = p_auction_header_id
7684: AND ROWNUM = 1;
7685:
7686: EXCEPTION WHEN NO_DATA_FOUND THEN --{

Line 7694: FROM PON_AUCTION_ATTRIBUTES

7690: IF (l_attributes_exist = 'YES') THEN --{
7691: BEGIN
7692: SELECT 'BOTH'
7693: INTO l_attributes_exist
7694: FROM PON_AUCTION_ATTRIBUTES
7695: WHERE AUCTION_HEADER_ID = p_auction_header_id
7696: AND MANDATORY_FLAG = 'Y'
7697: AND ROWNUM = 1;
7698: