1 PACKAGE OKL_FUNDING_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPFUNS.pls 120.2 2007/11/20 08:23:07 dcshanmu ship $ */
3 ----------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ----------------------------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FUNDING_PUB';
7 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8
9 ----------------------------------------------------------------------------
10 -- Data Structures
11 ----------------------------------------------------------------------------
12 subtype tapv_rec_type is okl_tap_pvt.tapv_rec_type;
13 subtype tapv_tbl_type is okl_tap_pvt.tapv_tbl_type;
14 subtype tplv_rec_type is okl_tpl_pvt.tplv_rec_type;
15 subtype tplv_tbl_type is okl_tpl_pvt.tplv_tbl_type;
16
17 ----------------------------------------------------------------------------
18 -- Global Exception
19 ----------------------------------------------------------------------------
20 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
21
22 ----------------------------------------------------------------------------
23 -- Procedures and Functions
24 ------------------------------------------------------------------------------
25
26 PROCEDURE create_funding_header(
27 p_api_version IN NUMBER
28 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
29 ,x_return_status OUT NOCOPY VARCHAR2
30 ,x_msg_count OUT NOCOPY NUMBER
31 ,x_msg_data OUT NOCOPY VARCHAR2
32 ,p_tapv_rec IN tapv_rec_type
33 ,x_tapv_rec OUT NOCOPY tapv_rec_type
34 );
35
36 PROCEDURE update_funding_header(
37 p_api_version IN NUMBER
38 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
39 ,x_return_status OUT NOCOPY VARCHAR2
40 ,x_msg_count OUT NOCOPY NUMBER
41 ,x_msg_data OUT NOCOPY VARCHAR2
42 ,p_tapv_rec IN tapv_rec_type
43 ,x_tapv_rec OUT NOCOPY tapv_rec_type
44 );
45
46 PROCEDURE delete_funding_header(
47 p_api_version IN NUMBER
48 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
49 ,x_return_status OUT NOCOPY VARCHAR2
50 ,x_msg_count OUT NOCOPY NUMBER
51 ,x_msg_data OUT NOCOPY VARCHAR2
52 ,p_tapv_rec IN tapv_rec_type
53 );
54
55 PROCEDURE create_funding_lines(
56 p_api_version IN NUMBER
57 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
58 ,x_return_status OUT NOCOPY VARCHAR2
59 ,x_msg_count OUT NOCOPY NUMBER
60 ,x_msg_data OUT NOCOPY VARCHAR2
61 ,p_tplv_tbl IN tplv_tbl_type
62 ,x_tplv_tbl OUT NOCOPY tplv_tbl_type
63 );
64
65 PROCEDURE create_funding_lines(
66 p_api_version IN NUMBER
67 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
68 ,x_return_status OUT NOCOPY VARCHAR2
69 ,x_msg_count OUT NOCOPY NUMBER
70 ,x_msg_data OUT NOCOPY VARCHAR2
71 ,p_hdr_id IN NUMBER
72 ,p_khr_id IN NUMBER
73 ,p_vendor_site_id IN NUMBER
74 ,x_tplv_tbl OUT NOCOPY tplv_tbl_type
75 );
76
77 PROCEDURE update_funding_lines(
78 p_api_version IN NUMBER
79 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
80 ,x_return_status OUT NOCOPY VARCHAR2
81 ,x_msg_count OUT NOCOPY NUMBER
82 ,x_msg_data OUT NOCOPY VARCHAR2
83 ,p_tplv_tbl IN tplv_tbl_type
84 ,x_tplv_tbl OUT NOCOPY tplv_tbl_type
85 );
86
87 PROCEDURE delete_funding_lines(
88 p_api_version IN NUMBER
89 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
90 ,x_return_status OUT NOCOPY VARCHAR2
91 ,x_msg_count OUT NOCOPY NUMBER
92 ,x_msg_data OUT NOCOPY VARCHAR2
93 ,p_tplv_tbl IN tplv_tbl_type
94 );
95
96 PROCEDURE create_funding_assets(
97 p_api_version IN NUMBER
98 ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
99 ,x_return_status OUT NOCOPY VARCHAR2
100 ,x_msg_count OUT NOCOPY NUMBER
101 ,x_msg_data OUT NOCOPY VARCHAR2
102 ,p_fund_id IN NUMBER
103 );
104
105
106 END OKL_FUNDING_PUB;