669:
670: /* CASE 2b - site being merged is not the last site
671:
672: Followling table will be updated while merging at Vendor level.
673: 1. pon_bid_item_prices
674: 2. pon_bid_headers
675: 3. pon_bidding_parties
676: 4. pon_party_line_exclusions
677: 5. pon_pf_supplier_formula
679:
680: l_progress := 500;
681: fnd_file.put_line (fnd_file.log, l_progress|| ' Start : MERGE_DIFF_VENDOR_AND_SITE');
682:
683: UPDATE pon_bid_item_prices pbip1
684: SET pbip1.bid_trading_partner_id = p_trading_partner_id,
685: pbip1.last_updated_by = -1,
686: pbip1.last_update_date = sysdate
687: WHERE pbip1.bid_trading_partner_id = p_dup_trading_partner_id
699: AND pbh2.trading_partner_contact_id = pbh1.trading_partner_contact_id)
700: );
701:
702: l_progress := 501;
703: fnd_file.put_line (fnd_file.log, l_progress|| ' Done: pon_bid_item_prices ');
704:
705: UPDATE pon_bid_headers pbh1
706: SET pbh1.trading_partner_id = p_trading_partner_id,
707: pbh1.trading_partner_name = p_trading_partner_name,
843: /* CASE 2a - site being merged is the last site
844:
845: Followling table will be updated while merging last site
846:
847: 1. pon_bid_item_prices
848: 2. pon_bid_headers
849: 3. pon_bidding_parties
850: 4. pon_party_line_exclusions
851: 5. pon_pf_supplier_formula
859:
860: l_progress := 701;
861: fnd_file.put_line (fnd_file.log, l_progress|| 'Start : MERGE_DIFF_VENDOR_LAST_SITE ');
862:
863: UPDATE pon_bid_item_prices pbip1
864: SET pbip1.bid_trading_partner_id = p_trading_partner_id,
865: pbip1.last_updated_by = -1,
866: pbip1.last_update_date = sysdate
867: WHERE pbip1.bid_trading_partner_id = p_dup_trading_partner_id
880: );
881:
882:
883: l_progress := 702;
884: fnd_file.put_line (fnd_file.log, l_progress|| 'Done pon_bid_item_prices ');
885:
886: UPDATE pon_acknowledgements
887: SET trading_partner_id = p_trading_partner_id,
888: last_updated_by = -1,