[Home] [Help]
PACKAGE: APPS.OKS_BSD_PRINT_PREVIEW_PVT
Source
1 Package OKS_BSD_PRINT_PREVIEW_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSBSDPS.pls 120.1 2006/09/19 18:57:57 hvaladip noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE bsd_pr_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM
8 ,bsl_id NUMBER := OKC_API.G_MISS_NUM
9 ,bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM
10 ,bsd_id NUMBER := OKC_API.G_MISS_NUM
11 ,bsd_id_applied NUMBER := OKC_API.G_MISS_NUM
12 ,unit_of_measure OKS_BSD_PR.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR
13 ,amcv_yn OKS_BSD_PR.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR
14 ,result NUMBER := OKC_API.G_MISS_NUM
15 ,amount NUMBER := OKC_API.G_MISS_NUM
16 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
17 ,created_by NUMBER := OKC_API.G_MISS_NUM
18 ,creation_date OKS_BSD_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20 ,last_update_date OKS_BSD_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21 ,fixed NUMBER := OKC_API.G_MISS_NUM
22 ,actual NUMBER := OKC_API.G_MISS_NUM
23 ,default_default NUMBER := OKC_API.G_MISS_NUM
24 ,adjustment_level NUMBER := OKC_API.G_MISS_NUM
25 ,adjustment_minimum NUMBER := OKC_API.G_MISS_NUM
26 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
27 ,attribute_category OKS_BSD_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
28 ,attribute1 OKS_BSD_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
29 ,attribute2 OKS_BSD_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
30 ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
31 ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
32 ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
33 ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
34 ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
35 ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
36 ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
37 ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
38 ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
39 ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
40 ,attribute13 OKS_BSD_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
41 ,attribute14 OKS_BSD_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
42 ,attribute15 OKS_BSD_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
43 ,security_group_id NUMBER := OKC_API.G_MISS_NUM
44 ,start_reading NUMBER := OKC_API.G_MISS_NUM
45 ,end_reading NUMBER := OKC_API.G_MISS_NUM
46 ,base_reading NUMBER := OKC_API.G_MISS_NUM
47 ,estimated_quantity NUMBER := OKC_API.G_MISS_NUM
48 ,ccr_id NUMBER := OKC_API.G_MISS_NUM
49 ,cgr_id NUMBER := OKC_API.G_MISS_NUM);
50 G_MISS_bsd_pr_rec bsd_pr_rec_type;
51 TYPE bsd_pr_tbl_type IS TABLE OF bsd_pr_rec_type
52 INDEX BY BINARY_INTEGER;
53
54 TYPE ERROR_REC_TYPE IS RECORD (
55 msg_data VARCHAR2(2000),
56 msg_count NUMBER,
57 error_type VARCHAR2(1),
58 api_name VARCHAR2(200),
59 api_package VARCHAR2(60),
60 idx NUMBER,
61 sqlcode NUMBER
62 );
63 TYPE ERROR_TBL_TYPE IS TABLE OF ERROR_REC_TYPE
64 INDEX BY BINARY_INTEGER;
65 ---------------------------------------------------------------------------
66 -- GLOBAL MESSAGE CONSTANTS
67 ---------------------------------------------------------------------------
68 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
69 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
70 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
71 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
72 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
73 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
74 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
75 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
76 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
77 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
78 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
79 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
80 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
81
82 ---------------------------------------------------------------------------
83 -- GLOBAL EXCEPTIONS
84 ---------------------------------------------------------------------------
85 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
86
87 ---------------------------------------------------------------------------
88 -- GLOBAL VARIABLES
89 ---------------------------------------------------------------------------
90 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_BSD_PRINT_PREVIEW_PVT';
91 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
92 ---------------------------------------------------------------------------
93 -- Procedures and Functions
94 ---------------------------------------------------------------------------
95
96 PROCEDURE qc;
97 PROCEDURE change_version;
98 PROCEDURE api_copy;
99 PROCEDURE insert_row(
100 p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 p_bsd_pr_rec IN bsd_pr_rec_type,
106 x_bsd_pr_rec OUT NOCOPY bsd_pr_rec_type);
107
108 PROCEDURE lock_row(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_bsd_pr_rec IN bsd_pr_rec_type);
115 PROCEDURE lock_row(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_bsd_pr_tbl IN bsd_pr_tbl_type,
122 px_error_tbl IN OUT NOCOPY ERROR_TBL_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_bsd_pr_tbl IN bsd_pr_tbl_type);
130 PROCEDURE update_row(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 p_bsd_pr_rec IN bsd_pr_rec_type,
137 x_bsd_pr_rec OUT NOCOPY bsd_pr_rec_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_bsd_pr_tbl IN bsd_pr_tbl_type,
145 x_bsd_pr_tbl OUT NOCOPY bsd_pr_tbl_type,
146 px_error_tbl IN OUT NOCOPY ERROR_TBL_TYPE);
147 PROCEDURE update_row(
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 p_bsd_pr_tbl IN bsd_pr_tbl_type,
154 x_bsd_pr_tbl OUT NOCOPY bsd_pr_tbl_type);
155 PROCEDURE delete_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_bsd_pr_rec IN bsd_pr_rec_type);
162 PROCEDURE delete_row(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_bsd_pr_tbl IN bsd_pr_tbl_type,
169 px_error_tbl IN OUT NOCOPY ERROR_TBL_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_bsd_pr_tbl IN bsd_pr_tbl_type);
177 PROCEDURE validate_row(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_bsd_pr_rec IN bsd_pr_rec_type);
184 PROCEDURE validate_row(
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 p_bsd_pr_tbl IN bsd_pr_tbl_type,
191 px_error_tbl IN OUT NOCOPY ERROR_TBL_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_bsd_pr_tbl IN bsd_pr_tbl_type);
199 END OKS_BSD_PRINT_PREVIEW_PVT;