[Home] [Help]
PACKAGE: APPS.OKL_BTCH_CASH_APPLIC
Source
1 PACKAGE okl_btch_cash_applic AUTHID CURRENT_USER AS
2 /* $Header: OKLRBAPS.pls 120.3 2007/09/19 06:16:09 varangan ship $ */
3
4
5 ---------------------------------------------------------------------------
6 -- GLOBAL VARIABLES
7 ---------------------------------------------------------------------------
8
9 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_api.G_APP_NAME;
10 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
11 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
12 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
13
14 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BTCH_CASH_APPLIC';
15 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
16 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
17 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
18 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
19 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
21 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
22 ---------------------------------------------------------------------------
23 -- GLOBAL DATASTRUCTURES
24 ---------------------------------------------------------------------------
25
26 TYPE okl_batch_dtls_rec_type IS RECORD (
27 id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
28 irm_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
29 btc_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
30 btc_status VARCHAR2(30),
31 consolidated_invoice_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,
32 currency_code VARCHAR2(15), --DEFAULT Okl_Api.G_MISS_CHAR,
33 check_number VARCHAR2(90), --DEFAULT Okl_Api.G_MISS_CHAR,
34 receipt_date DATE, --DEFAULT Okl_Api.G_MISS_DATE,
35 amount NUMBER(14,3), --DEFAULT Okl_Api.G_MISS_NUM,
36 ile_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
37 consolidated_invoice_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
38 khr_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
39 contract_number VARCHAR2(120), --DEFAULT Okl_Api.G_MISS_CHAR,
40 --Added by nikshah as part of Receipts Project
41 ar_invoice_id NUMBER, --DEFAULT Okl_Api.G_MISS_NUM,
42 customer_number VARCHAR2(90),
43 -- Added by varangan for DFF in Batch Receipts
44 dff_attribute_category ar_cash_receipts.attribute_category%TYPE,
45 dff_attribute1 ar_cash_receipts.attribute1%TYPE,
46 dff_attribute2 ar_cash_receipts.attribute2%TYPE,
47 dff_attribute3 ar_cash_receipts.attribute3%TYPE,
48 dff_attribute4 ar_cash_receipts.attribute4%TYPE,
49 dff_attribute5 ar_cash_receipts.attribute5%TYPE,
50 dff_attribute6 ar_cash_receipts.attribute6%TYPE,
51 dff_attribute7 ar_cash_receipts.attribute7%TYPE,
52 dff_attribute8 ar_cash_receipts.attribute8%TYPE,
53 dff_attribute9 ar_cash_receipts.attribute9%TYPE,
54 dff_attribute10 ar_cash_receipts.attribute10%TYPE,
55 dff_attribute11 ar_cash_receipts.attribute11%TYPE,
56 dff_attribute12 ar_cash_receipts.attribute12%TYPE,
57 dff_attribute13 ar_cash_receipts.attribute13%TYPE,
58 dff_attribute14 ar_cash_receipts.attribute14%TYPE,
59 dff_attribute15 ar_cash_receipts.attribute15%TYPE
60 ); --DEFAULT Okl_Api.G_MISS_CHAR);
61
62 TYPE okl_btch_dtls_tbl_type IS TABLE OF okl_batch_dtls_rec_type
63 INDEX BY BINARY_INTEGER;
64
65 ---------------------------------------------------------------------------
66 -- GLOBAL VARIABLES
67 ---------------------------------------------------------------------------
68
69 ---------------------------------------------------------------------------
70 -- Procedures and Functions
71 ---------------------------------------------------------------------------
72
73 PROCEDURE handle_batch_pay ( p_api_version IN NUMBER -- TEMPORARY SOLUTION
74 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
75 ,x_return_status OUT NOCOPY VARCHAR2
76 ,x_msg_count OUT NOCOPY NUMBER
77 ,x_msg_data OUT NOCOPY VARCHAR2
78 ,p_btch_tbl IN okl_btch_dtls_tbl_type
79 ,x_btch_tbl OUT NOCOPY okl_btch_dtls_tbl_type
80 );
81
82
83 END OKL_BTCH_CASH_APPLIC;