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_HEADERS_B

Line 292: -- okc_k_headers_b also

288: --
289: -- cursor to get all the acounts from rules for a particular
290: -- contract
291: -- Bug 3555739 modified the cursor to check for account info. in okc_k_lines_b and
292: -- okc_k_headers_b also
293:
294: CURSOR c_rules (b_dnz_chr_id NUMBER) IS
295: select object1_id1, object2_id1, object3_id1
296: from okc_rules_b

Line 301: from okc_k_headers_b

297: where dnz_chr_id = b_dnz_chr_id
298: and rule_information_category IN ('BTO', 'STO')
299: union
300: select to_char(bill_to_site_use_id), to_char(ship_to_site_use_id), to_char(cust_acct_id)
301: from okc_k_headers_b
302: where id = b_dnz_chr_id
303: union
304: select to_char(bill_to_site_use_id), to_char(ship_to_site_use_id), to_char(cust_acct_id)
305: from okc_k_lines_b

Line 312: -- okc_k_headers_b also

308: --
309: -- cursor to check whether the source party has more than one
310: -- account in the contract
311: -- Bug 3555739 modified the cursor to check for account info. in okc_k_lines_b and
312: -- okc_k_headers_b also
313: CURSOR c_account_count (b_chr_id NUMBER) IS
314: select count(*)
315: from (select okr1.object1_id1 from okc_rules_b okr1
316: where okr1.object1_id1 in (

Line 335: from okc_k_headers_b where id = b_chr_id)

331: and okr3.rule_information_category IN ('BTO', 'STO')
332: union
333: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V
334: where id1 IN (select bill_to_site_use_id
335: from okc_k_headers_b where id = b_chr_id)
336: and party_id = l_source_party_id
337: and SITE_USE_CODE = 'BILL_TO')
338: union
339: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V

Line 341: from okc_k_headers_b where id = b_chr_id )

337: and SITE_USE_CODE = 'BILL_TO')
338: union
339: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V
340: where id1 IN (select ship_to_site_use_id
341: from okc_k_headers_b where id = b_chr_id )
342: and party_id =l_source_party_id
343: and SITE_USE_CODE = 'SHIP_TO')
344: union
345: (select to_char(cust_account_id) from OKX_CUST_SITE_USES_V

Line 365: from okc_k_headers_b where id = b_chr_id )

361: and party_id =l_source_party_id)
362: union
363: (select to_char(cust_account_id) from hz_cust_accounts
364: where cust_account_id IN (select cust_acct_id
365: from okc_k_headers_b where id = b_chr_id )
366: -- Changes for Bug# 6861077 Ends
367: and party_id =l_source_party_id));
368:
369: --

Line 374: FROM okc_k_headers_b

370: -- cursor to get the contract number and modifier for log purpose
371: --
372: CURSOR c_header_info (b_chr_id NUMBER) IS
373: SELECT contract_number, contract_number_modifier
374: FROM okc_k_headers_b
375: WHERE id=b_chr_id;
376:
377: CURSOR c_party_id_log(b_chr_id NUMBER) IS
378: SELECT kpr.id

Line 390: l_contract_number okc_k_headers_b.contract_number%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;
390: l_contract_number okc_k_headers_b.contract_number%type;
391: l_contract_number_modifier okc_k_headers_b.contract_number_modifier%type;
392: l_status VARCHAR2(1);
393: l_error_msg VARCHAR2(2000);
394: l_log_party_id NUMBER;

Line 391: l_contract_number_modifier okc_k_headers_b.contract_number_modifier%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;
390: l_contract_number okc_k_headers_b.contract_number%type;
391: l_contract_number_modifier okc_k_headers_b.contract_number_modifier%type;
392: l_status VARCHAR2(1);
393: l_error_msg VARCHAR2(2000);
394: l_log_party_id NUMBER;
395:

Line 890: -- Updating okc_k_headers_b

886: arp_message.set_name('AR','AR_ROWS_UPDATED');
887: arp_message.set_token('NUM_ROWS',to_char(l_count));
888:
889: -- Start:Code added for Bug 3555739
890: -- Updating okc_k_headers_b
891: -- Cust_Acct_Id
892: -- Insert into log table
893: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
894: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 909: 'OKC_K_HEADERS_B',

905: LAST_UPDATE_LOGIN,
906: LAST_UPDATE_DATE,
907: LAST_UPDATED_BY
908: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
909: 'OKC_K_HEADERS_B',
910: CUSTOMER_MERGE_HEADER_ID,
911: okh.ID,
912: to_char(okh.cust_acct_id),
913: to_char(rcm.customer_id),

Line 921: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm

917: hz_utility_pub.CREATION_DATE,
918: hz_utility_pub.LAST_UPDATE_LOGIN,
919: hz_utility_pub.LAST_UPDATE_DATE,
920: hz_utility_pub.LAST_UPDATED_BY
921: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
922: WHERE (
923: okh.cust_acct_id = rcm.duplicate_id
924: ) AND rcm.process_flag = 'N'
925: AND rcm.request_id = req_id

Line 936: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.CUST_ACCT_ID',FALSE);

932:
933: End If;
934:
935: arp_message.set_name('AR','AR_UPDATING_TABLE');
936: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.CUST_ACCT_ID',FALSE);
937:
938: UPDATE okc_k_headers_b okh
939: SET okh.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)
940: FROM ra_customer_merges rcm

Line 938: UPDATE okc_k_headers_b okh

934:
935: arp_message.set_name('AR','AR_UPDATING_TABLE');
936: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.CUST_ACCT_ID',FALSE);
937:
938: UPDATE okc_k_headers_b okh
939: SET okh.cust_acct_id = (SELECT DISTINCT (rcm.customer_id)
940: FROM ra_customer_merges rcm
941: WHERE okh.cust_acct_id = rcm.duplicate_id
942: AND rcm.process_flag = 'N'

Line 1845: -- Updating okc_k_headers_b

1841: arp_message.set_name('AR','AR_ROWS_UPDATED');
1842: arp_message.set_token('NUM_ROWS',to_char(l_count));
1843:
1844: -- Start:Code added for Bug 3555739
1845: -- Updating okc_k_headers_b
1846: -- Ship_to_site_use_id
1847: -- Insert into log table
1848: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1849: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1864: 'OKC_K_HEADERS_B',

1860: LAST_UPDATE_LOGIN,
1861: LAST_UPDATE_DATE,
1862: LAST_UPDATED_BY
1863: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1864: 'OKC_K_HEADERS_B',
1865: CUSTOMER_MERGE_HEADER_ID,
1866: okh.ID,
1867: to_char(okh.ship_to_site_use_id),
1868: to_char(rcm.customer_site_id),

Line 1876: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm

1872: hz_utility_pub.CREATION_DATE,
1873: hz_utility_pub.LAST_UPDATE_LOGIN,
1874: hz_utility_pub.LAST_UPDATE_DATE,
1875: hz_utility_pub.LAST_UPDATED_BY
1876: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
1877: WHERE (
1878: okh.ship_to_site_use_id = rcm.duplicate_site_id
1879: ) AND rcm.process_flag = 'N'
1880: AND rcm.request_id = req_id

Line 1891: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.SHIP_TO_SITE_USE_ID',FALSE);

1887:
1888: End If;
1889:
1890: arp_message.set_name('AR','AR_UPDATING_TABLE');
1891: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.SHIP_TO_SITE_USE_ID',FALSE);
1892:
1893: UPDATE okc_k_headers_b okh
1894: SET okh.ship_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
1895: FROM ra_customer_merges rcm

Line 1893: UPDATE okc_k_headers_b okh

1889:
1890: arp_message.set_name('AR','AR_UPDATING_TABLE');
1891: arp_message.set_token('TABLE_NAME','OKC_K_HEADERS_B.SHIP_TO_SITE_USE_ID',FALSE);
1892:
1893: UPDATE okc_k_headers_b okh
1894: SET okh.ship_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
1895: FROM ra_customer_merges rcm
1896: WHERE okh.ship_to_site_use_id = rcm.duplicate_site_id
1897: AND rcm.process_flag = 'N'

Line 1914: -- Updating okc_k_headers_b

1910: arp_message.set_name('AR','AR_ROWS_UPDATED');
1911: arp_message.set_token('NUM_ROWS',to_char(l_count));
1912:
1913:
1914: -- Updating okc_k_headers_b
1915: -- Bill_to_site_use_id
1916: -- Insert into log table
1917: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1918: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 1933: 'OKC_K_HEADERS_B',

1929: LAST_UPDATE_LOGIN,
1930: LAST_UPDATE_DATE,
1931: LAST_UPDATED_BY
1932: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1933: 'OKC_K_HEADERS_B',
1934: CUSTOMER_MERGE_HEADER_ID,
1935: okh.ID,
1936: to_char(okh.bill_to_site_use_id),
1937: to_char(rcm.customer_site_id),

Line 1945: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm

1941: hz_utility_pub.CREATION_DATE,
1942: hz_utility_pub.LAST_UPDATE_LOGIN,
1943: hz_utility_pub.LAST_UPDATE_DATE,
1944: hz_utility_pub.LAST_UPDATED_BY
1945: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
1946: WHERE (
1947: okh.bill_to_site_use_id = rcm.duplicate_site_id
1948: ) AND rcm.process_flag = 'N'
1949: AND rcm.request_id = req_id

Line 1962: UPDATE okc_k_headers_b okh

1958:
1959: arp_message.set_name('AR','AR_UPDATING_TABLE');
1960: arp_message.set_token('TABLE_NAME','OKC_K_LINES_B.BILL_TO_SITE_USE_ID',FALSE);
1961:
1962: UPDATE okc_k_headers_b okh
1963: SET okh.bill_to_site_use_id = (SELECT DISTINCT (rcm.customer_site_id)
1964: FROM ra_customer_merges rcm
1965: WHERE okh.bill_to_site_use_id = rcm.duplicate_site_id
1966: AND rcm.process_flag = 'N'