APPS.ISC_DBI_ACCT_MERGE_PKG dependencies on ISC_BOOK_SUM2_PDUE_F

Line 4: PROCEDURE ISC_BOOK_SUM2_PDUE_F_AM (

1: PACKAGE BODY ISC_DBI_ACCT_MERGE_PKG AS
2: /* $Header: ISCACMGB.pls 120.1 2006/02/27 17:25:23 scheung noship $ */
3:
4: PROCEDURE ISC_BOOK_SUM2_PDUE_F_AM (
5: req_id NUMBER,
6: set_num NUMBER,
7: process_mode VARCHAR2) IS
8:

Line 15: ISC_BOOK_SUM2_PDUE_F.LINE_ID%TYPE

11: INDEX BY BINARY_INTEGER;
12: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
13:
14: TYPE LINE_ID_LIST_TYPE IS TABLE OF
15: ISC_BOOK_SUM2_PDUE_F.LINE_ID%TYPE
16: INDEX BY BINARY_INTEGER;
17: PRIMARY_KEY_ID1_LIST LINE_ID_LIST_TYPE;
18:
19: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 20: ISC_BOOK_SUM2_PDUE_F.CUSTOMER_ID%TYPE

16: INDEX BY BINARY_INTEGER;
17: PRIMARY_KEY_ID1_LIST LINE_ID_LIST_TYPE;
18:
19: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
20: ISC_BOOK_SUM2_PDUE_F.CUSTOMER_ID%TYPE
21: INDEX BY BINARY_INTEGER;
22: NUM_COL0_NEW_LIST CUSTOMER_ID_LIST_TYPE;
23:
24: TYPE SOLD_TO_ORG_ID_LIST_TYPE IS TABLE OF

Line 25: ISC_BOOK_SUM2_PDUE_F.SOLD_TO_ORG_ID%TYPE

21: INDEX BY BINARY_INTEGER;
22: NUM_COL0_NEW_LIST CUSTOMER_ID_LIST_TYPE;
23:
24: TYPE SOLD_TO_ORG_ID_LIST_TYPE IS TABLE OF
25: ISC_BOOK_SUM2_PDUE_F.SOLD_TO_ORG_ID%TYPE
26: INDEX BY BINARY_INTEGER;
27: NUM_COL1_ORIG_LIST SOLD_TO_ORG_ID_LIST_TYPE;
28: NUM_COL1_NEW_LIST SOLD_TO_ORG_ID_LIST_TYPE;
29:

Line 31: ISC_BOOK_SUM2_PDUE_F.SHIP_TO_ORG_ID%TYPE

27: NUM_COL1_ORIG_LIST SOLD_TO_ORG_ID_LIST_TYPE;
28: NUM_COL1_NEW_LIST SOLD_TO_ORG_ID_LIST_TYPE;
29:
30: TYPE SHIP_TO_ORG_ID_LIST_TYPE IS TABLE OF
31: ISC_BOOK_SUM2_PDUE_F.SHIP_TO_ORG_ID%TYPE
32: INDEX BY BINARY_INTEGER;
33: NUM_COL2_ORIG_LIST SHIP_TO_ORG_ID_LIST_TYPE;
34: NUM_COL2_NEW_LIST SHIP_TO_ORG_ID_LIST_TYPE;
35:

Line 43: FROM ISC_BOOK_SUM2_PDUE_F yt, ra_customer_merges m

39: SELECT distinct CUSTOMER_MERGE_HEADER_ID
40: ,LINE_ID
41: ,SOLD_TO_ORG_ID
42: ,SHIP_TO_ORG_ID
43: FROM ISC_BOOK_SUM2_PDUE_F yt, ra_customer_merges m
44: WHERE (
45: yt.SOLD_TO_ORG_ID = m.DUPLICATE_ID
46: OR yt.SHIP_TO_ORG_ID = m.DUPLICATE_SITE_ID
47: ) AND m.process_flag = 'N'

Line 57: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ISC_BOOK_SUM2_PDUE_F',FALSE);

53: IF process_mode='LOCK' THEN
54: NULL;
55: ELSE
56: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
57: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ISC_BOOK_SUM2_PDUE_F',FALSE);
58: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
59: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
60:
61: open merged_records;

Line 104: 'ISC_BOOK_SUM2_PDUE_F',

100: LAST_UPDATE_LOGIN,
101: LAST_UPDATE_DATE,
102: LAST_UPDATED_BY
103: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
104: 'ISC_BOOK_SUM2_PDUE_F',
105: MERGE_HEADER_ID_LIST(I),
106: PRIMARY_KEY_ID1_LIST(I),
107: NUM_COL1_ORIG_LIST(I),
108: NUM_COL1_NEW_LIST(I),

Line 121: UPDATE ISC_BOOK_SUM2_PDUE_F yt SET

117: hz_utility_pub.LAST_UPDATED_BY
118: );
119:
120: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
121: UPDATE ISC_BOOK_SUM2_PDUE_F yt SET
122: SOLD_TO_ORG_ID=NUM_COL1_NEW_LIST(I)
123: ,SHIP_TO_ORG_ID=NUM_COL2_NEW_LIST(I)
124: ,CUSTOMER_ID=NUM_COL0_NEW_LIST(I)
125: WHERE LINE_ID=PRIMARY_KEY_ID1_LIST(I)

Line 138: arp_message.set_line( 'ISC_BOOK_SUM2_PDUE_F_AM');

134: arp_message.set_token('NUM_ROWS',to_char(l_count));
135: END IF;
136: EXCEPTION
137: WHEN OTHERS THEN
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 (

Line 140: END ISC_BOOK_SUM2_PDUE_F_AM;

136: EXCEPTION
137: WHEN OTHERS THEN
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,