eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_ACCOUNT_MERGE_PKG dependencies on CSC_CUSTOMERS

Line 27: CSC_CUSTOMERS_MERGE(

23: set_num IN NUMBER,
24: process_mode IN VARCHAR2 := 'LOCK' )
25: IS
26: BEGIN
27: CSC_CUSTOMERS_MERGE(
28: req_id => req_id,
29: set_num => set_num,
30: process_mode => process_mode );
31:

Line 32: CSC_CUSTOMERS_AUDIT_HIST_MERGE(

28: req_id => req_id,
29: set_num => set_num,
30: process_mode => process_mode );
31:
32: CSC_CUSTOMERS_AUDIT_HIST_MERGE(
33: req_id => req_id,
34: set_num => set_num,
35: process_mode => process_mode );
36:

Line 54: PROCEDURE CSC_CUSTOMERS_MERGE (

50: process_mode => process_mode );
51:
52: END CSC_MERGE_ALL_ACCOUNTS;
53:
54: PROCEDURE CSC_CUSTOMERS_MERGE (
55: req_id NUMBER,
56: set_num NUMBER,
57: process_mode VARCHAR2) IS
58:

Line 65: CSC_CUSTOMERS.cust_account_id%TYPE

61: INDEX BY BINARY_INTEGER;
62: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
63:
64: TYPE cust_account_id_LIST_TYPE IS TABLE OF
65: CSC_CUSTOMERS.cust_account_id%TYPE
66: INDEX BY BINARY_INTEGER;
67: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
68: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
69:

Line 71: CSC_CUSTOMERS.PARTY_ID%TYPE

67: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
68: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
69:
70: TYPE PARTY_ID_LIST_TYPE IS TABLE OF
71: CSC_CUSTOMERS.PARTY_ID%TYPE
72: INDEX BY BINARY_INTEGER;
73: NUM_COL2_ORIG_LIST PARTY_ID_LIST_TYPE;
74: NUM_COL2_NEW_LIST PARTY_ID_LIST_TYPE;
75:

Line 80: FROM CSC_CUSTOMERS yt, ra_customer_merges m, hz_cust_accounts hzca

76: l_profile_val VARCHAR2(30);
77: CURSOR merged_records IS
78: SELECT distinct m.CUSTOMER_MERGE_HEADER_ID
79: ,m.customer_id, m.duplicate_id, hzca.party_id, yt.party_id
80: FROM CSC_CUSTOMERS yt, ra_customer_merges m, hz_cust_accounts hzca
81: WHERE ( yt.cust_account_id = m.duplicate_id AND m.customer_id = hzca.cust_account_id )
82: AND m.process_flag = 'N'
83: AND m.request_id = req_id
84: AND m.set_number = set_num;

Line 92: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUSTOMERS',FALSE);

88: IF process_mode='LOCK' THEN
89: NULL;
90: ELSE
91: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
92: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUSTOMERS',FALSE);
93: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
94: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
95:
96: open merged_records;

Line 132: 'CSC_CUSTOMERS',

128: LAST_UPDATE_LOGIN,
129: LAST_UPDATE_DATE,
130: LAST_UPDATED_BY
131: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
132: 'CSC_CUSTOMERS',
133: MERGE_HEADER_ID_LIST(I),
134: NUM_COL1_ORIG_LIST(I),
135: NUM_COL1_NEW_LIST(I),
136: NUM_COL2_ORIG_LIST(I),

Line 148: UPDATE CSC_CUSTOMERS yt SET

144: hz_utility_pub.LAST_UPDATED_BY
145: );
146:
147: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
148: UPDATE CSC_CUSTOMERS yt SET
149: cust_account_id=NUM_COL1_NEW_LIST(I)
150: , party_id=NUM_COL2_NEW_LIST(I)
151: , LAST_UPDATE_DATE=SYSDATE
152: , last_updated_by=arp_standard.profile.user_id

Line 175: arp_message.set_line( 'CSC_CUSTOMERS_MERGE');

171: arp_message.set_token('NUM_ROWS',to_char(l_count));
172: END IF;
173: EXCEPTION
174: WHEN OTHERS THEN
175: arp_message.set_line( 'CSC_CUSTOMERS_MERGE');
176: RAISE;
177: END CSC_CUSTOMERS_MERGE;
178:
179: PROCEDURE CSC_CUSTOMERS_AUDIT_HIST_MERGE (

Line 177: END CSC_CUSTOMERS_MERGE;

173: EXCEPTION
174: WHEN OTHERS THEN
175: arp_message.set_line( 'CSC_CUSTOMERS_MERGE');
176: RAISE;
177: END CSC_CUSTOMERS_MERGE;
178:
179: PROCEDURE CSC_CUSTOMERS_AUDIT_HIST_MERGE (
180: req_id NUMBER,
181: set_num NUMBER,

Line 179: PROCEDURE CSC_CUSTOMERS_AUDIT_HIST_MERGE (

175: arp_message.set_line( 'CSC_CUSTOMERS_MERGE');
176: RAISE;
177: END CSC_CUSTOMERS_MERGE;
178:
179: PROCEDURE CSC_CUSTOMERS_AUDIT_HIST_MERGE (
180: req_id NUMBER,
181: set_num NUMBER,
182: process_mode VARCHAR2) IS
183:

Line 190: CSC_CUSTOMERS_AUDIT_HIST.cust_account_id%TYPE

186: INDEX BY BINARY_INTEGER;
187: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
188:
189: TYPE cust_account_id_LIST_TYPE IS TABLE OF
190: CSC_CUSTOMERS_AUDIT_HIST.cust_account_id%TYPE
191: INDEX BY BINARY_INTEGER;
192: NUM_COL1_ORIG_LIST cust_account_id_LIST_TYPE;
193: NUM_COL1_NEW_LIST cust_account_id_LIST_TYPE;
194:

Line 199: FROM CSC_CUSTOMERS_AUDIT_HIST yt, ra_customer_merges m , hz_cust_accounts hzca

195: l_profile_val VARCHAR2(30);
196: CURSOR merged_records IS
197: SELECT distinct CUSTOMER_MERGE_HEADER_ID
198: ,m.customer_id, m.duplicate_id
199: FROM CSC_CUSTOMERS_AUDIT_HIST yt, ra_customer_merges m , hz_cust_accounts hzca
200: WHERE ( yt.cust_account_id = m.duplicate_id AND m.customer_id = hzca.cust_account_id )
201: AND m.process_flag = 'N'
202: AND m.request_id = req_id
203: AND m.set_number = set_num;

Line 211: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUSTOMERS_AUDIT_HIST',FALSE);

207: IF process_mode='LOCK' THEN
208: NULL;
209: ELSE
210: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
211: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUSTOMERS_AUDIT_HIST',FALSE);
212: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
213: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
214:
215: open merged_records;

Line 247: 'CSC_CUSTOMERS_AUDIT_HIST',

243: LAST_UPDATE_LOGIN,
244: LAST_UPDATE_DATE,
245: LAST_UPDATED_BY
246: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
247: 'CSC_CUSTOMERS_AUDIT_HIST',
248: MERGE_HEADER_ID_LIST(I),
249: NUM_COL1_ORIG_LIST(I),
250: NUM_COL1_NEW_LIST(I),
251: 'U',

Line 261: UPDATE CSC_CUSTOMERS_AUDIT_HIST yt SET

257: hz_utility_pub.LAST_UPDATED_BY
258: );
259:
260: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
261: UPDATE CSC_CUSTOMERS_AUDIT_HIST yt SET
262: cust_account_id=NUM_COL1_NEW_LIST(I)
263: , LAST_UPDATE_DATE=SYSDATE
264: , last_updated_by=arp_standard.profile.user_id
265: , last_update_login=arp_standard.profile.last_update_login

Line 287: arp_message.set_line( 'CSC_CUSTOMERS_AUDIT_HIST_MERGE');

283: arp_message.set_token('NUM_ROWS',to_char(l_count));
284: END IF;
285: EXCEPTION
286: WHEN OTHERS THEN
287: arp_message.set_line( 'CSC_CUSTOMERS_AUDIT_HIST_MERGE');
288: RAISE;
289: END CSC_CUSTOMERS_AUDIT_HIST_MERGE;
290:
291: PROCEDURE CSC_CUSTOMIZED_PLANS_MERGE (

Line 289: END CSC_CUSTOMERS_AUDIT_HIST_MERGE;

285: EXCEPTION
286: WHEN OTHERS THEN
287: arp_message.set_line( 'CSC_CUSTOMERS_AUDIT_HIST_MERGE');
288: RAISE;
289: END CSC_CUSTOMERS_AUDIT_HIST_MERGE;
290:
291: PROCEDURE CSC_CUSTOMIZED_PLANS_MERGE (
292: req_id NUMBER,
293: set_num NUMBER,