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 98: FROM okc_k_party_roles_b kpr

94: -- cursors to lock tables
95: --
96: CURSOR c_lock_kpr(b_object_use VARCHAR2) IS
97: SELECT 1
98: FROM okc_k_party_roles_b kpr
99: WHERE kpr.jtot_object1_code IN (SELECT ojt.object_code
100: FROM jtf_objects_b ojt
101: ,jtf_object_usages oue
102: WHERE ojt.object_code = oue.object_code

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

185: arp_message.set_line('OKC_HZ_MERGE_PUB.LOCK_TABLES()+');
186:
187: -- party roles for accounts
188: arp_message.set_name('AR','AR_LOCKING_TABLE');
189: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);
190: arp_message.set_line('Locking for accounts');
191: open c_lock_kpr(c_account);
192: close c_lock_kpr;
193:

Line 278: FROM okc_k_party_roles_b kpr

274: -- merged account
275: --
276: CURSOR c_cpr (b_party_id NUMBER) IS
277: SELECT kpr.dnz_chr_id
278: FROM okc_k_party_roles_b kpr
279: WHERE kpr.jtot_object1_code IN (SELECT ojt.object_code
280: FROM jtf_objects_b ojt
281: ,jtf_object_usages oue
282: WHERE ojt.object_code = oue.object_code

Line 379: FROM okc_k_party_roles_b kpr

375: WHERE id=b_chr_id;
376:
377: CURSOR c_party_id_log(b_chr_id NUMBER) IS
378: SELECT kpr.id
379: FROM okc_k_party_roles_b kpr
380: WHERE kpr.object1_id1 = l_target_party_id
381: AND kpr.dnz_chr_id = b_chr_id;
382:
383: l_count NUMBER(10) := 0;

Line 385: l_chr_id okc_k_party_roles_b.dnz_chr_id%type;

381: AND kpr.dnz_chr_id = b_chr_id;
382:
383: l_count NUMBER(10) := 0;
384: l_object_user_code VARCHAR2(20);
385: l_chr_id okc_k_party_roles_b.dnz_chr_id%type;
386: l_object1_id1 okc_rules_b.object1_id1%type;
387: l_object2_id1 okc_rules_b.object2_id1%type;
388: l_object3_id1 okc_rules_b.object3_id1%type;
389: l_account_count NUMBER(10) := 0;

Line 460: -- updating OKC_K_PARTY_ROLES_B

456: EXIT WHEN c_rules%NOTFOUND;
457: IF ( (TO_CHAR(l_duplicate_id) = nvl(l_object1_id1,'*')) OR (TO_CHAR(l_duplicate_id) = nvl(l_object2_id1, '*')) OR
458: (TO_CHAR(l_duplicate_id) = nvl(l_object3_id1, '*')) ) THEN
459:
460: -- updating OKC_K_PARTY_ROLES_B
461: UPDATE okc_k_party_roles_b kpr
462: SET kpr.object1_id1 = l_target_party_id
463: ,kpr.object_version_number = kpr.object_version_number + 1
464: ,kpr.last_update_date = SYSDATE

Line 461: UPDATE okc_k_party_roles_b kpr

457: IF ( (TO_CHAR(l_duplicate_id) = nvl(l_object1_id1,'*')) OR (TO_CHAR(l_duplicate_id) = nvl(l_object2_id1, '*')) OR
458: (TO_CHAR(l_duplicate_id) = nvl(l_object3_id1, '*')) ) THEN
459:
460: -- updating OKC_K_PARTY_ROLES_B
461: UPDATE okc_k_party_roles_b kpr
462: SET kpr.object1_id1 = l_target_party_id
463: ,kpr.object_version_number = kpr.object_version_number + 1
464: ,kpr.last_update_date = SYSDATE
465: ,kpr.last_updated_by = arp_standard.profile.user_id

Line 488: 'OKC_K_PARTY_ROLES_B',

484: MERGE_LOG_ID,
485: TABLE_NAME,
486: PRIMARY_KEY_ID1
487: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
488: 'OKC_K_PARTY_ROLES_B',
489: l_log_party_id
490: FROM DUAL;
491:
492: UPDATE HZ_CUSTOMER_MERGE_LOG hz

Line 601: 'OKC_K_PARTY_ROLES_B',

597: LAST_UPDATE_LOGIN,
598: LAST_UPDATE_DATE,
599: LAST_UPDATED_BY
600: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
601: 'OKC_K_PARTY_ROLES_B',
602: CUSTOMER_MERGE_HEADER_ID,
603: kpr.ID,
604: kpr.object1_id1,
605: to_char(rcm.customer_id),

Line 613: FROM OKC_K_PARTY_ROLES_B kpr, ra_customer_merges rcm

609: hz_utility_pub.CREATION_DATE,
610: hz_utility_pub.LAST_UPDATE_LOGIN,
611: hz_utility_pub.LAST_UPDATE_DATE,
612: hz_utility_pub.LAST_UPDATED_BY
613: FROM OKC_K_PARTY_ROLES_B kpr, ra_customer_merges rcm
614: WHERE (
615: kpr.object1_id1 = to_char(rcm.duplicate_id)
616: ) AND rcm.process_flag = 'N'
617: AND rcm.request_id = req_id

Line 633: UPDATE okc_k_party_roles_b kpr

629: End If;
630:
631: arp_message.set_name('AR','AR_UPDATING_TABLE');
632: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES',FALSE);
633: UPDATE okc_k_party_roles_b kpr
634: SET kpr.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_id)
635: FROM ra_customer_merges rcm
636: WHERE kpr.object1_id1 = rcm.duplicate_id
637: AND rcm.process_flag = 'N'

Line 1030: -- Updating okc_k_party_roles_b

1026: l_count := sql%rowcount;
1027: arp_message.set_name('AR','AR_ROWS_UPDATED');
1028: arp_message.set_token('NUM_ROWS',to_char(l_count));
1029:
1030: -- Updating okc_k_party_roles_b
1031: -- Cust_Acct_Id
1032: -- Insert into log table
1033: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1034: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1049: 'OKC_K_PARTY_ROLES_B',

1045: LAST_UPDATE_LOGIN,
1046: LAST_UPDATE_DATE,
1047: LAST_UPDATED_BY
1048: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1049: 'OKC_K_PARTY_ROLES_B',
1050: CUSTOMER_MERGE_HEADER_ID,
1051: okpr.ID,
1052: to_char(okpr.cust_acct_id),
1053: to_char(rcm.customer_id),

Line 1061: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm

1057: hz_utility_pub.CREATION_DATE,
1058: hz_utility_pub.LAST_UPDATE_LOGIN,
1059: hz_utility_pub.LAST_UPDATE_DATE,
1060: hz_utility_pub.LAST_UPDATED_BY
1061: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
1062: WHERE (
1063: okpr.cust_acct_id = rcm.duplicate_id
1064: ) AND rcm.process_flag = 'N'
1065: AND rcm.request_id = req_id

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

1072:
1073: End If;
1074:
1075: arp_message.set_name('AR','AR_UPDATING_TABLE');
1076: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.CUST_ACCT_ID',FALSE);
1077:
1078: UPDATE okc_k_party_roles_b okpr
1079: SET okpr.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)
1080: FROM ra_customer_merges rcm

Line 1078: UPDATE okc_k_party_roles_b okpr

1074:
1075: arp_message.set_name('AR','AR_UPDATING_TABLE');
1076: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.CUST_ACCT_ID',FALSE);
1077:
1078: UPDATE okc_k_party_roles_b okpr
1079: SET okpr.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)
1080: FROM ra_customer_merges rcm
1081: WHERE okpr.cust_acct_id = rcm.duplicate_id
1082: AND rcm.process_flag = 'N'

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

1514: --
1515:
1516:
1517: --
1518: -- Account Site Use in OKC_K_PARTY_ROLES_B (see Bug 3950642)
1519: -- OKE only uses the first object1_id1 to hold the site use id
1520: --
1521: --chkrishn 11/03/2004
1522: arp_message.set_line('Updating account site uses for OKE');

Line 1540: 'OKC_K_PARTY_ROLES_B',

1536: LAST_UPDATE_LOGIN,
1537: LAST_UPDATE_DATE,
1538: LAST_UPDATED_BY
1539: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1540: 'OKC_K_PARTY_ROLES_B',
1541: CUSTOMER_MERGE_HEADER_ID,
1542: rle.ID,
1543: rle.object1_id1,
1544: to_char(rcm.customer_site_id),

Line 1552: FROM OKC_K_PARTY_ROLES_B rle, ra_customer_merges rcm

1548: hz_utility_pub.CREATION_DATE,
1549: hz_utility_pub.LAST_UPDATE_LOGIN,
1550: hz_utility_pub.LAST_UPDATE_DATE,
1551: hz_utility_pub.LAST_UPDATED_BY
1552: FROM OKC_K_PARTY_ROLES_B rle, ra_customer_merges rcm
1553: WHERE (
1554: rle.object1_id1 = to_char(rcm.duplicate_site_id)
1555: ) AND rcm.process_flag = 'N'
1556: AND rcm.request_id = req_id

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

1569:
1570: --chkrishn 11/03/2004
1571:
1572: arp_message.set_name('AR','AR_UPDATING_TABLE');
1573: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);
1574:
1575: UPDATE okc_k_party_roles_b rle
1576: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1577: FROM ra_customer_merges rcm

Line 1575: UPDATE okc_k_party_roles_b rle

1571:
1572: arp_message.set_name('AR','AR_UPDATING_TABLE');
1573: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B',FALSE);
1574:
1575: UPDATE okc_k_party_roles_b rle
1576: SET rle.object1_id1 = (SELECT DISTINCT to_char(rcm.customer_site_id)
1577: FROM ra_customer_merges rcm
1578: WHERE rle.object1_id1 = rcm.duplicate_site_id
1579: AND rcm.process_flag = 'N'

Line 2120: -- Updating okc_k_party_roles_b

2116: arp_message.set_name('AR','AR_ROWS_UPDATED');
2117: arp_message.set_token('NUM_ROWS',to_char(l_count));
2118:
2119:
2120: -- Updating okc_k_party_roles_b
2121: -- Bill_to_site_use_id
2122: -- Insert into log table
2123: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2124: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 2139: 'OKC_K_PARTY_ROLES_B',

2135: LAST_UPDATE_LOGIN,
2136: LAST_UPDATE_DATE,
2137: LAST_UPDATED_BY
2138: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2139: 'OKC_K_PARTY_ROLES_B',
2140: CUSTOMER_MERGE_HEADER_ID,
2141: okpr.ID,
2142: to_char(okpr.bill_to_site_use_id),
2143: to_char(rcm.customer_site_id),

Line 2151: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm

2147: hz_utility_pub.CREATION_DATE,
2148: hz_utility_pub.LAST_UPDATE_LOGIN,
2149: hz_utility_pub.LAST_UPDATE_DATE,
2150: hz_utility_pub.LAST_UPDATED_BY
2151: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
2152: WHERE (
2153: okpr.bill_to_site_use_id = rcm.duplicate_site_id
2154: ) AND rcm.process_flag = 'N'
2155: AND rcm.request_id = req_id

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

2162:
2163: End If;
2164:
2165: arp_message.set_name('AR','AR_UPDATING_TABLE');
2166: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.BILL_TO_SITE_USE_ID',FALSE);
2167:
2168: UPDATE okc_k_party_roles_b okpr
2169: SET okpr.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
2170: FROM ra_customer_merges rcm

Line 2168: UPDATE okc_k_party_roles_b okpr

2164:
2165: arp_message.set_name('AR','AR_UPDATING_TABLE');
2166: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES_B.BILL_TO_SITE_USE_ID',FALSE);
2167:
2168: UPDATE okc_k_party_roles_b okpr
2169: SET okpr.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
2170: FROM ra_customer_merges rcm
2171: WHERE okpr.bill_to_site_use_id = rcm.duplicate_site_id
2172: AND rcm.process_flag = 'N'

Line 2320: FROM okc_k_party_roles_b kpr

2316: -- merged account
2317: --
2318: CURSOR c_cpr (b_party_id NUMBER) IS
2319: SELECT kpr.dnz_chr_id
2320: FROM okc_k_party_roles_b kpr
2321: WHERE kpr.jtot_object1_code IN (SELECT ojt.object_code
2322: FROM jtf_objects_b ojt
2323: ,jtf_object_usages oue
2324: WHERE ojt.object_code = oue.object_code

Line 2352: l_chr_id okc_k_party_roles_b.dnz_chr_id%type;

2348: l_customer_id ra_customer_merge_headers.customer_id%type;
2349: l_duplicate_id ra_customer_merge_headers.duplicate_id%type;
2350: l_source_party_id hz_parties.party_id%type;
2351: l_target_party_id hz_parties.party_id%type;
2352: l_chr_id okc_k_party_roles_b.dnz_chr_id%type;
2353: l_error_msg VARCHAR2(2000);
2354:
2355: l_merge_disallowed_excp EXCEPTION;
2356: l_no_data_found_excp EXCEPTION;