[Home] [Help]
PACKAGE: APPS.OKL_XLR_PVT
Source
1 Package OKL_XLR_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSXLRS.pls 115.2 2002/03/14 17:30:33 pkm ship $ */
3
4 /*
5 ---------------------------------------------------------------------------
6 -- GLOBAL DATASTRUCTURES
7 ---------------------------------------------------------------------------
8 TYPE xlr_rec_type IS RECORD (
9 id NUMBER := OKC_API.G_MISS_NUM,
10 irn_id NUMBER := OKC_API.G_MISS_NUM,
11 imr_id NUMBER := OKC_API.G_MISS_NUM,
12 xhr_id_details NUMBER := OKC_API.G_MISS_NUM,
13 object_version_number NUMBER := OKC_API.G_MISS_NUM,
14 created_by NUMBER := OKC_API.G_MISS_NUM,
15 creation_date OKL_XTL_FUND_RQNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17 last_update_date OKL_XTL_FUND_RQNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18 quantity NUMBER := OKC_API.G_MISS_NUM,
19 org_id NUMBER := OKC_API.G_MISS_NUM,
20 request_id NUMBER := OKC_API.G_MISS_NUM,
21 program_application_id NUMBER := OKC_API.G_MISS_NUM,
22 program_id NUMBER := OKC_API.G_MISS_NUM,
23 program_update_date OKL_XTL_FUND_RQNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
24 attribute_category OKL_XTL_FUND_RQNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
25 attribute1 OKL_XTL_FUND_RQNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
26 attribute2 OKL_XTL_FUND_RQNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
27 attribute3 OKL_XTL_FUND_RQNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
28 attribute4 OKL_XTL_FUND_RQNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
29 attribute5 OKL_XTL_FUND_RQNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
30 attribute6 OKL_XTL_FUND_RQNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
31 attribute7 OKL_XTL_FUND_RQNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
32 attribute8 OKL_XTL_FUND_RQNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
33 attribute9 OKL_XTL_FUND_RQNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34 attribute10 OKL_XTL_FUND_RQNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
35 attribute11 OKL_XTL_FUND_RQNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
36 attribute12 OKL_XTL_FUND_RQNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
37 attribute13 OKL_XTL_FUND_RQNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
38 attribute14 OKL_XTL_FUND_RQNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
39 attribute15 OKL_XTL_FUND_RQNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
40 last_update_login NUMBER := OKC_API.G_MISS_NUM);
41 g_miss_xlr_rec xlr_rec_type;
42 TYPE xlr_tbl_type IS TABLE OF xlr_rec_type
43 INDEX BY BINARY_INTEGER;
44 TYPE xlrv_rec_type IS RECORD (
45 id NUMBER := OKC_API.G_MISS_NUM,
46 object_version_number NUMBER := OKC_API.G_MISS_NUM,
47 irn_id NUMBER := OKC_API.G_MISS_NUM,
48 imr_id NUMBER := OKC_API.G_MISS_NUM,
49 xhr_id_details NUMBER := OKC_API.G_MISS_NUM,
50 quantity NUMBER := OKC_API.G_MISS_NUM,
51 attribute_category OKL_XTL_FUND_RQNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
52 attribute1 OKL_XTL_FUND_RQNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
53 attribute2 OKL_XTL_FUND_RQNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
54 attribute3 OKL_XTL_FUND_RQNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
55 attribute4 OKL_XTL_FUND_RQNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
56 attribute5 OKL_XTL_FUND_RQNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
57 attribute6 OKL_XTL_FUND_RQNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
58 attribute7 OKL_XTL_FUND_RQNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
59 attribute8 OKL_XTL_FUND_RQNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
60 attribute9 OKL_XTL_FUND_RQNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
61 attribute10 OKL_XTL_FUND_RQNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
62 attribute11 OKL_XTL_FUND_RQNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
63 attribute12 OKL_XTL_FUND_RQNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
64 attribute13 OKL_XTL_FUND_RQNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
65 attribute14 OKL_XTL_FUND_RQNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
66 attribute15 OKL_XTL_FUND_RQNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
67 org_id NUMBER := OKC_API.G_MISS_NUM,
68 request_id NUMBER := OKC_API.G_MISS_NUM,
69 program_application_id NUMBER := OKC_API.G_MISS_NUM,
70 program_id NUMBER := OKC_API.G_MISS_NUM,
71 program_update_date OKL_XTL_FUND_RQNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
72 created_by NUMBER := OKC_API.G_MISS_NUM,
73 creation_date OKL_XTL_FUND_RQNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75 last_update_date OKL_XTL_FUND_RQNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
76 last_update_login NUMBER := OKC_API.G_MISS_NUM);
77 g_miss_xlrv_rec xlrv_rec_type;
78 TYPE xlrv_tbl_type IS TABLE OF xlrv_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 ---------------------------------------------------------------------------
94 -- GLOBAL VARIABLES
95 ---------------------------------------------------------------------------
96 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_XLR_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_xlrv_rec IN xlrv_rec_type,
112 x_xlrv_rec OUT NOCOPY xlrv_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_xlrv_tbl IN xlrv_tbl_type,
121 x_xlrv_tbl OUT NOCOPY xlrv_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_xlrv_rec IN xlrv_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_xlrv_tbl IN xlrv_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_xlrv_rec IN xlrv_rec_type,
146 x_xlrv_rec OUT NOCOPY xlrv_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_xlrv_tbl IN xlrv_tbl_type,
155 x_xlrv_tbl OUT NOCOPY xlrv_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_xlrv_rec IN xlrv_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_xlrv_tbl IN xlrv_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_xlrv_rec IN xlrv_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_xlrv_tbl IN xlrv_tbl_type);
188 */
189 END OKL_XLR_PVT;