APPS.PAP_CMERGE dependencies on PA_SUMMARY_PROJECT_RETN

Line 158: SELECT CUSTOMER_ID FROM pa_summary_project_retn PA

154: AND RACM.SET_NUMBER = set_no )
155: FOR UPDATE NOWAIT;
156: --
157: CURSOR cursor_lock_9 IS
158: SELECT CUSTOMER_ID FROM pa_summary_project_retn PA
159: WHERE
160: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
161: FROM RA_CUSTOMER_MERGES RACM
162: WHERE RACM.PROCESS_FLAG = 'N'

Line 250: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_SUMMARY_PROJECT_RETN', FALSE );

246: open cursor_lock_8;
247: close cursor_lock_8;
248: --
249: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
250: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_SUMMARY_PROJECT_RETN', FALSE );
251: --
252: open cursor_lock_9;
253: close cursor_lock_9;
254: --

Line 1547: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_SUMMARY_PROJECT_RETN' );

1543: --
1544: -- update log file to indicate the table being updated. For bug# 1676538
1545: --
1546: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1547: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_SUMMARY_PROJECT_RETN' );
1548: --
1549: -- update pa_summary_project_retn for customer_id (duplicate_id ).
1550: --
1551: IF g_audit_profile='Y' THEN

Line 1549: -- update pa_summary_project_retn for customer_id (duplicate_id ).

1545: --
1546: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1547: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_SUMMARY_PROJECT_RETN' );
1548: --
1549: -- update pa_summary_project_retn for customer_id (duplicate_id ).
1550: --
1551: IF g_audit_profile='Y' THEN
1552:
1553: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1570: 'PA_SUMMARY_PROJECT_RETN',

1566: LAST_UPDATE_LOGIN,
1567: LAST_UPDATE_DATE,
1568: LAST_UPDATED_BY)
1569: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1570: 'PA_SUMMARY_PROJECT_RETN',
1571: RACM.CUSTOMER_MERGE_HEADER_ID,
1572: PS.PROJECT_ID,
1573: PS.TASK_ID,
1574: PS.AGREEMENT_ID,

Line 1584: FROM PA_SUMMARY_PROJECT_RETN PS, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

1580: hz_utility_pub.CREATION_DATE,
1581: hz_utility_pub.LAST_UPDATE_LOGIN,
1582: hz_utility_pub.LAST_UPDATE_DATE,
1583: hz_utility_pub.LAST_UPDATED_BY
1584: FROM PA_SUMMARY_PROJECT_RETN PS, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1585: CUSTOMER_ID,
1586: DUPLICATE_ID FROM RA_CUSTOMER_MERGES
1587: WHERE PROCESS_FLAG = 'N'
1588: AND SET_NUMBER = set_no

Line 1598: UPDATE PA_SUMMARY_PROJECT_RETN PS

1594: /* end 3891382 */
1595:
1596:
1597: END IF;
1598: UPDATE PA_SUMMARY_PROJECT_RETN PS
1599: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1600: FROM RA_CUSTOMER_MERGES RACM
1601: WHERE RACM.DUPLICATE_ID = PS.CUSTOMER_ID
1602: AND RACM.PROCESS_FLAG = 'N'