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_K_RATE_PARAMS_PVT dependencies on OKL_K_RATE_PARAMS

Line 1: PACKAGE OKL_K_RATE_PARAMS_PVT AS

1: PACKAGE OKL_K_RATE_PARAMS_PVT AS
2: /* $Header: OKLRKRPS.pls 120.5.12010000.2 2008/09/30 06:06:06 rpillay ship $ */
3: TYPE krpdel_rec_type IS RECORD (
4: khr_id NUMBER := OKC_API.G_MISS_NUM
5: ,rate_type VARCHAR2(30) := OKC_API.G_MISS_CHAR

Line 6: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE

2: /* $Header: OKLRKRPS.pls 120.5.12010000.2 2008/09/30 06:06:06 rpillay ship $ */
3: TYPE krpdel_rec_type IS RECORD (
4: khr_id NUMBER := OKC_API.G_MISS_NUM
5: ,rate_type VARCHAR2(30) := OKC_API.G_MISS_CHAR
6: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
7: );
8:
9: TYPE krpdel_tbl_type IS TABLE OF krpdel_rec_type INDEX BY BINARY_INTEGER;
10:

Line 13: ,parameter_type_code OKL_K_RATE_PARAMS_V.PARAMETER_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR

9: TYPE krpdel_tbl_type IS TABLE OF krpdel_rec_type INDEX BY BINARY_INTEGER;
10:
11: TYPE krpr_rec_type IS RECORD (
12: khr_id NUMBER := OKC_API.G_MISS_NUM
13: ,parameter_type_code OKL_K_RATE_PARAMS_V.PARAMETER_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,interest_index_id NUMBER := OKC_API.G_MISS_NUM
17: ,base_rate NUMBER := OKC_API.G_MISS_NUM

Line 14: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE

10:
11: TYPE krpr_rec_type IS RECORD (
12: khr_id NUMBER := OKC_API.G_MISS_NUM
13: ,parameter_type_code OKL_K_RATE_PARAMS_V.PARAMETER_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,interest_index_id NUMBER := OKC_API.G_MISS_NUM
17: ,base_rate NUMBER := OKC_API.G_MISS_NUM
18: ,interest_start_date OKL_K_RATE_PARAMS_V.INTEREST_START_DATE%TYPE := OKC_API.G_MISS_DATE

Line 15: ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE

11: TYPE krpr_rec_type IS RECORD (
12: khr_id NUMBER := OKC_API.G_MISS_NUM
13: ,parameter_type_code OKL_K_RATE_PARAMS_V.PARAMETER_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,interest_index_id NUMBER := OKC_API.G_MISS_NUM
17: ,base_rate NUMBER := OKC_API.G_MISS_NUM
18: ,interest_start_date OKL_K_RATE_PARAMS_V.INTEREST_START_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,adder_rate NUMBER := OKC_API.G_MISS_NUM

Line 18: ,interest_start_date OKL_K_RATE_PARAMS_V.INTEREST_START_DATE%TYPE := OKC_API.G_MISS_DATE

14: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,interest_index_id NUMBER := OKC_API.G_MISS_NUM
17: ,base_rate NUMBER := OKC_API.G_MISS_NUM
18: ,interest_start_date OKL_K_RATE_PARAMS_V.INTEREST_START_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,adder_rate NUMBER := OKC_API.G_MISS_NUM
20: ,maximum_rate NUMBER := OKC_API.G_MISS_NUM
21: ,minimum_rate NUMBER := OKC_API.G_MISS_NUM
22: ,principal_basis_code OKL_K_RATE_PARAMS_V.PRINCIPAL_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 22: ,principal_basis_code OKL_K_RATE_PARAMS_V.PRINCIPAL_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR

18: ,interest_start_date OKL_K_RATE_PARAMS_V.INTEREST_START_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,adder_rate NUMBER := OKC_API.G_MISS_NUM
20: ,maximum_rate NUMBER := OKC_API.G_MISS_NUM
21: ,minimum_rate NUMBER := OKC_API.G_MISS_NUM
22: ,principal_basis_code OKL_K_RATE_PARAMS_V.PRINCIPAL_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,days_in_a_month_code OKL_K_RATE_PARAMS_V.DAYS_IN_A_MONTH_CODE%TYPE := OKC_API.G_MISS_CHAR
24: ,days_in_a_year_code OKL_K_RATE_PARAMS_V.DAYS_IN_A_YEAR_CODE%TYPE := OKC_API.G_MISS_CHAR
25: ,interest_basis_code OKL_K_RATE_PARAMS_V.INTEREST_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR
26: );

Line 23: ,days_in_a_month_code OKL_K_RATE_PARAMS_V.DAYS_IN_A_MONTH_CODE%TYPE := OKC_API.G_MISS_CHAR

19: ,adder_rate NUMBER := OKC_API.G_MISS_NUM
20: ,maximum_rate NUMBER := OKC_API.G_MISS_NUM
21: ,minimum_rate NUMBER := OKC_API.G_MISS_NUM
22: ,principal_basis_code OKL_K_RATE_PARAMS_V.PRINCIPAL_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,days_in_a_month_code OKL_K_RATE_PARAMS_V.DAYS_IN_A_MONTH_CODE%TYPE := OKC_API.G_MISS_CHAR
24: ,days_in_a_year_code OKL_K_RATE_PARAMS_V.DAYS_IN_A_YEAR_CODE%TYPE := OKC_API.G_MISS_CHAR
25: ,interest_basis_code OKL_K_RATE_PARAMS_V.INTEREST_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR
26: );
27:

Line 24: ,days_in_a_year_code OKL_K_RATE_PARAMS_V.DAYS_IN_A_YEAR_CODE%TYPE := OKC_API.G_MISS_CHAR

20: ,maximum_rate NUMBER := OKC_API.G_MISS_NUM
21: ,minimum_rate NUMBER := OKC_API.G_MISS_NUM
22: ,principal_basis_code OKL_K_RATE_PARAMS_V.PRINCIPAL_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,days_in_a_month_code OKL_K_RATE_PARAMS_V.DAYS_IN_A_MONTH_CODE%TYPE := OKC_API.G_MISS_CHAR
24: ,days_in_a_year_code OKL_K_RATE_PARAMS_V.DAYS_IN_A_YEAR_CODE%TYPE := OKC_API.G_MISS_CHAR
25: ,interest_basis_code OKL_K_RATE_PARAMS_V.INTEREST_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR
26: );
27:
28: TYPE krpar_rec_type IS RECORD (

Line 25: ,interest_basis_code OKL_K_RATE_PARAMS_V.INTEREST_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR

21: ,minimum_rate NUMBER := OKC_API.G_MISS_NUM
22: ,principal_basis_code OKL_K_RATE_PARAMS_V.PRINCIPAL_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR
23: ,days_in_a_month_code OKL_K_RATE_PARAMS_V.DAYS_IN_A_MONTH_CODE%TYPE := OKC_API.G_MISS_CHAR
24: ,days_in_a_year_code OKL_K_RATE_PARAMS_V.DAYS_IN_A_YEAR_CODE%TYPE := OKC_API.G_MISS_CHAR
25: ,interest_basis_code OKL_K_RATE_PARAMS_V.INTEREST_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR
26: );
27:
28: TYPE krpar_rec_type IS RECORD (
29: khr_id NUMBER := OKC_API.G_MISS_NUM

Line 30: ,parameter_type_code OKL_K_RATE_PARAMS_V.PARAMETER_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR

26: );
27:
28: TYPE krpar_rec_type IS RECORD (
29: khr_id NUMBER := OKC_API.G_MISS_NUM
30: ,parameter_type_code OKL_K_RATE_PARAMS_V.PARAMETER_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
31: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,rate_delay_code OKL_K_RATE_PARAMS_V.RATE_DELAY_CODE%TYPE := OKC_API.G_MISS_CHAR
34: ,rate_delay_frequency NUMBER := OKC_API.G_MISS_NUM

Line 31: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE

27:
28: TYPE krpar_rec_type IS RECORD (
29: khr_id NUMBER := OKC_API.G_MISS_NUM
30: ,parameter_type_code OKL_K_RATE_PARAMS_V.PARAMETER_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
31: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,rate_delay_code OKL_K_RATE_PARAMS_V.RATE_DELAY_CODE%TYPE := OKC_API.G_MISS_CHAR
34: ,rate_delay_frequency NUMBER := OKC_API.G_MISS_NUM
35: ,compounding_frequency_code OKL_K_RATE_PARAMS_V.COMPOUNDING_FREQUENCY_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 32: ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE

28: TYPE krpar_rec_type IS RECORD (
29: khr_id NUMBER := OKC_API.G_MISS_NUM
30: ,parameter_type_code OKL_K_RATE_PARAMS_V.PARAMETER_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
31: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,rate_delay_code OKL_K_RATE_PARAMS_V.RATE_DELAY_CODE%TYPE := OKC_API.G_MISS_CHAR
34: ,rate_delay_frequency NUMBER := OKC_API.G_MISS_NUM
35: ,compounding_frequency_code OKL_K_RATE_PARAMS_V.COMPOUNDING_FREQUENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
36: ,calculation_formula_id NUMBER := OKC_API.G_MISS_NUM

Line 33: ,rate_delay_code OKL_K_RATE_PARAMS_V.RATE_DELAY_CODE%TYPE := OKC_API.G_MISS_CHAR

29: khr_id NUMBER := OKC_API.G_MISS_NUM
30: ,parameter_type_code OKL_K_RATE_PARAMS_V.PARAMETER_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
31: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,rate_delay_code OKL_K_RATE_PARAMS_V.RATE_DELAY_CODE%TYPE := OKC_API.G_MISS_CHAR
34: ,rate_delay_frequency NUMBER := OKC_API.G_MISS_NUM
35: ,compounding_frequency_code OKL_K_RATE_PARAMS_V.COMPOUNDING_FREQUENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
36: ,calculation_formula_id NUMBER := OKC_API.G_MISS_NUM
37: ,catchup_basis_code OKL_K_RATE_PARAMS_V.CATCHUP_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 35: ,compounding_frequency_code OKL_K_RATE_PARAMS_V.COMPOUNDING_FREQUENCY_CODE%TYPE := OKC_API.G_MISS_CHAR

31: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE
33: ,rate_delay_code OKL_K_RATE_PARAMS_V.RATE_DELAY_CODE%TYPE := OKC_API.G_MISS_CHAR
34: ,rate_delay_frequency NUMBER := OKC_API.G_MISS_NUM
35: ,compounding_frequency_code OKL_K_RATE_PARAMS_V.COMPOUNDING_FREQUENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
36: ,calculation_formula_id NUMBER := OKC_API.G_MISS_NUM
37: ,catchup_basis_code OKL_K_RATE_PARAMS_V.CATCHUP_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,catchup_start_date OKL_K_RATE_PARAMS_V.CATCHUP_START_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,catchup_settlement_code OKL_K_RATE_PARAMS_V.CATCHUP_SETTLEMENT_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 37: ,catchup_basis_code OKL_K_RATE_PARAMS_V.CATCHUP_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR

33: ,rate_delay_code OKL_K_RATE_PARAMS_V.RATE_DELAY_CODE%TYPE := OKC_API.G_MISS_CHAR
34: ,rate_delay_frequency NUMBER := OKC_API.G_MISS_NUM
35: ,compounding_frequency_code OKL_K_RATE_PARAMS_V.COMPOUNDING_FREQUENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
36: ,calculation_formula_id NUMBER := OKC_API.G_MISS_NUM
37: ,catchup_basis_code OKL_K_RATE_PARAMS_V.CATCHUP_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,catchup_start_date OKL_K_RATE_PARAMS_V.CATCHUP_START_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,catchup_settlement_code OKL_K_RATE_PARAMS_V.CATCHUP_SETTLEMENT_CODE%TYPE := OKC_API.G_MISS_CHAR
40: ,rate_change_start_date OKL_K_RATE_PARAMS_V.RATE_CHANGE_START_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,rate_change_frequency_code OKL_K_RATE_PARAMS_V.RATE_CHANGE_FREQUENCY_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 38: ,catchup_start_date OKL_K_RATE_PARAMS_V.CATCHUP_START_DATE%TYPE := OKC_API.G_MISS_DATE

34: ,rate_delay_frequency NUMBER := OKC_API.G_MISS_NUM
35: ,compounding_frequency_code OKL_K_RATE_PARAMS_V.COMPOUNDING_FREQUENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
36: ,calculation_formula_id NUMBER := OKC_API.G_MISS_NUM
37: ,catchup_basis_code OKL_K_RATE_PARAMS_V.CATCHUP_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,catchup_start_date OKL_K_RATE_PARAMS_V.CATCHUP_START_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,catchup_settlement_code OKL_K_RATE_PARAMS_V.CATCHUP_SETTLEMENT_CODE%TYPE := OKC_API.G_MISS_CHAR
40: ,rate_change_start_date OKL_K_RATE_PARAMS_V.RATE_CHANGE_START_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,rate_change_frequency_code OKL_K_RATE_PARAMS_V.RATE_CHANGE_FREQUENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,rate_change_value NUMBER := OKC_API.G_MISS_NUM

Line 39: ,catchup_settlement_code OKL_K_RATE_PARAMS_V.CATCHUP_SETTLEMENT_CODE%TYPE := OKC_API.G_MISS_CHAR

35: ,compounding_frequency_code OKL_K_RATE_PARAMS_V.COMPOUNDING_FREQUENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
36: ,calculation_formula_id NUMBER := OKC_API.G_MISS_NUM
37: ,catchup_basis_code OKL_K_RATE_PARAMS_V.CATCHUP_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,catchup_start_date OKL_K_RATE_PARAMS_V.CATCHUP_START_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,catchup_settlement_code OKL_K_RATE_PARAMS_V.CATCHUP_SETTLEMENT_CODE%TYPE := OKC_API.G_MISS_CHAR
40: ,rate_change_start_date OKL_K_RATE_PARAMS_V.RATE_CHANGE_START_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,rate_change_frequency_code OKL_K_RATE_PARAMS_V.RATE_CHANGE_FREQUENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,rate_change_value NUMBER := OKC_API.G_MISS_NUM
43: );

Line 40: ,rate_change_start_date OKL_K_RATE_PARAMS_V.RATE_CHANGE_START_DATE%TYPE := OKC_API.G_MISS_DATE

36: ,calculation_formula_id NUMBER := OKC_API.G_MISS_NUM
37: ,catchup_basis_code OKL_K_RATE_PARAMS_V.CATCHUP_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,catchup_start_date OKL_K_RATE_PARAMS_V.CATCHUP_START_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,catchup_settlement_code OKL_K_RATE_PARAMS_V.CATCHUP_SETTLEMENT_CODE%TYPE := OKC_API.G_MISS_CHAR
40: ,rate_change_start_date OKL_K_RATE_PARAMS_V.RATE_CHANGE_START_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,rate_change_frequency_code OKL_K_RATE_PARAMS_V.RATE_CHANGE_FREQUENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,rate_change_value NUMBER := OKC_API.G_MISS_NUM
43: );
44:

Line 41: ,rate_change_frequency_code OKL_K_RATE_PARAMS_V.RATE_CHANGE_FREQUENCY_CODE%TYPE := OKC_API.G_MISS_CHAR

37: ,catchup_basis_code OKL_K_RATE_PARAMS_V.CATCHUP_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,catchup_start_date OKL_K_RATE_PARAMS_V.CATCHUP_START_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,catchup_settlement_code OKL_K_RATE_PARAMS_V.CATCHUP_SETTLEMENT_CODE%TYPE := OKC_API.G_MISS_CHAR
40: ,rate_change_start_date OKL_K_RATE_PARAMS_V.RATE_CHANGE_START_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,rate_change_frequency_code OKL_K_RATE_PARAMS_V.RATE_CHANGE_FREQUENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,rate_change_value NUMBER := OKC_API.G_MISS_NUM
43: );
44:
45: TYPE krpc_rec_type IS RECORD (

Line 47: ,parameter_type_code OKL_K_RATE_PARAMS_V.PARAMETER_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR

43: );
44:
45: TYPE krpc_rec_type IS RECORD (
46: khr_id NUMBER := OKC_API.G_MISS_NUM
47: ,parameter_type_code OKL_K_RATE_PARAMS_V.PARAMETER_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
48: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,conversion_option_code OKL_K_RATE_PARAMS_V.CONVERSION_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
51: ,next_conversion_date OKL_K_RATE_PARAMS_V.NEXT_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 48: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE

44:
45: TYPE krpc_rec_type IS RECORD (
46: khr_id NUMBER := OKC_API.G_MISS_NUM
47: ,parameter_type_code OKL_K_RATE_PARAMS_V.PARAMETER_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
48: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,conversion_option_code OKL_K_RATE_PARAMS_V.CONVERSION_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
51: ,next_conversion_date OKL_K_RATE_PARAMS_V.NEXT_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE
52: ,conversion_type_code OKL_K_RATE_PARAMS_V.CONVERSION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 49: ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE

45: TYPE krpc_rec_type IS RECORD (
46: khr_id NUMBER := OKC_API.G_MISS_NUM
47: ,parameter_type_code OKL_K_RATE_PARAMS_V.PARAMETER_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
48: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,conversion_option_code OKL_K_RATE_PARAMS_V.CONVERSION_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
51: ,next_conversion_date OKL_K_RATE_PARAMS_V.NEXT_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE
52: ,conversion_type_code OKL_K_RATE_PARAMS_V.CONVERSION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
53: );

Line 50: ,conversion_option_code OKL_K_RATE_PARAMS_V.CONVERSION_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR

46: khr_id NUMBER := OKC_API.G_MISS_NUM
47: ,parameter_type_code OKL_K_RATE_PARAMS_V.PARAMETER_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
48: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,conversion_option_code OKL_K_RATE_PARAMS_V.CONVERSION_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
51: ,next_conversion_date OKL_K_RATE_PARAMS_V.NEXT_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE
52: ,conversion_type_code OKL_K_RATE_PARAMS_V.CONVERSION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
53: );
54:

Line 51: ,next_conversion_date OKL_K_RATE_PARAMS_V.NEXT_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE

47: ,parameter_type_code OKL_K_RATE_PARAMS_V.PARAMETER_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
48: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,conversion_option_code OKL_K_RATE_PARAMS_V.CONVERSION_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
51: ,next_conversion_date OKL_K_RATE_PARAMS_V.NEXT_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE
52: ,conversion_type_code OKL_K_RATE_PARAMS_V.CONVERSION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
53: );
54:
55: TYPE var_prm_rec_type is RECORD (

Line 52: ,conversion_type_code OKL_K_RATE_PARAMS_V.CONVERSION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR

48: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,effective_to_date OKL_K_RATE_PARAMS_V.EFFECTIVE_TO_DATE%TYPE := OKC_API.G_MISS_DATE
50: ,conversion_option_code OKL_K_RATE_PARAMS_V.CONVERSION_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
51: ,next_conversion_date OKL_K_RATE_PARAMS_V.NEXT_CONVERSION_DATE%TYPE := OKC_API.G_MISS_DATE
52: ,conversion_type_code OKL_K_RATE_PARAMS_V.CONVERSION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
53: );
54:
55: TYPE var_prm_rec_type is RECORD (
56: param_identifier FND_LOOKUPS.LOOKUP_CODE%TYPE,

Line 58: parameter_type_code OKL_K_RATE_PARAMS.PARAMETER_TYPE_CODE%TYPE,

54:
55: TYPE var_prm_rec_type is RECORD (
56: param_identifier FND_LOOKUPS.LOOKUP_CODE%TYPE,
57: param_identifier_meaning FND_LOOKUPS.MEANING%TYPE,
58: parameter_type_code OKL_K_RATE_PARAMS.PARAMETER_TYPE_CODE%TYPE,
59: interest_index_id OKL_K_RATE_PARAMS.INTEREST_INDEX_ID%TYPE,
60: effective_from_date OKL_K_RATE_PARAMS.EFFECTIVE_FROM_DATE%TYPE,
61: effective_to_date OKL_K_RATE_PARAMS.EFFECTIVE_TO_DATE%TYPE
62: );

Line 59: interest_index_id OKL_K_RATE_PARAMS.INTEREST_INDEX_ID%TYPE,

55: TYPE var_prm_rec_type is RECORD (
56: param_identifier FND_LOOKUPS.LOOKUP_CODE%TYPE,
57: param_identifier_meaning FND_LOOKUPS.MEANING%TYPE,
58: parameter_type_code OKL_K_RATE_PARAMS.PARAMETER_TYPE_CODE%TYPE,
59: interest_index_id OKL_K_RATE_PARAMS.INTEREST_INDEX_ID%TYPE,
60: effective_from_date OKL_K_RATE_PARAMS.EFFECTIVE_FROM_DATE%TYPE,
61: effective_to_date OKL_K_RATE_PARAMS.EFFECTIVE_TO_DATE%TYPE
62: );
63:

Line 60: effective_from_date OKL_K_RATE_PARAMS.EFFECTIVE_FROM_DATE%TYPE,

56: param_identifier FND_LOOKUPS.LOOKUP_CODE%TYPE,
57: param_identifier_meaning FND_LOOKUPS.MEANING%TYPE,
58: parameter_type_code OKL_K_RATE_PARAMS.PARAMETER_TYPE_CODE%TYPE,
59: interest_index_id OKL_K_RATE_PARAMS.INTEREST_INDEX_ID%TYPE,
60: effective_from_date OKL_K_RATE_PARAMS.EFFECTIVE_FROM_DATE%TYPE,
61: effective_to_date OKL_K_RATE_PARAMS.EFFECTIVE_TO_DATE%TYPE
62: );
63:
64: TYPE var_prm_tbl_type IS TABLE OF var_prm_rec_type INDEX BY BINARY_INTEGER;

Line 61: effective_to_date OKL_K_RATE_PARAMS.EFFECTIVE_TO_DATE%TYPE

57: param_identifier_meaning FND_LOOKUPS.MEANING%TYPE,
58: parameter_type_code OKL_K_RATE_PARAMS.PARAMETER_TYPE_CODE%TYPE,
59: interest_index_id OKL_K_RATE_PARAMS.INTEREST_INDEX_ID%TYPE,
60: effective_from_date OKL_K_RATE_PARAMS.EFFECTIVE_FROM_DATE%TYPE,
61: effective_to_date OKL_K_RATE_PARAMS.EFFECTIVE_TO_DATE%TYPE
62: );
63:
64: TYPE var_prm_tbl_type IS TABLE OF var_prm_rec_type INDEX BY BINARY_INTEGER;
65:

Line 73: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_K_RATE_PARAMS_PVT';

69: subtype krpv_tbl_type is OKL_KRP_PVT.krpv_tbl_type;
70:
71: -- GLOBAL VARIABLES
72:
73: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_K_RATE_PARAMS_PVT';
74: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
75:
76: procedure get_product(
77: p_api_version IN NUMBER,

Line 278: END OKL_K_RATE_PARAMS_PVT;

274: x_msg_count OUT NOCOPY NUMBER,
275: x_msg_data OUT NOCOPY VARCHAR2,
276: p_khr_id IN NUMBER);
277:
278: END OKL_K_RATE_PARAMS_PVT;