APPS.PAP_CMERGE dependencies on PA_SUMMARY_PROJECT_RETN

Line 190: SELECT CUSTOMER_ID FROM pa_summary_project_retn PA

186: AND RACM.SET_NUMBER = set_no )
187: FOR UPDATE NOWAIT;
188: --
189: CURSOR cursor_lock_9 IS
190: SELECT CUSTOMER_ID FROM pa_summary_project_retn PA
191: WHERE
192: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
193: FROM RA_CUSTOMER_MERGES RACM
194: WHERE RACM.PROCESS_FLAG = 'N'

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

278: open cursor_lock_8;
279: close cursor_lock_8;
280: --
281: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
282: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_SUMMARY_PROJECT_RETN', FALSE );
283: --
284: open cursor_lock_9;
285: close cursor_lock_9;
286: --

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

1581: --
1582: -- update log file to indicate the table being updated. For bug# 1676538
1583: --
1584: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1585: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_SUMMARY_PROJECT_RETN' );
1586: --
1587: -- update pa_summary_project_retn for customer_id (duplicate_id ).
1588: --
1589: IF g_audit_profile='Y' THEN

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

1583: --
1584: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1585: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_SUMMARY_PROJECT_RETN' );
1586: --
1587: -- update pa_summary_project_retn for customer_id (duplicate_id ).
1588: --
1589: IF g_audit_profile='Y' THEN
1590:
1591: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1608: 'PA_SUMMARY_PROJECT_RETN',

1604: LAST_UPDATE_LOGIN,
1605: LAST_UPDATE_DATE,
1606: LAST_UPDATED_BY)
1607: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1608: 'PA_SUMMARY_PROJECT_RETN',
1609: RACM.CUSTOMER_MERGE_HEADER_ID,
1610: PS.PROJECT_ID,
1611: PS.TASK_ID,
1612: PS.AGREEMENT_ID,

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

1618: hz_utility_pub.CREATION_DATE,
1619: hz_utility_pub.LAST_UPDATE_LOGIN,
1620: hz_utility_pub.LAST_UPDATE_DATE,
1621: hz_utility_pub.LAST_UPDATED_BY
1622: FROM PA_SUMMARY_PROJECT_RETN PS, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1623: CUSTOMER_ID,
1624: DUPLICATE_ID FROM RA_CUSTOMER_MERGES
1625: WHERE PROCESS_FLAG = 'N'
1626: AND SET_NUMBER = set_no

Line 1636: UPDATE PA_SUMMARY_PROJECT_RETN PS

1632: /* end 3891382 */
1633:
1634:
1635: END IF;
1636: UPDATE PA_SUMMARY_PROJECT_RETN PS
1637: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1638: FROM RA_CUSTOMER_MERGES RACM
1639: WHERE RACM.DUPLICATE_ID = PS.CUSTOMER_ID
1640: AND RACM.PROCESS_FLAG = 'N'