APPS.PV_ACCOUNT_MERGE_PKG dependencies on PV_REFERRALS_B

Line 21: | Account merge procedure for the table, PV_REFERRALS_B

17: |
18: | PROCEDURE
19: | MERGE_REFERRAL_ACCOUNT
20: | DESCRIPTION :
21: | Account merge procedure for the table, PV_REFERRALS_B
22: |
23: |--------------------------------------------------------------*/
24:
25: PROCEDURE MERGE_REFERRAL_ACCOUNT (

Line 36: PV_REFERRALS_B.REFERRAL_ID%TYPE

32: INDEX BY BINARY_INTEGER;
33: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
34:
35: TYPE REFERRAL_ID_LIST_TYPE IS TABLE OF
36: PV_REFERRALS_B.REFERRAL_ID%TYPE
37: INDEX BY BINARY_INTEGER;
38: PRIMARY_KEY_ID_LIST REFERRAL_ID_LIST_TYPE;
39:
40: TYPE PARTNER_CUST_ACCOUNT_ID_TYPE IS TABLE OF

Line 41: PV_REFERRALS_B.PARTNER_CUST_ACCOUNT_ID%TYPE

37: INDEX BY BINARY_INTEGER;
38: PRIMARY_KEY_ID_LIST REFERRAL_ID_LIST_TYPE;
39:
40: TYPE PARTNER_CUST_ACCOUNT_ID_TYPE IS TABLE OF
41: PV_REFERRALS_B.PARTNER_CUST_ACCOUNT_ID%TYPE
42: INDEX BY BINARY_INTEGER;
43:
44: NUM_COL1_ORIG_LIST PARTNER_CUST_ACCOUNT_ID_TYPE;
45: NUM_COL1_NEW_LIST PARTNER_CUST_ACCOUNT_ID_TYPE;

Line 53: FROM PV_REFERRALS_B yt, ra_customer_merges m

49: CURSOR merged_records IS
50: SELECT distinct CUSTOMER_MERGE_HEADER_ID
51: ,REFERRAL_ID
52: ,PARTNER_CUST_ACCOUNT_ID
53: FROM PV_REFERRALS_B yt, ra_customer_merges m
54: WHERE (
55: yt.PARTNER_CUST_ACCOUNT_ID = m.DUPLICATE_ID
56: ) AND m.process_flag = 'N'
57: AND m.request_id = req_id

Line 69: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PV_REFERRALS_B',FALSE);

65: NULL;
66:
67: ELSE
68: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
69: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','PV_REFERRALS_B',FALSE);
70: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
71: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
72:
73: OPEN merged_records;

Line 111: 'PV_REFERRALS_B',

107: LAST_UPDATE_LOGIN,
108: LAST_UPDATE_DATE,
109: LAST_UPDATED_BY
110: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
111: 'PV_REFERRALS_B',
112: MERGE_HEADER_ID_LIST(I),
113: PRIMARY_KEY_ID_LIST(I),
114: NUM_COL1_ORIG_LIST(I),
115: NUM_COL1_NEW_LIST(I),

Line 128: UPDATE PV_REFERRALS_B yt SET

124:
125: END IF;
126:
127: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
128: UPDATE PV_REFERRALS_B yt SET
129: PARTNER_CUST_ACCOUNT_ID=NUM_COL1_NEW_LIST(I)
130: , LAST_UPDATE_DATE=SYSDATE
131: , last_updated_by=arp_standard.profile.user_id
132: , last_update_login=arp_standard.profile.last_update_login