APPS.OZF_ACCOUNT_MERGE_PKG dependencies on OZF_ACCOUNT_ALLOCATIONS

Line 13: | Account merge procedure for the table, ozf_account_allocations

9: |
10: | PROCEDURE
11: | merge_acct_alloc
12: | DESCRIPTION :
13: | Account merge procedure for the table, ozf_account_allocations
14: |
15: | NOTES:
16: |
17: |--------------------------------------------------------------*/

Line 30: ozf_account_allocations.account_allocation_id%TYPE

26: INDEX BY BINARY_INTEGER;
27: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
28:
29: TYPE account_alloc_id_LIST_TYPE IS TABLE OF
30: ozf_account_allocations.account_allocation_id%TYPE
31: INDEX BY BINARY_INTEGER;
32: PRIMARY_KEY_ID1_LIST account_alloc_id_LIST_TYPE;
33:
34: TYPE cust_account_id_LIST_TYPE IS TABLE OF

Line 35: ozf_account_allocations.cust_account_id%TYPE

31: INDEX BY BINARY_INTEGER;
32: PRIMARY_KEY_ID1_LIST account_alloc_id_LIST_TYPE;
33:
34: TYPE cust_account_id_LIST_TYPE IS TABLE OF
35: ozf_account_allocations.cust_account_id%TYPE
36: INDEX BY BINARY_INTEGER;
37: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
38: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
39:

Line 41: ozf_account_allocations.bill_to_site_use_id%TYPE

37: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
38: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
39:
40: TYPE bill_to_site_use_id_LIST_TYPE IS TABLE OF
41: ozf_account_allocations.bill_to_site_use_id%TYPE
42: INDEX BY BINARY_INTEGER;
43: NUM_COL2_ORIG_LIST bill_to_site_use_id_LIST_TYPE;
44: NUM_COL2_NEW_LIST bill_to_site_use_id_LIST_TYPE;
45:

Line 47: ozf_account_allocations.site_use_id%TYPE

43: NUM_COL2_ORIG_LIST bill_to_site_use_id_LIST_TYPE;
44: NUM_COL2_NEW_LIST bill_to_site_use_id_LIST_TYPE;
45:
46: TYPE site_use_id_LIST_TYPE IS TABLE OF
47: ozf_account_allocations.site_use_id%TYPE
48: INDEX BY BINARY_INTEGER;
49: NUM_COL3_ORIG_LIST site_use_id_LIST_TYPE;
50: NUM_COL3_NEW_LIST site_use_id_LIST_TYPE;
51:

Line 59: FROM ozf_account_allocations yt, ra_customer_merges m

55: ,account_allocation_id
56: ,cust_account_id
57: ,bill_to_site_use_id
58: ,site_use_id
59: FROM ozf_account_allocations yt, ra_customer_merges m
60: WHERE (
61: yt.cust_account_id = m.DUPLICATE_ADDRESS_ID
62: OR yt.bill_to_site_use_id = m.DUPLICATE_SITE_ID
63: OR yt.site_use_id = m.DUPLICATE_SITE_ID

Line 74: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_account_allocations',FALSE);

70: IF process_mode='LOCK' THEN
71: NULL;
72: ELSE
73: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
74: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_account_allocations',FALSE);
75: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
76: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
77:
78: open merged_records;

Line 120: 'ozf_account_allocations',

116: LAST_UPDATE_LOGIN,
117: LAST_UPDATE_DATE,
118: LAST_UPDATED_BY
119: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
120: 'ozf_account_allocations',
121: MERGE_HEADER_ID_LIST(I),
122: PRIMARY_KEY_ID1_LIST(I),
123: NUM_COL1_ORIG_LIST(I),
124: NUM_COL1_NEW_LIST(I),

Line 139: UPDATE ozf_account_allocations yt SET

135: hz_utility_pub.LAST_UPDATED_BY
136: );
137:
138: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
139: UPDATE ozf_account_allocations yt SET
140: cust_account_id=NUM_COL1_NEW_LIST(I)
141: ,bill_to_site_use_id=NUM_COL2_NEW_LIST(I)
142: ,site_use_id=NUM_COL3_NEW_LIST(I)
143: , LAST_UPDATE_DATE=SYSDATE