APPS.OTAP_CMERGE dependencies on OTA_NOTRNG_HISTORIES

Line 816: | Account merge procedure for the table, OTA_NOTRNG_HISTORIES

812: |
813: | PROCEDURE
814: | OTA_TNH
815: | DESCRIPTION :
816: | Account merge procedure for the table, OTA_NOTRNG_HISTORIES
817: |
818: | NOTES:
819: |--------------------------------------------------------------*/
820: PROCEDURE OTA_TNH (

Line 831: OTA_NOTRNG_HISTORIES.NOTA_HISTORY_ID%TYPE

827: INDEX BY BINARY_INTEGER;
828: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
829:
830: TYPE NOTA_HISTORY_ID_LIST_TYPE IS TABLE OF
831: OTA_NOTRNG_HISTORIES.NOTA_HISTORY_ID%TYPE
832: INDEX BY BINARY_INTEGER;
833: PRIMARY_KEY_ID1_LIST NOTA_HISTORY_ID_LIST_TYPE;
834:
835: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 836: OTA_NOTRNG_HISTORIES.CUSTOMER_ID%TYPE

832: INDEX BY BINARY_INTEGER;
833: PRIMARY_KEY_ID1_LIST NOTA_HISTORY_ID_LIST_TYPE;
834:
835: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
836: OTA_NOTRNG_HISTORIES.CUSTOMER_ID%TYPE
837: INDEX BY BINARY_INTEGER;
838: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
839: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
840:

Line 846: FROM OTA_NOTRNG_HISTORIES yt, ra_customer_merges m

842: CURSOR merged_records IS
843: SELECT distinct CUSTOMER_MERGE_HEADER_ID
844: ,NOTA_HISTORY_ID
845: ,yt.CUSTOMER_ID
846: FROM OTA_NOTRNG_HISTORIES yt, ra_customer_merges m
847: WHERE (
848: yt.CUSTOMER_ID = m.DUPLICATE_ID
849: ) AND m.process_flag = 'N'
850: AND m.request_id = req_id

Line 859: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_NOTRNG_HISTORIES',FALSE);

855: IF process_mode='LOCK' THEN
856: NULL;
857: ELSE
858: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
859: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_NOTRNG_HISTORIES',FALSE);
860: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
861: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
862:
863: open merged_records;

Line 896: 'OTA_NOTRNG_HISTORIES',

892: LAST_UPDATE_LOGIN,
893: LAST_UPDATE_DATE,
894: LAST_UPDATED_BY
895: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
896: 'OTA_NOTRNG_HISTORIES',
897: MERGE_HEADER_ID_LIST(I),
898: PRIMARY_KEY_ID1_LIST(I),
899: NUM_COL1_ORIG_LIST(I),
900: NUM_COL1_NEW_LIST(I),

Line 911: UPDATE OTA_NOTRNG_HISTORIES yt SET

907: hz_utility_pub.LAST_UPDATED_BY
908: );
909:
910: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
911: UPDATE OTA_NOTRNG_HISTORIES yt SET
912: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
913: , LAST_UPDATE_DATE=SYSDATE
914: , last_updated_by=arp_standard.profile.user_id
915: , last_update_login=arp_standard.profile.last_update_login