[Home] [Help]
PACKAGE: APPS.OKC_RRD_PVT
Source
1 Package OKC_RRD_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCSRRDS.pls 120.0 2005/05/25 22:33:14 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE rrd_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 srd_id NUMBER := OKC_API.G_MISS_NUM,
9 sre_id NUMBER := OKC_API.G_MISS_NUM,
10 object_version_number NUMBER := OKC_API.G_MISS_NUM,
11 created_by NUMBER := OKC_API.G_MISS_NUM,
12 creation_date OKC_RG_ROLE_DEFS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14 last_update_date OKC_RG_ROLE_DEFS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15 subject_object_flag OKC_RG_ROLE_DEFS.SUBJECT_OBJECT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
16 optional_yn OKC_RG_ROLE_DEFS.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
17 last_update_login NUMBER := OKC_API.G_MISS_NUM,
18 attribute_category OKC_RG_ROLE_DEFS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
19 attribute1 OKC_RG_ROLE_DEFS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
20 attribute2 OKC_RG_ROLE_DEFS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21 attribute3 OKC_RG_ROLE_DEFS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
22 attribute4 OKC_RG_ROLE_DEFS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23 attribute5 OKC_RG_ROLE_DEFS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24 attribute6 OKC_RG_ROLE_DEFS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25 attribute7 OKC_RG_ROLE_DEFS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26 attribute8 OKC_RG_ROLE_DEFS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27 attribute9 OKC_RG_ROLE_DEFS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28 attribute10 OKC_RG_ROLE_DEFS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29 attribute11 OKC_RG_ROLE_DEFS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30 attribute12 OKC_RG_ROLE_DEFS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31 attribute13 OKC_RG_ROLE_DEFS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
32 attribute14 OKC_RG_ROLE_DEFS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
33 attribute15 OKC_RG_ROLE_DEFS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
34 access_level OKC_RG_ROLE_DEFS.access_level%TYPE := OKC_API.G_MISS_CHAR);
35 g_miss_rrd_rec rrd_rec_type;
36 TYPE rrd_tbl_type IS TABLE OF rrd_rec_type
37 INDEX BY BINARY_INTEGER;
38 TYPE rrdv_rec_type IS RECORD (
39 id NUMBER := OKC_API.G_MISS_NUM,
40 object_version_number NUMBER := OKC_API.G_MISS_NUM,
41 srd_id NUMBER := OKC_API.G_MISS_NUM,
42 sre_id NUMBER := OKC_API.G_MISS_NUM,
43 optional_yn OKC_RG_ROLE_DEFS_V.OPTIONAL_YN%TYPE := OKC_API.G_MISS_CHAR,
44 subject_object_flag OKC_RG_ROLE_DEFS_V.SUBJECT_OBJECT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
45 attribute_category OKC_RG_ROLE_DEFS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
46 attribute1 OKC_RG_ROLE_DEFS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
47 attribute2 OKC_RG_ROLE_DEFS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
48 attribute3 OKC_RG_ROLE_DEFS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
49 attribute4 OKC_RG_ROLE_DEFS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
50 attribute5 OKC_RG_ROLE_DEFS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
51 attribute6 OKC_RG_ROLE_DEFS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
52 attribute7 OKC_RG_ROLE_DEFS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
53 attribute8 OKC_RG_ROLE_DEFS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
54 attribute9 OKC_RG_ROLE_DEFS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
55 attribute10 OKC_RG_ROLE_DEFS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
56 attribute11 OKC_RG_ROLE_DEFS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
57 attribute12 OKC_RG_ROLE_DEFS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
58 attribute13 OKC_RG_ROLE_DEFS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
59 attribute14 OKC_RG_ROLE_DEFS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
60 attribute15 OKC_RG_ROLE_DEFS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
61 created_by NUMBER := OKC_API.G_MISS_NUM,
62 creation_date OKC_RG_ROLE_DEFS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
63 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
64 last_update_date OKC_RG_ROLE_DEFS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
65 last_update_login NUMBER := OKC_API.G_MISS_NUM,
66 access_level OKC_RG_ROLE_DEFS.access_level%TYPE := OKC_API.G_MISS_CHAR);
67 g_miss_rrdv_rec rrdv_rec_type;
68 TYPE rrdv_tbl_type IS TABLE OF rrdv_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_RRD_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_rrdv_rec IN rrdv_rec_type,
112 x_rrdv_rec OUT NOCOPY rrdv_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_rrdv_tbl IN rrdv_tbl_type,
121 x_rrdv_tbl OUT NOCOPY rrdv_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_rrdv_rec IN rrdv_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_rrdv_tbl IN rrdv_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_rrdv_rec IN rrdv_rec_type,
146 x_rrdv_rec OUT NOCOPY rrdv_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_rrdv_tbl IN rrdv_tbl_type,
155 x_rrdv_tbl OUT NOCOPY rrdv_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_rrdv_rec IN rrdv_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_rrdv_tbl IN rrdv_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_rrdv_rec IN rrdv_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_rrdv_tbl IN rrdv_tbl_type);
188
189 END OKC_RRD_PVT;