[Home] [Help]
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
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,
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,
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,
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,