[Home] [Help]
PACKAGE: APPS.OKL_OPD_PVT
Source
1 Package OKL_OPD_PVT AS
2 /* $Header: OKLSOPDS.pls 120.2 2006/12/07 06:11:39 ssdeshpa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE opd_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 name OKL_OPERANDS_B.NAME%TYPE := OKC_API.G_MISS_CHAR,
9 fma_id NUMBER := OKC_API.G_MISS_NUM,
10 dsf_id NUMBER := OKC_API.G_MISS_NUM,
11 version OKL_OPERANDS_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
12 opd_type OKL_OPERANDS_B.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13 object_version_number NUMBER := OKC_API.G_MISS_NUM,
14 org_id NUMBER := OKC_API.G_MISS_NUM,
15 start_date OKL_OPERANDS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
16 source OKL_OPERANDS_B.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
17 created_by NUMBER := OKC_API.G_MISS_NUM,
18 creation_date OKL_OPERANDS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
20 last_update_date OKL_OPERANDS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21 last_update_login NUMBER := OKC_API.G_MISS_NUM,
22 end_date OKL_OPERANDS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE);
23 g_miss_opd_rec opd_rec_type;
24 TYPE opd_tbl_type IS TABLE OF opd_rec_type
25 INDEX BY BINARY_INTEGER;
26 TYPE okl_operands_tl_rec_type IS RECORD (
27 id NUMBER := OKC_API.G_MISS_NUM,
28 language OKL_OPERANDS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
29 source_lang OKL_OPERANDS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
30 sfwt_flag OKL_OPERANDS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
31 description OKL_OPERANDS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
32 created_by NUMBER := OKC_API.G_MISS_NUM,
33 creation_date OKL_OPERANDS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
34 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
35 last_update_date OKL_OPERANDS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
36 last_update_login NUMBER := OKC_API.G_MISS_NUM);
37 g_miss_okl_operands_tl_rec okl_operands_tl_rec_type;
38 TYPE okl_operands_tl_tbl_type IS TABLE OF okl_operands_tl_rec_type
39 INDEX BY BINARY_INTEGER;
40 TYPE opdv_rec_type IS RECORD (
41 id NUMBER := OKC_API.G_MISS_NUM,
42 object_version_number NUMBER := OKC_API.G_MISS_NUM,
43 sfwt_flag OKL_OPERANDS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44 fma_id NUMBER := OKC_API.G_MISS_NUM,
45 dsf_id NUMBER := OKC_API.G_MISS_NUM,
46 name OKL_OPERANDS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
47 description OKL_OPERANDS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
48 version OKL_OPERANDS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
49 start_date OKL_OPERANDS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
50 end_date OKL_OPERANDS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
51 source OKL_OPERANDS_V.SOURCE%TYPE := OKC_API.G_MISS_CHAR,
52 opd_type OKL_OPERANDS_V.OPD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53 org_id NUMBER := OKC_API.G_MISS_NUM,
54 created_by NUMBER := OKC_API.G_MISS_NUM,
55 creation_date OKL_OPERANDS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
56 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
57 last_update_date OKL_OPERANDS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
58 last_update_login NUMBER := OKC_API.G_MISS_NUM);
59 g_miss_opdv_rec opdv_rec_type;
60 TYPE opdv_tbl_type IS TABLE OF opdv_rec_type
61 INDEX BY BINARY_INTEGER;
62 ---------------------------------------------------------------------------
63 -- GLOBAL MESSAGE CONSTANTS
64 ---------------------------------------------------------------------------
65 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
66 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
67 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
68 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
69 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
70 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
71 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
72 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
73 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
74 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
75
76 --RPOONUGA001: Added the following
77 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
78 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
79 G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
80 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
81 G_UNQS CONSTANT VARCHAR2(200) := 'OKL_NOT_UNIQUE';
82 G_INVALID_KEY CONSTANT VARCHAR2(200) := 'OKL_INVALID_KEY';
83 G_MISS_DATA CONSTANT VARCHAR2(200) := 'OKL_MISS_DATA';
84 G_TO_DATE_ERROR CONSTANT VARCHAR2(200) := 'OKL_TO_DATE_ERROR';
85
86 ---------------------------------------------------------------------------
87 -- GLOBAL VARIABLES
88 ---------------------------------------------------------------------------
89 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_OPD_PVT';
90 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
91 --RPOONUGA001: Added the following
92 G_FORMULA_TYPE CONSTANT VARCHAR2(10) := 'FMLA';
93 G_FUNCTION_TYPE CONSTANT VARCHAR2(10) := 'FCNT';
94 G_CONSTANT_TYPE CONSTANT VARCHAR2(10) := 'CNST';
95
96 --------------------------------------------------------------------------------
97 -- ERRORS AND EXCEPTIONS
98 --------------------------------------------------------------------------------
99 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
100
101 ---------------------------------------------------------------------------
102 -- Procedures and Functions
103 ---------------------------------------------------------------------------
104
105 PROCEDURE qc;
106 PROCEDURE change_version;
107 PROCEDURE api_copy;
108 PROCEDURE add_language;
109 PROCEDURE insert_row(
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_opdv_rec IN opdv_rec_type,
116 x_opdv_rec OUT NOCOPY opdv_rec_type);
117
118 PROCEDURE insert_row(
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 p_opdv_tbl IN opdv_tbl_type,
125 x_opdv_tbl OUT NOCOPY opdv_tbl_type);
126
127 PROCEDURE lock_row(
128 p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 p_opdv_rec IN opdv_rec_type);
134
135 PROCEDURE lock_row(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_opdv_tbl IN opdv_tbl_type);
142
143 PROCEDURE update_row(
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_opdv_rec IN opdv_rec_type,
150 x_opdv_rec OUT NOCOPY opdv_rec_type);
151
152 PROCEDURE update_row(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2,
158 p_opdv_tbl IN opdv_tbl_type,
159 x_opdv_tbl OUT NOCOPY opdv_tbl_type);
160
161 PROCEDURE delete_row(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 p_opdv_rec IN opdv_rec_type);
168
169 PROCEDURE delete_row(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_opdv_tbl IN opdv_tbl_type);
176
177 PROCEDURE validate_row(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_opdv_rec IN opdv_rec_type);
184
185 PROCEDURE validate_row(
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2,
191 p_opdv_tbl IN opdv_tbl_type);
192
193 PROCEDURE LOAD_SEED_ROW(
194 p_upload_mode IN VARCHAR2,
195 p_okl_operand_id IN VARCHAR2,
196 p_name IN VARCHAR2,
197 p_version IN VARCHAR2,
198 p_fma_id IN VARCHAR2,
199 p_dsf_id IN VARCHAR2,
200 p_opd_type IN VARCHAR2,
201 p_object_version_number IN VARCHAR2,
202 p_org_id IN VARCHAR2,
203 p_start_date IN VARCHAR2,
204 p_end_date IN VARCHAR2,
205 p_source IN VARCHAR2,
206 p_last_update_date IN VARCHAR2,
207 p_owner IN VARCHAR2,
208 p_description IN VARCHAR2);
209
210 END OKL_OPD_PVT;