[Home] [Help]
PACKAGE: APPS.OKL_TRY_PVT
Source
1 PACKAGE OKL_TRY_PVT AS
2 /* $Header: OKLSTRYS.pls 120.4 2006/12/26 07:22:23 dpsingh noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE try_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 try_id NUMBER := OKC_API.G_MISS_NUM,
9 try_id_for NUMBER := OKC_API.G_MISS_NUM,
10 ilc_id NUMBER := OKC_API.G_MISS_NUM,
11 aep_code OKL_TRX_TYPES_B.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
12 try_type OKL_TRX_TYPES_B.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13 object_version_number NUMBER := OKC_API.G_MISS_NUM,
14 org_id NUMBER := OKC_API.G_MISS_NUM,
15 created_by NUMBER := OKC_API.G_MISS_NUM,
16 creation_date OKL_TRX_TYPES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18 last_update_date OKL_TRX_TYPES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19 last_update_login NUMBER := OKC_API.G_MISS_NUM,
20 trx_type_class OKL_TRX_TYPES_B.TRX_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
21 --Added by kthiruva on 04-May-2005 for Tax Enhancements
22 --Bug 4386433 - Start of Changes
23 tax_upfront_yn OKL_TRX_TYPES_B.TAX_UPFRONT_YN%TYPE := OKC_API.G_MISS_CHAR,
24 tax_invoice_yn OKL_TRX_TYPES_B.TAX_INVOICE_YN%TYPE := OKC_API.G_MISS_CHAR,
25 tax_schedule_yn OKL_TRX_TYPES_B.TAX_SCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR,
26 --Bug 4386433 -End of Changes
27 --Bug 5707866 dpsingh
28 formula_yn OKL_TRX_TYPES_B.FORMULA_YN%TYPE := OKL_API.G_MISS_CHAR,
29 accounting_event_class_code OKL_TRX_TYPES_B.ACCOUNTING_EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
30 );
31 g_miss_try_rec try_rec_type;
32 TYPE try_tbl_type IS TABLE OF try_rec_type
33 INDEX BY BINARY_INTEGER;
34 TYPE okl_trx_types_tl_rec_type IS RECORD (
35 id NUMBER := OKC_API.G_MISS_NUM,
36 LANGUAGE OKL_TRX_TYPES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
37 source_lang OKL_TRX_TYPES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
38 sfwt_flag OKL_TRX_TYPES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39 name OKL_TRX_TYPES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
40 description OKL_TRX_TYPES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41 contract_header_line_flag OKL_TRX_TYPES_TL.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
42 transaction_header_line_detail OKL_TRX_TYPES_TL.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
43 created_by NUMBER := OKC_API.G_MISS_NUM,
44 creation_date OKL_TRX_TYPES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46 last_update_date OKL_TRX_TYPES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47 last_update_login NUMBER := OKC_API.G_MISS_NUM);
48 g_miss_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
49 TYPE okl_trx_types_tl_tbl_type IS TABLE OF okl_trx_types_tl_rec_type
50 INDEX BY BINARY_INTEGER;
51 TYPE tryv_rec_type IS RECORD (
52 id NUMBER := OKC_API.G_MISS_NUM,
53 object_version_number NUMBER := OKC_API.G_MISS_NUM,
54 sfwt_flag OKL_TRX_TYPES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55 aep_code OKL_TRX_TYPES_V.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
56 ilc_id NUMBER := OKC_API.G_MISS_NUM,
57 try_id NUMBER := OKC_API.G_MISS_NUM,
58 try_id_for NUMBER := OKC_API.G_MISS_NUM,
59 try_type OKL_TRX_TYPES_V.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
60 name OKL_TRX_TYPES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
61 description OKL_TRX_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
62 contract_header_line_flag OKL_TRX_TYPES_V.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
63 transaction_header_line_detail OKL_TRX_TYPES_V.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
64 org_id NUMBER := OKC_API.G_MISS_NUM,
65 created_by NUMBER := OKC_API.G_MISS_NUM,
66 creation_date OKL_TRX_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
67 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
68 last_update_date OKL_TRX_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
69 last_update_login NUMBER := OKC_API.G_MISS_NUM,
70 trx_type_class OKL_TRX_TYPES_V.TRX_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
71 --Added by kthiruva on 04-May-2005 for Tax Enhancements
72 --Bug 4386433 - Start of Changes
73 tax_upfront_yn OKL_TRX_TYPES_V.TAX_UPFRONT_YN%TYPE := OKC_API.G_MISS_CHAR,
74 tax_invoice_yn OKL_TRX_TYPES_V.TAX_INVOICE_YN%TYPE := OKC_API.G_MISS_CHAR,
75 tax_schedule_yn OKL_TRX_TYPES_V.TAX_SCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR,
76 --Bug 4386433 - End of Changes
77 --Bug 5707866 dpsingh
78 formula_yn OKL_TRX_TYPES_B.FORMULA_YN%TYPE := OKL_API.G_MISS_CHAR,
79 accounting_event_class_code OKL_TRX_TYPES_B.ACCOUNTING_EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
80 );
81 g_miss_tryv_rec tryv_rec_type;
82 TYPE tryv_tbl_type IS TABLE OF tryv_rec_type
83 INDEX BY BINARY_INTEGER;
84 ---------------------------------------------------------------------------
85 -- GLOBAL MESSAGE CONSTANTS
86 ---------------------------------------------------------------------------
87 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
88 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
89 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
90 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
94 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
95 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
96 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
97 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
98 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_UPPER_CASE_REQUIRED';
99 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
100 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
101 G_UNQS CONSTANT VARCHAR2(200) := 'OKL_TRY_ELEMENT_NOT_UNIQUE';
102 ---------------------------------------------------------------------------
103 -- GLOBAL EXCEPTION
104 ---------------------------------------------------------------------------
105 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
106 ---------------------------------------------------------------------------
107 -- GLOBAL VARIABLES
108 ---------------------------------------------------------------------------
109 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TRY_PVT';
110 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
111 ---------------------------------------------------------------------------
112 -- Procedures and Functions
113 ---------------------------------------------------------------------------
114
115 PROCEDURE qc;
116 PROCEDURE change_version;
117 PROCEDURE api_copy;
118 PROCEDURE add_language;
119 PROCEDURE insert_row(
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 p_tryv_rec IN tryv_rec_type,
126 x_tryv_rec OUT NOCOPY tryv_rec_type);
127
128 PROCEDURE insert_row(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_tryv_tbl IN tryv_tbl_type,
135 x_tryv_tbl OUT NOCOPY tryv_tbl_type);
136
137 PROCEDURE lock_row(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_tryv_rec IN tryv_rec_type);
144
145 PROCEDURE lock_row(
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_tryv_tbl IN tryv_tbl_type);
152
153 PROCEDURE update_row(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_tryv_rec IN tryv_rec_type,
160 x_tryv_rec OUT NOCOPY tryv_rec_type);
161
162 PROCEDURE update_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_tryv_tbl IN tryv_tbl_type,
169 x_tryv_tbl OUT NOCOPY tryv_tbl_type);
170
171 PROCEDURE delete_row(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_tryv_rec IN tryv_rec_type);
178
179 PROCEDURE delete_row(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_tryv_tbl IN tryv_tbl_type);
186
187 PROCEDURE validate_row(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_tryv_rec IN tryv_rec_type);
194
195 PROCEDURE validate_row(
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_tryv_tbl IN tryv_tbl_type);
202
203 PROCEDURE LOAD_SEED_ROW(
204 p_upload_mode IN VARCHAR2,
205 p_id IN VARCHAR2,
206 p_trx_type_class IN VARCHAR2,
207 p_try_id IN VARCHAR2,
208 p_try_id_for IN VARCHAR2,
209 p_ilc_id IN VARCHAR2,
210 p_aep_code IN VARCHAR2,
211 p_try_type IN VARCHAR2,
212 p_object_version_number IN VARCHAR2,
213 p_org_id IN VARCHAR2,
214 p_name IN VARCHAR2,
215 p_description IN VARCHAR2,
216 p_owner IN VARCHAR2,
217 p_last_update_date IN VARCHAR2,
218 p_tax_upfront_yn IN VARCHAR2,
219 p_tax_invoice_yn IN VARCHAR2,
220 p_tax_schedule_yn IN VARCHAR2,
221 --Added by dpsingh for Bug 5707866
222 p_formula_yn IN VARCHAR2,
223 p_accounting_event_class_code IN VARCHAR2);
224
225 END OKL_TRY_PVT;