DBA Data[Home] [Help]

PACKAGE: APPS.OKL_VARIABLE_INTEREST_PUB

Source


1 PACKAGE OKL_VARIABLE_INTEREST_PUB AUTHID CURRENT_USER AS
2     /* $Header: OKLPVARS.pls 120.1.12020000.2 2012/08/13 06:32:09 bkatraga ship $ */
3      ------------------------------------------------------------------------------
4      -- Global Variables
5      ------------------------------------------------------------------------------
6 
7      G_PKG_NAME             CONSTANT VARCHAR2(200) := 'OKL_VARIABLE_INTEREST_PUB';
8      G_APP_NAME             CONSTANT VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
9      G_UNEXPECTED_ERROR     CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
10      G_SQLERRM_TOKEN        CONSTANT VARCHAR2(200) := 'SQLERRM';
11      G_SQLCODE_TOKEN        CONSTANT VARCHAR2(200) := 'SQLCODE';
12 
13      ---------------------------------------------------------------------------
14      -- Procedures and Functions
15      ---------------------------------------------------------------------------
16 
17        PROCEDURE VARIABLE_INTEREST
18          (p_api_version		IN  NUMBER
19     	,p_init_msg_list		IN  VARCHAR2	DEFAULT OKC_API.G_FALSE
20     	,x_return_status		OUT NOCOPY VARCHAR2
21     	,x_msg_count		OUT NOCOPY NUMBER
22     	,x_msg_data		    	OUT NOCOPY VARCHAR2
23         ,p_contract_number VARCHAR2
24         ,P_to_date       DATE);
25 
26 
27         PROCEDURE VARIABLE_INTEREST
28         (errbuf	 OUT NOCOPY  VARCHAR2
29     	,retcode OUT NOCOPY  NUMBER
30         ,p_contract_number  IN  VARCHAR2 DEFAULT NULL
31     	,p_to_date	 IN  VARCHAR2	DEFAULT NULL);
32 
33 
34 END;
35