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_VERS_NUMBERS

Line 26: -- 19-JAN-05 chkrishn Bug 4105272 Added insert statement to OKC_K_VERS_NUMBERS_H

22: -- account_site_merge procedure to take care of 11.5.10 rule
23: -- migration changes for OKS
24: -- 01-NOV-04 who Bug 3950642 Added code to take care of site use merge for OKE
25: -- in the OKC_K_PARTY_ROLES tables.
26: -- 19-JAN-05 chkrishn Bug 4105272 Added insert statement to OKC_K_VERS_NUMBERS_H
27: -- in procedure PARTY_MERGE
28: -- 27-FEB-07 harchand Bug 6861077. Added the code to the union query of cursor c_account_count
29: /* 04-DEC-2009 vgujarat Bug9077092. Changed the procedure party_merge, account_merge and
30: account_site_merge to increment the minor version in

Line 31: okc_k_vers_numbers accordingly.

27: -- in procedure PARTY_MERGE
28: -- 27-FEB-07 harchand Bug 6861077. Added the code to the union query of cursor c_account_count
29: /* 04-DEC-2009 vgujarat Bug9077092. Changed the procedure party_merge, account_merge and
30: account_site_merge to increment the minor version in
31: okc_k_vers_numbers accordingly.
32: 28-dec-2010 vgujarat Bug10434787. Changed the cursor contract_id under procedure account_site_merge
33: */
34: -- NOTES
35: -- Merging Rules:

Line 516: -- Fix for bug 4105272 Insert into okc_k_vers_numbers_h

512: ,hz.LAST_UPDATED_BY = hz_utility_pub.LAST_UPDATED_BY
513: ,hz.ACTION_FLAG = 'U'
514: WHERE hz.PRIMARY_KEY_ID1 = l_log_party_id;
515: END IF;
516: -- Fix for bug 4105272 Insert into okc_k_vers_numbers_h
517: INSERT INTO OKC_K_VERS_NUMBERS_H(
518: chr_id,
519: major_version,
520: minor_version,

Line 517: INSERT INTO OKC_K_VERS_NUMBERS_H(

513: ,hz.ACTION_FLAG = 'U'
514: WHERE hz.PRIMARY_KEY_ID1 = l_log_party_id;
515: END IF;
516: -- Fix for bug 4105272 Insert into okc_k_vers_numbers_h
517: INSERT INTO OKC_K_VERS_NUMBERS_H(
518: chr_id,
519: major_version,
520: minor_version,
521: object_version_number,

Line 537: FROM OKC_K_VERS_NUMBERS

533: creation_date,
534: last_updated_by,
535: last_update_date,
536: last_update_login
537: FROM OKC_K_VERS_NUMBERS
538: WHERE chr_id = l_chr_id);
539: -- Updating okc_k_vers_numbers for Bug 3553330/3215231/3224957
540: UPDATE okc_k_vers_numbers ver
541: SET ver.minor_version = ver.minor_version + 1

Line 539: -- Updating okc_k_vers_numbers for Bug 3553330/3215231/3224957

535: last_update_date,
536: last_update_login
537: FROM OKC_K_VERS_NUMBERS
538: WHERE chr_id = l_chr_id);
539: -- Updating okc_k_vers_numbers for Bug 3553330/3215231/3224957
540: UPDATE okc_k_vers_numbers ver
541: SET ver.minor_version = ver.minor_version + 1
542: ,ver.object_version_number = ver.object_version_number + 1
543: ,ver.last_update_date = SYSDATE

Line 540: UPDATE okc_k_vers_numbers ver

536: last_update_login
537: FROM OKC_K_VERS_NUMBERS
538: WHERE chr_id = l_chr_id);
539: -- Updating okc_k_vers_numbers for Bug 3553330/3215231/3224957
540: UPDATE okc_k_vers_numbers ver
541: SET ver.minor_version = ver.minor_version + 1
542: ,ver.object_version_number = ver.object_version_number + 1
543: ,ver.last_update_date = SYSDATE
544: ,ver.last_updated_by = arp_standard.profile.user_id

Line 547: -- Updating okc_k_vers_numbers for Bug 3553330/3215231/3224957

543: ,ver.last_update_date = SYSDATE
544: ,ver.last_updated_by = arp_standard.profile.user_id
545: ,ver.last_update_login = arp_standard.profile.last_update_login
546: WHERE chr_id = l_chr_id;
547: -- Updating okc_k_vers_numbers for Bug 3553330/3215231/3224957
548: g_minor_ver_upd_processed := 'Y'; /*bug9077092*/
549: END IF;
550:
551: EXIT;

Line 1218: INSERT INTO OKC_K_VERS_NUMBERS_H(

1214: IF l_cum_count > 0 AND g_minor_ver_upd_processed = 'N' THEN
1215:
1216: IF l_chr_id.Count > 0 THEN
1217: FOR k IN l_chr_id.first..l_chr_id.last loop
1218: INSERT INTO OKC_K_VERS_NUMBERS_H(
1219: chr_id,
1220: major_version,
1221: minor_version,
1222: object_version_number,

Line 1238: FROM OKC_K_VERS_NUMBERS

1234: creation_date,
1235: last_updated_by,
1236: last_update_date,
1237: last_update_login
1238: FROM OKC_K_VERS_NUMBERS
1239: WHERE chr_id = l_chr_id(k));
1240:
1241: UPDATE okc_k_vers_numbers ver
1242: SET ver.minor_version = ver.minor_version + 1

Line 1241: UPDATE okc_k_vers_numbers ver

1237: last_update_login
1238: FROM OKC_K_VERS_NUMBERS
1239: WHERE chr_id = l_chr_id(k));
1240:
1241: UPDATE okc_k_vers_numbers ver
1242: SET ver.minor_version = ver.minor_version + 1
1243: ,ver.object_version_number = ver.object_version_number + 1
1244: ,ver.last_update_date = SYSDATE
1245: ,ver.last_updated_by = arp_standard.profile.user_id

Line 2386: INSERT INTO OKC_K_VERS_NUMBERS_H(

2382: IF l_cum_count > 0 AND g_minor_ver_upd_processed = 'N' THEN
2383:
2384: IF l_chr_id.Count > 0 THEN
2385: FOR k IN l_chr_id.first..l_chr_id.last loop
2386: INSERT INTO OKC_K_VERS_NUMBERS_H(
2387: chr_id,
2388: major_version,
2389: minor_version,
2390: object_version_number,

Line 2406: FROM OKC_K_VERS_NUMBERS

2402: creation_date,
2403: last_updated_by,
2404: last_update_date,
2405: last_update_login
2406: FROM OKC_K_VERS_NUMBERS
2407: WHERE chr_id = l_chr_id(k));
2408:
2409: UPDATE okc_k_vers_numbers ver
2410: SET ver.minor_version = ver.minor_version + 1

Line 2409: UPDATE okc_k_vers_numbers ver

2405: last_update_login
2406: FROM OKC_K_VERS_NUMBERS
2407: WHERE chr_id = l_chr_id(k));
2408:
2409: UPDATE okc_k_vers_numbers ver
2410: SET ver.minor_version = ver.minor_version + 1
2411: ,ver.object_version_number = ver.object_version_number + 1
2412: ,ver.last_update_date = SYSDATE
2413: ,ver.last_updated_by = arp_standard.profile.user_id