eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SUBSIDY_POOL_RPT_PVT dependencies on OKL_API

Line 9: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

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,

Line 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,

Line 14: subsidy_pool_name okl_subsidy_pools_b.subsidy_pool_name%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,

Line 15: pool_type_code okl_subsidy_pools_b.pool_type_code%TYPE := OKL_API.G_MISS_CHAR,

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);

Line 16: currency_code okl_subsidy_pools_b.currency_code%TYPE := OKL_API.G_MISS_CHAR,

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;

Line 17: currency_conversion_type okl_subsidy_pools_b.currency_conversion_type%TYPE := OKL_API.G_MISS_CHAR,

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:

Line 18: reporting_pool_limit okl_subsidy_pools_b.reporting_pool_limit%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

Line 19: effective_from_date okl_subsidy_pools_b.effective_from_date%TYPE := OKL_API.G_MISS_DATE);

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 (