PACKAGE: APPS.OKL_VR_DATA_HANDLER_PVT

Source

1 PACKAGE OKL_VR_DATA_HANDLER_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLMVARS.pls 120.0.12020000.2 2012/11/23 06:15:33 bkatraga noship $ */
3 
4   --------------------------------------------------------------------------
5   -- Global Variables
6   --------------------------------------------------------------------------
7   G_PKG_NAME             CONSTANT VARCHAR2(200)  := 'OKL_VR_DATA_HANDLER_PVT';
8   G_APP_NAME             CONSTANT VARCHAR2(3)    := OKL_API.G_APP_NAME;
9   G_UNEXPECTED_ERROR     CONSTANT VARCHAR2(200)  := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
10   G_SQLERRM_TOKEN        CONSTANT VARCHAR2(200)  := 'SQLERRM';
11   G_SQLCODE_TOKEN        CONSTANT VARCHAR2(200)  := 'SQLCODE';
12 
13 
14   PROCEDURE UPDATE_LAST_INT_CAL_DATE(
15         p_api_version            IN  NUMBER,
16         p_init_msg_list          IN  VARCHAR2,
17         x_return_status          OUT NOCOPY VARCHAR2,
18         x_msg_count              OUT NOCOPY NUMBER,
19         x_msg_data               OUT NOCOPY VARCHAR2,
20         p_contract_id            IN  NUMBER,
21         p_last_interest_cal_date IN  DATE);
22 
23   PROCEDURE INSERT_PRINCIPAL_BAL_TXN(
24         p_api_version        IN  NUMBER,
25         p_init_msg_list      IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
26         x_return_status      OUT NOCOPY VARCHAR2,
27         x_msg_count          OUT NOCOPY NUMBER,
28         x_msg_data           OUT NOCOPY VARCHAR2,
29         p_vpb_tbl            IN  OKL_VARIABLE_INTEREST_PVT.vpb_tbl_type);
30 
31   PROCEDURE INSERT_VIR_PARAMS(
32         p_api_version        IN  NUMBER,
33         p_init_msg_list      IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
34         x_return_status      OUT NOCOPY VARCHAR2,
35         x_msg_count          OUT NOCOPY NUMBER,
36         x_msg_data           OUT NOCOPY VARCHAR2,
37         p_vir_tbl            IN  OKL_VARIABLE_INTEREST_PVT.vir_tbl_type);
38 
39 END;