APPS.PON_NEGOTIATION_COPY_GRP dependencies on PON_PF_SUPPLIER_VALUES

Line 7792: -- Procedure to blindly copy the PON_PF_SUPPLIER_VALUES data.

7788: END;
7789: -- } End of COPY_PARTY_LINE_EXCLUSIONS
7790:
7791: --
7792: -- Procedure to blindly copy the PON_PF_SUPPLIER_VALUES data.
7793: -- It does not have any business logic as of now. So, it is a blind copy.
7794: --
7795: PROCEDURE COPY_PF_SUPPLIER_VALUES (
7796: p_source_auction_header_id IN NUMBER,

Line 7805: -- { Start of PON_PF_SUPPLIER_VALUES

7801: p_from_line_number IN NUMBER,
7802: p_to_line_number IN NUMBER)
7803: IS
7804: BEGIN
7805: -- { Start of PON_PF_SUPPLIER_VALUES
7806:
7807: LOG_MESSAGE('copy negotiation','in COPY_PF_SUPPLIER_VALUES for '||p_source_auction_header_id||' to '||p_auction_header_id);
7808:
7809: --

Line 7819: INSERT INTO PON_PF_SUPPLIER_VALUES

7815: -- Copy all the price factor values EXCEPT
7816: -- where the price factor has become inactive
7817: -- join on pbp.sequence to exclude inactive, rejected suppliers from getting copied over
7818:
7819: INSERT INTO PON_PF_SUPPLIER_VALUES
7820: ( AUCTION_HEADER_ID,
7821: LINE_NUMBER,
7822: PF_SEQ_NUMBER,
7823: SUPPLIER_SEQ_NUMBER,

Line 7841: FROM PON_PF_SUPPLIER_VALUES PPSV,

7837: p_user_id, -- CREATED_BY
7838: SYSDATE, -- LAST_UPDATE_DATE
7839: p_user_id, -- LAST_UPDATED_BY
7840: p_user_id -- LAST_UPDATE_LOGIN
7841: FROM PON_PF_SUPPLIER_VALUES PPSV,
7842: PON_PRICE_ELEMENTS PPE,
7843: PON_PRICE_ELEMENT_TYPES_VL VL,
7844: PON_BIDDING_PARTIES PBP
7845: WHERE PPSV.AUCTION_HEADER_ID = p_source_auction_header_id AND

Line 10112: LOG_MESSAGE('copy_lines_and_children','Copy PON_PF_SUPPLIER_VALUES table data is starting');

10108: END IF;
10109:
10110: g_err_loc := '12. After Copying PON_PARTY_LINE_EXCLUSIONS data';
10111:
10112: LOG_MESSAGE('copy_lines_and_children','Copy PON_PF_SUPPLIER_VALUES table data is starting');
10113:
10114: --
10115: -- Here comes the Tranformation project related table PON_PF_SUPPLIER_VALUES
10116: --

Line 10115: -- Here comes the Tranformation project related table PON_PF_SUPPLIER_VALUES

10111:
10112: LOG_MESSAGE('copy_lines_and_children','Copy PON_PF_SUPPLIER_VALUES table data is starting');
10113:
10114: --
10115: -- Here comes the Tranformation project related table PON_PF_SUPPLIER_VALUES
10116: --
10117:
10118: --The values of CALL_COPY_PF_SUPPLIER_VALUES and CALL_PON_LRG_DRAFT_TO_ORD_PF
10119: --are set based on l_price_elements_allowed. So we need not check if

Line 10149: g_err_loc := '13. After Copying PON_PF_SUPPLIER_VALUES data';

10145: );
10146:
10147: end if;
10148:
10149: g_err_loc := '13. After Copying PON_PF_SUPPLIER_VALUES data';
10150:
10151: -- remove lots and groups if disabled by style
10152: -- this code is separated from main copy routines as this is a corner case.
10153: REMOVE_LOT_AND_GROUP (p_auction_header_id => l_auction_header_id,

Line 12346: delete from pon_pf_supplier_values

12342: or p_group_enabled = 'N'
12343: and ip.group_type in ('GROUP', 'GROUP_LINE')));
12344:
12345:
12346: delete from pon_pf_supplier_values
12347: where auction_header_id = p_auction_header_id
12348: and line_number in
12349: (select ip.line_number
12350: from pon_auction_item_prices_all ip

Line 12434: insert into pon_pf_supplier_values(

12430: if l_current_status = 'DRAFT' then
12431:
12432: LOG_MESSAGE('PON_LRG_DRAFT_TO_ORD_PF_COPY','inserting rows in pon_large_neg_pf_values for new auction : ' || p_destination_auction_hdr_id || ' whihc is getting copied from auction : ' || p_source_auction_hdr_id);
12433:
12434: insert into pon_pf_supplier_values(
12435: auction_header_id,
12436: line_number,
12437: pf_seq_number,
12438: supplier_seq_number,