DBA Data[Home] [Help]

APPS.PAP_CMERGE_BB2 dependencies on RA_CUSTOMER_MERGES

Line 9: var_new_customer_id OUT NOCOPY ra_customer_merges.customer_id%TYPE,/*File.sql.39*/

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

Line 10: var_old_customer_id OUT NOCOPY ra_customer_merges.customer_id%TYPE /*File.sql.39*/ )

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: --

Line 20: FROM RA_CUSTOMER_MERGES RACM

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: --

Line 73: var_cust_merge_head_id IN ra_customer_merges.customer_merge_header_id%TYPE,

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: --

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 216: var_racm_customer_id ra_customer_merges.customer_id%TYPE;/*Added for TCA AUDIT */

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;

Line 217: var_cust_merge_header_id ra_customer_merges.CUSTOMER_MERGE_HEADER_ID%TYPE;/*Added for TCA AUDIT */

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;