1 PACKAGE OKL_SUBSIDY_POOL_BUDGET_PVT AS
2 /* $Header: OKLRSIBS.pls 120.1 2005/10/30 03:17:04 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ---------------------------------------------------------------------------
6 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SUBSIDY_POOL_BUDGET_PVT';
8 G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
9 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
10
11 SUBTYPE budget_line_rec IS okl_sib_pvt.sibv_rec_type ;
12 SUBTYPE budget_line_tbl IS okl_sib_pvt.sibv_tbl_type ;
13 ---------------------------------------------------------------------------
14 -- Procedures and Functions
15 ---------------------------------------------------------------------------
16 ---------------------------------------------------------------------------
17 -- PROCEDURE create_budget_line
18 ---------------------------------------------------------------------------
19 -- Start of comments
20 --
21 -- Procedure Name : create_budget_line
22 -- Description : procedure for inserting the records in
23 -- table OKL_SUBSIDY_POOL_BUDGETS
24 -- Business Rules : This procedure creates budget lines for a subsidy pool
25 -- where subsidy pool id of table OKL_SUBSIDY_POOL_BUDGETS
26 -- represents that pool id.
27 -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count
28 -- x_msg_data, p_budget_line_tbl, x_budget_line_tbl.
29 -- Version : 1.0
30 -- End of comments
31 ---------------------------------------------------------------------------
32
33 PROCEDURE create_budget_line ( p_api_version IN NUMBER
34 ,p_init_msg_list IN VARCHAR2
35 ,x_return_status OUT NOCOPY VARCHAR2
36 ,x_msg_count OUT NOCOPY NUMBER
37 ,x_msg_data OUT NOCOPY VARCHAR2
38 ,p_budget_line_tbl IN budget_line_tbl
39 ,x_budget_line_tbl OUT NOCOPY budget_line_tbl
40 );
41 ---------------------------------------------------------------------------
42 -- PROCEDURE update_budget_line
43 ---------------------------------------------------------------------------
44 -- Start of comments
45 --
46 -- Procedure Name : update_budget_line
47 -- Description : procedure for updating the records in
48 -- table OKL_SUBSIDY_POOL_BUDGETS
49 -- Business Rules : This procedure updates the existing budget lines
50 -- only when the budget line status is "new".
51 -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
52 -- x_msg_data, p_budget_line_tbl, x_budget_line_tbl.
53 -- Version : 1.0
54 -- End of comments
55 ---------------------------------------------------------------------------
56
57 PROCEDURE update_budget_line ( p_api_version IN NUMBER
58 ,p_init_msg_list IN VARCHAR2
59 ,x_return_status OUT NOCOPY VARCHAR2
60 ,x_msg_count OUT NOCOPY NUMBER
61 ,x_msg_data OUT NOCOPY VARCHAR2
62 ,p_budget_line_tbl IN budget_line_tbl
63 ,x_budget_line_tbl OUT NOCOPY budget_line_tbl
64 );
65 ---------------------------------------------------------------------------
66 -- PROCEDURE set_decision_status_code
67 ---------------------------------------------------------------------------
68 -- Start of comments
69 --
70 -- Procedure Name : set_decision_status_code
71 -- Description : procedure for updating the decision status code
72 -- table OKL_SUBSIDY_POOL_BUDGETS_B.
73 -- Business Rules : This procedure sets the value of column desicion_status_code
74 -- with the value passed to this procedure for the given line id.
75 -- decision_status_code is a status of the corresponding budget line.
76 -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
77 -- x_msg_data, p_sub_pool_budget_id, p_decision_status_code.
78 -- Version : 1.0
79 -- End of comments
80 ---------------------------------------------------------------------------
81
82 PROCEDURE set_decision_status_code ( p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2,
87 p_sub_pool_budget_id IN okl_subsidy_pool_budgets_b.id%TYPE,
88 p_decision_status_code IN OUT NOCOPY okl_subsidy_pool_budgets_b.decision_status_code%TYPE);
89
90 ---------------------------------------------------------------------------
91 -- PROCEDURE validate_budget_line
92 ---------------------------------------------------------------------------
93 -- Start of comments
94
95 -- Procedure Name : validate_budget_line
96 -- Description : procedure for validating the records in
97
98 -- table OKL_SUBSIDY_POOL_BUDGETS
99 -- Business Rules : Validates the attributes.
100 -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
101 -- x_msg_data, p_budget_line_tbl.
102 -- Version : 1.0
103 -- End of comments
104 ---------------------------------------------------------------------------
105 PROCEDURE validate_budget_line( p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 p_budget_line_tbl IN budget_line_tbl
111 );
112
113 END OKL_SUBSIDY_POOL_BUDGET_PVT;
114