[Home] [Help]
7736: END HAS_NEED_TO_COPY_MEMBER;
7737: --} End of HAS_NEED_TO_COPY_MEMBER
7738:
7739: --
7740: -- Procedure to blindly copy the PON_PARTY_LINE_EXCLUSIONS data.
7741: -- It does not have any business logic as of now. So, it is a blind copy.
7742: --
7743: PROCEDURE COPY_PARTY_LINE_EXCLUSIONS (
7744: p_source_auction_header_id IN NUMBER,
7754:
7755: --
7756: -- join on pbp.sequence to exclude inactive, rejected suppliers from getting copied over
7757: --
7758: INSERT INTO PON_PARTY_LINE_EXCLUSIONS
7759: ( AUCTION_HEADER_ID,
7760: TRADING_PARTNER_ID,
7761: VENDOR_SITE_ID,
7762: LINE_NUMBER,
7776: SYSDATE, -- LAST_UPDATE_DATE
7777: p_user_id, -- LAST_UPDATED_BY
7778: p_user_id, -- LAST_UPDATE_LOGIN
7779: ple.SEQUENCE_NUMBER
7780: FROM PON_PARTY_LINE_EXCLUSIONS ple, pon_bidding_parties pbp
7781: WHERE ple.AUCTION_HEADER_ID = p_source_auction_header_id
7782: AND ple.line_number >= p_from_line_number
7783: AND ple.line_number <= p_to_line_number
7784: AND pbp.auction_header_id = p_auction_header_id
10077:
10078: g_err_loc := '8. After Copying Price Elements';
10079:
10080:
10081: LOG_MESSAGE('copy_lines_and_children','Copy PON_PARTY_LINE_EXCLUSIONS table data is starting;' ||
10082: 'g_neg_style_control.rfi_line_enabled_flag : ' || g_neg_style_control.rfi_line_enabled_flag ||
10083: 'p_doctype_id : ' || p_doctype_id ||
10084: 'IS_LARGE_SOURCE : ' || IS_LARGE_SOURCE ||
10085: 'IS_LARGE_DESTINATION : ' || IS_LARGE_DESTINATION);
10084: 'IS_LARGE_SOURCE : ' || IS_LARGE_SOURCE ||
10085: 'IS_LARGE_DESTINATION : ' || IS_LARGE_DESTINATION);
10086:
10087: --
10088: -- Here comes the Lot based bidding project related table PON_PARTY_LINE_EXCLUSIONS
10089: --
10090: --Do not copy party exclusions in case of either the source or the destination auction being a large one
10091: IF ( (g_neg_style_control.rfi_line_enabled_flag = 'Y' or p_doctype_id <> g_rfi_doctype_id) and
10092: IS_LARGE_SOURCE <> 'Y' and IS_LARGE_DESTINATION <> 'Y') THEN
10106: LOG_MESSAGE('copy_lines_and_children','Party exclusions are not allowed');
10107:
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: --
12328: or p_group_enabled = 'N'
12329: and ip.group_type in ('GROUP', 'GROUP_LINE')));
12330:
12331:
12332: delete from pon_party_line_exclusions
12333: where auction_header_id = p_auction_header_id
12334: and line_number in
12335: (select ip.line_number
12336: from pon_auction_item_prices_all ip