APPS.PAP_CMERGE dependencies on PA_TASKS

Line 103: SELECT ADDRESS_ID FROM pa_tasks PT

99: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' )
100: FOR UPDATE NOWAIT;
101:
102: CURSOR cursor_lock_3 IS
103: SELECT ADDRESS_ID FROM pa_tasks PT
104: WHERE
105: PT.ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
106: FROM RA_CUSTOMER_MERGES RACM
107: WHERE RACM.PROCESS_FLAG = 'N'

Line 213: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_TASKS', FALSE );

209: open cursor_lock_2;
210: close cursor_lock_2;
211: --
212: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
213: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_TASKS', FALSE );
214: --
215: open cursor_lock_3;
216: close cursor_lock_3;
217: --

Line 356: Update pa_tasks

352: WHERE PC.PROJECT_ID = var_project_id
353: AND PC.CUSTOMER_ID = old_customer_id;
354:
355: /*Bug5462389*/
356: Update pa_tasks
357: Set Customer_ID = new_customer_id
358: Where Project_ID = var_project_id
359: And Customer_ID = old_customer_id;
360: ELSE

Line 526: /*Bug5462389:moved the update on pa_tasks before the IF condition*/

522: WHERE PC.PROJECT_ID = var_project_id
523: AND PC.CUSTOMER_ID = new_customer_id;
524: End IF; /* Added for bug 4218767*/
525:
526: /*Bug5462389:moved the update on pa_tasks before the IF condition*/
527: -- End of FP_M Changes
528: ELSE
529: --
530: -- update pa_project_customers table for bill to address id, this is necessary

Line 1249: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_TASKS' );

1245: --
1246: -- update log file to indicate the table being updated.
1247: --
1248: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1249: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_TASKS' );
1250: --
1251: -- update pa_tasks for address_id ( ship address id ).
1252: --
1253: IF g_audit_profile='Y' THEN

Line 1251: -- update pa_tasks for address_id ( ship address id ).

1247: --
1248: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1249: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_TASKS' );
1250: --
1251: -- update pa_tasks for address_id ( ship address id ).
1252: --
1253: IF g_audit_profile='Y' THEN
1254:
1255: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1272: 'PA_TASKS',

1268: LAST_UPDATE_LOGIN,
1269: LAST_UPDATE_DATE,
1270: LAST_UPDATED_BY)
1271: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1272: 'PA_TASKS',
1273: RACM.CUSTOMER_MERGE_HEADER_ID,
1274: PT.TASK_ID,
1275: PT. address_id,
1276: RACM.CUSTOMER_ADDRESS_ID,

Line 1286: FROM PA_TASKS PT, ra_customer_merges RACM

1282: hz_utility_pub.CREATION_DATE,
1283: hz_utility_pub.LAST_UPDATE_LOGIN,
1284: hz_utility_pub.LAST_UPDATE_DATE,
1285: hz_utility_pub.LAST_UPDATED_BY
1286: FROM PA_TASKS PT, ra_customer_merges RACM
1287: WHERE RACM.DUPLICATE_ADDRESS_ID = PT.ADDRESS_ID
1288: AND RACM.PROCESS_FLAG = 'N'
1289: AND RACM.SET_NUMBER = set_no
1290: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO');

Line 1293: UPDATE pa_tasks PT

1289: AND RACM.SET_NUMBER = set_no
1290: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO');
1291: END IF;
1292:
1293: UPDATE pa_tasks PT
1294: SET ( ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
1295: FROM RA_CUSTOMER_MERGES RACM
1296: WHERE RACM.DUPLICATE_ADDRESS_ID = PT.ADDRESS_ID
1297: AND RACM.PROCESS_FLAG = 'N'