DBA Data[Home] [Help]

PACKAGE: APPS.OKL_BTC_PVT

Source


1 PACKAGE Okl_Btc_Pvt AS
2 /*$Header: OKLSBTCS.pls 120.5 2007/09/06 12:30:48 sosharma noship $*/
3   ---------------------------------------------------------------------------
4   -- GLOBAL DATASTRUCTURES
5   ---------------------------------------------------------------------------
6   TYPE btc_rec_type IS RECORD (
7     id                             NUMBER := Okl_Api.G_MISS_NUM,
8     object_version_number          NUMBER := Okl_Api.G_MISS_NUM,
9     date_entered                   OKL_TRX_CSH_BATCH_B.DATE_ENTERED%TYPE := Okl_Api.G_MISS_DATE,
10     date_gl_requested              OKL_TRX_CSH_BATCH_B.DATE_GL_REQUESTED%TYPE := Okl_Api.G_MISS_DATE,
11     date_deposit                   OKL_TRX_CSH_BATCH_B.DATE_DEPOSIT%TYPE := Okl_Api.G_MISS_DATE,
12     batch_qty                      NUMBER := Okl_Api.G_MISS_NUM,
13     batch_total                    NUMBER := Okl_Api.G_MISS_NUM,
14     batch_currency                 OKL_TRX_CSH_BATCH_B.BATCH_CURRENCY%TYPE := Okl_Api.G_MISS_CHAR,
15     irm_id                         OKL_TRX_CSH_BATCH_B.IRM_ID%TYPE := Okl_Api.G_MISS_NUM,
16     request_id                     NUMBER := Okl_Api.G_MISS_NUM,
17     program_application_id         NUMBER := Okl_Api.G_MISS_NUM,
18     program_id                     NUMBER := Okl_Api.G_MISS_NUM,
19     program_update_date            OKL_TRX_CSH_BATCH_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
20    org_id                         NUMBER := Okl_Api.G_MISS_NUM,
21     attribute_category             OKL_TRX_CSH_BATCH_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
22     attribute1                     OKL_TRX_CSH_BATCH_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
23     attribute2                     OKL_TRX_CSH_BATCH_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
24     attribute3                     OKL_TRX_CSH_BATCH_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
25     attribute4                     OKL_TRX_CSH_BATCH_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
26     attribute5                     OKL_TRX_CSH_BATCH_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
27     attribute6                     OKL_TRX_CSH_BATCH_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
28     attribute7                     OKL_TRX_CSH_BATCH_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
29     attribute8                     OKL_TRX_CSH_BATCH_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
30     attribute9                     OKL_TRX_CSH_BATCH_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
31     attribute10                    OKL_TRX_CSH_BATCH_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
32     attribute11                    OKL_TRX_CSH_BATCH_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
33     attribute12                    OKL_TRX_CSH_BATCH_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
34     attribute13                    OKL_TRX_CSH_BATCH_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
35     attribute14                    OKL_TRX_CSH_BATCH_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
36     attribute15                    OKL_TRX_CSH_BATCH_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
37     created_by                     NUMBER := Okl_Api.G_MISS_NUM,
38     creation_date                  OKL_TRX_CSH_BATCH_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
39     last_updated_by                NUMBER := Okl_Api.G_MISS_NUM,
40     last_update_date               OKL_TRX_CSH_BATCH_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
41     last_update_login              NUMBER := Okl_Api.G_MISS_NUM,
42     trx_status_code				   OKL_TRX_CSH_BATCH_B.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
43     currency_conversion_type       OKL_TRX_CSH_BATCH_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
44     currency_conversion_rate       OKL_TRX_CSH_BATCH_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
45     currency_conversion_date       OKL_TRX_CSH_BATCH_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
46     remit_bank_id                  OKL_TRX_CSH_BATCH_B.REMIT_BANK_ID%TYPE := Okl_Api.G_MISS_NUM
47 
48  );
49   g_miss_btc_rec                          btc_rec_type;
50   TYPE btc_tbl_type IS TABLE OF btc_rec_type
51         INDEX BY BINARY_INTEGER;
52   TYPE okl_trx_csh_batch_tl_rec_type IS RECORD (
53     id                             NUMBER := Okl_Api.G_MISS_NUM,
54     LANGUAGE                       OKL_TRX_CSH_BATCH_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
55     source_lang                    OKL_TRX_CSH_BATCH_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
56     sfwt_flag                      OKL_TRX_CSH_BATCH_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
57     name                           OKL_TRX_CSH_BATCH_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
58     description                    OKL_TRX_CSH_BATCH_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
59     created_by                     NUMBER := Okl_Api.G_MISS_NUM,
60     creation_date                  OKL_TRX_CSH_BATCH_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
61     last_updated_by                NUMBER := Okl_Api.G_MISS_NUM,
62     last_update_date               OKL_TRX_CSH_BATCH_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
63     last_update_login              NUMBER := Okl_Api.G_MISS_NUM);
64   GMissOklTrxCshBatchTlRec                okl_trx_csh_batch_tl_rec_type;
65   TYPE okl_trx_csh_batch_tl_tbl_type IS TABLE OF okl_trx_csh_batch_tl_rec_type
66         INDEX BY BINARY_INTEGER;
67   TYPE btcv_rec_type IS RECORD (
68     id                             NUMBER := Okl_Api.G_MISS_NUM,
69     object_version_number          NUMBER := Okl_Api.G_MISS_NUM,
70     sfwt_flag                      OKL_TRX_CSH_BATCH_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
71     name                           OKL_TRX_CSH_BATCH_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
72     date_entered                   OKL_TRX_CSH_BATCH_V.DATE_ENTERED%TYPE := Okl_Api.G_MISS_DATE,
73     date_gl_requested              OKL_TRX_CSH_BATCH_V.DATE_GL_REQUESTED%TYPE := Okl_Api.G_MISS_DATE,
74     date_deposit                   OKL_TRX_CSH_BATCH_V.DATE_DEPOSIT%TYPE := Okl_Api.G_MISS_DATE,
75     batch_qty                      NUMBER := Okl_Api.G_MISS_NUM,
76     batch_total                    NUMBER := Okl_Api.G_MISS_NUM,
77     batch_currency                 OKL_TRX_CSH_BATCH_B.BATCH_CURRENCY%TYPE := Okl_Api.G_MISS_CHAR,
78     irm_id                         OKL_TRX_CSH_BATCH_B.IRM_ID%TYPE := Okl_Api.G_MISS_NUM,
79     description                    OKL_TRX_CSH_BATCH_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
80     attribute_category             OKL_TRX_CSH_BATCH_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
81     attribute1                     OKL_TRX_CSH_BATCH_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
82     attribute2                     OKL_TRX_CSH_BATCH_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
83     attribute3                     OKL_TRX_CSH_BATCH_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
84     attribute4                     OKL_TRX_CSH_BATCH_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
85     attribute5                     OKL_TRX_CSH_BATCH_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
86     attribute6                     OKL_TRX_CSH_BATCH_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
87     attribute7                     OKL_TRX_CSH_BATCH_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
88     attribute8                     OKL_TRX_CSH_BATCH_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
89     attribute9                     OKL_TRX_CSH_BATCH_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
90     attribute10                    OKL_TRX_CSH_BATCH_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
91     attribute11                    OKL_TRX_CSH_BATCH_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
92     attribute12                    OKL_TRX_CSH_BATCH_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
93     attribute13                    OKL_TRX_CSH_BATCH_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
94     attribute14                    OKL_TRX_CSH_BATCH_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
95     attribute15                    OKL_TRX_CSH_BATCH_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
96     request_id                     NUMBER := Okl_Api.G_MISS_NUM,
97     program_application_id         NUMBER := Okl_Api.G_MISS_NUM,
98     program_id                     NUMBER := Okl_Api.G_MISS_NUM,
99     program_update_date            OKL_TRX_CSH_BATCH_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
100     org_id                         NUMBER := Okl_Api.G_MISS_NUM,
101     created_by                     NUMBER := Okl_Api.G_MISS_NUM,
102     creation_date                  OKL_TRX_CSH_BATCH_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
103     last_updated_by                NUMBER := Okl_Api.G_MISS_NUM,
104     last_update_date               OKL_TRX_CSH_BATCH_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
105     last_update_login              NUMBER := Okl_Api.G_MISS_NUM,
106 	trx_status_code				   OKL_TRX_CSH_BATCH_V.TRX_STATUS_CODE%TYPE := Okl_Api.G_MISS_CHAR,
107     currency_conversion_type       OKL_TRX_CSH_BATCH_B.currency_conversion_type%TYPE := Okl_Api.G_MISS_CHAR,
108     currency_conversion_rate       OKL_TRX_CSH_BATCH_B.currency_conversion_rate%TYPE := Okl_Api.G_MISS_NUM,
109     currency_conversion_date       OKL_TRX_CSH_BATCH_B.currency_conversion_date%TYPE := Okl_Api.G_MISS_DATE,
110         remit_bank_id                  OKL_TRX_CSH_BATCH_B.REMIT_BANK_ID%TYPE := Okl_Api.G_MISS_NUM
111 	);
112 
113     g_miss_btcv_rec                         btcv_rec_type;
114   TYPE btcv_tbl_type IS TABLE OF btcv_rec_type
115         INDEX BY BINARY_INTEGER;
116   ---------------------------------------------------------------------------
117   -- GLOBAL MESSAGE CONSTANTS
118   ---------------------------------------------------------------------------
119   G_FND_APP			CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
120   G_FORM_UNABLE_TO_RESERVE_REC	CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
121   G_FORM_RECORD_DELETED		CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
122   G_FORM_RECORD_CHANGED		CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
123   G_RECORD_LOGICALLY_DELETED	CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
124   G_REQUIRED_VALUE		CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
125   G_INVALID_VALUE			CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
126   G_COL_NAME_TOKEN		CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
127   G_PARENT_TABLE_TOKEN		CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
128   G_CHILD_TABLE_TOKEN		CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
129   G_NOT_SAME         CONSTANT   VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
130   ---------------------------------------------------------------------------
131   -- GLOBAL VARIABLES
132   ---------------------------------------------------------------------------
133   G_PKG_NAME			CONSTANT VARCHAR2(200) := 'OKL_BTC_PVT';
134   G_APP_NAME			CONSTANT VARCHAR2(3)   :=  Okl_Api.G_APP_NAME;
135   ---------------------------------------------------------------------------
136   -- ADDED AFTER TAPI 04/17/2001
137   ---------------------------------------------------------------------------
138   ---------------------------------------------------------------------------
139   -- GLOBAL MESSAGES
140   ---------------------------------------------------------------------------
141   G_NO_PARENT_RECORD           CONSTANT   VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
142   G_UNEXPECTED_ERROR           CONSTANT   VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
143   G_SQLCODE_TOKEN              CONSTANT   VARCHAR2(200) := 'ERROR_CODE';
144   G_SQLERRM_TOKEN              CONSTANT   VARCHAR2(200) := 'ERROR_MESSAGE';
145 
146   ---------------------------------------------------------------------------
147   -- GLOBAL VARIABLES
148   ---------------------------------------------------------------------------
149   G_VIEW			CONSTANT   VARCHAR2(30) := 'OKL_TRX_AR_INVOICES_V';
150   G_EXCEPTION_HALT_VALIDATION           EXCEPTION;
151 
152   ---------------------------------------------------------------------------
153   -- POST GEN TAPI CODE ENDS HERE 04/17/2001
154   ---------------------------------------------------------------------------
155   ---------------------------------------------------------------------------
156   -- Procedures and Functions
157   ---------------------------------------------------------------------------
158 
159   PROCEDURE qc;
160   PROCEDURE change_version;
161   PROCEDURE api_copy;
162   PROCEDURE add_language;
163   PROCEDURE insert_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_btcv_rec                     IN btcv_rec_type,
170     x_btcv_rec                     OUT NOCOPY btcv_rec_type);
171 
172   PROCEDURE insert_row(
173     p_api_version                  IN NUMBER,
174     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
175     x_return_status                OUT NOCOPY VARCHAR2,
176     x_msg_count                    OUT NOCOPY NUMBER,
177     x_msg_data                     OUT NOCOPY VARCHAR2,
178     p_btcv_tbl                     IN btcv_tbl_type,
179     x_btcv_tbl                     OUT NOCOPY btcv_tbl_type);
180 
181   PROCEDURE lock_row(
182     p_api_version                  IN NUMBER,
183     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
184     x_return_status                OUT NOCOPY VARCHAR2,
185     x_msg_count                    OUT NOCOPY NUMBER,
186     x_msg_data                     OUT NOCOPY VARCHAR2,
187     p_btcv_rec                     IN btcv_rec_type);
188 
189   PROCEDURE lock_row(
190     p_api_version                  IN NUMBER,
191     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
192     x_return_status                OUT NOCOPY VARCHAR2,
193     x_msg_count                    OUT NOCOPY NUMBER,
194     x_msg_data                     OUT NOCOPY VARCHAR2,
195     p_btcv_tbl                     IN btcv_tbl_type);
196 
197   PROCEDURE update_row(
198     p_api_version                  IN NUMBER,
199     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
200     x_return_status                OUT NOCOPY VARCHAR2,
201     x_msg_count                    OUT NOCOPY NUMBER,
202     x_msg_data                     OUT NOCOPY VARCHAR2,
203     p_btcv_rec                     IN btcv_rec_type,
204     x_btcv_rec                     OUT NOCOPY btcv_rec_type);
205 
206   PROCEDURE update_row(
207     p_api_version                  IN NUMBER,
208     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
209     x_return_status                OUT NOCOPY VARCHAR2,
210     x_msg_count                    OUT NOCOPY NUMBER,
211     x_msg_data                     OUT NOCOPY VARCHAR2,
212     p_btcv_tbl                     IN btcv_tbl_type,
213     x_btcv_tbl                     OUT NOCOPY btcv_tbl_type);
214 
215   PROCEDURE delete_row(
216     p_api_version                  IN NUMBER,
217     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
218     x_return_status                OUT NOCOPY VARCHAR2,
219     x_msg_count                    OUT NOCOPY NUMBER,
220     x_msg_data                     OUT NOCOPY VARCHAR2,
221     p_btcv_rec                     IN btcv_rec_type);
222 
223   PROCEDURE delete_row(
224     p_api_version                  IN NUMBER,
225     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
226     x_return_status                OUT NOCOPY VARCHAR2,
227     x_msg_count                    OUT NOCOPY NUMBER,
228     x_msg_data                     OUT NOCOPY VARCHAR2,
229     p_btcv_tbl                     IN btcv_tbl_type);
230 
231   PROCEDURE validate_row(
232     p_api_version                  IN NUMBER,
233     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
234     x_return_status                OUT NOCOPY VARCHAR2,
235     x_msg_count                    OUT NOCOPY NUMBER,
236     x_msg_data                     OUT NOCOPY VARCHAR2,
237     p_btcv_rec                     IN btcv_rec_type);
238 
239   PROCEDURE validate_row(
240     p_api_version                  IN NUMBER,
241     p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
242     x_return_status                OUT NOCOPY VARCHAR2,
243     x_msg_count                    OUT NOCOPY NUMBER,
244     x_msg_data                     OUT NOCOPY VARCHAR2,
245     p_btcv_tbl                     IN btcv_tbl_type);
246 
247 END Okl_Btc_Pvt;