DBA Data[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;