APPS.CSP_MERGE_PKG dependencies on CSP_RS_CUST_RELATIONS

Line 10: -- CSP_RS_CUST_RELATIONS

6: -- Spares tables that need to be considered for
7: -- Party Merge are:
8: -- CSP_MOVEORDER_HEADERS
9: -- CSP_PACKLIST_HEADERS
10: -- CSP_RS_CUST_RELATIONS
11:
12: --
13: -- History
14: -- Date NAME MODIFICATIONS

Line 189: CSP_RS_CUST_RELATIONS.RS_CUST_RELATION_ID%TYPE

185: INDEX BY BINARY_INTEGER;
186: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
187:
188: TYPE RS_CUST_RELATION_ID_LIST_TYPE IS TABLE OF
189: CSP_RS_CUST_RELATIONS.RS_CUST_RELATION_ID%TYPE
190: INDEX BY BINARY_INTEGER;
191: PRIMARY_KEY_ID_LIST RS_CUST_RELATION_ID_LIST_TYPE;
192:
193: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 194: CSP_RS_CUST_RELATIONS.CUSTOMER_ID%TYPE

190: INDEX BY BINARY_INTEGER;
191: PRIMARY_KEY_ID_LIST RS_CUST_RELATION_ID_LIST_TYPE;
192:
193: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
194: CSP_RS_CUST_RELATIONS.CUSTOMER_ID%TYPE
195: INDEX BY BINARY_INTEGER;
196: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
197: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
198:

Line 204: FROM CSP_RS_CUST_RELATIONS yt, ra_customer_merges m

200: CURSOR merged_records IS
201: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
202: ,yt.RS_CUST_RELATION_ID
203: ,yt.CUSTOMER_ID
204: FROM CSP_RS_CUST_RELATIONS yt, ra_customer_merges m
205: WHERE (
206: yt.CUSTOMER_ID = m.DUPLICATE_ID
207: ) AND m.process_flag = 'N'
208: AND m.request_id = req_id

Line 217: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSP_RS_CUST_RELATIONS',FALSE);

213: IF process_mode='LOCK' THEN
214: NULL;
215: ELSE
216: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
217: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSP_RS_CUST_RELATIONS',FALSE);
218: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
219: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
220:
221: open merged_records;

Line 254: 'CSP_RS_CUST_RELATIONS',

250: LAST_UPDATE_LOGIN,
251: LAST_UPDATE_DATE,
252: LAST_UPDATED_BY
253: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
254: 'CSP_RS_CUST_RELATIONS',
255: MERGE_HEADER_ID_LIST(I),
256: PRIMARY_KEY_ID_LIST(I),
257: NUM_COL1_ORIG_LIST(I),
258: NUM_COL1_NEW_LIST(I),

Line 269: UPDATE CSP_RS_CUST_RELATIONS yt SET

265: hz_utility_pub.LAST_UPDATED_BY
266: );
267:
268: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
269: UPDATE CSP_RS_CUST_RELATIONS yt SET
270: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
271: , LAST_UPDATE_DATE=SYSDATE
272: , last_updated_by=arp_standard.profile.user_id
273: , last_update_login=arp_standard.profile.last_update_login