DBA Data[Home] [Help]

PACKAGE: APPS.OKL_ECC_DEF_PVT

Source


1 PACKAGE okl_ecc_def_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRECCS.pls 120.1 2005/10/30 04:58:55 appldev noship $ */
3 
4   SUBTYPE okl_eccv_rec IS okl_ecc_pvt.okl_eccv_rec;
5 
6   SUBTYPE okl_eco_rec IS okl_eco_pvt.okl_eco_rec;
7 
8   SUBTYPE okl_eco_tbl IS okl_eco_pvt.okl_eco_tbl;
9 
10   ------------------------------------------------------------------------------
11   -- Global Variables
12 
13   g_pkg_name         CONSTANT varchar2(200) := 'OKL_ECC_DEF_PVT';
14   g_app_name         CONSTANT varchar2(3) := okl_api.g_app_name;
15   g_api_type         CONSTANT varchar2(4) := '_PVT';
16   g_unexpected_error CONSTANT varchar2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
17   g_sqlerrm_token    CONSTANT varchar2(200) := 'SQLERRM';
18   g_sqlcode_token    CONSTANT varchar2(200) := 'SQLCODE';
19 
20   ------------------------------------------------------------------------------
21   --Global Exception
22   ------------------------------------------------------------------------------
23 
24   g_exception_halt_validation EXCEPTION;
25 
26   ------------------------------------------------------------------------------
27 
28   PROCEDURE create_ecc(p_api_version    IN             number
29                       ,p_init_msg_list  IN             varchar2     DEFAULT okl_api.g_false
30                       ,x_return_status     OUT NOCOPY  varchar2
31                       ,x_msg_count         OUT NOCOPY  number
32                       ,x_msg_data          OUT NOCOPY  varchar2
33                       ,p_eccv_rec       IN             okl_eccv_rec
34                       ,x_eccv_rec          OUT NOCOPY  okl_eccv_rec
35                       ,p_eco_tbl        IN             okl_eco_tbl
36                       ,x_eco_tbl           OUT NOCOPY  okl_eco_tbl);
37 
38   PROCEDURE update_ecc(p_api_version    IN             number
39                       ,p_init_msg_list  IN             varchar2     DEFAULT okl_api.g_false
40                       ,x_return_status     OUT NOCOPY  varchar2
41                       ,x_msg_count         OUT NOCOPY  number
42                       ,x_msg_data          OUT NOCOPY  varchar2
43                       ,p_eccv_rec       IN             okl_eccv_rec
44                       ,x_eccv_rec          OUT NOCOPY  okl_eccv_rec
45                       ,p_eco_tbl        IN             okl_eco_tbl
46                       ,x_eco_tbl           OUT NOCOPY  okl_eco_tbl);
47 
48 END okl_ecc_def_pvt;