APPS.ISC_DBI_ACCT_MERGE_PKG dependencies on ISC_BOOK_SUM2_PDUE2_F

Line 142: PROCEDURE ISC_BOOK_SUM2_PDUE2_F_AM (

138: arp_message.set_line( 'ISC_BOOK_SUM2_PDUE_F_AM');
139: RAISE;
140: END ISC_BOOK_SUM2_PDUE_F_AM;
141:
142: PROCEDURE ISC_BOOK_SUM2_PDUE2_F_AM (
143: req_id NUMBER,
144: set_num NUMBER,
145: process_mode VARCHAR2) IS
146:

Line 153: ISC_BOOK_SUM2_PDUE2_F.LINE_ID%TYPE

149: INDEX BY BINARY_INTEGER;
150: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
151:
152: TYPE LINE_ID_LIST_TYPE IS TABLE OF
153: ISC_BOOK_SUM2_PDUE2_F.LINE_ID%TYPE
154: INDEX BY BINARY_INTEGER;
155: PRIMARY_KEY_ID1_LIST LINE_ID_LIST_TYPE;
156:
157: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 158: ISC_BOOK_SUM2_PDUE2_F.CUSTOMER_ID%TYPE

154: INDEX BY BINARY_INTEGER;
155: PRIMARY_KEY_ID1_LIST LINE_ID_LIST_TYPE;
156:
157: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
158: ISC_BOOK_SUM2_PDUE2_F.CUSTOMER_ID%TYPE
159: INDEX BY BINARY_INTEGER;
160: NUM_COL0_NEW_LIST CUSTOMER_ID_LIST_TYPE;
161:
162: TYPE SOLD_TO_ORG_ID_LIST_TYPE IS TABLE OF

Line 163: ISC_BOOK_SUM2_PDUE2_F.SOLD_TO_ORG_ID%TYPE

159: INDEX BY BINARY_INTEGER;
160: NUM_COL0_NEW_LIST CUSTOMER_ID_LIST_TYPE;
161:
162: TYPE SOLD_TO_ORG_ID_LIST_TYPE IS TABLE OF
163: ISC_BOOK_SUM2_PDUE2_F.SOLD_TO_ORG_ID%TYPE
164: INDEX BY BINARY_INTEGER;
165: NUM_COL1_ORIG_LIST SOLD_TO_ORG_ID_LIST_TYPE;
166: NUM_COL1_NEW_LIST SOLD_TO_ORG_ID_LIST_TYPE;
167:

Line 169: ISC_BOOK_SUM2_PDUE2_F.SHIP_TO_ORG_ID%TYPE

165: NUM_COL1_ORIG_LIST SOLD_TO_ORG_ID_LIST_TYPE;
166: NUM_COL1_NEW_LIST SOLD_TO_ORG_ID_LIST_TYPE;
167:
168: TYPE SHIP_TO_ORG_ID_LIST_TYPE IS TABLE OF
169: ISC_BOOK_SUM2_PDUE2_F.SHIP_TO_ORG_ID%TYPE
170: INDEX BY BINARY_INTEGER;
171: NUM_COL2_ORIG_LIST SHIP_TO_ORG_ID_LIST_TYPE;
172: NUM_COL2_NEW_LIST SHIP_TO_ORG_ID_LIST_TYPE;
173:

Line 181: FROM ISC_BOOK_SUM2_PDUE2_F yt, ra_customer_merges m

177: SELECT distinct CUSTOMER_MERGE_HEADER_ID
178: ,LINE_ID
179: ,SOLD_TO_ORG_ID
180: ,SHIP_TO_ORG_ID
181: FROM ISC_BOOK_SUM2_PDUE2_F yt, ra_customer_merges m
182: WHERE (
183: yt.SOLD_TO_ORG_ID = m.DUPLICATE_ID
184: OR yt.SHIP_TO_ORG_ID = m.DUPLICATE_SITE_ID
185: ) AND m.process_flag = 'N'

Line 195: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ISC_BOOK_SUM2_PDUE2_F',FALSE);

191: IF process_mode='LOCK' THEN
192: NULL;
193: ELSE
194: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
195: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ISC_BOOK_SUM2_PDUE2_F',FALSE);
196: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
197: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
198:
199: open merged_records;

Line 242: 'ISC_BOOK_SUM2_PDUE2_F',

238: LAST_UPDATE_LOGIN,
239: LAST_UPDATE_DATE,
240: LAST_UPDATED_BY
241: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
242: 'ISC_BOOK_SUM2_PDUE2_F',
243: MERGE_HEADER_ID_LIST(I),
244: PRIMARY_KEY_ID1_LIST(I),
245: NUM_COL1_ORIG_LIST(I),
246: NUM_COL1_NEW_LIST(I),

Line 259: UPDATE ISC_BOOK_SUM2_PDUE2_F yt SET

255: hz_utility_pub.LAST_UPDATED_BY
256: );
257:
258: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
259: UPDATE ISC_BOOK_SUM2_PDUE2_F yt SET
260: SOLD_TO_ORG_ID=NUM_COL1_NEW_LIST(I)
261: ,SHIP_TO_ORG_ID=NUM_COL2_NEW_LIST(I)
262: ,CUSTOMER_ID=NUM_COL0_NEW_LIST(I)
263: WHERE LINE_ID=PRIMARY_KEY_ID1_LIST(I)

Line 276: arp_message.set_line( 'ISC_BOOK_SUM2_PDUE2_F_AM');

272: arp_message.set_token('NUM_ROWS',to_char(l_count));
273: END IF;
274: EXCEPTION
275: WHEN OTHERS THEN
276: arp_message.set_line( 'ISC_BOOK_SUM2_PDUE2_F_AM');
277: RAISE;
278: END ISC_BOOK_SUM2_PDUE2_F_AM;
279:
280: PROCEDURE ISC_BOOK_SUM2_BKORD_F_AM (

Line 278: END ISC_BOOK_SUM2_PDUE2_F_AM;

274: EXCEPTION
275: WHEN OTHERS THEN
276: arp_message.set_line( 'ISC_BOOK_SUM2_PDUE2_F_AM');
277: RAISE;
278: END ISC_BOOK_SUM2_PDUE2_F_AM;
279:
280: PROCEDURE ISC_BOOK_SUM2_BKORD_F_AM (
281: req_id NUMBER,
282: set_num NUMBER,