DBA Data[Home] [Help]

APPS.OKC_VERSION_PVT dependencies on OKC_K_VERS_NUMBERS_H

Line 45: from okc_k_vers_numbers_h

41: where dnz_chr_id = p_chr_id;
42: --
43: cursor c_rest_to_ver is
44: select object_version_number
45: from okc_k_vers_numbers_h
46: where chr_id = p_chr_id
47: and major_version = l_minus_version;
48:
49: begin

Line 1144: insert into okc_k_vers_numbers_h

1140: RAISE OKC_API.G_EXCEPTION_ERROR;
1141: END IF;
1142:
1143: -- just to save maj/min versions somewhere
1144: insert into okc_k_vers_numbers_h
1145: (
1146: CHR_ID
1147: ,MAJOR_VERSION
1148: ,MINOR_VERSION

Line 1632: delete FROM okc_k_vers_numbers_h

1628: END IF;
1629: END LOOP;
1630: END IF;
1631: --
1632: delete FROM okc_k_vers_numbers_h
1633: WHERE chr_id= p_chr_id
1634: and ((MAJOR_VERSION = -1
1635: and p_called_from = 'ERASE_SAVED_VERSION')
1636: or (p_called_from = 'RESTORE_VERSION'

Line 1790: from okc_k_vers_numbers_h

1786: l_msg_count NUMBER;
1787:
1788: cursor v is
1789: select object_version_number, minor_version
1790: from okc_k_vers_numbers_h
1791: WHERE chr_id= p_chr_id
1792: and MAJOR_VERSION = -1;
1793:
1794: cursor v_lock is

Line 2275: from okc_k_vers_numbers_h

2271: ,CREATION_DATE
2272: ,FND_GLOBAL.USER_ID
2273: ,sysdate
2274: ,FND_GLOBAL.LOGIN_ID
2275: from okc_k_vers_numbers_h
2276: where chr_id = p_chr_id
2277: and MAJOR_VERSION = -1;
2278: --
2279: delete_version( p_chr_id => p_chr_id,