DBA Data[Home] [Help]

APPS.PON_TCA_MERGE_PVT dependencies on PON_DISCUSSIONS

Line 792: UPDATE PON_DISCUSSIONS

788: WHERE TRADING_PARTNER_CONTACT_ID = p_From_FK_id;
789:
790: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated TPC IDs in PON_AUCTION_HEADERS_ALL: '||sql%rowcount||' rows');
791:
792: UPDATE PON_DISCUSSIONS
793: SET OWNER_PARTY_ID = p_To_FK_id,
794: LAST_UPDATE_DATE = SYSDATE
795: WHERE OWNER_PARTY_ID = p_From_FK_id;
796:

Line 797: fnd_file.put_line (fnd_file.log, '60 : Buyer Merge - Updated TPC IDs in PON_DISCUSSIONS');

793: SET OWNER_PARTY_ID = p_To_FK_id,
794: LAST_UPDATE_DATE = SYSDATE
795: WHERE OWNER_PARTY_ID = p_From_FK_id;
796:
797: fnd_file.put_line (fnd_file.log, '60 : Buyer Merge - Updated TPC IDs in PON_DISCUSSIONS');
798:
799: --
800: -- We will be updating the user_id column of pon_neg_team_members table
801: -- if there are only one FND_USER associated with the merge from ot merge to party id.