APPS.PON_TCA_MERGE_PVT dependencies on PON_AUCTION_SUMMARY

Line 4480: -- merge for Sourcing PON_AUCTION_SUMMARY entity.

4476: -- Pre-reqs : Award Summary records with the given trading_partner_contact_id
4477: -- (p_From_FK_id) must exists in the database
4478: --
4479: -- Function : This procedure will be attached to the TRADING_PARTNER_CONTACT_ID
4480: -- merge for Sourcing PON_AUCTION_SUMMARY entity.
4481: --
4482: -- It will veto Party Merge if -
4483: -- p_From_FK_id and p_To_FK_id both are not Seller user party
4484: --

Line 4485: -- This will merge the all the PON_AUCTION_SUMMARY records

4481: --
4482: -- It will veto Party Merge if -
4483: -- p_From_FK_id and p_To_FK_id both are not Seller user party
4484: --
4485: -- This will merge the all the PON_AUCTION_SUMMARY records
4486: -- having TRADING_PARTNER_CONTACT_ID equals to p_From_FK_id
4487: -- to party id having value (p_To_FK_id)
4488: --
4489: -- Parameters:

Line 4569: -- PON_AUCTION_SUMMARY.TRADING_PARTNER_CONTACT_ID

4565: IF (l_merge_scenario = G_BUYER OR l_merge_scenario = G_INCOMPATIBLE) THEN
4566: fnd_file.put_line (fnd_file.log, '20 : Buyer or Incompatible Merge - Error');
4567: --
4568: -- This can not happen in any normal scenario as
4569: -- PON_AUCTION_SUMMARY.TRADING_PARTNER_CONTACT_ID
4570: -- can never contain a buyer user id. Thus, raising a veto though
4571: -- it will possibly never be called
4572: --
4573: FND_MESSAGE.SET_NAME('AR', 'PON_TCA_MRG_ERR'); -- Need to put some Sourcing Specific Error Message

Line 4588: UPDATE PON_AUCTION_SUMMARY

4584:
4585: --
4586: -- NOTE: The table does not have WHO columns
4587: --
4588: UPDATE PON_AUCTION_SUMMARY
4589: SET TRADING_PARTNER_CONTACT_ID = p_To_FK_id
4590: WHERE TRADING_PARTNER_CONTACT_ID = p_From_FK_id;
4591:
4592: fnd_file.put_line (fnd_file.log, '50 : Seller Merge - Updated TRADING_PARTNER_CONTACT_IDs in PON_AUCTION_SUMMARY: '||sql%rowcount||' rows');

Line 4592: fnd_file.put_line (fnd_file.log, '50 : Seller Merge - Updated TRADING_PARTNER_CONTACT_IDs in PON_AUCTION_SUMMARY: '||sql%rowcount||' rows');

4588: UPDATE PON_AUCTION_SUMMARY
4589: SET TRADING_PARTNER_CONTACT_ID = p_To_FK_id
4590: WHERE TRADING_PARTNER_CONTACT_ID = p_From_FK_id;
4591:
4592: fnd_file.put_line (fnd_file.log, '50 : Seller Merge - Updated TRADING_PARTNER_CONTACT_IDs in PON_AUCTION_SUMMARY: '||sql%rowcount||' rows');
4593:
4594: ELSIF (l_merge_scenario = G_IRRELEVANT) THEN
4595: --
4596: -- Nothing to do