[Home] [Help]
PACKAGE: APPS.OKC_AST_PVT
Source
1 Package OKC_AST_PVT AS
2 /* $Header: OKCSASTS.pls 120.0 2005/05/25 23:08:34 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE ast_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 sts_code OKC_ASSENTS.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
9 opn_code OKC_ASSENTS.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR,
10 ste_code OKC_ASSENTS.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
11 scs_code OKC_ASSENTS.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
12 allowed_yn OKC_ASSENTS.ALLOWED_YN%TYPE := OKC_API.G_MISS_CHAR,
13 object_version_number NUMBER := OKC_API.G_MISS_NUM,
14 created_by NUMBER := OKC_API.G_MISS_NUM,
15 creation_date OKC_ASSENTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17 last_update_date OKC_ASSENTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18 last_update_login NUMBER := OKC_API.G_MISS_NUM,
19 attribute_category OKC_ASSENTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
20 attribute1 OKC_ASSENTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
21 attribute2 OKC_ASSENTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
22 attribute3 OKC_ASSENTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
23 attribute4 OKC_ASSENTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
24 attribute5 OKC_ASSENTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
25 attribute6 OKC_ASSENTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
26 attribute7 OKC_ASSENTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
27 attribute8 OKC_ASSENTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
28 attribute9 OKC_ASSENTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
29 attribute10 OKC_ASSENTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
30 attribute11 OKC_ASSENTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
31 attribute12 OKC_ASSENTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
32 attribute13 OKC_ASSENTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
33 attribute14 OKC_ASSENTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
34 attribute15 OKC_ASSENTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
35 g_miss_ast_rec ast_rec_type;
36 TYPE ast_tbl_type IS TABLE OF ast_rec_type
37 INDEX BY BINARY_INTEGER;
38 TYPE astv_rec_type IS RECORD (
39 id NUMBER := OKC_API.G_MISS_NUM,
40 sts_code OKC_ASSENTS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
41 opn_code OKC_ASSENTS_V.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR,
42 ste_code OKC_ASSENTS_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
43 scs_code OKC_ASSENTS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
44 object_version_number NUMBER := OKC_API.G_MISS_NUM,
45 allowed_yn OKC_ASSENTS_V.ALLOWED_YN%TYPE := OKC_API.G_MISS_CHAR,
46 attribute_category OKC_ASSENTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
47 attribute1 OKC_ASSENTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
48 attribute2 OKC_ASSENTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
49 attribute3 OKC_ASSENTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
50 attribute4 OKC_ASSENTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
51 attribute5 OKC_ASSENTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
52 attribute6 OKC_ASSENTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
53 attribute7 OKC_ASSENTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
54 attribute8 OKC_ASSENTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
55 attribute9 OKC_ASSENTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56 attribute10 OKC_ASSENTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
57 attribute11 OKC_ASSENTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
58 attribute12 OKC_ASSENTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
59 attribute13 OKC_ASSENTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
60 attribute14 OKC_ASSENTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
61 attribute15 OKC_ASSENTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
62 created_by NUMBER := OKC_API.G_MISS_NUM,
63 creation_date OKC_ASSENTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
64 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
65 last_update_date OKC_ASSENTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
66 last_update_login NUMBER := OKC_API.G_MISS_NUM);
67 g_miss_astv_rec astv_rec_type;
68 TYPE astv_tbl_type IS TABLE OF astv_rec_type
69 INDEX BY BINARY_INTEGER;
70 ---------------------------------------------------------------------------
71 -- GLOBAL MESSAGE CONSTANTS
72 ---------------------------------------------------------------------------
73 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
74 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
75 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
76 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
77 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
78 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
79 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
80 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
81 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
82 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
83 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
84 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
85 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
86 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
87
88 ------------------------------------------------------------------------------------
89 -- GLOBAL EXCEPTION
90 ---------------------------------------------------------------------------
91 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
92
93 ---------------------------------------------------------------------------
94 -- GLOBAL VARIABLES
95 ---------------------------------------------------------------------------
96 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_AST_PVT';
97 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
98 ---------------------------------------------------------------------------
99 -- Procedures and Functions
100 ---------------------------------------------------------------------------
101
102 PROCEDURE qc;
103 PROCEDURE change_version;
104 PROCEDURE api_copy;
105 PROCEDURE insert_row(
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 p_astv_rec IN astv_rec_type,
112 x_astv_rec OUT NOCOPY astv_rec_type);
113
114 PROCEDURE insert_row(
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_astv_tbl IN astv_tbl_type,
121 x_astv_tbl OUT NOCOPY astv_tbl_type);
122
123 PROCEDURE lock_row(
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_astv_rec IN astv_rec_type);
130
131 PROCEDURE lock_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_astv_tbl IN astv_tbl_type);
138
139 PROCEDURE update_row(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_astv_rec IN astv_rec_type,
146 x_astv_rec OUT NOCOPY astv_rec_type);
147
148 PROCEDURE update_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_astv_tbl IN astv_tbl_type,
155 x_astv_tbl OUT NOCOPY astv_tbl_type);
156
157 PROCEDURE delete_row(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_astv_rec IN astv_rec_type);
164
165 PROCEDURE delete_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_astv_tbl IN astv_tbl_type);
172
173 PROCEDURE validate_row(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_astv_rec IN astv_rec_type);
180
181 PROCEDURE validate_row(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_astv_tbl IN astv_tbl_type);
188
189 FUNCTION header_operation_allowed(
190 p_header_id IN NUMBER,
191 p_opn_code IN VARCHAR2,
192 p_crt_id IN NUMBER DEFAULT NULL) return varchar2;
193
194 FUNCTION line_operation_allowed(
195 p_line_id IN NUMBER,
196 p_opn_code IN VARCHAR2) return varchar2;
197
198 END OKC_AST_PVT;