APPS.GMS_CMERGE dependencies on GMS_DEFAULT_REPORTS

Line 488: | Account merge procedure for the table, GMS_DEFAULT_REPORTS

484: |
485: | PROCEDURE
486: | MERGE_DEFAULT_REPORTS
487: | DESCRIPTION :
488: | Account merge procedure for the table, GMS_DEFAULT_REPORTS
489: |
490: |--------------------------------------------------------------*/
491:
492: PROCEDURE MERGE_DEFAULT_REPORTS (

Line 503: GMS_DEFAULT_REPORTS.DEFAULT_REPORT_ID%TYPE

499: INDEX BY BINARY_INTEGER;
500: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
501:
502: TYPE DEFAULT_REPORT_ID_LIST_TYPE IS TABLE OF
503: GMS_DEFAULT_REPORTS.DEFAULT_REPORT_ID%TYPE
504: INDEX BY BINARY_INTEGER;
505: PRIMARY_KEY_ID_LIST DEFAULT_REPORT_ID_LIST_TYPE;
506:
507: TYPE SITE_USE_ID_LIST_TYPE IS TABLE OF

Line 508: GMS_DEFAULT_REPORTS.SITE_USE_ID%TYPE

504: INDEX BY BINARY_INTEGER;
505: PRIMARY_KEY_ID_LIST DEFAULT_REPORT_ID_LIST_TYPE;
506:
507: TYPE SITE_USE_ID_LIST_TYPE IS TABLE OF
508: GMS_DEFAULT_REPORTS.SITE_USE_ID%TYPE
509: INDEX BY BINARY_INTEGER;
510: NUM_COL1_ORIG_LIST SITE_USE_ID_LIST_TYPE;
511: NUM_COL1_NEW_LIST SITE_USE_ID_LIST_TYPE;
512:

Line 518: FROM GMS_DEFAULT_REPORTS yt, ra_customer_merges m

514: CURSOR merged_records IS
515: SELECT distinct CUSTOMER_MERGE_HEADER_ID
516: ,DEFAULT_REPORT_ID
517: ,SITE_USE_ID
518: FROM GMS_DEFAULT_REPORTS yt, ra_customer_merges m
519: WHERE (
520: yt.SITE_USE_ID = m.DUPLICATE_SITE_ID
521: ) AND m.process_flag = 'N'
522: AND m.request_id = req_id

Line 531: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','GMS_DEFAULT_REPORTS',FALSE);

527: IF process_mode='LOCK' THEN
528: NULL;
529: ELSE
530: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
531: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','GMS_DEFAULT_REPORTS',FALSE);
532: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
533: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
534:
535: open merged_records;

Line 569: 'GMS_DEFAULT_REPORTS',

565: LAST_UPDATE_LOGIN,
566: LAST_UPDATE_DATE,
567: LAST_UPDATED_BY
568: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
569: 'GMS_DEFAULT_REPORTS',
570: MERGE_HEADER_ID_LIST(I),
571: PRIMARY_KEY_ID_LIST(I),
572: NUM_COL1_ORIG_LIST(I),
573: NUM_COL1_NEW_LIST(I),

Line 584: UPDATE GMS_DEFAULT_REPORTS yt SET

580: hz_utility_pub.LAST_UPDATED_BY
581: );
582:
583: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
584: UPDATE GMS_DEFAULT_REPORTS yt SET
585: SITE_USE_ID=NUM_COL1_NEW_LIST(I)
586: , LAST_UPDATE_DATE=SYSDATE
587: , last_updated_by=arp_standard.profile.user_id
588: , last_update_login=arp_standard.profile.last_update_login