[Home] [Help]
PACKAGE: APPS.OKL_SEL_PVT
Source
1 PACKAGE Okl_Sel_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSSELS.pls 120.2 2005/06/24 03:12:09 hkpatel noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 ---------------------------------------------------------------------------
7 -- GLOBAL DATASTRUCTURES
8 ---------------------------------------------------------------------------
9 TYPE sel_rec_type IS RECORD (
10 id NUMBER,
11 stm_id NUMBER,
12 object_version_number NUMBER,
13 stream_element_date OKL_STRM_ELEMENTS.STREAM_ELEMENT_DATE%TYPE,
14 amount NUMBER,
15 comments OKL_STRM_ELEMENTS.COMMENTS%TYPE,
16 accrued_yn OKL_STRM_ELEMENTS.ACCRUED_YN%TYPE,
17 program_id NUMBER,
18 request_id NUMBER,
19 program_application_id NUMBER,
20 program_update_date OKL_STRM_ELEMENTS.PROGRAM_UPDATE_DATE%TYPE,
21 se_line_number OKL_STRM_ELEMENTS.SE_LINE_NUMBER%TYPE,
22 date_billed OKL_STRM_ELEMENTS.DATE_BILLED%TYPE,
23 created_by NUMBER,
24 creation_date OKL_STRM_ELEMENTS.CREATION_DATE%TYPE,
25 last_updated_by NUMBER,
26 last_update_date OKL_STRM_ELEMENTS.LAST_UPDATE_DATE%TYPE,
27 last_update_login NUMBER,
28 ---- Changed by Kjinger
29 sel_id NUMBER,
30 --- Changes End
31 --Added by Keerthi 15-Sep-2003
32 source_id NUMBER,
33 source_table OKL_STRM_ELEMENTS.SOURCE_TABLE%TYPE,
34 -- Added by rgooty: 4212626
35 bill_adj_flag OKL_STRM_ELEMENTS.BILL_ADJ_FLAG%TYPE,
36 accrual_adj_flag OKL_STRM_ELEMENTS.ACCRUAL_ADJ_FLAG%TYPE,
37 -- Added by hkpatel for bug 4350255
38 date_disbursed OKL_STRM_ELEMENTS.DATE_DISBURSED%TYPE );
39 g_miss_sel_rec sel_rec_type;
40 TYPE sel_tbl_type IS TABLE OF sel_rec_type
41 INDEX BY BINARY_INTEGER;
42 TYPE selv_rec_type IS RECORD (
43 id NUMBER ,
44 object_version_number NUMBER ,
45 stm_id NUMBER ,
46 amount NUMBER ,
47 comments OKL_STRM_ELEMENTS_V.COMMENTS%TYPE ,
48 accrued_yn OKL_STRM_ELEMENTS_V.ACCRUED_YN%TYPE ,
49 stream_element_date OKL_STRM_ELEMENTS_V.STREAM_ELEMENT_DATE%TYPE ,
50 program_id NUMBER ,
51 request_id NUMBER ,
52 program_application_id NUMBER ,
53 program_update_date OKL_STRM_ELEMENTS_V.PROGRAM_UPDATE_DATE%TYPE ,
54 se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE ,
55 date_billed OKL_STRM_ELEMENTS_V.DATE_BILLED%TYPE ,
56 created_by NUMBER ,
57 creation_date OKL_STRM_ELEMENTS_V.CREATION_DATE%TYPE ,
58 last_updated_by NUMBER ,
59 last_update_date OKL_STRM_ELEMENTS_V.LAST_UPDATE_DATE%TYPE ,
60 last_update_login NUMBER ,
61 parent_index NUMBER ,
62 ---- Changed by Kjinger
63 sel_id NUMBER ,
64 ---- Changes End
65 --Added by Keerthi 15-Sep-2003
66 source_id NUMBER ,
67 source_table OKL_STRM_ELEMENTS.SOURCE_TABLE%TYPE,
68 -- Added by rgooty: 4212626
69 bill_adj_flag OKL_STRM_ELEMENTS_V.BILL_ADJ_FLAG%TYPE,
70 accrual_adj_flag OKL_STRM_ELEMENTS_V.ACCRUAL_ADJ_FLAG%TYPE,
71 -- Added by hkpatel for bug 4350255
72 date_disbursed OKL_STRM_ELEMENTS_V.DATE_DISBURSED%TYPE );
73
74
75 g_miss_selv_rec selv_rec_type;
76 TYPE selv_tbl_type IS TABLE OF selv_rec_type
77 INDEX BY BINARY_INTEGER;
78 ---------------------------------------------------------------------------
79 -- GLOBAL MESSAGE CONSTANTS
80 ---------------------------------------------------------------------------
81 G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
82 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
83 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
84 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
85 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
86 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
87 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
88 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
89 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
90 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
91 -- START CHANGE : akjain -- 05/14/2001
92 -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM','Unexpected Error'
93 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
94 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
95 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
96 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_NO_PARENT_RECORD';
97 G_UNQS CONSTANT VARCHAR2(200) := 'OKL_UNIQUE_KEY_VALIDATION_FAILED';
98 -- END CHANGE : akjain
99 ---------------------------------------------------------------------------
100 -- GLOBAL VARIABLES
101 ---------------------------------------------------------------------------
102 G_PKG_NAME CONSTANT VARCHAR2(200) := 'Okl_Sel_Pvt';
103 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
104
105 /* Hand written code start - akjain 05/10/2001 */
106 ---------------------------------------------------------------------------
107 -- GLOBAL EXCEPTIONS
108 ---------------------------------------------------------------------------
109
110 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
111 ---------------------------------------------------------------------------
112 /* hand written code end */
113
114
115 ---------------------------------------------------------------------------
116 -- Procedures and Functions
117 ---------------------------------------------------------------------------
118
119 PROCEDURE qc;
120 PROCEDURE change_version;
121 PROCEDURE api_copy;
122 PROCEDURE insert_row(
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 p_selv_rec IN selv_rec_type,
129 x_selv_rec OUT NOCOPY selv_rec_type);
130
131 PROCEDURE insert_row(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_selv_tbl IN selv_tbl_type,
138 x_selv_tbl OUT NOCOPY selv_tbl_type);
139
140 PROCEDURE lock_row(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_selv_rec IN selv_rec_type);
147
148 PROCEDURE lock_row(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_selv_tbl IN selv_tbl_type);
155
156 PROCEDURE update_row(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_selv_rec IN selv_rec_type,
163 x_selv_rec OUT NOCOPY selv_rec_type);
164
165 PROCEDURE update_row(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT Okc_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_selv_tbl IN selv_tbl_type,
172 x_selv_tbl OUT NOCOPY selv_tbl_type);
173
174 PROCEDURE delete_row(
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2,
180 p_selv_rec IN selv_rec_type);
181
182 PROCEDURE delete_row(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_selv_tbl IN selv_tbl_type);
189
190 PROCEDURE validate_row(
191 p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2,
196 p_selv_rec IN selv_rec_type);
197
198 PROCEDURE validate_row(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_selv_tbl IN selv_tbl_type);
205
206 END Okl_Sel_Pvt;