[Home] [Help]
PACKAGE: APPS.OKL_ILS_PVT
Source
1 PACKAGE Okl_Ils_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSILSS.pls 115.4 2002/03/04 20:17:58 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE ils_rec_type IS RECORD (
7 id NUMBER := Okl_Api.G_MISS_NUM,
8 sty_id NUMBER := Okl_Api.G_MISS_NUM,
9 inf_id NUMBER := Okl_Api.G_MISS_NUM,
10 ilt_id NUMBER := Okl_Api.G_MISS_NUM,
11 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
12 attribute_category OKL_INVC_FRMT_STRMS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
13 attribute1 OKL_INVC_FRMT_STRMS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
14 attribute2 OKL_INVC_FRMT_STRMS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
15 attribute3 OKL_INVC_FRMT_STRMS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
16 attribute4 OKL_INVC_FRMT_STRMS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
17 attribute5 OKL_INVC_FRMT_STRMS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
18 attribute6 OKL_INVC_FRMT_STRMS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
19 attribute7 OKL_INVC_FRMT_STRMS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
20 attribute8 OKL_INVC_FRMT_STRMS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
21 attribute9 OKL_INVC_FRMT_STRMS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
22 attribute10 OKL_INVC_FRMT_STRMS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
23 attribute11 OKL_INVC_FRMT_STRMS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
24 attribute12 OKL_INVC_FRMT_STRMS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
25 attribute13 OKL_INVC_FRMT_STRMS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
26 attribute14 OKL_INVC_FRMT_STRMS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
27 attribute15 OKL_INVC_FRMT_STRMS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
28 created_by NUMBER := Okl_Api.G_MISS_NUM,
29 creation_date OKL_INVC_FRMT_STRMS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
30 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
31 last_update_date OKL_INVC_FRMT_STRMS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
32 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
33 g_miss_ils_rec ils_rec_type;
34 TYPE ils_tbl_type IS TABLE OF ils_rec_type
35 INDEX BY BINARY_INTEGER;
36 TYPE ilsv_rec_type IS RECORD (
37 id NUMBER := Okl_Api.G_MISS_NUM,
38 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
39 sty_id NUMBER := Okl_Api.G_MISS_NUM,
40 inf_id NUMBER := Okl_Api.G_MISS_NUM,
41 ilt_id NUMBER := Okl_Api.G_MISS_NUM,
42 attribute_category OKL_INVC_FRMT_STRMS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
43 attribute1 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
44 attribute2 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
45 attribute3 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
46 attribute4 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
47 attribute5 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
48 attribute6 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
49 attribute7 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
50 attribute8 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
51 attribute9 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
52 attribute10 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
53 attribute11 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
54 attribute12 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
55 attribute13 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
56 attribute14 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
57 attribute15 OKL_INVC_FRMT_STRMS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
58 created_by NUMBER := Okl_Api.G_MISS_NUM,
59 creation_date OKL_INVC_FRMT_STRMS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
60 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
61 last_update_date OKL_INVC_FRMT_STRMS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
62 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
63 g_miss_ilsv_rec ilsv_rec_type;
64 TYPE ilsv_tbl_type IS TABLE OF ilsv_rec_type
65 INDEX BY BINARY_INTEGER;
66 ---------------------------------------------------------------------------
67 -- GLOBAL MESSAGE CONSTANTS
68 ---------------------------------------------------------------------------
69 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
70 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
71 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
72 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
73 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
74 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
75 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
76 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
77 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
78 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
79
80 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
81 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
82 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
83 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
84 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
85 ---------------------------------------------------------------------------
86 -- GLOBAL VARIABLES
87 ---------------------------------------------------------------------------
88 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ILS_PVT';
89 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
90
91 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_XTD_SELL_INVS_V';
92 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
93
94
95 ---------------------------------------------------------------------------
96 -- Procedures and Functions
97 ---------------------------------------------------------------------------
98
99 PROCEDURE qc;
100 PROCEDURE change_version;
101 PROCEDURE api_copy;
102 PROCEDURE insert_row(
103 p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 p_ilsv_rec IN ilsv_rec_type,
109 x_ilsv_rec OUT NOCOPY ilsv_rec_type);
110
111 PROCEDURE insert_row(
112 p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2,
117 p_ilsv_tbl IN ilsv_tbl_type,
118 x_ilsv_tbl OUT NOCOPY ilsv_tbl_type);
119
120 PROCEDURE lock_row(
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_ilsv_rec IN ilsv_rec_type);
127
128 PROCEDURE lock_row(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_ilsv_tbl IN ilsv_tbl_type);
135
136 PROCEDURE update_row(
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_ilsv_rec IN ilsv_rec_type,
143 x_ilsv_rec OUT NOCOPY ilsv_rec_type);
144
145 PROCEDURE update_row(
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 p_ilsv_tbl IN ilsv_tbl_type,
152 x_ilsv_tbl OUT NOCOPY ilsv_tbl_type);
153
154 PROCEDURE delete_row(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_ilsv_rec IN ilsv_rec_type);
161
162 PROCEDURE delete_row(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_ilsv_tbl IN ilsv_tbl_type);
169
170 PROCEDURE validate_row(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_ilsv_rec IN ilsv_rec_type);
177
178 PROCEDURE validate_row(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 p_ilsv_tbl IN ilsv_tbl_type);
185
186 END Okl_Ils_Pvt;