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: -- NOTES
30: -- Merging Rules:

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

505: ,hz.LAST_UPDATED_BY = hz_utility_pub.LAST_UPDATED_BY
506: ,hz.ACTION_FLAG = 'U'
507: WHERE hz.PRIMARY_KEY_ID1 = l_log_party_id;
508: END IF;
509: -- Fix for bug 4105272 Insert into okc_k_vers_numbers_h
510: INSERT INTO OKC_K_VERS_NUMBERS_H(
511: chr_id,
512: major_version,
513: minor_version,

Line 510: INSERT INTO OKC_K_VERS_NUMBERS_H(

506: ,hz.ACTION_FLAG = 'U'
507: WHERE hz.PRIMARY_KEY_ID1 = l_log_party_id;
508: END IF;
509: -- Fix for bug 4105272 Insert into okc_k_vers_numbers_h
510: INSERT INTO OKC_K_VERS_NUMBERS_H(
511: chr_id,
512: major_version,
513: minor_version,
514: object_version_number,

Line 530: FROM OKC_K_VERS_NUMBERS

526: creation_date,
527: last_updated_by,
528: last_update_date,
529: last_update_login
530: FROM OKC_K_VERS_NUMBERS
531: WHERE chr_id = l_chr_id);
532: -- Updating okc_k_vers_numbers for Bug 3553330/3215231/3224957
533: UPDATE okc_k_vers_numbers ver
534: SET ver.minor_version = ver.minor_version + 1

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

528: last_update_date,
529: last_update_login
530: FROM OKC_K_VERS_NUMBERS
531: WHERE chr_id = l_chr_id);
532: -- Updating okc_k_vers_numbers for Bug 3553330/3215231/3224957
533: UPDATE okc_k_vers_numbers ver
534: SET ver.minor_version = ver.minor_version + 1
535: ,ver.object_version_number = ver.object_version_number + 1
536: ,ver.last_update_date = SYSDATE

Line 533: UPDATE okc_k_vers_numbers ver

529: last_update_login
530: FROM OKC_K_VERS_NUMBERS
531: WHERE chr_id = l_chr_id);
532: -- Updating okc_k_vers_numbers for Bug 3553330/3215231/3224957
533: UPDATE okc_k_vers_numbers ver
534: SET ver.minor_version = ver.minor_version + 1
535: ,ver.object_version_number = ver.object_version_number + 1
536: ,ver.last_update_date = SYSDATE
537: ,ver.last_updated_by = arp_standard.profile.user_id

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

536: ,ver.last_update_date = SYSDATE
537: ,ver.last_updated_by = arp_standard.profile.user_id
538: ,ver.last_update_login = arp_standard.profile.last_update_login
539: WHERE chr_id = l_chr_id;
540: -- Updating okc_k_vers_numbers for Bug 3553330/3215231/3224957
541:
542: END IF;
543:
544: EXIT;