[Home] [Help]
PACKAGE: APPS.OKL_PVN_PVT
Source
1 Package Okl_Pvn_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSPVNS.pls 115.5 2002/02/05 12:19:14 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE pvn_rec_type IS RECORD (
7 id NUMBER := Okc_Api.G_MISS_NUM,
8 name OKL_PROVISIONS.NAME%TYPE := Okc_Api.G_MISS_CHAR,
9 app_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
10 rev_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
11 rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
12 app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
13 set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
14 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
15 version OKL_PROVISIONS.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
16 description OKL_PROVISIONS.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
17 from_date OKL_PROVISIONS.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
18 TO_DATE OKL_PROVISIONS.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
19 attribute_category OKL_PROVISIONS.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
20 attribute1 OKL_PROVISIONS.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
21 attribute2 OKL_PROVISIONS.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
22 attribute3 OKL_PROVISIONS.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
23 attribute4 OKL_PROVISIONS.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
24 attribute5 OKL_PROVISIONS.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
25 attribute6 OKL_PROVISIONS.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
26 attribute7 OKL_PROVISIONS.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
27 attribute8 OKL_PROVISIONS.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
28 attribute9 OKL_PROVISIONS.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
29 attribute10 OKL_PROVISIONS.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
30 attribute11 OKL_PROVISIONS.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
31 attribute12 OKL_PROVISIONS.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
32 attribute13 OKL_PROVISIONS.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
33 attribute14 OKL_PROVISIONS.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
34 attribute15 OKL_PROVISIONS.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
35 created_by NUMBER := Okc_Api.G_MISS_NUM,
36 creation_date OKL_PROVISIONS.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
37 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
38 last_update_date OKL_PROVISIONS.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
39 last_update_login NUMBER := Okc_Api.G_MISS_NUM);
40 g_miss_pvn_rec pvn_rec_type;
41 TYPE pvn_tbl_type IS TABLE OF pvn_rec_type
42 INDEX BY BINARY_INTEGER;
43 TYPE pvnv_rec_type IS RECORD (
44 id NUMBER := Okc_Api.G_MISS_NUM,
45 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
46 app_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
47 rev_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
48 rev_debit_ccid NUMBER := Okc_Api.G_MISS_NUM,
49 set_of_books_id NUMBER := Okc_Api.G_MISS_NUM,
50 app_credit_ccid NUMBER := Okc_Api.G_MISS_NUM,
51 name OKL_PROVISIONS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
52 description OKL_PROVISIONS_V.DESCRIPTION%TYPE := Okc_Api.G_MISS_CHAR,
53 attribute_category OKL_PROVISIONS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
54 attribute1 OKL_PROVISIONS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
55 attribute2 OKL_PROVISIONS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
56 attribute3 OKL_PROVISIONS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
57 attribute4 OKL_PROVISIONS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
58 attribute5 OKL_PROVISIONS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
59 attribute6 OKL_PROVISIONS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
60 attribute7 OKL_PROVISIONS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
61 attribute8 OKL_PROVISIONS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
62 attribute9 OKL_PROVISIONS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
63 attribute10 OKL_PROVISIONS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
64 attribute11 OKL_PROVISIONS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
65 attribute12 OKL_PROVISIONS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
66 attribute13 OKL_PROVISIONS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
67 attribute14 OKL_PROVISIONS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
68 attribute15 OKL_PROVISIONS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
69 version OKL_PROVISIONS_V.VERSION%TYPE := Okc_Api.G_MISS_CHAR,
70 from_date OKL_PROVISIONS_V.FROM_DATE%TYPE := Okc_Api.G_MISS_DATE,
71 TO_DATE OKL_PROVISIONS_V.TO_DATE%TYPE := Okc_Api.G_MISS_DATE,
72 created_by NUMBER := Okc_Api.G_MISS_NUM,
73 creation_date OKL_PROVISIONS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
74 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
75 last_update_date OKL_PROVISIONS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
76 last_update_login NUMBER := Okc_Api.G_MISS_NUM);
77 g_miss_pvnv_rec pvnv_rec_type;
78 TYPE pvnv_tbl_type IS TABLE OF pvnv_rec_type
79 INDEX BY BINARY_INTEGER;
80 ---------------------------------------------------------------------------
81 -- GLOBAL MESSAGE CONSTANTS
82 ---------------------------------------------------------------------------
83 G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
84 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
85 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
86 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
87 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
88 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
89 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
90 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
91 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
92 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
93 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
94 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
95 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
96 G_UNQS CONSTANT VARCHAR2(200) := 'OKL_PVN_ELEMENT_NOT_UNIQUE';
97 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL__PVN_NO_PARENT_RECORD';
98
99 ---------------------------------------------------------------------------
100 -- GLOBAL EXCEPTION
101 ---------------------------------------------------------------------------
102 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
103 ---------------------------------------------------------------------------
104
105 ---------------------------------------------------------------------------
106 -- GLOBAL VARIABLES
107 ---------------------------------------------------------------------------
108 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PVN_PVT';
109 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
110 ---------------------------------------------------------------------------
111 -- Procedures and Functions
112 ---------------------------------------------------------------------------
113
114 Procedure qc;
115 Procedure change_version;
116 Procedure api_copy;
117 Procedure insert_row(
118 p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 p_pvnv_rec IN pvnv_rec_type,
124 x_pvnv_rec OUT NOCOPY pvnv_rec_type);
125
126 Procedure insert_row(
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_pvnv_tbl IN pvnv_tbl_type,
133 x_pvnv_tbl OUT NOCOPY pvnv_tbl_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_pvnv_rec IN pvnv_rec_type);
142
143 Procedure lock_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_pvnv_tbl IN pvnv_tbl_type);
150
151 Procedure update_row(
152 p_api_version IN NUMBER,
153 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2,
157 p_pvnv_rec IN pvnv_rec_type,
158 x_pvnv_rec OUT NOCOPY pvnv_rec_type);
159
160 Procedure update_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_pvnv_tbl IN pvnv_tbl_type,
167 x_pvnv_tbl OUT NOCOPY pvnv_tbl_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_pvnv_rec IN pvnv_rec_type);
176
177 Procedure delete_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_pvnv_tbl IN pvnv_tbl_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_pvnv_rec IN pvnv_rec_type);
192
193 Procedure validate_row(
194 p_api_version IN NUMBER,
195 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199 p_pvnv_tbl IN pvnv_tbl_type);
200
201 END Okl_Pvn_Pvt;