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.OKC_HZ_MERGE_PUB dependencies on OKC_K_PARTY_ROLES_B

Line 105: FROM okc_k_party_roles_b kpr

101: -- cursors to lock tables
102: --
103: CURSOR c_lock_kpr(b_object_use VARCHAR2) IS
104: SELECT 1
105: FROM okc_k_party_roles_b kpr
106: WHERE kpr.jtot_object1_code IN (SELECT ojt.object_code
107: FROM jtf_objects_b ojt
108: ,jtf_object_usages oue
109: WHERE ojt.object_code = oue.object_code

Line 196: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);

192: arp_message.set_line('OKC_HZ_MERGE_PUB.LOCK_TABLES()+');
193:
194: -- party roles for accounts
195: arp_message.set_name('AR','AR_LOCKING_TABLE');
196: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);
197: arp_message.set_line('Locking for accounts');
198: open c_lock_kpr(c_account);
199: close c_lock_kpr;
200:

Line 285: FROM okc_k_party_roles_b kpr

281: -- merged account
282: --
283: CURSOR c_cpr (b_party_id NUMBER) IS
284: SELECT kpr.dnz_chr_id
285: FROM okc_k_party_roles_b kpr
286: WHERE kpr.jtot_object1_code IN (SELECT ojt.object_code
287: FROM jtf_objects_b ojt
288: ,jtf_object_usages oue
289: WHERE ojt.object_code = oue.object_code

Line 386: FROM okc_k_party_roles_b kpr

382: WHERE id=b_chr_id;
383:
384: CURSOR c_party_id_log(b_chr_id NUMBER) IS
385: SELECT kpr.id
386: FROM okc_k_party_roles_b kpr
387: WHERE kpr.object1_id1 = l_target_party_id
388: AND kpr.dnz_chr_id = b_chr_id;
389:
390: l_count NUMBER(10) := 0;

Line 392: l_chr_id okc_k_party_roles_b.dnz_chr_id%type;

388: AND kpr.dnz_chr_id = b_chr_id;
389:
390: l_count NUMBER(10) := 0;
391: l_object_user_code VARCHAR2(20);
392: l_chr_id okc_k_party_roles_b.dnz_chr_id%type;
393: l_object1_id1 okc_rules_b.object1_id1%type;
394: l_object2_id1 okc_rules_b.object2_id1%type;
395: l_object3_id1 okc_rules_b.object3_id1%type;
396: l_account_count NUMBER(10) := 0;

Line 467: -- updating OKC_K_PARTY_ROLES_B

463: EXIT WHEN c_rules%NOTFOUND;
464: IF ( (TO_CHAR(l_duplicate_id) = nvl(l_object1_id1,'*')) OR (TO_CHAR(l_duplicate_id) = nvl(l_object2_id1, '*')) OR
465: (TO_CHAR(l_duplicate_id) = nvl(l_object3_id1, '*')) ) THEN
466:
467: -- updating OKC_K_PARTY_ROLES_B
468: UPDATE okc_k_party_roles_b kpr
469: SET kpr.object1_id1 = l_target_party_id
470: ,kpr.object_version_number = kpr.object_version_number + 1
471: ,kpr.last_update_date = SYSDATE

Line 468: UPDATE okc_k_party_roles_b kpr

464: IF ( (TO_CHAR(l_duplicate_id) = nvl(l_object1_id1,'*')) OR (TO_CHAR(l_duplicate_id) = nvl(l_object2_id1, '*')) OR
465: (TO_CHAR(l_duplicate_id) = nvl(l_object3_id1, '*')) ) THEN
466:
467: -- updating OKC_K_PARTY_ROLES_B
468: UPDATE okc_k_party_roles_b kpr
469: SET kpr.object1_id1 = l_target_party_id
470: ,kpr.object_version_number = kpr.object_version_number + 1
471: ,kpr.last_update_date = SYSDATE
472: ,kpr.last_updated_by = arp_standard.profile.user_id

Line 495: 'OKC_K_PARTY_ROLES_B',

491: MERGE_LOG_ID,
492: TABLE_NAME,
493: PRIMARY_KEY_ID1
494: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
495: 'OKC_K_PARTY_ROLES_B',
496: l_log_party_id
497: FROM DUAL;
498:
499: UPDATE HZ_CUSTOMER_MERGE_LOG hz

Line 622: 'OKC_K_PARTY_ROLES_B',

618: LAST_UPDATE_LOGIN,
619: LAST_UPDATE_DATE,
620: LAST_UPDATED_BY
621: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
622: 'OKC_K_PARTY_ROLES_B',
623: CUSTOMER_MERGE_HEADER_ID,
624: kpr.ID,
625: kpr.object1_id1,
626: to_char(rcm.customer_id),

Line 634: FROM OKC_K_PARTY_ROLES_B kpr, ra_customer_merges rcm

630: hz_utility_pub.CREATION_DATE,
631: hz_utility_pub.LAST_UPDATE_LOGIN,
632: hz_utility_pub.LAST_UPDATE_DATE,
633: hz_utility_pub.LAST_UPDATED_BY
634: FROM OKC_K_PARTY_ROLES_B kpr, ra_customer_merges rcm
635: WHERE (
636: kpr.object1_id1 = to_char(rcm.duplicate_id)
637: ) AND rcm.process_flag = 'N'
638: AND rcm.request_id = req_id

Line 654: UPDATE okc_k_party_roles_b kpr

650: End If;
651:
652: arp_message.set_name('AR','AR_UPDATING_TABLE');
653: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES',FALSE);
654: UPDATE okc_k_party_roles_b kpr
655: SET kpr.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
656: FROM ra_customer_merges rcm
657: WHERE kpr.object1_id1 = rcm.duplicate_id
658: AND rcm.process_flag = 'N'

Line 1062: -- Updating okc_k_party_roles_b

1058: l_cum_count := l_cum_count + l_count; /*bug9077092*/
1059: arp_message.set_name('AR','AR_ROWS_UPDATED');
1060: arp_message.set_token('NUM_ROWS',to_char(l_count));
1061:
1062: -- Updating okc_k_party_roles_b
1063: -- Cust_Acct_Id
1064: -- Insert into log table
1065: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1066: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1081: 'OKC_K_PARTY_ROLES_B',

1077: LAST_UPDATE_LOGIN,
1078: LAST_UPDATE_DATE,
1079: LAST_UPDATED_BY
1080: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1081: 'OKC_K_PARTY_ROLES_B',
1082: CUSTOMER_MERGE_HEADER_ID,
1083: okpr.ID,
1084: to_char(okpr.cust_acct_id),
1085: to_char(rcm.customer_id),

Line 1093: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm

1089: hz_utility_pub.CREATION_DATE,
1090: hz_utility_pub.LAST_UPDATE_LOGIN,
1091: hz_utility_pub.LAST_UPDATE_DATE,
1092: hz_utility_pub.LAST_UPDATED_BY
1093: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
1094: WHERE (
1095: okpr.cust_acct_id = rcm.duplicate_id
1096: ) AND rcm.process_flag = 'N'
1097: AND rcm.request_id = req_id

Line 1108: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.CUST_ACCT_ID',FALSE);

1104:
1105: End If;
1106:
1107: arp_message.set_name('AR','AR_UPDATING_TABLE');
1108: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.CUST_ACCT_ID',FALSE);
1109:
1110: UPDATE okc_k_party_roles_b okpr
1111: SET okpr.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)
1112: FROM ra_customer_merges rcm

Line 1110: UPDATE okc_k_party_roles_b okpr

1106:
1107: arp_message.set_name('AR','AR_UPDATING_TABLE');
1108: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.CUST_ACCT_ID',FALSE);
1109:
1110: UPDATE okc_k_party_roles_b okpr
1111: SET okpr.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)
1112: FROM ra_customer_merges rcm
1113: WHERE okpr.cust_acct_id = rcm.duplicate_id
1114: AND rcm.process_flag = 'N'

Line 1615: -- Account Site Use in OKC_K_PARTY_ROLES_B (see Bug 3950642)

1611: --
1612:
1613:
1614: --
1615: -- Account Site Use in OKC_K_PARTY_ROLES_B (see Bug 3950642)
1616: -- OKE only uses the first object1_id1 to hold the site use id
1617: --
1618: --chkrishn 11/03/2004
1619: arp_message.set_line('Updating account site uses for OKE');

Line 1637: 'OKC_K_PARTY_ROLES_B',

1633: LAST_UPDATE_LOGIN,
1634: LAST_UPDATE_DATE,
1635: LAST_UPDATED_BY
1636: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1637: 'OKC_K_PARTY_ROLES_B',
1638: CUSTOMER_MERGE_HEADER_ID,
1639: rle.ID,
1640: rle.object1_id1,
1641: to_char(rcm.customer_site_id),

Line 1649: FROM OKC_K_PARTY_ROLES_B rle, ra_customer_merges rcm

1645: hz_utility_pub.CREATION_DATE,
1646: hz_utility_pub.LAST_UPDATE_LOGIN,
1647: hz_utility_pub.LAST_UPDATE_DATE,
1648: hz_utility_pub.LAST_UPDATED_BY
1649: FROM OKC_K_PARTY_ROLES_B rle, ra_customer_merges rcm
1650: WHERE (
1651: rle.object1_id1 = to_char(rcm.duplicate_site_id)
1652: ) AND rcm.process_flag = 'N'
1653: AND rcm.request_id = req_id

Line 1670: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);

1666:
1667: --chkrishn 11/03/2004
1668:
1669: arp_message.set_name('AR','AR_UPDATING_TABLE');
1670: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);
1671:
1672: UPDATE okc_k_party_roles_b rle
1673: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1674: FROM ra_customer_merges rcm

Line 1672: UPDATE okc_k_party_roles_b rle

1668:
1669: arp_message.set_name('AR','AR_UPDATING_TABLE');
1670: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);
1671:
1672: UPDATE okc_k_party_roles_b rle
1673: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1674: FROM ra_customer_merges rcm
1675: WHERE rle.object1_id1 = rcm.duplicate_site_id
1676: AND rcm.process_flag = 'N'

Line 2229: -- Updating okc_k_party_roles_b

2225: arp_message.set_name('AR','AR_ROWS_UPDATED');
2226: arp_message.set_token('NUM_ROWS',to_char(l_count));
2227:
2228:
2229: -- Updating okc_k_party_roles_b
2230: -- Bill_to_site_use_id
2231: -- Insert into log table
2232: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2233: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 2248: 'OKC_K_PARTY_ROLES_B',

2244: LAST_UPDATE_LOGIN,
2245: LAST_UPDATE_DATE,
2246: LAST_UPDATED_BY
2247: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2248: 'OKC_K_PARTY_ROLES_B',
2249: CUSTOMER_MERGE_HEADER_ID,
2250: okpr.ID,
2251: to_char(okpr.bill_to_site_use_id),
2252: to_char(rcm.customer_site_id),

Line 2260: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm

2256: hz_utility_pub.CREATION_DATE,
2257: hz_utility_pub.LAST_UPDATE_LOGIN,
2258: hz_utility_pub.LAST_UPDATE_DATE,
2259: hz_utility_pub.LAST_UPDATED_BY
2260: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
2261: WHERE (
2262: okpr.bill_to_site_use_id = rcm.duplicate_site_id
2263: ) AND rcm.process_flag = 'N'
2264: AND rcm.request_id = req_id

Line 2275: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.BILL_TO_SITE_USE_ID',FALSE);

2271:
2272: End If;
2273:
2274: arp_message.set_name('AR','AR_UPDATING_TABLE');
2275: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.BILL_TO_SITE_USE_ID',FALSE);
2276:
2277: UPDATE okc_k_party_roles_b okpr
2278: SET okpr.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
2279: FROM ra_customer_merges rcm

Line 2277: UPDATE okc_k_party_roles_b okpr

2273:
2274: arp_message.set_name('AR','AR_UPDATING_TABLE');
2275: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.BILL_TO_SITE_USE_ID',FALSE);
2276:
2277: UPDATE okc_k_party_roles_b okpr
2278: SET okpr.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
2279: FROM ra_customer_merges rcm
2280: WHERE okpr.bill_to_site_use_id = rcm.duplicate_site_id
2281: AND rcm.process_flag = 'N'

Line 2471: FROM okc_k_party_roles_b kpr

2467: -- merged account
2468: --
2469: CURSOR c_cpr (b_party_id NUMBER) IS
2470: SELECT kpr.dnz_chr_id
2471: FROM okc_k_party_roles_b kpr
2472: WHERE kpr.jtot_object1_code IN (SELECT ojt.object_code
2473: FROM jtf_objects_b ojt
2474: ,jtf_object_usages oue
2475: WHERE ojt.object_code = oue.object_code

Line 2503: l_chr_id okc_k_party_roles_b.dnz_chr_id%type;

2499: l_customer_id ra_customer_merge_headers.customer_id%type;
2500: l_duplicate_id ra_customer_merge_headers.duplicate_id%type;
2501: l_source_party_id hz_parties.party_id%type;
2502: l_target_party_id hz_parties.party_id%type;
2503: l_chr_id okc_k_party_roles_b.dnz_chr_id%type;
2504: l_error_msg VARCHAR2(2000);
2505:
2506: l_merge_disallowed_excp EXCEPTION;
2507: l_no_data_found_excp EXCEPTION;