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_THREADS

Line 2435: -- merge for Sourcing PON_THREADS entity.

2431: -- Pre-reqs : Discussion Messages with the given owner_party_id
2432: -- (p_From_FK_id) must exists in the database
2433: --
2434: -- Function : This procedure will be attached to the OWNER_PARTY_ID
2435: -- merge for Sourcing PON_THREADS entity.
2436: --
2437: -- It will veto Party Merge if -
2438: -- p_From_FK_id and p_To_FK_id both are not Buyer user party
2439: -- OR

Line 2442: -- This will merge the all the PON_THREADS records

2438: -- p_From_FK_id and p_To_FK_id both are not Buyer user party
2439: -- OR
2440: -- p_From_FK_id and p_To_FK_id both are not Seller user party
2441: --
2442: -- This will merge the all the PON_THREADS records
2443: -- having OWNER_PARTY_ID equals to p_From_FK_id
2444: -- to party id having value (p_To_FK_id)
2445: --
2446: -- Parameters:

Line 2540: UPDATE PON_THREADS

2536: -- there is no chance of unique key constraint violation
2537: -- due to the following updates
2538: --
2539:
2540: UPDATE PON_THREADS
2541: SET LAST_UPDATE_DATE = SYSDATE,
2542: OWNER_PARTY_ID = p_To_FK_id
2543: WHERE OWNER_PARTY_ID = p_From_FK_id;
2544:

Line 2545: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated OWNER_PARTY_IDs in PON_THREADS: '||sql%rowcount||' rows');

2541: SET LAST_UPDATE_DATE = SYSDATE,
2542: OWNER_PARTY_ID = p_To_FK_id
2543: WHERE OWNER_PARTY_ID = p_From_FK_id;
2544:
2545: fnd_file.put_line (fnd_file.log, '50 : Buyer Merge - Updated OWNER_PARTY_IDs in PON_THREADS: '||sql%rowcount||' rows');
2546:
2547: ELSIF (l_merge_scenario = G_IRRELEVANT) THEN
2548: --
2549: -- Nothing to do