[Home] [Help]
PACKAGE: APPS.OKL_CASH_RULES_SUMRY_PVT
Source
1 PACKAGE OKL_CASH_RULES_SUMRY_PVT AS
2 /* $Header: OKLRCSYS.pls 120.2 2006/07/11 09:45:04 dkagrawa 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_CASH_RULES_SUMRY_PVT';
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_cash_rl_sumry_rec_type IS RECORD (
25 ID OKL_CASH_ALLCTN_RLS.ID%TYPE);
26
27 TYPE okl_cash_rl_sumry_tbl_type IS TABLE OF okl_cash_rl_sumry_rec_type INDEX BY BINARY_INTEGER;
28
29 ---------------------------------------------------------------------------
30 -- GLOBAL VARIABLES
31 ---------------------------------------------------------------------------
32
33 ---------------------------------------------------------------------------
34 -- Procedures and Functions
35 ---------------------------------------------------------------------------
36
37 PROCEDURE handle_cash_rl_sumry( p_api_version IN NUMBER
38 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
39 ,x_return_status OUT NOCOPY VARCHAR2
40 ,x_msg_count OUT NOCOPY NUMBER
41 ,x_msg_data OUT NOCOPY VARCHAR2
42 ,p_cash_rl_tbl IN okl_cash_rl_sumry_tbl_type
43 );
44
45
46 END OKL_CASH_RULES_SUMRY_PVT;