APPS.PON_TCA_MERGE_PVT dependencies on PON_AUCTION_EVENTS

Line 1327: -- merge for Sourcing PON_AUCTION_EVENTS entity.

1323: -- Pre-reqs : Negotiation Event with the given trading_partner_contact_id
1324: -- (p_From_FK_id) must exists in the database
1325: --
1326: -- Function : This procedure will be attached to the TRADING_PARTNER_CONTACT_ID
1327: -- merge for Sourcing PON_AUCTION_EVENTS entity.
1328: --
1329: -- It will veto Party Merge if -
1330: -- p_From_FK_id and p_To_FK_id both are not Buyer user party
1331: --

Line 1332: -- This will merge the all the PON_AUCTION_EVENTS records

1328: --
1329: -- It will veto Party Merge if -
1330: -- p_From_FK_id and p_To_FK_id both are not Buyer user party
1331: --
1332: -- This will merge the all the PON_AUCTION_EVENTS records
1333: -- having TRADING_PARTNER_CONTACT_ID equals to p_From_FK_id
1334: -- to party id having value (p_To_FK_id)
1335: --
1336: -- Parameters:

Line 1418: -- PON_AUCTION_EVENTS.TRADING_PARTNER_CONTACT_ID

1414:
1415: fnd_file.put_line (fnd_file.log, '20 : Seller Merge - Error');
1416: --
1417: -- This can not happen in any normal scenario as
1418: -- PON_AUCTION_EVENTS.TRADING_PARTNER_CONTACT_ID
1419: -- can never contain a seller user id. Thus, raising a veto though
1420: -- it will possibly never be called
1421: --
1422: FND_MESSAGE.SET_NAME('AR', 'PON_TCA_MRG_ERR'); -- Need to put some Sourcing Specific Error Message

Line 1444: UPDATE PON_AUCTION_EVENTS

1440: --
1441: -- there is no chance of unique key constraint violation
1442: -- due to the following updates
1443: --
1444: UPDATE PON_AUCTION_EVENTS
1445: SET TRADING_PARTNER_CONTACT_ID = p_To_FK_id,
1446: LAST_UPDATE_DATE = SYSDATE,
1447: LAST_UPDATED_BY = -1,
1448: TRADING_PARTNER_CONTACT_NAME = l_person_name

Line 1451: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated TRADING_PARTNER_CONTACT_IDs in PON_AUCTION_EVENTS: '||sql%rowcount||' rows');

1447: LAST_UPDATED_BY = -1,
1448: TRADING_PARTNER_CONTACT_NAME = l_person_name
1449: WHERE TRADING_PARTNER_CONTACT_ID = p_From_FK_id;
1450:
1451: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated TRADING_PARTNER_CONTACT_IDs in PON_AUCTION_EVENTS: '||sql%rowcount||' rows');
1452:
1453: ELSIF (l_merge_scenario = G_IRRELEVANT) THEN
1454: --
1455: -- Nothing to do