APPS.GMS_CMERGE dependencies on GMS_AWARDS_CONTACTS

Line 213: | Account merge procedure for the table, GMS_AWARDS_CONTACTS

209: |
210: | PROCEDURE
211: | MERGE_CONTACTS
212: | DESCRIPTION :
213: | Account merge procedure for the table, GMS_AWARDS_CONTACTS
214: |
215: |--------------------------------------------------------------*/
216:
217: PROCEDURE MERGE_CONTACTS (

Line 228: GMS_AWARDS_CONTACTS.AWARD_ID%TYPE

224: INDEX BY BINARY_INTEGER;
225: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
226:
227: TYPE AWARD_ID_LIST_TYPE IS TABLE OF
228: GMS_AWARDS_CONTACTS.AWARD_ID%TYPE
229: INDEX BY BINARY_INTEGER;
230: PRIMARY_KEY1_LIST AWARD_ID_LIST_TYPE;
231:
232: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 233: GMS_AWARDS_CONTACTS.CUSTOMER_ID%TYPE

229: INDEX BY BINARY_INTEGER;
230: PRIMARY_KEY1_LIST AWARD_ID_LIST_TYPE;
231:
232: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
233: GMS_AWARDS_CONTACTS.CUSTOMER_ID%TYPE
234: INDEX BY BINARY_INTEGER;
235: PRIMARY_KEY2_LIST CUSTOMER_ID_LIST_TYPE;
236:
237: TYPE CONTACT_ID_LIST_TYPE IS TABLE OF

Line 238: GMS_AWARDS_CONTACTS.CONTACT_ID%TYPE

234: INDEX BY BINARY_INTEGER;
235: PRIMARY_KEY2_LIST CUSTOMER_ID_LIST_TYPE;
236:
237: TYPE CONTACT_ID_LIST_TYPE IS TABLE OF
238: GMS_AWARDS_CONTACTS.CONTACT_ID%TYPE
239: INDEX BY BINARY_INTEGER;
240: PRIMARY_KEY3_LIST CONTACT_ID_LIST_TYPE;
241:
242: TYPE USAGE_CODE_LIST_TYPE IS TABLE OF

Line 243: GMS_AWARDS_CONTACTS.USAGE_CODE%TYPE

239: INDEX BY BINARY_INTEGER;
240: PRIMARY_KEY3_LIST CONTACT_ID_LIST_TYPE;
241:
242: TYPE USAGE_CODE_LIST_TYPE IS TABLE OF
243: GMS_AWARDS_CONTACTS.USAGE_CODE%TYPE
244: INDEX BY BINARY_INTEGER;
245: PRIMARY_KEY4_LIST USAGE_CODE_LIST_TYPE;
246:
247: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;

Line 258: FROM GMS_AWARDS_CONTACTS yt, ra_customer_merges m

254: ,yt.CUSTOMER_ID
255: ,yt.CONTACT_ID
256: ,yt.USAGE_CODE
257: ,yt.CUSTOMER_ID
258: FROM GMS_AWARDS_CONTACTS yt, ra_customer_merges m
259: WHERE (
260: yt.CUSTOMER_ID = m.DUPLICATE_ID
261: ) AND m.process_flag = 'N'
262: AND m.request_id = req_id

Line 271: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','GMS_AWARDS_CONTACTS',FALSE);

267: IF process_mode='LOCK' THEN
268: NULL;
269: ELSE
270: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
271: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','GMS_AWARDS_CONTACTS',FALSE);
272: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
273: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
274:
275: open merged_records;

Line 315: 'GMS_AWARDS_CONTACTS',

311: LAST_UPDATE_LOGIN,
312: LAST_UPDATE_DATE,
313: LAST_UPDATED_BY
314: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
315: 'GMS_AWARDS_CONTACTS',
316: MERGE_HEADER_ID_LIST(I),
317: PRIMARY_KEY1_LIST(I),
318: PRIMARY_KEY2_LIST(I),
319: PRIMARY_KEY3_LIST(I),

Line 333: UPDATE GMS_AWARDS_CONTACTS yt SET

329: hz_utility_pub.LAST_UPDATED_BY
330: );
331:
332: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
333: UPDATE GMS_AWARDS_CONTACTS yt SET
334: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
335: , LAST_UPDATE_DATE=SYSDATE
336: , last_updated_by=arp_standard.profile.user_id
337: , last_update_login=arp_standard.profile.last_update_login