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.OKS_HZ_MERGE_PUB dependencies on OKS_BILLING_PROFILES_B

Line 22: -- (the duplicate) is referenced in OKS_BILLING_PROFILES_B. To do so will invalidate

18: --
19: -- NOTES
20: -- Merging Rules:
21: -- OKS will not allow an account merge across parties when the source account
22: -- (the duplicate) is referenced in OKS_BILLING_PROFILES_B. To do so will invalidate
23: -- the party - account relationship in this table.
24: --
25: -- OKS will allow an account merge in other cases.
26: --

Line 28: -- OKS_BILLING_PROFILES_B

24: --
25: -- OKS will allow an account merge in other cases.
26: --
27: -- When merging accounts, customer account ids are looked for in:
28: -- OKS_BILLING_PROFILES_B
29: --
30: -- When merging sites, customer site use ids are looked for in:
31: -- OKS_BILLING_PROFILES_B
32: --

Line 31: -- OKS_BILLING_PROFILES_B

27: -- When merging accounts, customer account ids are looked for in:
28: -- OKS_BILLING_PROFILES_B
29: --
30: -- When merging sites, customer site use ids are looked for in:
31: -- OKS_BILLING_PROFILES_B
32: --
33: -- JTF Objects:
34: -- The merge depends upon the proper usages being set for the JTF objects used
35: -- to represent parties, party site, accounts and account sites.

Line 74: FROM oks_billing_profiles_b bpe

70: -- cursors to lock tables
71: --
72: CURSOR c_lock_bpe IS
73: SELECT 1
74: FROM oks_billing_profiles_b bpe
75: WHERE bpe.dependent_cust_acct_id1 IN (SELECT cme.duplicate_id
76: FROM ra_customer_merges cme
77: WHERE cme.process_flag = 'N'
78: AND cme.request_id = req_id

Line 88: arp_message.set_token('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);

84: arp_message.set_line('OKS_HZ_MERGE_PUB.LOCK_TABLES()+');
85:
86: -- billing profiles
87: arp_message.set_name('AR','AR_LOCKING_TABLE');
88: arp_message.set_token('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);
89: open c_lock_bpe;
90: close c_lock_bpe;
91:
92: arp_message.set_line('OKS_HZ_MERGE_PUB.LOCK_TABLES()-');

Line 113: OKS_BILLING_PROFILES_B.ID%TYPE

109: INDEX BY BINARY_INTEGER;
110: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
111:
112: TYPE ID_LIST_TYPE IS TABLE OF
113: OKS_BILLING_PROFILES_B.ID%TYPE
114: INDEX BY BINARY_INTEGER;
115: PRIMARY_KEY_ID1_LIST ID_LIST_TYPE;
116:
117: TYPE DEP_CUST_ACCT_ID1_LIST_TYPE IS TABLE OF

Line 118: OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID1%TYPE

114: INDEX BY BINARY_INTEGER;
115: PRIMARY_KEY_ID1_LIST ID_LIST_TYPE;
116:
117: TYPE DEP_CUST_ACCT_ID1_LIST_TYPE IS TABLE OF
118: OKS_BILLING_PROFILES_B.DEPENDENT_CUST_ACCT_ID1%TYPE
119: INDEX BY BINARY_INTEGER;
120: NUM_COL1_ORIG_LIST DEP_CUST_ACCT_ID1_LIST_TYPE ;
121: NUM_COL1_NEW_LIST DEP_CUST_ACCT_ID1_LIST_TYPE ;
122:

Line 124: OKS_BILLING_PROFILES_B.OBJECT_VERSION_NUMBER%TYPE

120: NUM_COL1_ORIG_LIST DEP_CUST_ACCT_ID1_LIST_TYPE ;
121: NUM_COL1_NEW_LIST DEP_CUST_ACCT_ID1_LIST_TYPE ;
122:
123: TYPE OBJECT_VER_NUMBER_LIST_TYPE IS TABLE OF
124: OKS_BILLING_PROFILES_B.OBJECT_VERSION_NUMBER%TYPE
125: INDEX BY BINARY_INTEGER;
126: NUM_COL2_ORIG_LIST OBJECT_VER_NUMBER_LIST_TYPE ;
127: NUM_COL2_NEW_LIST OBJECT_VER_NUMBER_LIST_TYPE ;
128:

Line 135: FROM OKS_BILLING_PROFILES_B yt, ra_customer_merges m

131: SELECT distinct CUSTOMER_MERGE_HEADER_ID
132: ,ID
133: ,DEPENDENT_CUST_ACCT_ID1
134: ,OBJECT_VERSION_NUMBER
135: FROM OKS_BILLING_PROFILES_B yt, ra_customer_merges m
136: WHERE (
137: yt.DEPENDENT_CUST_ACCT_ID1 = m.DUPLICATE_ID
138: OR yt.OBJECT_VERSION_NUMBER = m.DUPLICATE_SITE_ID
139: ) AND m.process_flag = 'N'

Line 148: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);

144:
145: BEGIN
146: --CK new code with logging
147: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
148: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);
149: HZ_ACCT_MERGE_UTIL.load_set(set_number, req_id);
150: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
151:
152: open merged_records;

Line 189: 'OKS_BILLING_PROFILES_B',

185: LAST_UPDATE_LOGIN,
186: LAST_UPDATE_DATE,
187: LAST_UPDATED_BY
188: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
189: 'OKS_BILLING_PROFILES_B',
190: MERGE_HEADER_ID_LIST(I),
191: PRIMARY_KEY_ID1_LIST(I),
192: NUM_COL1_ORIG_LIST(I),
193: NUM_COL1_NEW_LIST(I),

Line 206: UPDATE OKS_BILLING_PROFILES_B yt SET

202: hz_utility_pub.LAST_UPDATED_BY
203: );
204: END IF;
205: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
206: UPDATE OKS_BILLING_PROFILES_B yt SET
207: DEPENDENT_CUST_ACCT_ID1=NUM_COL1_NEW_LIST(I)
208: ,OBJECT_VERSION_NUMBER=NUM_COL2_NEW_LIST(I)
209: , LAST_UPDATE_DATE=SYSDATE
210: , last_updated_by=arp_standard.profile.user_id

Line 225: arp_message.set_token('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);

221: arp_message.set_token('NUM_ROWS',to_char(l_count));
222: -- billing profile
223: /*CK old code
224: arp_message.set_name('AR','AR_UPDATING_TABLE');
225: arp_message.set_token('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);
226: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
227: MERGE_LOG_ID,
228: MERGE_HEADER_ID,
229: TABLE_NAME,

Line 238: 'OKS_BILLING_PROFILES_B',

234: NUM_COL2_NEW,
235: REQUEST_ID
236: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
237: CUSTOMER_MERGE_HEADER_ID,
238: 'OKS_BILLING_PROFILES_B',
239: ID,
240: DEPENDENT_CUST_ACCT_ID1,
241: decode(yt.DEPENDENT_CUST_ACCT_ID1,m.DUPLICATE_ID,m.CUSTOMER_ID,yt.DEPENDENT_CUST_ACCT_ID1),
242: OBJECT_VERSION_NUMBER,

Line 245: FROM OKS_BILLING_PROFILES_B yt, ra_customer_merges m

241: decode(yt.DEPENDENT_CUST_ACCT_ID1,m.DUPLICATE_ID,m.CUSTOMER_ID,yt.DEPENDENT_CUST_ACCT_ID1),
242: OBJECT_VERSION_NUMBER,
243: OBJECT_VERSION_NUMBER,
244: request_id
245: FROM OKS_BILLING_PROFILES_B yt, ra_customer_merges m
246: WHERE (
247: yt.DEPENDENT_CUST_ACCT_ID1 = m.DUPLICATE_ID
248: -- OR yt.BILL_TO_ADDRESS_ID1 = m.DUPLICATE_SITE_ID
249: ) AND m.process_flag = 'N'

Line 253: UPDATE OKS_BILLING_PROFILES_B yt SET (

249: ) AND m.process_flag = 'N'
250: AND m.request_id = req_id
251: AND m.set_number = set_number;
252:
253: UPDATE OKS_BILLING_PROFILES_B yt SET (
254: DEPENDENT_CUST_ACCT_ID1, OBJECT_VERSION_NUMBER) = (
255: SELECT NUM_COL1_NEW, NUM_COL2_NEW
256: FROM HZ_CUSTOMER_MERGE_LOG l
257: WHERE l.REQUEST_ID = req_id

Line 258: AND l.TABLE_NAME = 'OKS_BILLING_PROFILES_B'

254: DEPENDENT_CUST_ACCT_ID1, OBJECT_VERSION_NUMBER) = (
255: SELECT NUM_COL1_NEW, NUM_COL2_NEW
256: FROM HZ_CUSTOMER_MERGE_LOG l
257: WHERE l.REQUEST_ID = req_id
258: AND l.TABLE_NAME = 'OKS_BILLING_PROFILES_B'
259: AND l.PRIMARY_KEY_ID = ID
260: AND DEPENDENT_CUST_ACCT_ID1 = NUM_COL1_ORIG
261: and rownum <2
262: )

Line 270: AND l1.TABLE_NAME = 'OKS_BILLING_PROFILES_B'

266: WHERE (ID) in (
267: SELECT PRIMARY_KEY_ID
268: FROM HZ_CUSTOMER_MERGE_LOG l1, RA_CUSTOMER_MERGES h
269: WHERE h.CUSTOMER_MERGE_HEADER_ID = l1.MERGE_HEADER_ID
270: AND l1.TABLE_NAME = 'OKS_BILLING_PROFILES_B'
271: AND l1.REQUEST_ID = req_id
272: AND h.set_number = set_number);
273: l_count := SQL%ROWCOUNT;
274:

Line 294: OKS_BILLING_PROFILES_B.ID%TYPE

290: RA_CUSTOMER_MERGE_HEADERS.CUSTOMER_MERGE_HEADER_ID%TYPE
291: INDEX BY BINARY_INTEGER;
292: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
293: TYPE ID_LIST_TYPE IS TABLE OF
294: OKS_BILLING_PROFILES_B.ID%TYPE
295: INDEX BY BINARY_INTEGER;
296: PRIMARY_KEY_ID1_LIST ID_LIST_TYPE;
297:
298: TYPE BILL_TO_ADDRESS_ID1_LIST_TYPE IS TABLE OF

Line 299: OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID1%TYPE

295: INDEX BY BINARY_INTEGER;
296: PRIMARY_KEY_ID1_LIST ID_LIST_TYPE;
297:
298: TYPE BILL_TO_ADDRESS_ID1_LIST_TYPE IS TABLE OF
299: OKS_BILLING_PROFILES_B.BILL_TO_ADDRESS_ID1%TYPE
300: INDEX BY BINARY_INTEGER;
301:
302: NUM_COL3_ORIG_LIST BILL_TO_ADDRESS_ID1_LIST_TYPE;
303: NUM_COL3_NEW_LIST BILL_TO_ADDRESS_ID1_LIST_TYPE;

Line 306: OKS_BILLING_PROFILES_B.OBJECT_VERSION_NUMBER%TYPE

302: NUM_COL3_ORIG_LIST BILL_TO_ADDRESS_ID1_LIST_TYPE;
303: NUM_COL3_NEW_LIST BILL_TO_ADDRESS_ID1_LIST_TYPE;
304:
305: TYPE OBJECT_VERSION_NUM_LIST_TYPE IS TABLE OF
306: OKS_BILLING_PROFILES_B.OBJECT_VERSION_NUMBER%TYPE
307: INDEX BY BINARY_INTEGER;
308: NUM_COL4_ORIG_LIST OBJECT_VERSION_NUM_LIST_TYPE;
309: NUM_COL4_NEW_LIST OBJECT_VERSION_NUM_LIST_TYPE;
310:

Line 332: FROM OKS_BILLING_PROFILES_B yt, ra_customer_merges m

328: SELECT distinct CUSTOMER_MERGE_HEADER_ID
329: ,ID
330: ,BILL_TO_ADDRESS_ID1
331: ,OBJECT_VERSION_NUMBER
332: FROM OKS_BILLING_PROFILES_B yt, ra_customer_merges m
333: WHERE (
334: yt.BILL_TO_ADDRESS_ID1 = m.DUPLICATE_SITE_ID
335: ) AND m.process_flag = 'N'
336: AND m.request_id = req_id

Line 358: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);

354:
355: BEGIN
356: --ck new code with logging
357: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
358: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OKS_BILLING_PROFILES_B',FALSE);
359: HZ_ACCT_MERGE_UTIL.load_set(set_number, req_id);
360: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
361: open merged_records;
362: LOOP

Line 398: 'OKS_BILLING_PROFILES_B',

394: LAST_UPDATE_LOGIN,
395: LAST_UPDATE_DATE,
396: LAST_UPDATED_BY
397: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
398: 'OKS_BILLING_PROFILES_B',
399: MERGE_HEADER_ID_LIST(I),
400: PRIMARY_KEY_ID1_LIST(I),
401: NUM_COL3_ORIG_LIST(I),
402: NUM_COL3_NEW_LIST(I),

Line 416: UPDATE OKS_BILLING_PROFILES_B yt SET

412: );
413:
414: END IF;
415: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
416: UPDATE OKS_BILLING_PROFILES_B yt SET
417: BILL_TO_ADDRESS_ID1=NUM_COL3_NEW_LIST(I)
418: ,OBJECT_VERSION_NUMBER=NUM_COL4_NEW_LIST(I)
419: , LAST_UPDATE_DATE=SYSDATE
420: , last_updated_by=arp_standard.profile.user_id

Line 568: FROM oks_billing_profiles_b bpe

564: -- merged account
565: --
566: CURSOR c_bpe (b_party_id NUMBER) IS
567: SELECT 1
568: FROM oks_billing_profiles_b bpe
569: WHERE bpe.owned_party_id1 = b_party_id
570: ;
571: --
572: -- local variables