DBA Data[Home] [Help]

APPS.OKC_PARTY_MERGE_PUB dependencies on OKC_K_VERS_NUMBERS

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

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

Line 204: INSERT INTO OKC_K_VERS_NUMBERS_H(

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

Line 224: FROM OKC_K_VERS_NUMBERS

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

Line 235: UPDATE okc_k_vers_numbers ver

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