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_SUBSIDY_POOLS_B

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 (

Line 30: P_POOL_ID okl_subsidy_pools_b.id%TYPE;

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;

Line 34: P_CURRENCY okl_subsidy_pools_b.currency_code%TYPE;

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

Line 56: p_pool_id IN okl_subsidy_pools_b.id%TYPE,

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: -------------------------------------------------------------------------------

Line 76: p_pool_id IN okl_subsidy_pools_b.id%TYPE,

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:

Line 100: p_currency IN okl_subsidy_pools_b.currency_code%TYPE,

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: -------------------------------------------------------------------------------