eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAP_CMERGE_BB2 dependencies on PA_PROJECT_CONTACTS

Line 8: var_customer_id IN pa_project_contacts.customer_id%TYPE,

4: -- function to retrieve new and old customer id's.
5: --
6: FUNCTION RETRIEVE_CUSTOMER_ID(
7: set_no IN NUMBER,
8: var_customer_id IN pa_project_contacts.customer_id%TYPE,
9: var_new_customer_id OUT NOCOPY ra_customer_merges.customer_id%TYPE,/*File.sql.39*/
10: var_old_customer_id OUT NOCOPY ra_customer_merges.customer_id%TYPE /*File.sql.39*/ )
11: --
12: RETURN BOOLEAN IS

Line 36: var_project_id IN pa_project_contacts.project_id%TYPE,

32: --
33: END RETRIEVE_CUSTOMER_ID;
34: --
35: FUNCTION CHECK_FOR_MUL_BILLING_CON(
36: var_project_id IN pa_project_contacts.project_id%TYPE,
37: var_new_customer_id IN pa_project_contacts.customer_id%TYPE )
38: --
39: RETURN BOOLEAN IS
40: --

Line 37: var_new_customer_id IN pa_project_contacts.customer_id%TYPE )

33: END RETRIEVE_CUSTOMER_ID;
34: --
35: FUNCTION CHECK_FOR_MUL_BILLING_CON(
36: var_project_id IN pa_project_contacts.project_id%TYPE,
37: var_new_customer_id IN pa_project_contacts.customer_id%TYPE )
38: --
39: RETURN BOOLEAN IS
40: --
41: dummy_project_id pa_project_contacts.project_id%TYPE;

Line 41: dummy_project_id pa_project_contacts.project_id%TYPE;

37: var_new_customer_id IN pa_project_contacts.customer_id%TYPE )
38: --
39: RETURN BOOLEAN IS
40: --
41: dummy_project_id pa_project_contacts.project_id%TYPE;
42: dummy_customer_id pa_project_contacts.customer_id%TYPE;
43: dummy_contact_id pa_project_contacts.contact_id%TYPE;
44: dummy_proj_con_type_code pa_project_contacts.project_contact_type_code%TYPE;
45: --

Line 42: dummy_customer_id pa_project_contacts.customer_id%TYPE;

38: --
39: RETURN BOOLEAN IS
40: --
41: dummy_project_id pa_project_contacts.project_id%TYPE;
42: dummy_customer_id pa_project_contacts.customer_id%TYPE;
43: dummy_contact_id pa_project_contacts.contact_id%TYPE;
44: dummy_proj_con_type_code pa_project_contacts.project_contact_type_code%TYPE;
45: --
46: BEGIN

Line 43: dummy_contact_id pa_project_contacts.contact_id%TYPE;

39: RETURN BOOLEAN IS
40: --
41: dummy_project_id pa_project_contacts.project_id%TYPE;
42: dummy_customer_id pa_project_contacts.customer_id%TYPE;
43: dummy_contact_id pa_project_contacts.contact_id%TYPE;
44: dummy_proj_con_type_code pa_project_contacts.project_contact_type_code%TYPE;
45: --
46: BEGIN
47: --

Line 44: dummy_proj_con_type_code pa_project_contacts.project_contact_type_code%TYPE;

40: --
41: dummy_project_id pa_project_contacts.project_id%TYPE;
42: dummy_customer_id pa_project_contacts.customer_id%TYPE;
43: dummy_contact_id pa_project_contacts.contact_id%TYPE;
44: dummy_proj_con_type_code pa_project_contacts.project_contact_type_code%TYPE;
45: --
46: BEGIN
47: --
48: SELECT DISTINCT PROJECT_ID, CUSTOMER_ID, CONTACT_ID,

Line 52: FROM PA_PROJECT_CONTACTS PC

48: SELECT DISTINCT PROJECT_ID, CUSTOMER_ID, CONTACT_ID,
49: PROJECT_CONTACT_TYPE_CODE
50: INTO dummy_project_id, dummy_customer_id, dummy_contact_id,
51: dummy_proj_con_type_code
52: FROM PA_PROJECT_CONTACTS PC
53: WHERE PC.PROJECT_ID = var_project_id
54: AND PC.CUSTOMER_ID = var_new_customer_id
55: AND PC.CONTACT_ID >= 0
56: AND PC.PROJECT_CONTACT_TYPE_CODE = 'BILLING';

Line 70: var_project_id IN pa_project_contacts.project_id%TYPE,

66: --
67: END CHECK_FOR_MUL_BILLING_CON;
68: --
69: FUNCTION DELETE_BILLING_CONTACTS(
70: var_project_id IN pa_project_contacts.project_id%TYPE,
71: var_old_customer_id IN pa_project_contacts.customer_id%TYPE,
72: var_new_customer_id IN pa_project_contacts.customer_id%TYPE,
73: var_cust_merge_head_id IN ra_customer_merges.customer_merge_header_id%TYPE,
74: request_id IN NUMBER)

Line 71: var_old_customer_id IN pa_project_contacts.customer_id%TYPE,

67: END CHECK_FOR_MUL_BILLING_CON;
68: --
69: FUNCTION DELETE_BILLING_CONTACTS(
70: var_project_id IN pa_project_contacts.project_id%TYPE,
71: var_old_customer_id IN pa_project_contacts.customer_id%TYPE,
72: var_new_customer_id IN pa_project_contacts.customer_id%TYPE,
73: var_cust_merge_head_id IN ra_customer_merges.customer_merge_header_id%TYPE,
74: request_id IN NUMBER)
75: --

Line 72: var_new_customer_id IN pa_project_contacts.customer_id%TYPE,

68: --
69: FUNCTION DELETE_BILLING_CONTACTS(
70: var_project_id IN pa_project_contacts.project_id%TYPE,
71: var_old_customer_id IN pa_project_contacts.customer_id%TYPE,
72: var_new_customer_id IN pa_project_contacts.customer_id%TYPE,
73: var_cust_merge_head_id IN ra_customer_merges.customer_merge_header_id%TYPE,
74: request_id IN NUMBER)
75: --
76:

Line 86: -- PA_PROJECT_CONTACTS table. All rows are inserted that are going

82: /* Added for Tca audit*/
83: IF pap_cmerge.g_audit_profile = 'Y' THEN
84: --
85: -- Inserting the data into HZ_CUSTOMER_MERGE_LOG table for
86: -- PA_PROJECT_CONTACTS table. All rows are inserted that are going
87: -- to be deleted for old customer.
88: --
89: /*DEL_COL11 added for customer account relation enhancement*/
90: INSERT INTO hz_customer_merge_log

Line 120: 'PA_PROJECT_CONTACTS',

116: (select
117: HZ_CUSTOMER_MERGE_LOG_S.nextval,
118: var_cust_merge_head_id,
119: request_id,
120: 'PA_PROJECT_CONTACTS',
121: var_project_id,
122: var_new_customer_id,
123: PC.contact_id,
124: PC.project_contact_type_code,

Line 142: FROM PA_PROJECT_CONTACTS PC

138: hz_utility_pub.CREATION_DATE,
139: hz_utility_pub.LAST_UPDATE_LOGIN,
140: hz_utility_pub.LAST_UPDATE_DATE,
141: hz_utility_pub.LAST_UPDATED_BY
142: FROM PA_PROJECT_CONTACTS PC
143: WHERE PC.PROJECT_ID = var_project_id
144: AND PC.CUSTOMER_ID = var_old_customer_id
145: AND PC.CONTACT_ID >= 0
146: AND PC.PROJECT_CONTACT_TYPE_CODE = 'BILLING');

Line 150: DELETE PA_PROJECT_CONTACTS PC

146: AND PC.PROJECT_CONTACT_TYPE_CODE = 'BILLING');
147: END IF;
148: /* End for Tca Audit */
149:
150: DELETE PA_PROJECT_CONTACTS PC
151: WHERE PC.PROJECT_ID = var_project_id
152: AND PC.CUSTOMER_ID = var_old_customer_id
153: AND PC.CONTACT_ID >= 0
154: AND PC.PROJECT_CONTACT_TYPE_CODE = 'BILLING';

Line 165: PROCEDURE MERGE_PA_PROJECT_CONTACTS ( req_id IN NUMBER, set_no IN NUMBER ) IS

161: RETURN FALSE;
162: --
163: END DELETE_BILLING_CONTACTS;
164: --
165: PROCEDURE MERGE_PA_PROJECT_CONTACTS ( req_id IN NUMBER, set_no IN NUMBER ) IS
166: /*CURSOR cursor_3 IS SELECT PROJECT_ID, CUSTOMER_ID FROM pa_project_contacts;*/
167:
168: /*Cursor_3 fetches all those records for which the
169: primary customer has been merged.

Line 166: /CURSOR cursor_3 IS SELECT PROJECT_ID, CUSTOMER_ID FROM pa_project_contacts;/

162: --
163: END DELETE_BILLING_CONTACTS;
164: --
165: PROCEDURE MERGE_PA_PROJECT_CONTACTS ( req_id IN NUMBER, set_no IN NUMBER ) IS
166: /*CURSOR cursor_3 IS SELECT PROJECT_ID, CUSTOMER_ID FROM pa_project_contacts;*/
167:
168: /*Cursor_3 fetches all those records for which the
169: primary customer has been merged.
170: Cursor_4 will fetch all those records for which

Line 180: FROM pa_project_contacts pc,ra_customer_merges RACM

176: PC.PROJECT_CONTACT_TYPE_CODE,
177: RACM.CUSTOMER_ID,
178: RACM.CUSTOMER_MERGE_HEADER_ID,
179: PC.BILL_SHIP_CUSTOMER_ID /*For customer account relationship*/
180: FROM pa_project_contacts pc,ra_customer_merges RACM
181: WHERE RACM.DUPLICATE_ID = PC.CUSTOMER_ID
182: AND RACM.PROCESS_FLAG = 'N'
183: AND RACM.SET_NUMBER = set_no
184: AND RACM.CUSTOMER_ID <> RACM.DUPLICATE_ID

Line 197: FROM pa_project_contacts pc,ra_customer_merges RACM

193: PC.PROJECT_CONTACT_TYPE_CODE,
194: RACM.CUSTOMER_ID,
195: RACM.CUSTOMER_MERGE_HEADER_ID,
196: PC.BILL_SHIP_CUSTOMER_ID /*For customer account relationship*/
197: FROM pa_project_contacts pc,ra_customer_merges RACM
198: WHERE RACM.DUPLICATE_ID = PC.BILL_SHIP_CUSTOMER_ID
199: AND RACM.PROCESS_FLAG = 'N'
200: AND RACM.SET_NUMBER = set_no
201: AND RACM.CUSTOMER_ID <> RACM.DUPLICATE_ID

Line 209: var_project_id pa_project_contacts.project_id%TYPE;

205: WHERE PROJECT_ID = PC.PROJECT_ID );
206:
207: --
208:
209: var_project_id pa_project_contacts.project_id%TYPE;
210: var_customer_id pa_project_contacts.customer_id%TYPE;
211: var_contact_id pa_project_contacts.contact_id%TYPE;
212: var_contact_type_code pa_project_contacts.project_contact_type_code%TYPE;
213: var_bill_ship_customer_id pa_project_contacts.bill_ship_customer_id%TYPE;/*Added for customer account*/

Line 210: var_customer_id pa_project_contacts.customer_id%TYPE;

206:
207: --
208:
209: var_project_id pa_project_contacts.project_id%TYPE;
210: var_customer_id pa_project_contacts.customer_id%TYPE;
211: var_contact_id pa_project_contacts.contact_id%TYPE;
212: var_contact_type_code pa_project_contacts.project_contact_type_code%TYPE;
213: var_bill_ship_customer_id pa_project_contacts.bill_ship_customer_id%TYPE;/*Added for customer account*/
214: var_old_customer_id pa_project_contacts.customer_id%TYPE; /*uncommented for customer account relation*/

Line 211: var_contact_id pa_project_contacts.contact_id%TYPE;

207: --
208:
209: var_project_id pa_project_contacts.project_id%TYPE;
210: var_customer_id pa_project_contacts.customer_id%TYPE;
211: var_contact_id pa_project_contacts.contact_id%TYPE;
212: var_contact_type_code pa_project_contacts.project_contact_type_code%TYPE;
213: var_bill_ship_customer_id pa_project_contacts.bill_ship_customer_id%TYPE;/*Added for customer account*/
214: var_old_customer_id pa_project_contacts.customer_id%TYPE; /*uncommented for customer account relation*/
215: -- var_new_customer_id pa_project_contacts.customer_id%TYPE;

Line 212: var_contact_type_code pa_project_contacts.project_contact_type_code%TYPE;

208:
209: var_project_id pa_project_contacts.project_id%TYPE;
210: var_customer_id pa_project_contacts.customer_id%TYPE;
211: var_contact_id pa_project_contacts.contact_id%TYPE;
212: var_contact_type_code pa_project_contacts.project_contact_type_code%TYPE;
213: var_bill_ship_customer_id pa_project_contacts.bill_ship_customer_id%TYPE;/*Added for customer account*/
214: var_old_customer_id pa_project_contacts.customer_id%TYPE; /*uncommented for customer account relation*/
215: -- var_new_customer_id pa_project_contacts.customer_id%TYPE;
216: var_racm_customer_id ra_customer_merges.customer_id%TYPE;/*Added for TCA AUDIT */

Line 213: var_bill_ship_customer_id pa_project_contacts.bill_ship_customer_id%TYPE;/Added for customer account/

209: var_project_id pa_project_contacts.project_id%TYPE;
210: var_customer_id pa_project_contacts.customer_id%TYPE;
211: var_contact_id pa_project_contacts.contact_id%TYPE;
212: var_contact_type_code pa_project_contacts.project_contact_type_code%TYPE;
213: var_bill_ship_customer_id pa_project_contacts.bill_ship_customer_id%TYPE;/*Added for customer account*/
214: var_old_customer_id pa_project_contacts.customer_id%TYPE; /*uncommented for customer account relation*/
215: -- var_new_customer_id pa_project_contacts.customer_id%TYPE;
216: var_racm_customer_id ra_customer_merges.customer_id%TYPE;/*Added for TCA AUDIT */
217: var_cust_merge_header_id ra_customer_merges.CUSTOMER_MERGE_HEADER_ID%TYPE;/*Added for TCA AUDIT */

Line 214: var_old_customer_id pa_project_contacts.customer_id%TYPE; /uncommented for customer account relation/

210: var_customer_id pa_project_contacts.customer_id%TYPE;
211: var_contact_id pa_project_contacts.contact_id%TYPE;
212: var_contact_type_code pa_project_contacts.project_contact_type_code%TYPE;
213: var_bill_ship_customer_id pa_project_contacts.bill_ship_customer_id%TYPE;/*Added for customer account*/
214: var_old_customer_id pa_project_contacts.customer_id%TYPE; /*uncommented for customer account relation*/
215: -- var_new_customer_id pa_project_contacts.customer_id%TYPE;
216: var_racm_customer_id ra_customer_merges.customer_id%TYPE;/*Added for TCA AUDIT */
217: var_cust_merge_header_id ra_customer_merges.CUSTOMER_MERGE_HEADER_ID%TYPE;/*Added for TCA AUDIT */
218:

Line 215: -- var_new_customer_id pa_project_contacts.customer_id%TYPE;

211: var_contact_id pa_project_contacts.contact_id%TYPE;
212: var_contact_type_code pa_project_contacts.project_contact_type_code%TYPE;
213: var_bill_ship_customer_id pa_project_contacts.bill_ship_customer_id%TYPE;/*Added for customer account*/
214: var_old_customer_id pa_project_contacts.customer_id%TYPE; /*uncommented for customer account relation*/
215: -- var_new_customer_id pa_project_contacts.customer_id%TYPE;
216: var_racm_customer_id ra_customer_merges.customer_id%TYPE;/*Added for TCA AUDIT */
217: var_cust_merge_header_id ra_customer_merges.CUSTOMER_MERGE_HEADER_ID%TYPE;/*Added for TCA AUDIT */
218:
219: data_found BOOLEAN;

Line 227: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE_BB1.MERGE_PA_PROJECT_CONTACTS()+' );

223: BEGIN
224: --
225: -- update log file for entering this module successfully.
226: --
227: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE_BB1.MERGE_PA_PROJECT_CONTACTS()+' );
228: --
229: -- update log file to indicate table name being updated.
230: --
231: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );

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

228: --
229: -- update log file to indicate table name being updated.
230: --
231: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
232: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJECT_CONTACTS' );
233: --
234: OPEN cursor_3;
235: --
236: LOOP

Line 238: -- fetch each row from pa_project_contacts table.

234: OPEN cursor_3;
235: --
236: LOOP
237: --
238: -- fetch each row from pa_project_contacts table.
239: --
240: FETCH cursor_3 INTO var_project_id,
241: var_customer_id,
242: var_contact_id,

Line 288: -- PA_PROJECT_CONTACTS table the new and old contact id.

284: --
285: IF pap_cmerge.g_audit_profile = 'Y' THEN
286: --
287: -- Inserting data into HZ_CUSTOMER_MERGE_LOG table for
288: -- PA_PROJECT_CONTACTS table the new and old contact id.
289: --
290: INSERT INTO hz_customer_merge_log
291: (
292: MERGE_LOG_ID,

Line 312: 'PA_PROJECT_CONTACTS',

308: (SELECT
309: HZ_CUSTOMER_MERGE_LOG_S.nextval,
310: var_cust_merge_header_id,
311: req_id,
312: 'PA_PROJECT_CONTACTS',
313: var_project_id,
314: var_racm_customer_id,
315: PC.contact_id,
316: PC.project_contact_type_code,

Line 325: FROM pa_project_contacts PC

321: hz_utility_pub.CREATION_DATE,
322: hz_utility_pub.LAST_UPDATE_LOGIN,
323: hz_utility_pub.LAST_UPDATE_DATE,
324: hz_utility_pub.LAST_UPDATED_BY
325: FROM pa_project_contacts PC
326: WHERE PC.PROJECT_ID = var_project_id
327: AND PC.CUSTOMER_ID = var_customer_id);
328:
329:

Line 334: -- update table pa_project_contacts with new customer_id.

330: END IF; -- end if of IF pap_cmerge.g_audit_profile = 'Y' THEN
331: --
332: /* end of Tca audit*/
333: --
334: -- update table pa_project_contacts with new customer_id.
335: --
336: UPDATE pa_project_contacts PC
337: SET CUSTOMER_ID = var_racm_customer_id,
338: LAST_UPDATE_DATE = SYSDATE,

Line 336: UPDATE pa_project_contacts PC

332: /* end of Tca audit*/
333: --
334: -- update table pa_project_contacts with new customer_id.
335: --
336: UPDATE pa_project_contacts PC
337: SET CUSTOMER_ID = var_racm_customer_id,
338: LAST_UPDATE_DATE = SYSDATE,
339: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
340: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

Line 359: -- fetch each row from pa_project_contacts table.

355: OPEN cursor_4;
356: --
357: LOOP
358: --
359: -- fetch each row from pa_project_contacts table.
360: --
361: FETCH cursor_4 INTO var_project_id,
362: var_customer_id,
363: var_contact_id,

Line 384: -- PA_PROJECT_CONTACTS table the new and old contact id.

380:
381: IF pap_cmerge.g_audit_profile = 'Y' THEN
382: --
383: -- Inserting data into HZ_CUSTOMER_MERGE_LOG table for
384: -- PA_PROJECT_CONTACTS table the new and old contact id.
385: --
386: /*The new customer_id will be present in var_customer_id*/
387: INSERT INTO hz_customer_merge_log
388: (

Line 409: 'PA_PROJECT_CONTACTS',

405: (SELECT
406: HZ_CUSTOMER_MERGE_LOG_S.nextval,
407: var_cust_merge_header_id,
408: req_id,
409: 'PA_PROJECT_CONTACTS',
410: var_project_id,
411: var_customer_id,
412: PC.contact_id,
413: PC.project_contact_type_code,

Line 422: FROM pa_project_contacts PC

418: hz_utility_pub.CREATION_DATE,
419: hz_utility_pub.LAST_UPDATE_LOGIN,
420: hz_utility_pub.LAST_UPDATE_DATE,
421: hz_utility_pub.LAST_UPDATED_BY
422: FROM pa_project_contacts PC
423: WHERE PC.PROJECT_ID = var_project_id
424: AND PC.CUSTOMER_ID = var_customer_id
425: AND PC.BILL_SHIP_CUSTOMER_ID=var_bill_ship_customer_id);
426:

Line 430: UPDATE pa_project_contacts PC

426:
427:
428: END IF; -- end if of IF pap_cmerge.g_audit_profile = 'Y' THEN
429:
430: UPDATE pa_project_contacts PC
431: SET BILL_SHIP_CUSTOMER_ID = var_racm_customer_id,
432: LAST_UPDATE_DATE = SYSDATE,
433: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
434: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

Line 465: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE_BB1.MERGE_PA_PROJECT_CONTACTS()-' );

461: total_record_del_count := 0;
462: --
463: -- update log file for exiting this module successfully.
464: --
465: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE_BB1.MERGE_PA_PROJECT_CONTACTS()-' );
466: --
467: EXCEPTION
468: --
469: WHEN OTHERS THEN

Line 470: ARP_MESSAGE.SET_ERROR( 'PAP_CMERGE_BB1.MERGE_PA_PROJECT_CONTACTS' );

466: --
467: EXCEPTION
468: --
469: WHEN OTHERS THEN
470: ARP_MESSAGE.SET_ERROR( 'PAP_CMERGE_BB1.MERGE_PA_PROJECT_CONTACTS' );
471: RAISE;
472:
473: END MERGE_PA_PROJECT_CONTACTS;
474: --

Line 473: END MERGE_PA_PROJECT_CONTACTS;

469: WHEN OTHERS THEN
470: ARP_MESSAGE.SET_ERROR( 'PAP_CMERGE_BB1.MERGE_PA_PROJECT_CONTACTS' );
471: RAISE;
472:
473: END MERGE_PA_PROJECT_CONTACTS;
474: --
475: END PAP_CMERGE_BB2;