[Home] [Help]
PACKAGE: APPS.OKL_AUL_PVT
Source
1 PACKAGE OKL_AUL_PVT AS
2 /* $Header: OKLSAULS.pls 120.2 2007/02/27 07:06:38 dpsingh ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE aul_rec_type IS RECORD (
7 id NUMBER := okl_API.G_MISS_NUM,
8 SEGMENT OKL_ACC_GEN_RUL_LNS.SEGMENT%TYPE := okl_API.G_MISS_CHAR,
9 agr_id NUMBER := okl_API.G_MISS_NUM,
10 source OKL_ACC_GEN_RUL_LNS.SOURCE%TYPE := okl_API.G_MISS_CHAR,
11 segment_number NUMBER := okl_API.G_MISS_NUM,
12 object_version_number NUMBER := okl_API.G_MISS_NUM,
13 constants OKL_ACC_GEN_RUL_LNS.CONSTANTS%TYPE := okl_API.G_MISS_CHAR,
14 attribute_category OKL_ACC_GEN_RUL_LNS.ATTRIBUTE_CATEGORY%TYPE := okl_API.G_MISS_CHAR,
15 attribute1 OKL_ACC_GEN_RUL_LNS.ATTRIBUTE1%TYPE := okl_API.G_MISS_CHAR,
16 attribute2 OKL_ACC_GEN_RUL_LNS.ATTRIBUTE2%TYPE := okl_API.G_MISS_CHAR,
17 attribute3 OKL_ACC_GEN_RUL_LNS.ATTRIBUTE3%TYPE := okl_API.G_MISS_CHAR,
18 attribute4 OKL_ACC_GEN_RUL_LNS.ATTRIBUTE4%TYPE := okl_API.G_MISS_CHAR,
19 attribute5 OKL_ACC_GEN_RUL_LNS.ATTRIBUTE5%TYPE := okl_API.G_MISS_CHAR,
20 attribute6 OKL_ACC_GEN_RUL_LNS.ATTRIBUTE6%TYPE := okl_API.G_MISS_CHAR,
21 attribute7 OKL_ACC_GEN_RUL_LNS.ATTRIBUTE7%TYPE := okl_API.G_MISS_CHAR,
22 attribute8 OKL_ACC_GEN_RUL_LNS.ATTRIBUTE8%TYPE := okl_API.G_MISS_CHAR,
23 attribute9 OKL_ACC_GEN_RUL_LNS.ATTRIBUTE9%TYPE := okl_API.G_MISS_CHAR,
24 attribute10 OKL_ACC_GEN_RUL_LNS.ATTRIBUTE10%TYPE := okl_API.G_MISS_CHAR,
25 attribute11 OKL_ACC_GEN_RUL_LNS.ATTRIBUTE11%TYPE := okl_API.G_MISS_CHAR,
26 attribute12 OKL_ACC_GEN_RUL_LNS.ATTRIBUTE12%TYPE := okl_API.G_MISS_CHAR,
27 attribute13 OKL_ACC_GEN_RUL_LNS.ATTRIBUTE13%TYPE := okl_API.G_MISS_CHAR,
28 attribute14 OKL_ACC_GEN_RUL_LNS.ATTRIBUTE14%TYPE := okl_API.G_MISS_CHAR,
29 attribute15 OKL_ACC_GEN_RUL_LNS.ATTRIBUTE15%TYPE := okl_API.G_MISS_CHAR,
30 created_by NUMBER := okl_API.G_MISS_NUM,
31 creation_date OKL_ACC_GEN_RUL_LNS.CREATION_DATE%TYPE := okl_API.G_MISS_DATE,
32 last_updated_by NUMBER := okl_API.G_MISS_NUM,
33 last_update_date OKL_ACC_GEN_RUL_LNS.LAST_UPDATE_DATE%TYPE := okl_API.G_MISS_DATE,
34 last_update_login NUMBER := okl_API.G_MISS_NUM);
35 g_miss_aul_rec aul_rec_type;
36 TYPE aul_tbl_type IS TABLE OF aul_rec_type
37 INDEX BY BINARY_INTEGER;
38 TYPE aulv_rec_type IS RECORD (
39 id NUMBER := okl_API.G_MISS_NUM,
40 object_version_number NUMBER := okl_API.G_MISS_NUM,
41 source OKL_ACC_GEN_RUL_LNS_V.SOURCE%TYPE := okl_API.G_MISS_CHAR,
42 SEGMENT OKL_ACC_GEN_RUL_LNS_V.SEGMENT%TYPE := okl_API.G_MISS_CHAR,
43 segment_number NUMBER := okl_API.G_MISS_NUM,
44 constants OKL_ACC_GEN_RUL_LNS_V.constants%TYPE := okl_API.G_MISS_CHAR,
45 attribute_category OKL_ACC_GEN_RUL_LNS_V.ATTRIBUTE_CATEGORY%TYPE := okl_API.G_MISS_CHAR,
46 attribute1 OKL_ACC_GEN_RUL_LNS_V.ATTRIBUTE1%TYPE := okl_API.G_MISS_CHAR,
47 attribute2 OKL_ACC_GEN_RUL_LNS_V.ATTRIBUTE2%TYPE := okl_API.G_MISS_CHAR,
48 attribute3 OKL_ACC_GEN_RUL_LNS_V.ATTRIBUTE3%TYPE := okl_API.G_MISS_CHAR,
49 attribute4 OKL_ACC_GEN_RUL_LNS_V.ATTRIBUTE4%TYPE := okl_API.G_MISS_CHAR,
50 attribute5 OKL_ACC_GEN_RUL_LNS_V.ATTRIBUTE5%TYPE := okl_API.G_MISS_CHAR,
51 attribute6 OKL_ACC_GEN_RUL_LNS_V.ATTRIBUTE6%TYPE := okl_API.G_MISS_CHAR,
52 attribute7 OKL_ACC_GEN_RUL_LNS_V.ATTRIBUTE7%TYPE := okl_API.G_MISS_CHAR,
53 attribute8 OKL_ACC_GEN_RUL_LNS_V.ATTRIBUTE8%TYPE := okl_API.G_MISS_CHAR,
54 attribute9 OKL_ACC_GEN_RUL_LNS_V.ATTRIBUTE9%TYPE := okl_API.G_MISS_CHAR,
55 attribute10 OKL_ACC_GEN_RUL_LNS_V.ATTRIBUTE10%TYPE := okl_API.G_MISS_CHAR,
56 attribute11 OKL_ACC_GEN_RUL_LNS_V.ATTRIBUTE11%TYPE := okl_API.G_MISS_CHAR,
57 attribute12 OKL_ACC_GEN_RUL_LNS_V.ATTRIBUTE12%TYPE := okl_API.G_MISS_CHAR,
58 attribute13 OKL_ACC_GEN_RUL_LNS_V.ATTRIBUTE13%TYPE := okl_API.G_MISS_CHAR,
59 attribute14 OKL_ACC_GEN_RUL_LNS_V.ATTRIBUTE14%TYPE := okl_API.G_MISS_CHAR,
60 attribute15 OKL_ACC_GEN_RUL_LNS_V.ATTRIBUTE15%TYPE := okl_API.G_MISS_CHAR,
61 agr_id NUMBER := okl_API.G_MISS_NUM,
62 created_by NUMBER := okl_API.G_MISS_NUM,
63 creation_date OKL_ACC_GEN_RUL_LNS_V.CREATION_DATE%TYPE := okl_API.G_MISS_DATE,
64 last_updated_by NUMBER := okl_API.G_MISS_NUM,
65 last_update_date OKL_ACC_GEN_RUL_LNS_V.LAST_UPDATE_DATE%TYPE := okl_API.G_MISS_DATE,
66 last_update_login NUMBER := okl_API.G_MISS_NUM);
67 g_miss_aulv_rec aulv_rec_type;
68 TYPE aulv_tbl_type IS TABLE OF aulv_rec_type
69 INDEX BY BINARY_INTEGER;
70 ---------------------------------------------------------------------------
71 -- GLOBAL MESSAGE CONSTANTS
72 ---------------------------------------------------------------------------
73 G_FND_APP CONSTANT VARCHAR2(200) := okl_API.G_FND_APP;
74 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_API.G_FORM_UNABLE_TO_RESERVE_REC;
75 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_API.G_FORM_RECORD_DELETED;
76 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_API.G_FORM_RECORD_CHANGED;
77 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_API.G_RECORD_LOGICALLY_DELETED;
78 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_API.G_REQUIRED_VALUE;
79 G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_API.G_INVALID_VALUE;
80 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_API.G_COL_NAME_TOKEN;
81 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_API.G_PARENT_TABLE_TOKEN;
82 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_API.G_CHILD_TABLE_TOKEN;
83 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
84 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
85 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
86
87 ---------------------------------------------------------------------------
88 -- GLOBAL VARIABLES
89 ---------------------------------------------------------------------------
90 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AUL_PVT';
91 G_APP_NAME CONSTANT VARCHAR2(3) := okl_API.G_APP_NAME;
92
93 ---------------------------------------------------------------------------
94 -- GLOBAL EXCEPTION
95 ---------------------------------------------------------------------------
96
97 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
98
99 ---------------------------------------------------------------------------
100 -- Procedures and Functions
101 ---------------------------------------------------------------------------
102
103 PROCEDURE qc;
104 PROCEDURE change_version;
105 PROCEDURE api_copy;
106 PROCEDURE insert_row(
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 DEFAULT okl_API.G_FALSE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_aulv_rec IN aulv_rec_type,
113 x_aulv_rec OUT NOCOPY aulv_rec_type);
114
115 PROCEDURE insert_row(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 DEFAULT okl_API.G_FALSE,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_aulv_tbl IN aulv_tbl_type,
122 x_aulv_tbl OUT NOCOPY aulv_tbl_type);
123
124 PROCEDURE lock_row(
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2 DEFAULT okl_API.G_FALSE,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 p_aulv_rec IN aulv_rec_type);
131
132 PROCEDURE lock_row(
133 p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2 DEFAULT okl_API.G_FALSE,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 p_aulv_tbl IN aulv_tbl_type);
139
140 PROCEDURE update_row(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_aulv_rec IN aulv_rec_type,
147 x_aulv_rec OUT NOCOPY aulv_rec_type);
148
149 PROCEDURE update_row(
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 DEFAULT okl_API.G_FALSE,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155 p_aulv_tbl IN aulv_tbl_type,
156 x_aulv_tbl OUT NOCOPY aulv_tbl_type);
157
158 PROCEDURE delete_row(
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 DEFAULT okl_API.G_FALSE,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_aulv_rec IN aulv_rec_type);
165
166 PROCEDURE delete_row(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 DEFAULT okl_API.G_FALSE,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 p_aulv_tbl IN aulv_tbl_type);
173
174 PROCEDURE validate_row(
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_aulv_rec IN aulv_rec_type);
181
182 PROCEDURE validate_row(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_aulv_tbl IN aulv_tbl_type);
189
190 END OKL_AUL_PVT;