APPS.PAP_CMERGE dependencies on PA_PROJECT_CONTACTS

Line 145: SELECT CUSTOMER_ID FROM pa_project_contacts PC

141: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' )
142: FOR UPDATE NOWAIT;
143: --
144: CURSOR cursor_lock_4 IS
145: SELECT CUSTOMER_ID FROM pa_project_contacts PC
146: WHERE
147: PC.CUSTOMER_ID IN ( SELECT RACM.DUPLICATE_ID
148: FROM RA_CUSTOMER_MERGES RACM
149: WHERE RACM.PROCESS_FLAG = 'N'

Line 251: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJECT_CONTACTS', FALSE );

247: open cursor_lock_3;
248: close cursor_lock_3;
249: --
250: ARP_MESSAGE.SET_NAME( 'AR', 'AR_LOCKING_TABLE' );
251: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJECT_CONTACTS', FALSE );
252: --
253: open cursor_lock_4;
254: close cursor_lock_4;
255: --

Line 327: SELECT count(*) INTO var_count2 FROM pa_project_contacts

323: SELECT DISTINCT org_id FROM pa_projects);
324:
325: var_count1 := var_count1 + var_count2;
326:
327: SELECT count(*) INTO var_count2 FROM pa_project_contacts
328: WHERE customer_id = var_dup_id
329: AND project_id NOT IN (
330: SELECT project_id FROM pa_projects);
331:

Line 1668: -- update pa_project_contacts for customer_id only.

1664: -- update pa_agreements for customer_id only.
1665: --
1666: PAP_CMERGE_BB1.MERGE_PA_AGREEMENTS( req_id, set_no );
1667: --
1668: -- update pa_project_contacts for customer_id only.
1669: --
1670: PAP_CMERGE_BB2.MERGE_PA_PROJECT_CONTACTS( req_id, set_no );
1671: --
1672: --

Line 1670: PAP_CMERGE_BB2.MERGE_PA_PROJECT_CONTACTS( req_id, set_no );

1666: PAP_CMERGE_BB1.MERGE_PA_AGREEMENTS( req_id, set_no );
1667: --
1668: -- update pa_project_contacts for customer_id only.
1669: --
1670: PAP_CMERGE_BB2.MERGE_PA_PROJECT_CONTACTS( req_id, set_no );
1671: --
1672: --
1673: <>
1674: --