[Home] [Help]
PACKAGE: APPS.OKS_BCL_PRINT_PREVIEW_PVT
Source
1 Package OKS_BCL_PRINT_PREVIEW_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSBCLPS.pls 120.0 2005/05/25 18:02:00 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE bcl_pr_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM
8 ,cle_id NUMBER := OKC_API.G_MISS_NUM
9 ,btn_id NUMBER := OKC_API.G_MISS_NUM
10 ,date_billed_from OKS_BCL_PR.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE
11 ,date_billed_to OKS_BCL_PR.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE
12 ,sent_yn OKS_BCL_PR.SENT_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 OKS_BCL_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
16 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
17 ,last_update_date OKS_BCL_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18 ,amount NUMBER := OKC_API.G_MISS_NUM
19 ,bill_action OKS_BCL_PR.BILL_ACTION%TYPE := OKC_API.G_MISS_CHAR
20 ,date_next_invoice OKS_BCL_PR.DATE_NEXT_INVOICE%TYPE := OKC_API.G_MISS_DATE
21 ,currency_code OKS_BCL_PR.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
22 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23 ,attribute_category OKS_BCL_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
24 ,attribute1 OKS_BCL_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
25 ,attribute2 OKS_BCL_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
26 ,attribute3 OKS_BCL_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
27 ,attribute4 OKS_BCL_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
28 ,attribute5 OKS_BCL_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
29 ,attribute6 OKS_BCL_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
30 ,attribute7 OKS_BCL_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
31 ,attribute8 OKS_BCL_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
32 ,attribute9 OKS_BCL_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
33 ,attribute10 OKS_BCL_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
34 ,attribute11 OKS_BCL_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
35 ,attribute12 OKS_BCL_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
36 ,attribute13 OKS_BCL_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
37 ,attribute14 OKS_BCL_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
38 ,attribute15 OKS_BCL_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
39 ,security_group_id NUMBER := OKC_API.G_MISS_NUM);
40 G_MISS_bcl_pr_rec bcl_pr_rec_type;
41 TYPE bcl_pr_tbl_type IS TABLE OF bcl_pr_rec_type
42 INDEX BY BINARY_INTEGER;
43
44 TYPE ERROR_REC_TYPE IS RECORD (
45 msg_data VARCHAR2(2000),
46 msg_count NUMBER,
47 error_type VARCHAR2(1),
48 api_name VARCHAR2(200),
49 api_package VARCHAR2(60),
50 idx NUMBER,
51 sqlcode NUMBER
52 );
53 TYPE ERROR_TBL_TYPE IS TABLE OF ERROR_REC_TYPE
54 INDEX BY BINARY_INTEGER;
55
56 ---------------------------------------------------------------------------
57 -- GLOBAL MESSAGE CONSTANTS
58 ---------------------------------------------------------------------------
59 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
60 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
61 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
62 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
63 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
64 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
65 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
66 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
67 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
68 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
69 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
70 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
71 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
72
73 ---------------------------------------------------------------------------
74 -- GLOBAL EXCEPTIONS
75 ---------------------------------------------------------------------------
76 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
77
78 ---------------------------------------------------------------------------
79 -- GLOBAL VARIABLES
80 ---------------------------------------------------------------------------
81 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_BCL_PRINT_PREVIEW_PVT';
82 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
83 ---------------------------------------------------------------------------
84 -- Procedures and Functions
85 ---------------------------------------------------------------------------
86
87 PROCEDURE qc;
88 PROCEDURE change_version;
89 PROCEDURE api_copy;
90 PROCEDURE insert_row(
91 p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2,
96 p_bcl_pr_rec IN bcl_pr_rec_type,
97 x_bcl_pr_rec OUT NOCOPY bcl_pr_rec_type);
98 /* PROCEDURE insert_row(
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_bcl_pr_tbl IN bcl_pr_tbl_type,
105 x_bcl_pr_tbl OUT NOCOPY bcl_pr_tbl_type,
106 px_error_tbl IN OUT NOCOPY ERROR_TBL_TYPE);
107 PROCEDURE insert_row(
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 p_bcl_pr_tbl IN bcl_pr_tbl_type,
114 x_bcl_pr_tbl OUT NOCOPY bcl_pr_tbl_type);
115 */
116 PROCEDURE lock_row(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_bcl_pr_rec IN bcl_pr_rec_type);
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_bcl_pr_tbl IN bcl_pr_tbl_type,
130 px_error_tbl IN OUT NOCOPY ERROR_TBL_TYPE);
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_bcl_pr_tbl IN bcl_pr_tbl_type);
138 PROCEDURE update_row(
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 p_bcl_pr_rec IN bcl_pr_rec_type,
145 x_bcl_pr_rec OUT NOCOPY bcl_pr_rec_type);
146 PROCEDURE update_row(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_bcl_pr_tbl IN bcl_pr_tbl_type,
153 x_bcl_pr_tbl OUT NOCOPY bcl_pr_tbl_type,
154 px_error_tbl IN OUT NOCOPY ERROR_TBL_TYPE);
155 PROCEDURE update_row(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_bcl_pr_tbl IN bcl_pr_tbl_type,
162 x_bcl_pr_tbl OUT NOCOPY bcl_pr_tbl_type);
163 PROCEDURE delete_row(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_bcl_pr_rec IN bcl_pr_rec_type);
170 PROCEDURE delete_row(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_bcl_pr_tbl IN bcl_pr_tbl_type,
177 px_error_tbl IN OUT NOCOPY ERROR_TBL_TYPE);
178 PROCEDURE delete_row(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_bcl_pr_tbl IN bcl_pr_tbl_type);
185 PROCEDURE validate_row(
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2,
191 p_bcl_pr_rec IN bcl_pr_rec_type);
192 PROCEDURE validate_row(
193 p_api_version IN NUMBER,
194 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 p_bcl_pr_tbl IN bcl_pr_tbl_type,
199 px_error_tbl IN OUT NOCOPY ERROR_TBL_TYPE);
200 PROCEDURE validate_row(
201 p_api_version IN NUMBER,
202 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
203 x_return_status OUT NOCOPY VARCHAR2,
204 x_msg_count OUT NOCOPY NUMBER,
205 x_msg_data OUT NOCOPY VARCHAR2,
206 p_bcl_pr_tbl IN bcl_pr_tbl_type);
207 END OKS_BCL_PRINT_PREVIEW_PVT;