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,
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,
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,
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);
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;
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:
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
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 (