[Home] [Help]
PACKAGE: APPS.OKL_CIN_PVT
Source
1 PACKAGE OKL_CIN_PVT AS
2 /* $Header: OKLSCINS.pls 120.0 2007/03/13 21:19:10 pjgomes noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_CNSLD_AP_INVS Record Spec
7 TYPE cin_rec_type IS RECORD (
8 cnsld_ap_inv_id NUMBER
9 ,trx_status_code OKL_CNSLD_AP_INVS.TRX_STATUS_CODE%TYPE
10 ,vendor_invoice_number OKL_CNSLD_AP_INVS.VENDOR_INVOICE_NUMBER%TYPE
11 ,currency_code OKL_CNSLD_AP_INVS.CURRENCY_CODE%TYPE
12 ,currency_conversion_type OKL_CNSLD_AP_INVS.CURRENCY_CONVERSION_TYPE%TYPE
13 ,currency_conversion_rate NUMBER
14 ,currency_conversion_date OKL_CNSLD_AP_INVS.CURRENCY_CONVERSION_DATE%TYPE
15 ,payment_method_code OKL_CNSLD_AP_INVS.PAYMENT_METHOD_CODE%TYPE
16 ,pay_group_lookup_code OKL_CNSLD_AP_INVS.PAY_GROUP_LOOKUP_CODE%TYPE
17 ,invoice_type OKL_CNSLD_AP_INVS.INVOICE_TYPE%TYPE
18 ,set_of_books_id NUMBER
19 ,try_id NUMBER
20 ,ipvs_id NUMBER
21 ,ippt_id NUMBER
22 ,date_invoiced OKL_CNSLD_AP_INVS.DATE_INVOICED%TYPE
23 ,amount NUMBER
24 ,invoice_number OKL_CNSLD_AP_INVS.INVOICE_NUMBER%TYPE
25 ,date_gl OKL_CNSLD_AP_INVS.DATE_GL%TYPE
26 ,vendor_id NUMBER
27 ,org_id NUMBER
28 ,legal_entity_id NUMBER
29 ,vpa_id NUMBER
30 ,accts_pay_cc_id NUMBER
31 ,fee_charged_yn OKL_CNSLD_AP_INVS.FEE_CHARGED_YN%TYPE
32 ,self_bill_yn OKL_CNSLD_AP_INVS.SELF_BILL_YN%TYPE
33 ,self_bill_inv_num OKL_CNSLD_AP_INVS.SELF_BILL_INV_NUM%TYPE
34 ,match_required_yn OKL_CNSLD_AP_INVS.MATCH_REQUIRED_YN%TYPE
35 ,object_version_number NUMBER
36 ,request_id NUMBER
37 ,program_application_id NUMBER
38 ,program_id NUMBER
39 ,program_update_date OKL_CNSLD_AP_INVS.PROGRAM_UPDATE_DATE%TYPE
40 ,attribute_category OKL_CNSLD_AP_INVS.ATTRIBUTE_CATEGORY%TYPE
41 ,attribute1 OKL_CNSLD_AP_INVS.ATTRIBUTE1%TYPE
42 ,attribute2 OKL_CNSLD_AP_INVS.ATTRIBUTE2%TYPE
43 ,attribute3 OKL_CNSLD_AP_INVS.ATTRIBUTE3%TYPE
44 ,attribute4 OKL_CNSLD_AP_INVS.ATTRIBUTE4%TYPE
45 ,attribute5 OKL_CNSLD_AP_INVS.ATTRIBUTE5%TYPE
46 ,attribute6 OKL_CNSLD_AP_INVS.ATTRIBUTE6%TYPE
47 ,attribute7 OKL_CNSLD_AP_INVS.ATTRIBUTE7%TYPE
48 ,attribute8 OKL_CNSLD_AP_INVS.ATTRIBUTE8%TYPE
49 ,attribute9 OKL_CNSLD_AP_INVS.ATTRIBUTE9%TYPE
50 ,attribute10 OKL_CNSLD_AP_INVS.ATTRIBUTE10%TYPE
51 ,attribute11 OKL_CNSLD_AP_INVS.ATTRIBUTE11%TYPE
52 ,attribute12 OKL_CNSLD_AP_INVS.ATTRIBUTE12%TYPE
53 ,attribute13 OKL_CNSLD_AP_INVS.ATTRIBUTE13%TYPE
54 ,attribute14 OKL_CNSLD_AP_INVS.ATTRIBUTE14%TYPE
55 ,attribute15 OKL_CNSLD_AP_INVS.ATTRIBUTE15%TYPE
56 ,created_by NUMBER
57 ,creation_date OKL_CNSLD_AP_INVS.CREATION_DATE%TYPE
58 ,last_updated_by NUMBER
59 ,last_update_date OKL_CNSLD_AP_INVS.LAST_UPDATE_DATE%TYPE
60 ,last_update_login NUMBER);
61 G_MISS_cin_rec cin_rec_type;
62 TYPE cin_tbl_type IS TABLE OF cin_rec_type
63 INDEX BY BINARY_INTEGER;
64 ---------------------------------------------------------------------------
65 -- GLOBAL MESSAGE CONSTANTS
66 ---------------------------------------------------------------------------
67 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
68 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
69 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
70 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
71 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
72 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
73 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
74 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
75 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
76 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
77 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
78 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
79 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
80
81 ---------------------------------------------------------------------------
82 -- GLOBAL EXCEPTIONS
83 ---------------------------------------------------------------------------
84 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
85
86 ---------------------------------------------------------------------------
87 -- GLOBAL VARIABLES
88 ---------------------------------------------------------------------------
89 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CIN_PVT';
90 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
91 ---------------------------------------------------------------------------
92 -- Procedures and Functions
93 ---------------------------------------------------------------------------
94
95 PROCEDURE qc;
96 PROCEDURE change_version;
97 PROCEDURE api_copy;
98 PROCEDURE insert_row(
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_cin_rec IN cin_rec_type,
105 x_cin_rec OUT NOCOPY cin_rec_type);
106 PROCEDURE insert_row(
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_cin_tbl IN cin_tbl_type,
113 x_cin_tbl OUT NOCOPY cin_tbl_type,
114 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
115 PROCEDURE insert_row(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_cin_tbl IN cin_tbl_type,
122 x_cin_tbl OUT NOCOPY cin_tbl_type);
123 PROCEDURE lock_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_cin_rec IN cin_rec_type);
130 PROCEDURE lock_row(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_cin_tbl IN cin_tbl_type,
137 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
138 PROCEDURE lock_row(
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_cin_tbl IN cin_tbl_type);
145 PROCEDURE update_row(
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 p_cin_rec IN cin_rec_type,
152 x_cin_rec OUT NOCOPY cin_rec_type);
153 PROCEDURE update_row(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_cin_tbl IN cin_tbl_type,
160 x_cin_tbl OUT NOCOPY cin_tbl_type,
161 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
162 PROCEDURE update_row(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_cin_tbl IN cin_tbl_type,
169 x_cin_tbl OUT NOCOPY cin_tbl_type);
170 PROCEDURE delete_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_cin_rec IN cin_rec_type);
177 PROCEDURE delete_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_cin_tbl IN cin_tbl_type,
184 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
185 PROCEDURE delete_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_cin_tbl IN cin_tbl_type);
192 PROCEDURE validate_row(
193 p_api_version IN NUMBER,
194 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_cin_rec IN cin_rec_type);
199 PROCEDURE validate_row(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_cin_tbl IN cin_tbl_type,
206 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
207 PROCEDURE validate_row(
208 p_api_version IN NUMBER,
209 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
210 x_return_status OUT NOCOPY VARCHAR2,
211 x_msg_count OUT NOCOPY NUMBER,
212 x_msg_data OUT NOCOPY VARCHAR2,
213 p_cin_tbl IN cin_tbl_type);
214 END OKL_CIN_PVT;