eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTAP_CMERGE dependencies on OTA_EVENT_ASSOCIATIONS

Line 498: | Account merge procedure for the table, OTA_EVENT_ASSOCIATIONS

Line 513: OTA_EVENT_ASSOCIATIONS.EVENT_ASSOCIATION_ID%TYPE

509: INDEX BY BINARY_INTEGER;
510: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
511:
512: TYPE EVENT_ASSOCIATION_ID_LIST_TYPE IS TABLE OF
513: OTA_EVENT_ASSOCIATIONS.EVENT_ASSOCIATION_ID%TYPE
514: INDEX BY BINARY_INTEGER;
515: PRIMARY_KEY_ID1_LIST EVENT_ASSOCIATION_ID_LIST_TYPE;
516:
517: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 518: OTA_EVENT_ASSOCIATIONS.CUSTOMER_ID%TYPE

514: INDEX BY BINARY_INTEGER;
515: PRIMARY_KEY_ID1_LIST EVENT_ASSOCIATION_ID_LIST_TYPE;
516:
517: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
518: OTA_EVENT_ASSOCIATIONS.CUSTOMER_ID%TYPE
519: INDEX BY BINARY_INTEGER;
520: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
521: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
522:

Line 524: OTA_EVENT_ASSOCIATIONS.EVENT_ID%TYPE

520: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
521: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
522:
523: TYPE EVENT_ID_LIST_TYPE IS TABLE OF
524: OTA_EVENT_ASSOCIATIONS.EVENT_ID%TYPE
525: INDEX BY BINARY_INTEGER;
526:
527: EVENT_ID_LIST EVENT_ID_LIST_TYPE;
528:

Line 535: FROM OTA_EVENT_ASSOCIATIONS yt, ra_customer_merges m

531: SELECT distinct CUSTOMER_MERGE_HEADER_ID
532: ,EVENT_ASSOCIATION_ID
533: ,yt.CUSTOMER_ID
534: ,EVENT_ID
535: FROM OTA_EVENT_ASSOCIATIONS yt, ra_customer_merges m
536: WHERE (
537: yt.CUSTOMER_ID = m.DUPLICATE_ID
538: ) AND m.process_flag = 'N'
539: AND m.request_id = req_id

Line 545: FROM OTA_EVENT_ASSOCIATIONS tea

541:
542: CURSOR csr_duplicate_record(EVENT_ID NUMBER
543: ,TO_CUSTOMER NUMBER) IS
544: SELECT NULL
545: FROM OTA_EVENT_ASSOCIATIONS tea
546: WHERE tea.event_id = event_id
547: AND tea.CUSTOMER_ID = TO_CUSTOMER;
548:
549: CURSOR csr_evt_assoc(P_EVENT_ASSOCIATION_ID NUMBER) IS

Line 551: from ota_event_associations

547: AND tea.CUSTOMER_ID = TO_CUSTOMER;
548:
549: CURSOR csr_evt_assoc(P_EVENT_ASSOCIATION_ID NUMBER) IS
550: select *
551: from ota_event_associations
552: where EVENT_ASSOCIATION_ID = P_EVENT_ASSOCIATION_ID;
553:
554: l_duplicate_result VARCHAR2(30);
555: l_last_fetch BOOLEAN := FALSE;

Line 564: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_EVENT_ASSOCIATIONS',FALSE);

560: IF process_mode='LOCK' THEN
561: NULL;
562: ELSE
563: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
564: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_EVENT_ASSOCIATIONS',FALSE);
565: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
566: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
567:
568: open merged_records;

Line 594: --Retrieve OTA_EVENT_ASSOCIATIONS data for HZ_CUSTOMER_MERGE_LOG record

590: FETCH csr_duplicate_record into l_duplicate_result;
591:
592: IF csr_duplicate_record%FOUND THEN
593:
594: --Retrieve OTA_EVENT_ASSOCIATIONS data for HZ_CUSTOMER_MERGE_LOG record
595: OPEN csr_evt_assoc(PRIMARY_KEY_ID1_LIST(I));
596: FETCH csr_evt_assoc into l_evt_assoc_rec;
597:
598: IF csr_evt_assoc%FOUND THEN

Line 656: , 'OTA_EVENT_ASSOCIATIONS'

652: LAST_UPDATE_LOGIN,
653: LAST_UPDATE_DATE,
654: LAST_UPDATED_BY
655: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval
656: , 'OTA_EVENT_ASSOCIATIONS'
657: , MERGE_HEADER_ID_LIST(I)
658: , PRIMARY_KEY_ID1_LIST(I)
659: , NUM_COL1_ORIG_LIST(I)
660: , NUM_COL1_NEW_LIST(I)

Line 712: DELETE OTA_EVENT_ASSOCIATIONS

708: , hz_utility_pub.LAST_UPDATE_DATE
709: , hz_utility_pub.LAST_UPDATED_BY
710: );
711: --Purge the "Merge From" record
712: DELETE OTA_EVENT_ASSOCIATIONS
713: WHERE EVENT_ASSOCIATION_ID=PRIMARY_KEY_ID1_LIST(I)
714: ;
715: l_del_count := l_del_count + SQL%ROWCOUNT;
716: -- remove table entries

Line 740: 'OTA_EVENT_ASSOCIATIONS',

736: LAST_UPDATE_LOGIN,
737: LAST_UPDATE_DATE,
738: LAST_UPDATED_BY
739: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
740: 'OTA_EVENT_ASSOCIATIONS',
741: MERGE_HEADER_ID_LIST(I),
742: PRIMARY_KEY_ID1_LIST(I),
743: NUM_COL1_ORIG_LIST(I),
744: NUM_COL1_NEW_LIST(I),

Line 764: DELETE OTA_EVENT_ASSOCIATIONS

760: FETCH csr_duplicate_record into l_duplicate_result;
761:
762: IF csr_duplicate_record%FOUND THEN
763: --Purge the "Merge From" record
764: DELETE OTA_EVENT_ASSOCIATIONS
765: WHERE EVENT_ASSOCIATION_ID=PRIMARY_KEY_ID1_LIST(I)
766: ;
767: l_del_count := l_del_count + SQL%ROWCOUNT;
768: -- remove pl/sql table entries

Line 786: UPDATE OTA_EVENT_ASSOCIATIONS yt SET

782: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
783: IF MERGE_HEADER_ID_LIST.COUNT = 0 THEN
784: exit;
785: END IF;
786: UPDATE OTA_EVENT_ASSOCIATIONS yt SET
787: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
788: , LAST_UPDATE_DATE=SYSDATE
789: , last_updated_by=arp_standard.profile.user_id
790: , last_update_login=arp_standard.profile.last_update_login