APPS.PAP_CMERGE dependencies on PA_IMPLEMENTATIONS

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

127: AND RACM.SET_NUMBER = set_no )
128: FOR UPDATE NOWAIT;
129: --
130: CURSOR cursor_lock_6 IS
131: SELECT CUSTOMER_ID FROM pa_implementations PA -- bug 3891382
132: WHERE
133: PA.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
134: FROM RA_CUSTOMER_MERGES RACM
135: WHERE RACM.PROCESS_FLAG = 'N'

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

227: open cursor_lock_5;
228: close cursor_lock_5;
229: --
230: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
231: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_IMPLEMENTATIONS', FALSE );
232: --bug3891382
233: --
234: open cursor_lock_6;
235: close cursor_lock_6;

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

277: WHERE customer_id = var_dup_id
278: AND project_id NOT IN (
279: SELECT project_id FROM pa_projects);
280:
281: SELECT count(*) INTO var_count2 FROM pa_implementations_all
282: WHERE customer_id = var_dup_id
283: AND org_id NOT IN (
284: SELECT DISTINCT org_id FROM pa_projects);
285:

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

1316: --
1317: -- update log file to indicate the table being updated. For bug# 1676538
1318: --
1319: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1320: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_IMPLEMENTATIONS' );
1321: --
1322: -- update pa_implementations for customer_id (duplicate_id ).
1323: --
1324: IF g_audit_profile='Y' THEN

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

1318: --
1319: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1320: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_IMPLEMENTATIONS' );
1321: --
1322: -- update pa_implementations for customer_id (duplicate_id ).
1323: --
1324: IF g_audit_profile='Y' THEN
1325:
1326: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1341: 'PA_IMPLEMENTATIONS_ALL',

1337: LAST_UPDATE_LOGIN,
1338: LAST_UPDATE_DATE,
1339: LAST_UPDATED_BY)
1340: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1341: 'PA_IMPLEMENTATIONS_ALL',
1342: RACM.CUSTOMER_MERGE_HEADER_ID,
1343: PI.ORG_ID,
1344: PI.CUSTOMER_ID,
1345: RACM.CUSTOMER_ID,

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

1349: hz_utility_pub.CREATION_DATE,
1350: hz_utility_pub.LAST_UPDATE_LOGIN,
1351: hz_utility_pub.LAST_UPDATE_DATE,
1352: hz_utility_pub.LAST_UPDATED_BY
1353: FROM PA_IMPLEMENTATIONS PI, (SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1354: CUSTOMER_ID,
1355: DUPLICATE_ID
1356: FROM RA_CUSTOMER_MERGES
1357: WHERE PROCESS_FLAG = 'N'

Line 1364: UPDATE PA_IMPLEMENTATIONS PI -- Bug 3891382

1360: WHERE RACM.DUPLICATE_ID = PI.CUSTOMER_ID);
1361:
1362: END IF;
1363:
1364: UPDATE PA_IMPLEMENTATIONS PI -- Bug 3891382
1365: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1366: FROM RA_CUSTOMER_MERGES RACM
1367: WHERE RACM.DUPLICATE_ID = PI.CUSTOMER_ID
1368: AND RACM.PROCESS_FLAG = 'N'