APPS.PAP_CMERGE dependencies on PA_IMPLEMENTATIONS

Line 163: SELECT CUSTOMER_ID FROM pa_implementations PA -- bug 3891382

159: AND RACM.SET_NUMBER = set_no )
160: FOR UPDATE NOWAIT;
161: --
162: CURSOR cursor_lock_6 IS
163: SELECT CUSTOMER_ID FROM pa_implementations PA -- bug 3891382
164: WHERE
165: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
166: FROM RA_CUSTOMER_MERGES RACM
167: WHERE RACM.PROCESS_FLAG = 'N'

Line 263: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_IMPLEMENTATIONS', FALSE );

259: open cursor_lock_5;
260: close cursor_lock_5;
261: --
262: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
263: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_IMPLEMENTATIONS', FALSE );
264: --bug3891382
265: --
266: open cursor_lock_6;
267: close cursor_lock_6;

Line 313: SELECT count(*) INTO var_count2 FROM pa_implementations_all

309: WHERE customer_id = var_dup_id
310: AND project_id NOT IN (
311: SELECT project_id FROM pa_projects);
312:
313: SELECT count(*) INTO var_count2 FROM pa_implementations_all
314: WHERE customer_id = var_dup_id
315: AND org_id NOT IN (
316: SELECT DISTINCT org_id FROM pa_projects);
317:

Line 1358: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_IMPLEMENTATIONS' );

1354: --
1355: -- update log file to indicate the table being updated. For bug# 1676538
1356: --
1357: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1358: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_IMPLEMENTATIONS' );
1359: --
1360: -- update pa_implementations for customer_id (duplicate_id ).
1361: --
1362: IF g_audit_profile='Y' THEN

Line 1360: -- update pa_implementations for customer_id (duplicate_id ).

1356: --
1357: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1358: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_IMPLEMENTATIONS' );
1359: --
1360: -- update pa_implementations for customer_id (duplicate_id ).
1361: --
1362: IF g_audit_profile='Y' THEN
1363:
1364: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1379: 'PA_IMPLEMENTATIONS_ALL',

1375: LAST_UPDATE_LOGIN,
1376: LAST_UPDATE_DATE,
1377: LAST_UPDATED_BY)
1378: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1379: 'PA_IMPLEMENTATIONS_ALL',
1380: RACM.CUSTOMER_MERGE_HEADER_ID,
1381: PI.ORG_ID,
1382: PI.CUSTOMER_ID,
1383: RACM.CUSTOMER_ID,

Line 1391: FROM PA_IMPLEMENTATIONS PI, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

1387: hz_utility_pub.CREATION_DATE,
1388: hz_utility_pub.LAST_UPDATE_LOGIN,
1389: hz_utility_pub.LAST_UPDATE_DATE,
1390: hz_utility_pub.LAST_UPDATED_BY
1391: FROM PA_IMPLEMENTATIONS PI, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1392: CUSTOMER_ID,
1393: DUPLICATE_ID
1394: FROM RA_CUSTOMER_MERGES
1395: WHERE PROCESS_FLAG = 'N'

Line 1402: UPDATE PA_IMPLEMENTATIONS PI -- Bug 3891382

1398: WHERE RACM.DUPLICATE_ID = PI.CUSTOMER_ID);
1399:
1400: END IF;
1401:
1402: UPDATE PA_IMPLEMENTATIONS PI -- Bug 3891382
1403: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1404: FROM RA_CUSTOMER_MERGES RACM
1405: WHERE RACM.DUPLICATE_ID = PI.CUSTOMER_ID
1406: AND RACM.PROCESS_FLAG = 'N'