APPS.PAP_CMERGE dependencies on PA_PROJ_RETN_RULES

Line 140: SELECT CUSTOMER_ID FROM pa_proj_retn_rules PA

136: AND RACM.SET_NUMBER = set_no )
137: FOR UPDATE NOWAIT;
138: --
139: CURSOR cursor_lock_7 IS
140: SELECT CUSTOMER_ID FROM pa_proj_retn_rules PA
141: WHERE
142: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
143: FROM RA_CUSTOMER_MERGES RACM
144: WHERE RACM.PROCESS_FLAG = 'N'

Line 238: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_RULES', FALSE );

234: open cursor_lock_6;
235: close cursor_lock_6;
236: --
237: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
238: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_RULES', FALSE );
239: --
240: open cursor_lock_7;
241: close cursor_lock_7;
242: --

Line 1391: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_RULES' );

1387: --
1388: -- update log file to indicate the table being updated. For bug# 1676538
1389: --
1390: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1391: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_RULES' );
1392: --
1393: -- update pa_proj_retn_rules for customer_id (duplicate_id ).
1394:
1395: IF g_audit_profile='Y' THEN

Line 1393: -- update pa_proj_retn_rules for customer_id (duplicate_id ).

1389: --
1390: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1391: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_RULES' );
1392: --
1393: -- update pa_proj_retn_rules for customer_id (duplicate_id ).
1394:
1395: IF g_audit_profile='Y' THEN
1396:
1397: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1412: 'PA_PROJ_RETN_RULES',

1408: LAST_UPDATE_LOGIN,
1409: LAST_UPDATE_DATE,
1410: LAST_UPDATED_BY)
1411: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1412: 'PA_PROJ_RETN_RULES',
1413: RACM.CUSTOMER_MERGE_HEADER_ID,
1414: PR.RETENTION_RULE_ID,
1415: PR.CUSTOMER_ID,
1416: RACM.CUSTOMER_ID,

Line 1424: FROM PA_PROJ_RETN_RULES PR, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

1420: hz_utility_pub.CREATION_DATE,
1421: hz_utility_pub.LAST_UPDATE_LOGIN,
1422: hz_utility_pub.LAST_UPDATE_DATE,
1423: hz_utility_pub.LAST_UPDATED_BY
1424: FROM PA_PROJ_RETN_RULES PR, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1425: CUSTOMER_ID,
1426: DUPLICATE_ID FROM RA_CUSTOMER_MERGES
1427: WHERE PROCESS_FLAG = 'N'
1428: AND SET_NUMBER = set_no

Line 1439: UPDATE PA_PROJ_RETN_RULES PR

1435:
1436:
1437: END IF;
1438: --
1439: UPDATE PA_PROJ_RETN_RULES PR
1440: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1441: FROM RA_CUSTOMER_MERGES RACM
1442: WHERE RACM.DUPLICATE_ID = PR.CUSTOMER_ID
1443: AND RACM.PROCESS_FLAG = 'N'