[Home] [Help]
PACKAGE: APPS.OKS_SLL_PVT
Source
1 PACKAGE OKS_SLL_PVT AS
2 /* $Header: OKSSSLLS.pls 120.3 2006/09/19 18:57:18 hvaladip noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKS_STREAM_LEVELS_V Record Spec
7 TYPE sllv_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,chr_id NUMBER := OKC_API.G_MISS_NUM
10 ,cle_id NUMBER := OKC_API.G_MISS_NUM
11 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12 ,sequence_no NUMBER := OKC_API.G_MISS_NUM
13 ,uom_code OKS_STREAM_LEVELS_V.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
14 ,start_date OKS_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15 ,end_date OKS_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16 ,level_periods NUMBER := OKC_API.G_MISS_NUM
17 ,uom_per_period NUMBER := OKC_API.G_MISS_NUM
18 ,advance_periods NUMBER := OKC_API.G_MISS_NUM
19 ,level_amount NUMBER := OKC_API.G_MISS_NUM
20 ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM
21 ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM
22 ,comments OKS_STREAM_LEVELS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
23 ,due_arr_yn OKS_STREAM_LEVELS_V.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR
24 ,amount NUMBER := OKC_API.G_MISS_NUM
25 ,lines_detailed_yn OKS_STREAM_LEVELS_V.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR
26 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
27 ,security_group_id NUMBER := OKC_API.G_MISS_NUM
28 ,request_id NUMBER := OKC_API.G_MISS_NUM
29 ,created_by NUMBER := OKC_API.G_MISS_NUM
30 ,creation_date OKS_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
31 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
32 ,last_update_date OKS_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
33 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
34 ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
35 ,orig_system_reference1 OKS_STREAM_LEVELS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
36 ,orig_system_source_code OKS_STREAM_LEVELS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR);
37 G_MISS_sllv_rec sllv_rec_type;
38 TYPE sllv_tbl_type IS TABLE OF sllv_rec_type
39 INDEX BY BINARY_INTEGER;
40 -- OKS_STREAM_LEVELS_B Record Spec
41 TYPE sll_rec_type IS RECORD (
42 id NUMBER := OKC_API.G_MISS_NUM
43 ,chr_id NUMBER := OKC_API.G_MISS_NUM
44 ,cle_id NUMBER := OKC_API.G_MISS_NUM
45 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
46 ,sequence_no NUMBER := OKC_API.G_MISS_NUM
47 ,uom_code OKS_STREAM_LEVELS_B.UOM_CODE%TYPE := OKC_API.G_MISS_CHAR
48 ,start_date OKS_STREAM_LEVELS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE
49 ,end_date OKS_STREAM_LEVELS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE
50 ,level_periods NUMBER := OKC_API.G_MISS_NUM
51 ,uom_per_period NUMBER := OKC_API.G_MISS_NUM
52 ,advance_periods NUMBER := OKC_API.G_MISS_NUM
53 ,level_amount NUMBER := OKC_API.G_MISS_NUM
54 ,invoice_offset_days NUMBER := OKC_API.G_MISS_NUM
55 ,interface_offset_days NUMBER := OKC_API.G_MISS_NUM
56 ,comments OKS_STREAM_LEVELS_B.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
57 ,due_arr_yn OKS_STREAM_LEVELS_B.DUE_ARR_YN%TYPE := OKC_API.G_MISS_CHAR
58 ,amount NUMBER := OKC_API.G_MISS_NUM
59 ,lines_detailed_yn OKS_STREAM_LEVELS_B.LINES_DETAILED_YN%TYPE := OKC_API.G_MISS_CHAR
60 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
61 ,request_id NUMBER := OKC_API.G_MISS_NUM
62 ,created_by NUMBER := OKC_API.G_MISS_NUM
63 ,creation_date OKS_STREAM_LEVELS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
64 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
65 ,last_update_date OKS_STREAM_LEVELS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
66 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
67 ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
68 ,orig_system_reference1 OKS_STREAM_LEVELS_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
69 ,orig_system_source_code OKS_STREAM_LEVELS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR);
70 G_MISS_sll_rec sll_rec_type;
71 TYPE sll_tbl_type IS TABLE OF sll_rec_type
72 INDEX BY BINARY_INTEGER;
73 ---------------------------------------------------------------------------
74 -- GLOBAL MESSAGE CONSTANTS
75 ---------------------------------------------------------------------------
76 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
77 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
78 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
79 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
80 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
81 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
82 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
83 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
84 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
85 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
86 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
87 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
88 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
89
90 ---------------------------------------------------------------------------
91 -- GLOBAL EXCEPTIONS
92 ---------------------------------------------------------------------------
93 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
94
95 ---------------------------------------------------------------------------
96 -- GLOBAL VARIABLES
97 ---------------------------------------------------------------------------
98 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_SLL_PVT';
99 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
100 ---------------------------------------------------------------------------
101 -- Procedures and Functions
102 ---------------------------------------------------------------------------
103
104 PROCEDURE qc;
105 PROCEDURE change_version;
106 PROCEDURE api_copy;
107 PROCEDURE insert_row(
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 p_sllv_rec IN sllv_rec_type,
114 x_sllv_rec OUT NOCOPY sllv_rec_type);
115 PROCEDURE insert_row(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_sllv_tbl IN sllv_tbl_type,
122 x_sllv_tbl OUT NOCOPY sllv_tbl_type,
123 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
124 PROCEDURE insert_row(
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 p_sllv_tbl IN sllv_tbl_type,
131 x_sllv_tbl OUT NOCOPY sllv_tbl_type);
132 PROCEDURE lock_row(
133 p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 p_sllv_rec IN sllv_rec_type);
139 PROCEDURE lock_row(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_sllv_tbl IN sllv_tbl_type,
146 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
147 PROCEDURE lock_row(
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 p_sllv_tbl IN sllv_tbl_type);
154 PROCEDURE update_row(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_sllv_rec IN sllv_rec_type,
161 x_sllv_rec OUT NOCOPY sllv_rec_type);
162 PROCEDURE update_row(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_sllv_tbl IN sllv_tbl_type,
169 x_sllv_tbl OUT NOCOPY sllv_tbl_type,
170 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
171 PROCEDURE update_row(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_sllv_tbl IN sllv_tbl_type,
178 x_sllv_tbl OUT NOCOPY sllv_tbl_type);
179 PROCEDURE delete_row(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_sllv_rec IN sllv_rec_type);
186 PROCEDURE delete_row(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2,
192 p_sllv_tbl IN sllv_tbl_type,
193 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
194 PROCEDURE delete_row(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_sllv_tbl IN sllv_tbl_type);
201 PROCEDURE validate_row(
202 p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207 p_sllv_rec IN sllv_rec_type);
208 PROCEDURE validate_row(
209 p_api_version IN NUMBER,
210 p_init_msg_list IN VARCHAR2,
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2,
214 p_sllv_tbl IN sllv_tbl_type,
215 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
216 PROCEDURE validate_row(
217 p_api_version IN NUMBER,
218 p_init_msg_list IN VARCHAR2,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_msg_count OUT NOCOPY NUMBER,
221 x_msg_data OUT NOCOPY VARCHAR2,
222 p_sllv_tbl IN sllv_tbl_type);
223 END OKS_SLL_PVT;