APPS.OKC_PARTY_MERGE_PUB dependencies on OKC_K_VERS_NUMBERS

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

198: arp_message.set_token('TABLE_NAME','OKC_K_PARTY_ROLES',FALSE);
199: fnd_file.put_line(fnd_file.log, 'Updating Table okc_k_party_roles_b');
200: --
201: --
202: -- Fix for bug 4105272 Insert into okc_k_vers_numbers_h
203: INSERT INTO OKC_K_VERS_NUMBERS_H(
204: chr_id,
205: major_version,
206: minor_version,

Line 203: INSERT INTO OKC_K_VERS_NUMBERS_H(

199: fnd_file.put_line(fnd_file.log, 'Updating Table okc_k_party_roles_b');
200: --
201: --
202: -- Fix for bug 4105272 Insert into okc_k_vers_numbers_h
203: INSERT INTO OKC_K_VERS_NUMBERS_H(
204: chr_id,
205: major_version,
206: minor_version,
207: object_version_number,

Line 223: FROM OKC_K_VERS_NUMBERS

219: creation_date,
220: last_updated_by,
221: last_update_date,
222: last_update_login
223: FROM OKC_K_VERS_NUMBERS
224: WHERE chr_id IN (select dnz_chr_id
225: from okc_k_party_roles_b kpr
226: where kpr.object1_id1 = to_char(p_from_fk_id)
227: AND kpr.jtot_object1_code IN

Line 234: UPDATE okc_k_vers_numbers ver

230: ,jtf_object_usages oue
231: WHERE ojt.object_code = oue.object_code
232: AND oue.object_user_code = l_object_user_code)));
233: --
234: UPDATE okc_k_vers_numbers ver
235: SET ver.minor_version = ver.minor_version + 1
236: ,ver.object_version_number = ver.object_version_number + 1
237: ,ver.last_update_date = SYSDATE
238: ,ver.last_updated_by = arp_standard.profile.user_id