APPS.GMS_CMERGE dependencies on GMS_REPORTS

Line 364: | Account merge procedure for the table, GMS_REPORTS

360: |
361: | PROCEDURE
362: | MERGE_REPORTS
363: | DESCRIPTION :
364: | Account merge procedure for the table, GMS_REPORTS
365: |
366: |--------------------------------------------------------------*/
367:
368: PROCEDURE MERGE_REPORTS (

Line 379: GMS_REPORTS.REPORT_ID%TYPE

375: INDEX BY BINARY_INTEGER;
376: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
377:
378: TYPE REPORT_ID_LIST_TYPE IS TABLE OF
379: GMS_REPORTS.REPORT_ID%TYPE
380: INDEX BY BINARY_INTEGER;
381: PRIMARY_KEY_ID_LIST REPORT_ID_LIST_TYPE;
382:
383: TYPE SITE_USE_ID_LIST_TYPE IS TABLE OF

Line 384: GMS_REPORTS.SITE_USE_ID%TYPE

380: INDEX BY BINARY_INTEGER;
381: PRIMARY_KEY_ID_LIST REPORT_ID_LIST_TYPE;
382:
383: TYPE SITE_USE_ID_LIST_TYPE IS TABLE OF
384: GMS_REPORTS.SITE_USE_ID%TYPE
385: INDEX BY BINARY_INTEGER;
386: NUM_COL1_ORIG_LIST SITE_USE_ID_LIST_TYPE;
387: NUM_COL1_NEW_LIST SITE_USE_ID_LIST_TYPE;
388:

Line 394: FROM GMS_REPORTS yt, ra_customer_merges m

390: CURSOR merged_records IS
391: SELECT distinct CUSTOMER_MERGE_HEADER_ID
392: ,REPORT_ID
393: ,SITE_USE_ID
394: FROM GMS_REPORTS yt, ra_customer_merges m
395: WHERE (
396: yt.SITE_USE_ID = m.DUPLICATE_SITE_ID
397: ) AND m.process_flag = 'N'
398: AND m.request_id = req_id

Line 407: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','GMS_REPORTS',FALSE);

403: IF process_mode='LOCK' THEN
404: NULL;
405: ELSE
406: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
407: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','GMS_REPORTS',FALSE);
408: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
409: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
410:
411: open merged_records;

Line 445: 'GMS_REPORTS',

441: LAST_UPDATE_LOGIN,
442: LAST_UPDATE_DATE,
443: LAST_UPDATED_BY
444: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
445: 'GMS_REPORTS',
446: MERGE_HEADER_ID_LIST(I),
447: PRIMARY_KEY_ID_LIST(I),
448: NUM_COL1_ORIG_LIST(I),
449: NUM_COL1_NEW_LIST(I),

Line 460: UPDATE GMS_REPORTS yt SET

456: hz_utility_pub.LAST_UPDATED_BY
457: );
458:
459: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
460: UPDATE GMS_REPORTS yt SET
461: SITE_USE_ID=NUM_COL1_NEW_LIST(I)
462: , LAST_UPDATE_DATE=SYSDATE
463: , last_updated_by=arp_standard.profile.user_id
464: , last_update_login=arp_standard.profile.last_update_login