[Home] [Help]
PACKAGE: APPS.OKL_CSBRW_PVT
Source
1 PACKAGE OKL_CSBRW_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRFBRS.pls 115.1 2002/11/30 08:47:29 spillaip noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL MESSAGE CONSTANTS
5 ---------------------------------------------------------------------------
6 G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
7 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
8 G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
9 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
10 G_COL_NAME1_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME1';
11 G_COL_NAME2_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME2';
12 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'PARENT_TABLE';
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
16 ---------------------------------------------------------------------------
17 -- GLOBAL VARIABLES
18 ---------------------------------------------------------------------------
19 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CSBRW_PVT';
20 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
21 ---------------------------------------------------------------------------
22 -- GLOBAL EXCEPTION
23 ---------------------------------------------------------------------------
24 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
25 FUNCTION cust_amount_info( p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2,
29 p_cust_account_id IN NUMBER,
30 x_amnt_applied OUT NOCOPY NUMBER,
31 x_amnt_outstanding OUT NOCOPY NUMBER
32 ) RETURN VARCHAR2;
33
34 END OKL_CSBRW_PVT;