APPS.PON_TCA_MERGE_PVT dependencies on PON_BIDDERS_LISTS

Line 1486: -- merge for Sourcing PON_BIDDERS_LISTS entity.

1482: -- Pre-reqs : Bidders List with the given trading_partner_contact_id
1483: -- (p_From_FK_id) must exists in the database
1484: --
1485: -- Function : This procedure will be attached to the TRADING_PARTNER_CONTACT_ID
1486: -- merge for Sourcing PON_BIDDERS_LISTS entity.
1487: --
1488: -- It will veto Party Merge if -
1489: -- p_From_FK_id and p_To_FK_id both are not Buyer user party
1490: --

Line 1491: -- This will merge the all the PON_BIDDERS_LISTS records

1487: --
1488: -- It will veto Party Merge if -
1489: -- p_From_FK_id and p_To_FK_id both are not Buyer user party
1490: --
1491: -- This will merge the all the PON_BIDDERS_LISTS records
1492: -- having TRADING_PARTNER_CONTACT_ID equals to p_From_FK_id
1493: -- to party id having value (p_To_FK_id)
1494: --
1495: -- Parameters:

Line 1576: -- PON_BIDDERS_LISTS.TRADING_PARTNER_CONTACT_ID

1572:
1573: fnd_file.put_line (fnd_file.log, '20 : Seller Merge - Error');
1574: --
1575: -- This can not happen in any normal scenario as
1576: -- PON_BIDDERS_LISTS.TRADING_PARTNER_CONTACT_ID
1577: -- can never contain a seller user id. Thus, raising a veto though
1578: -- it will possibly never be called
1579: --
1580: FND_MESSAGE.SET_NAME('AR', 'PON_TCA_MRG_ERR'); -- Need to put some Sourcing Specific Error Message

Line 1597: UPDATE PON_BIDDERS_LISTS

1593: -- TRADING_PARTNER_CONTACT_NAME field is always null
1594: -- in the table hence it is not updated here to maintain the
1595: -- consistency
1596: --
1597: UPDATE PON_BIDDERS_LISTS
1598: SET LAST_UPDATE_DATE = SYSDATE,
1599: LAST_UPDATED_BY = -1,
1600: TRADING_PARTNER_CONTACT_ID = p_To_FK_id
1601: WHERE TRADING_PARTNER_CONTACT_ID = p_From_FK_id;

Line 1603: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated TPC IDs in PON_BIDDERS_LISTS: '||sql%rowcount||' rows');

1599: LAST_UPDATED_BY = -1,
1600: TRADING_PARTNER_CONTACT_ID = p_To_FK_id
1601: WHERE TRADING_PARTNER_CONTACT_ID = p_From_FK_id;
1602:
1603: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated TPC IDs in PON_BIDDERS_LISTS: '||sql%rowcount||' rows');
1604:
1605: ELSIF (l_merge_scenario = G_IRRELEVANT) THEN
1606: --
1607: -- Nothing to do