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
13: BEGIN
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
13: BEGIN
14: --
16: var_old_customer_id := NULL;
17: --
18: SELECT DISTINCT RACM.CUSTOMER_ID, RACM.DUPLICATE_ID INTO
19: var_new_customer_id, var_old_customer_id
20: FROM RA_CUSTOMER_MERGES RACM
21: WHERE RACM.DUPLICATE_ID = var_customer_id
22: AND RACM.PROCESS_FLAG = 'N'
23: AND RACM.SET_NUMBER = set_no;
24: --
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:
77: --
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
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
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;
220: total_record_upd_count NUMBER := 0;
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;
220: total_record_upd_count NUMBER := 0;
221: total_record_del_count NUMBER := 0;