APPS.PON_TCA_MERGE_PVT dependencies on PON_TE_RECIPIENTS

Line 2898: -- merge for Sourcing PON_TE_RECIPIENTS entity.

2894: -- Pre-reqs : Discussion Message Thread Entries with the given to_id
2895: -- (p_From_FK_id) must exists in the database
2896: --
2897: -- Function : This procedure will be attached to the TO_ID
2898: -- merge for Sourcing PON_TE_RECIPIENTS entity.
2899: --
2900: -- It will veto Party Merge if -
2901: -- p_From_FK_id and p_To_FK_id both are not Buyer user party
2902: -- OR

Line 2905: -- This will merge the all the PON_TE_RECIPIENTS records

2901: -- p_From_FK_id and p_To_FK_id both are not Buyer user party
2902: -- OR
2903: -- p_From_FK_id and p_To_FK_id both are not Seller user party
2904: --
2905: -- This will merge the all the PON_TE_RECIPIENTS records
2906: -- having TO_ID equals to p_From_FK_id
2907: -- to party id having value (p_To_FK_id)
2908: --
2909: -- Parameters:

Line 3021: UPDATE PON_TE_RECIPIENTS te

3017:
3018: --
3019: -- NOTE: There is no WHO columns in this table
3020: --
3021: UPDATE PON_TE_RECIPIENTS te
3022: SET te.TO_ID = p_To_FK_id,
3023: te.TO_FIRST_NAME = l_first_name,
3024: te.TO_LAST_NAME = l_last_name
3025: WHERE te.TO_ID = p_From_FK_id

Line 3027: FROM PON_TE_RECIPIENTS te1

3023: te.TO_FIRST_NAME = l_first_name,
3024: te.TO_LAST_NAME = l_last_name
3025: WHERE te.TO_ID = p_From_FK_id
3026: AND NOT EXISTS (SELECT 'duplicate'
3027: FROM PON_TE_RECIPIENTS te1
3028: WHERE te1.ENTRY_ID = te.ENTRY_ID
3029: AND te1.TO_ID = p_To_FK_id);
3030:
3031: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated TO_IDs in PON_TE_RECIPIENTS: '||sql%rowcount||' rows');

Line 3031: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated TO_IDs in PON_TE_RECIPIENTS: '||sql%rowcount||' rows');

3027: FROM PON_TE_RECIPIENTS te1
3028: WHERE te1.ENTRY_ID = te.ENTRY_ID
3029: AND te1.TO_ID = p_To_FK_id);
3030:
3031: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated TO_IDs in PON_TE_RECIPIENTS: '||sql%rowcount||' rows');
3032:
3033: --
3034: -- We will be updating the user_id column of pon_neg_team_members table
3035: -- if there are only one FND_USER associated with the merge from ot merge to party id.