APPS.PAP_CMERGE dependencies on PA_PROJ_RETN_RULES

Line 172: SELECT CUSTOMER_ID FROM pa_proj_retn_rules PA

168: AND RACM.SET_NUMBER = set_no )
169: FOR UPDATE NOWAIT;
170: --
171: CURSOR cursor_lock_7 IS
172: SELECT CUSTOMER_ID FROM pa_proj_retn_rules PA
173: WHERE
174: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
175: FROM RA_CUSTOMER_MERGES RACM
176: WHERE RACM.PROCESS_FLAG = 'N'

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

266: open cursor_lock_6;
267: close cursor_lock_6;
268: --
269: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
270: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_RULES', FALSE );
271: --
272: open cursor_lock_7;
273: close cursor_lock_7;
274: --

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

1425: --
1426: -- update log file to indicate the table being updated. For bug# 1676538
1427: --
1428: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1429: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_RULES' );
1430: --
1431: -- update pa_proj_retn_rules for customer_id (duplicate_id ).
1432:
1433: IF g_audit_profile='Y' THEN

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

1427: --
1428: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1429: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJ_RETN_RULES' );
1430: --
1431: -- update pa_proj_retn_rules for customer_id (duplicate_id ).
1432:
1433: IF g_audit_profile='Y' THEN
1434:
1435: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1450: 'PA_PROJ_RETN_RULES',

1446: LAST_UPDATE_LOGIN,
1447: LAST_UPDATE_DATE,
1448: LAST_UPDATED_BY)
1449: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1450: 'PA_PROJ_RETN_RULES',
1451: RACM.CUSTOMER_MERGE_HEADER_ID,
1452: PR.RETENTION_RULE_ID,
1453: PR.CUSTOMER_ID,
1454: RACM.CUSTOMER_ID,

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

1458: hz_utility_pub.CREATION_DATE,
1459: hz_utility_pub.LAST_UPDATE_LOGIN,
1460: hz_utility_pub.LAST_UPDATE_DATE,
1461: hz_utility_pub.LAST_UPDATED_BY
1462: FROM PA_PROJ_RETN_RULES PR, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1463: CUSTOMER_ID,
1464: DUPLICATE_ID FROM RA_CUSTOMER_MERGES
1465: WHERE PROCESS_FLAG = 'N'
1466: AND SET_NUMBER = set_no

Line 1477: UPDATE PA_PROJ_RETN_RULES PR

1473:
1474:
1475: END IF;
1476: --
1477: UPDATE PA_PROJ_RETN_RULES PR
1478: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1479: FROM RA_CUSTOMER_MERGES RACM
1480: WHERE RACM.DUPLICATE_ID = PR.CUSTOMER_ID
1481: AND RACM.PROCESS_FLAG = 'N'