eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_TCA_MERGE_PVT dependencies on PON_THREAD_ENTRIES

Line 2580: -- merge for Sourcing PON_THREAD_ENTRIES entity.

2576: -- Pre-reqs : Discussion Message Entries with the given from_id
2577: -- (p_From_FK_id) must exists in the database
2578: --
2579: -- Function : This procedure will be attached to the FROM_ID
2580: -- merge for Sourcing PON_THREAD_ENTRIES entity.
2581: --
2582: -- It will veto Party Merge if -
2583: -- p_From_FK_id and p_To_FK_id both are not Buyer user party
2584: -- OR

Line 2587: -- This will merge the all the PON_THREAD_ENTRIES records

2583: -- p_From_FK_id and p_To_FK_id both are not Buyer user party
2584: -- OR
2585: -- p_From_FK_id and p_To_FK_id both are not Seller user party
2586: --
2587: -- This will merge the all the PON_THREAD_ENTRIES records
2588: -- having FROM_ID equals to p_From_FK_id
2589: -- to party id having value (p_To_FK_id)
2590: --
2591: -- Parameters:

Line 2703: UPDATE PON_THREAD_ENTRIES

2699:
2700: --
2701: -- NOTE: There is no WHO columns in this table
2702: --
2703: UPDATE PON_THREAD_ENTRIES
2704: SET FROM_ID = p_To_FK_id,
2705: FROM_FIRST_NAME= l_first_name,
2706: FROM_LAST_NAME=l_last_name
2707: WHERE FROM_ID = p_From_FK_id;

Line 2709: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated FROM_IDs in PON_THREAD_ENTRIES: '||sql%rowcount||' rows');

2705: FROM_FIRST_NAME= l_first_name,
2706: FROM_LAST_NAME=l_last_name
2707: WHERE FROM_ID = p_From_FK_id;
2708:
2709: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated FROM_IDs in PON_THREAD_ENTRIES: '||sql%rowcount||' rows');
2710:
2711: --
2712: -- We will be updating the user_id column of pon_neg_team_members table
2713: -- if there are only one FND_USER associated with the merge from ot merge to party id.

Line 2758: -- merge for different Sourcing entities (like PON_THREAD_ENTRIES etc.).

2754: -- Pre-reqs : Trading Partner ID entries with the given from_company_id
2755: -- (p_From_FK_id) must exists in the database
2756: --
2757: -- Function : This procedure will be attached to the TRADING_PARTNER_ID (p_From_FK_id)
2758: -- merge for different Sourcing entities (like PON_THREAD_ENTRIES etc.).
2759: --
2760: -- It will veto Party Merge if -
2761: -- p_From_FK_id or p_To_FK_id is/are Buyer company party
2762: -- OR