PACKAGE: APPS.OKL_BPD_CREDIT_CHECK_PVT

Source

1 PACKAGE OKL_BPD_CREDIT_CHECK_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRCCFS.pls 120.2 2005/10/30 03:16:09 appldev noship $ */
3  ------------------------------------------------------------------------------
4  -- Global Variables
5  ------------------------------------------------------------------------------
6  G_PKG_NAME             CONSTANT VARCHAR2(200) := 'OKL_BPD_CREDIT_CHECK_PVT';
7  G_APP_NAME             CONSTANT VARCHAR2(3)   :=  OKL_API.G_APP_NAME;
8  G_UNEXPECTED_ERROR     CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
9  G_SQLERRM_TOKEN        CONSTANT VARCHAR2(200) := 'SQLERRM';
10  G_SQLCODE_TOKEN        CONSTANT VARCHAR2(200) := 'SQLCODE';
11 
12  ---------------------------------------------------------------------------
13  -- Procedures and Functions
14  ---------------------------------------------------------------------------
15 
16  --function to return the credit amount available for a customer
17  FUNCTION credit_check(p_api_version		IN  NUMBER
18 	,p_init_msg_list	IN  VARCHAR2	DEFAULT OKC_API.G_FALSE
19 	,x_return_status	OUT NOCOPY VARCHAR2
20 	,x_msg_count		OUT NOCOPY NUMBER
21 	,x_msg_data		    OUT NOCOPY VARCHAR2
22 	,p_creditline_id   IN  NUMBER
23 	,p_credit_max       IN  NUMBER
24     ,P_trx_date         IN DATE DEFAULT SYSDATE)
25     RETURN NUMBER;
26 
27 END OKL_BPD_CREDIT_CHECK_PVT;