[Home] [Help]
PACKAGE: APPS.OKL_CLL_PVT
Source
1 PACKAGE OKL_CLL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSCLLS.pls 115.2 2002/08/02 23:03:50 sanahuja noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_CNTR_LVLNG_LNS_V Record Spec
7 TYPE cllv_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,kle_id NUMBER := OKC_API.G_MISS_NUM
10 ,clg_id NUMBER := OKC_API.G_MISS_NUM
11 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
12 ,attribute_category OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
13 ,attribute1 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
14 ,attribute2 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
15 ,attribute3 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
16 ,attribute4 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
17 ,attribute5 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
18 ,attribute6 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
19 ,attribute7 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
20 ,attribute8 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
21 ,attribute9 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
22 ,attribute10 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
23 ,attribute11 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
24 ,attribute12 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
25 ,attribute13 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
26 ,attribute14 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
27 ,attribute15 OKL_CNTR_LVLNG_LNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
28 ,created_by NUMBER := OKC_API.G_MISS_NUM
29 ,creation_date OKL_CNTR_LVLNG_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
30 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
31 ,last_update_date OKL_CNTR_LVLNG_LNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
32 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
33 G_MISS_cllv_rec cllv_rec_type;
34 TYPE cllv_tbl_type IS TABLE OF cllv_rec_type
35 INDEX BY BINARY_INTEGER;
36 -- OKL_CNTR_LVLNG_LNS_B Record Spec
37 TYPE okl_cntr_lvlng_lns_b_rec_type IS RECORD (
38 id NUMBER := OKC_API.G_MISS_NUM
39 ,kle_id NUMBER := OKC_API.G_MISS_NUM
40 ,clg_id NUMBER := OKC_API.G_MISS_NUM
41 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
42 ,attribute_category OKL_CNTR_LVLNG_LNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
43 ,attribute1 OKL_CNTR_LVLNG_LNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
44 ,attribute2 OKL_CNTR_LVLNG_LNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
45 ,attribute3 OKL_CNTR_LVLNG_LNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
46 ,attribute4 OKL_CNTR_LVLNG_LNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
47 ,attribute5 OKL_CNTR_LVLNG_LNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
48 ,attribute6 OKL_CNTR_LVLNG_LNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
49 ,attribute7 OKL_CNTR_LVLNG_LNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
50 ,attribute8 OKL_CNTR_LVLNG_LNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
51 ,attribute9 OKL_CNTR_LVLNG_LNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
52 ,attribute10 OKL_CNTR_LVLNG_LNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
53 ,attribute11 OKL_CNTR_LVLNG_LNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
54 ,attribute12 OKL_CNTR_LVLNG_LNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
55 ,attribute13 OKL_CNTR_LVLNG_LNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
56 ,attribute14 OKL_CNTR_LVLNG_LNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
57 ,attribute15 OKL_CNTR_LVLNG_LNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
58 ,created_by NUMBER := OKC_API.G_MISS_NUM
59 ,creation_date OKL_CNTR_LVLNG_LNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
60 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
61 ,last_update_date OKL_CNTR_LVLNG_LNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
62 ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
63 GMissOklCntrLvlngLnsBRec okl_cntr_lvlng_lns_b_rec_type;
64 TYPE okl_cntr_lvlng_lns_b_tbl_type IS TABLE OF okl_cntr_lvlng_lns_b_rec_type
65 INDEX BY BINARY_INTEGER;
66 ---------------------------------------------------------------------------
67 -- GLOBAL MESSAGE CONSTANTS
68 ---------------------------------------------------------------------------
69 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
70 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
71 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
72 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
73 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
74 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
75 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
76 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
77 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
78 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
79 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
80 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
81 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
82
83 ---------------------------------------------------------------------------
84 -- GLOBAL EXCEPTIONS
85 ---------------------------------------------------------------------------
86 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
87
88 ---------------------------------------------------------------------------
89 -- GLOBAL VARIABLES
90 ---------------------------------------------------------------------------
91 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CLL_PVT';
92 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
93 ---------------------------------------------------------------------------
94 -- Procedures and Functions
95 ---------------------------------------------------------------------------
96
97 PROCEDURE qc;
98 PROCEDURE change_version;
99 PROCEDURE api_copy;
100 PROCEDURE insert_row(
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_cllv_rec IN cllv_rec_type,
107 x_cllv_rec OUT NOCOPY cllv_rec_type);
108 PROCEDURE insert_row(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_cllv_tbl IN cllv_tbl_type,
115 x_cllv_tbl OUT NOCOPY cllv_tbl_type);
116 PROCEDURE lock_row(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_cllv_rec IN cllv_rec_type);
123 PROCEDURE lock_row(
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_cllv_tbl IN cllv_tbl_type);
130 PROCEDURE update_row(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 p_cllv_rec IN cllv_rec_type,
137 x_cllv_rec OUT NOCOPY cllv_rec_type);
138 PROCEDURE update_row(
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 p_cllv_tbl IN cllv_tbl_type,
145 x_cllv_tbl OUT NOCOPY cllv_tbl_type);
146 PROCEDURE delete_row(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_cllv_rec IN cllv_rec_type);
153 PROCEDURE delete_row(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_cllv_tbl IN cllv_tbl_type);
160 PROCEDURE validate_row(
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2,
166 p_cllv_rec IN cllv_rec_type);
167 PROCEDURE validate_row(
168 p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 p_cllv_tbl IN cllv_tbl_type);
174 END OKL_CLL_PVT;