[Home] [Help]
PACKAGE: APPS.OKL_DRV_PVT
Source
1 PACKAGE OKL_DRV_PVT AS
2 /* $Header: OKLSDRVS.pls 120.0 2007/03/13 21:17:36 pjgomes noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_DISB_RULE_VENDOR_SITES Record Spec
7 TYPE drv_rec_type IS RECORD (
8 disb_rule_vendor_site_id NUMBER
9 ,object_version_number NUMBER
10 ,disb_rule_id NUMBER
11 ,vendor_id NUMBER
12 ,vendor_site_id NUMBER
13 ,start_date OKL_DISB_RULE_VENDOR_SITES.START_DATE%TYPE
14 ,end_date OKL_DISB_RULE_VENDOR_SITES.END_DATE%TYPE
15 ,invoice_seq_start NUMBER
16 ,invoice_seq_end NUMBER
17 ,next_inv_seq NUMBER
18 ,attribute_category OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE_CATEGORY%TYPE
19 ,attribute1 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE1%TYPE
20 ,attribute2 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE2%TYPE
21 ,attribute3 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE3%TYPE
22 ,attribute4 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE4%TYPE
23 ,attribute5 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE5%TYPE
24 ,attribute6 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE6%TYPE
25 ,attribute7 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE7%TYPE
26 ,attribute8 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE8%TYPE
27 ,attribute9 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE9%TYPE
28 ,attribute10 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE10%TYPE
29 ,attribute11 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE11%TYPE
30 ,attribute12 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE12%TYPE
31 ,attribute13 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE13%TYPE
32 ,attribute14 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE14%TYPE
33 ,attribute15 OKL_DISB_RULE_VENDOR_SITES.ATTRIBUTE15%TYPE
34 ,created_by NUMBER
35 ,creation_date OKL_DISB_RULE_VENDOR_SITES.CREATION_DATE%TYPE
36 ,last_updated_by NUMBER
37 ,last_update_date OKL_DISB_RULE_VENDOR_SITES.LAST_UPDATE_DATE%TYPE
38 ,last_update_login NUMBER);
39 G_MISS_drv_rec drv_rec_type;
40 TYPE drv_tbl_type IS TABLE OF drv_rec_type
41 INDEX BY BINARY_INTEGER;
42 ---------------------------------------------------------------------------
43 -- GLOBAL MESSAGE CONSTANTS
44 ---------------------------------------------------------------------------
45 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
46 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
47 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
48 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
49 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
50 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
51 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
52 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
53 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
54 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
55 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
56 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
57 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
58
59 ---------------------------------------------------------------------------
60 -- GLOBAL EXCEPTIONS
61 ---------------------------------------------------------------------------
62 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
63
64 ---------------------------------------------------------------------------
65 -- GLOBAL VARIABLES
66 ---------------------------------------------------------------------------
67 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_DRV_PVT';
68 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
69 ---------------------------------------------------------------------------
70 -- Procedures and Functions
71 ---------------------------------------------------------------------------
72
73 PROCEDURE qc;
74 PROCEDURE change_version;
75 PROCEDURE api_copy;
76 PROCEDURE insert_row(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_drv_rec IN drv_rec_type,
83 x_drv_rec OUT NOCOPY drv_rec_type);
84 PROCEDURE insert_row(
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_drv_tbl IN drv_tbl_type,
91 x_drv_tbl OUT NOCOPY drv_tbl_type,
92 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
93 PROCEDURE insert_row(
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_drv_tbl IN drv_tbl_type,
100 x_drv_tbl OUT NOCOPY drv_tbl_type);
101 PROCEDURE lock_row(
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 p_drv_rec IN drv_rec_type);
108 PROCEDURE lock_row(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_drv_tbl IN drv_tbl_type,
115 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
116 PROCEDURE lock_row(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_drv_tbl IN drv_tbl_type);
123 PROCEDURE update_row(
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_drv_rec IN drv_rec_type,
130 x_drv_rec OUT NOCOPY drv_rec_type);
131 PROCEDURE update_row(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_drv_tbl IN drv_tbl_type,
138 x_drv_tbl OUT NOCOPY drv_tbl_type,
139 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
140 PROCEDURE update_row(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_drv_tbl IN drv_tbl_type,
147 x_drv_tbl OUT NOCOPY drv_tbl_type);
148 PROCEDURE delete_row(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_drv_rec IN drv_rec_type);
155 PROCEDURE delete_row(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_drv_tbl IN drv_tbl_type,
162 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
163 PROCEDURE delete_row(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_drv_tbl IN drv_tbl_type);
170 PROCEDURE validate_row(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_drv_rec IN drv_rec_type);
177 PROCEDURE validate_row(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_drv_tbl IN drv_tbl_type,
184 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
185 PROCEDURE validate_row(
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_drv_tbl IN drv_tbl_type);
192 END OKL_DRV_PVT;