APPS.OZF_ACCOUNT_MERGE_PKG dependencies on OZF_CODE_CONVERSIONS

Line 864: | Account merge procedure for the table, ozf_code_conversions

860: |
861: | PROCEDURE
862: | merge_code_conversions
863: | DESCRIPTION :
864: | Account merge procedure for the table, ozf_code_conversions
865: |
866: | NOTES:
867: |
868: |--------------------------------------------------------------*/

Line 881: ozf_code_conversions.code_conversion_id%TYPE

877: INDEX BY BINARY_INTEGER;
878: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
879:
880: TYPE code_conversion_id_LIST_TYPE IS TABLE OF
881: ozf_code_conversions.code_conversion_id%TYPE
882: INDEX BY BINARY_INTEGER;
883: PRIMARY_KEY_ID1_LIST code_conversion_id_LIST_TYPE;
884:
885: TYPE cust_account_id_LIST_TYPE IS TABLE OF

Line 886: ozf_code_conversions.cust_account_id%TYPE

882: INDEX BY BINARY_INTEGER;
883: PRIMARY_KEY_ID1_LIST code_conversion_id_LIST_TYPE;
884:
885: TYPE cust_account_id_LIST_TYPE IS TABLE OF
886: ozf_code_conversions.cust_account_id%TYPE
887: INDEX BY BINARY_INTEGER;
888: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
889: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
890:

Line 896: FROM ozf_code_conversions yt, ra_customer_merges m

892: CURSOR merged_records IS
893: SELECT distinct CUSTOMER_MERGE_HEADER_ID
894: ,code_conversion_id
895: ,cust_account_id
896: FROM ozf_code_conversions yt, ra_customer_merges m
897: WHERE (
898: yt.cust_account_id = m.DUPLICATE_ID
899: ) AND m.process_flag = 'N'
900: AND m.request_id = req_id

Line 909: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_code_conversions',FALSE);

905: IF process_mode='LOCK' THEN
906: NULL;
907: ELSE
908: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
909: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_code_conversions',FALSE);
910: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
911: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
912:
913: open merged_records;

Line 946: 'ozf_code_conversions',

942: LAST_UPDATE_LOGIN,
943: LAST_UPDATE_DATE,
944: LAST_UPDATED_BY
945: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
946: 'ozf_code_conversions',
947: MERGE_HEADER_ID_LIST(I),
948: PRIMARY_KEY_ID1_LIST(I),
949: NUM_COL1_ORIG_LIST(I),
950: NUM_COL1_NEW_LIST(I),

Line 961: UPDATE ozf_code_conversions yt SET

957: hz_utility_pub.LAST_UPDATED_BY
958: );
959:
960: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
961: UPDATE ozf_code_conversions yt SET
962: cust_account_id=NUM_COL1_NEW_LIST(I)
963: , LAST_UPDATE_DATE=SYSDATE
964: , last_updated_by=arp_standard.profile.user_id
965: , last_update_login=arp_standard.profile.last_update_login