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