[Home] [Help]
PACKAGE: APPS.OKL_BTCH_CASH_SUMRY_PVT
Source
1 PACKAGE OKL_BTCH_CASH_SUMRY_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRBASS.pls 115.3 2003/11/10 23:37:47 bvaghela noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ---------------------------------------------------------------------------
6
7 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_api.G_APP_NAME;
8 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
9 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
10 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
11
12 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BTCH_CASH_APPLIC';
13 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
14 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
15 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
16 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
17 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
18 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
20 ---------------------------------------------------------------------------
21 -- GLOBAL DATASTRUCTURES
22 ---------------------------------------------------------------------------
23
24 TYPE okl_batch_sumry_rec_type IS RECORD (
25 id OKL_TRX_CSH_BATCH_B.ID%TYPE,
26 trx_status_code OKL_TRX_CSH_BATCH_B.TRX_STATUS_CODE%TYPE);
27
28 TYPE okl_btch_sumry_tbl_type IS TABLE OF okl_batch_sumry_rec_type
29 INDEX BY BINARY_INTEGER;
30
31 ---------------------------------------------------------------------------
32 -- GLOBAL VARIABLES
33 ---------------------------------------------------------------------------
34
35 ---------------------------------------------------------------------------
36 -- Procedures and Functions
37 ---------------------------------------------------------------------------
38
39 PROCEDURE handle_batch_sumry( p_api_version IN NUMBER -- TEMPORARY SOLUTION
40 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
41 ,x_return_status OUT NOCOPY VARCHAR2
42 ,x_msg_count OUT NOCOPY NUMBER
43 ,x_msg_data OUT NOCOPY VARCHAR2
44 ,p_btch_tbl IN okl_btch_sumry_tbl_type
45 );
46
47
48 END OKL_BTCH_CASH_SUMRY_PVT;