APPS.PAP_CMERGE dependencies on PA_TASKS

Line 135: SELECT ADDRESS_ID FROM pa_tasks PT

131: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' )
132: FOR UPDATE NOWAIT;
133:
134: CURSOR cursor_lock_3 IS
135: SELECT ADDRESS_ID FROM pa_tasks PT
136: WHERE
137: PT.ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
138: FROM RA_CUSTOMER_MERGES RACM
139: WHERE RACM.PROCESS_FLAG = 'N'

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

241: open cursor_lock_2;
242: close cursor_lock_2;
243: --
244: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
245: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_TASKS', FALSE );
246: --
247: open cursor_lock_3;
248: close cursor_lock_3;
249: --

Line 388: Update pa_tasks

384: WHERE PC.PROJECT_ID = var_project_id
385: AND PC.CUSTOMER_ID = old_customer_id;
386:
387: /*Bug5462389*/
388: Update pa_tasks
389: Set Customer_ID = new_customer_id
390: Where Project_ID = var_project_id
391: And Customer_ID = old_customer_id;
392: ELSE

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

554: WHERE PC.PROJECT_ID = var_project_id
555: AND PC.CUSTOMER_ID = new_customer_id;
556: End IF; /* Added for bug 4218767*/
557:
558: /*Bug5462389:moved the update on pa_tasks before the IF condition*/
559: -- End of FP_M Changes
560: ELSE
561: --
562: -- update pa_project_customers table for bill to address id, this is necessary

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

1283: --
1284: -- update log file to indicate the table being updated.
1285: --
1286: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1287: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_TASKS' );
1288: --
1289: -- update pa_tasks for address_id ( ship address id ).
1290: --
1291: IF g_audit_profile='Y' THEN

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

1285: --
1286: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
1287: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_TASKS' );
1288: --
1289: -- update pa_tasks for address_id ( ship address id ).
1290: --
1291: IF g_audit_profile='Y' THEN
1292:
1293: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1310: 'PA_TASKS',

1306: LAST_UPDATE_LOGIN,
1307: LAST_UPDATE_DATE,
1308: LAST_UPDATED_BY)
1309: ( select HZ_CUSTOMER_MERGE_LOG_s.nextval,
1310: 'PA_TASKS',
1311: RACM.CUSTOMER_MERGE_HEADER_ID,
1312: PT.TASK_ID,
1313: PT. address_id,
1314: RACM.CUSTOMER_ADDRESS_ID,

Line 1324: FROM PA_TASKS PT, ra_customer_merges RACM

1320: hz_utility_pub.CREATION_DATE,
1321: hz_utility_pub.LAST_UPDATE_LOGIN,
1322: hz_utility_pub.LAST_UPDATE_DATE,
1323: hz_utility_pub.LAST_UPDATED_BY
1324: FROM PA_TASKS PT, ra_customer_merges RACM
1325: WHERE RACM.DUPLICATE_ADDRESS_ID = PT.ADDRESS_ID
1326: AND RACM.PROCESS_FLAG = 'N'
1327: AND RACM.SET_NUMBER = set_no
1328: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO');

Line 1331: UPDATE pa_tasks PT

1327: AND RACM.SET_NUMBER = set_no
1328: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO');
1329: END IF;
1330:
1331: UPDATE pa_tasks PT
1332: SET ( ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
1333: FROM RA_CUSTOMER_MERGES RACM
1334: WHERE RACM.DUPLICATE_ADDRESS_ID = PT.ADDRESS_ID
1335: AND RACM.PROCESS_FLAG = 'N'