[Home] [Help]
PACKAGE: APPS.OKL_SUBSIDY_POOL_RPT_PVT
Source
1 PACKAGE okl_subsidy_pool_rpt_pvt AS
2 /* $Header: OKLRSIOS.pls 120.3 2007/01/09 12:36:48 udhenuko noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL VARIABLES
6 ---------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SUBSIDY_POOL_RPT_PVT';
8 G_API_TYPE CONSTANT VARCHAR2(30) := '_PVT';
9 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
10 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
11
12 TYPE okl_sub_pool_rec IS RECORD (
13 id okl_subsidy_pools_b.id%TYPE := OKL_API.G_MISS_NUM,
14 subsidy_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE := OKL_API.G_MISS_CHAR,
15 pool_type_code okl_subsidy_pools_b.pool_type_code%TYPE := OKL_API.G_MISS_CHAR,
16 currency_code okl_subsidy_pools_b.currency_code%TYPE := OKL_API.G_MISS_CHAR,
17 currency_conversion_type okl_subsidy_pools_b.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR,
18 reporting_pool_limit okl_subsidy_pools_b.reporting_pool_limit%TYPE := OKL_API.G_MISS_NUM,
19 effective_from_date okl_subsidy_pools_b.effective_from_date%TYPE := OKL_API.G_MISS_DATE);
20 TYPE subsidy_pool_tbl_type IS TABLE OF okl_sub_pool_rec INDEX BY BINARY_INTEGER;
21
22 --To hold the amounts for the subsidy pool
23 TYPE pool_dtl_rec_type IS RECORD (
24 reporting_limit VARCHAR2(2000) := NULL,
25 total_budget VARCHAR2(2000) := NULL,
26 remaining_balance VARCHAR2(2000) := NULL,
27 error_message VARCHAR2(4000) := NULL);
28
29 -- Variables for XML Publisher Report input parameters
30 P_POOL_ID okl_subsidy_pools_b.id%TYPE;
31 P_DATE VARCHAR2(120);
32 P_PERCENT NUMBER;
33 P_REMAINING NUMBER;
34 P_CURRENCY okl_subsidy_pools_b.currency_code%TYPE;
35 P_DAYS NUMBER;
36 P_FROM_DATE VARCHAR2(120);
37 P_TO_DATE VARCHAR2(120);
38 P_END_DATE VARCHAR2(120);
39
40 -------------------------------------------------------------------------------
41 -- PROCEDURE POOL_ASSOC_REPORT
42 -------------------------------------------------------------------------------
43 -- Start of comments
44 --
45 -- Procedure Name : POOL_ASSOC_REPORT
46 -- Description : Procedure for Subsidy pool association Report Generation
47 -- Business Rules :
48 -- Parameters : required parameters are p_pool_name
49 -- Version : 1.0
50 -- History : 08-Mar-2005 ABINDAL created
51 -- End of comments
52 -------------------------------------------------------------------------------
53
54 PROCEDURE POOL_ASSOC_REPORT(x_errbuf OUT NOCOPY VARCHAR2,
55 x_retcode OUT NOCOPY NUMBER,
56 p_pool_id IN okl_subsidy_pools_b.id%TYPE,
57 p_date IN VARCHAR2);
58
59
60 -------------------------------------------------------------------------------
61 -- PROCEDURE POOL_RECONC_REPORT
62 -------------------------------------------------------------------------------
63 -- Start of comments
64 --
65 -- Procedure Name : POOL_RECONC_REPORT
66 -- Description : Procedure for Subsidy pool reconciliation Report Generation
67 -- Business Rules :
68 -- Parameters : required parameters are p_pool_name
69 -- Version : 1.0
70 -- History : 08-Mar-2005 ABINDAL created
71 -- End of comments
72 -------------------------------------------------------------------------------
73
74 PROCEDURE POOL_RECONC_REPORT(x_errbuf OUT NOCOPY VARCHAR2,
75 x_retcode OUT NOCOPY NUMBER,
76 p_pool_id IN okl_subsidy_pools_b.id%TYPE,
77 p_from_date IN VARCHAR2,
78 p_to_date IN VARCHAR2);
79
80
81
82 -------------------------------------------------------------------------------
83 -- PROCEDURE POOL_ATLIMIT_REPORT
84 -------------------------------------------------------------------------------
85 -- Start of comments
86 --
87 -- Procedure Name : POOL_ATLIMIT_REPORT
88 -- Description : Procedure for Subsidy pool association Report Generation
89 -- Business Rules :
90 -- Parameters : parameter p_currency is required if p_remaining is entered.
91 -- Version : 1.0
92 -- History : 08-Mar-2005 ABINDAL created
93 -- End of comments
94 -------------------------------------------------------------------------------
95
96 PROCEDURE POOL_ATLIMIT_REPORT(x_errbuf OUT NOCOPY VARCHAR2,
97 x_retcode OUT NOCOPY NUMBER,
98 p_percent IN NUMBER,
99 p_remaining IN NUMBER,
100 p_currency IN okl_subsidy_pools_b.currency_code%TYPE,
101 p_end_date IN VARCHAR2,
102 p_days IN NUMBER );
103
104 -------------------------------------------------------------------------------
105 -- FUNCTION XML_POOL_ASSOC_REPORT
106 -------------------------------------------------------------------------------
107 -- Start of comments
108 --
109 -- Procedure Name : XML_POOL_ASSOC_REPORT
110 -- Description : FUNCTION for Subsidy pool association Report Generation for
111 -- XML Publisher
112 -- Business Rules :
113 -- Parameters :
114 -- Version : 1.0
115 -- History : 03-Jan-2007 UDHENUKO created.
116 -- End of comments
117 -------------------------------------------------------------------------------
118 FUNCTION XML_POOL_ASSOC_REPORT RETURN BOOLEAN;
119
120 ---------------------------------------------------------------------------
121 -- FUNCTION xml_print_atlimit_detail
122 ---------------------------------------------------------------------------
123 ---------------------------------------------------------------------------
124 -- Start of comments
125 --
126 -- Procedure Name : xml_print_atlimit_detail
127 -- Description : To insert the At-Limit subsidy pool detail into the
128 -- Global Temporary Table for XML Publisher.
129 -- Business Rules :
130 -- Parameters :
131 -- Version : 1.0
132 -- History : 03-Jan-2007 UDHENUKO created.
133 -- End of comments
134 ---------------------------------------------------------------------------
135 FUNCTION xml_print_atlimit_detail RETURN BOOLEAN;
136
137 -------------------------------------------------------------------------------
138 -- FUNCTION XML_POOL_RECONC_REPORT
139 -------------------------------------------------------------------------------
140 -- Start of comments
141 --
142 -- Procedure Name : XML_POOL_RECONC_REPORT
143 -- Description : FUNCTION for Subsidy pool reconciliation Report Generation
144 -- in XML Publisher
145 -- Business Rules :
146 -- Parameters :
147 -- Version : 1.0
148 -- History : 03-Jan-2007 UDHENUKO created.
149 -- End of comments
150 -------------------------------------------------------------------------------
151
152 FUNCTION XML_POOL_RECONC_REPORT RETURN BOOLEAN;
153 END okl_subsidy_pool_rpt_pvt;