DBA Data[Home] [Help]

APPS.OKL_K_RATE_PARAMS_PVT dependencies on OKC_API

Line 4: khr_id NUMBER := OKC_API.G_MISS_NUM

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
6: ,effective_from_date OKL_K_RATE_PARAMS_V.EFFECTIVE_FROM_DATE%TYPE := OKC_API.G_MISS_DATE
7: );
8:

Line 5: ,rate_type VARCHAR2(30) := OKC_API.G_MISS_CHAR

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

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 12: khr_id NUMBER := OKC_API.G_MISS_NUM

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

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 16: ,interest_index_id NUMBER := OKC_API.G_MISS_NUM

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
20: ,maximum_rate NUMBER := OKC_API.G_MISS_NUM

Line 17: ,base_rate 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
20: ,maximum_rate NUMBER := OKC_API.G_MISS_NUM
21: ,minimum_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 19: ,adder_rate NUMBER := OKC_API.G_MISS_NUM

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
23: ,days_in_a_month_code OKL_K_RATE_PARAMS_V.DAYS_IN_A_MONTH_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 20: ,maximum_rate NUMBER := OKC_API.G_MISS_NUM

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

Line 21: ,minimum_rate 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
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

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 29: khr_id NUMBER := OKC_API.G_MISS_NUM

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

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 34: ,rate_delay_frequency 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
38: ,catchup_start_date OKL_K_RATE_PARAMS_V.CATCHUP_START_DATE%TYPE := OKC_API.G_MISS_DATE

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 36: ,calculation_formula_id NUMBER := OKC_API.G_MISS_NUM

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
40: ,rate_change_start_date OKL_K_RATE_PARAMS_V.RATE_CHANGE_START_DATE%TYPE := OKC_API.G_MISS_DATE

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 42: ,rate_change_value NUMBER := OKC_API.G_MISS_NUM

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 (
46: khr_id NUMBER := OKC_API.G_MISS_NUM

Line 46: khr_id NUMBER := OKC_API.G_MISS_NUM

42: ,rate_change_value NUMBER := OKC_API.G_MISS_NUM
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

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 78: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

74: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
75:
76: procedure get_product(
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
81: x_msg_data OUT NOCOPY VARCHAR2,
82: p_khr_id IN okc_k_headers_b.id%type,

Line 88: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

84:
85: /* This is to be called from contract import */
86: PROCEDURE create_k_rate_params(
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2,
92: p_krpv_rec IN krpv_rec_type,

Line 98: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

94: p_validate_flag IN VARCHAR2 DEFAULT 'Y');
95:
96: PROCEDURE create_k_rate_params(
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_krpr_rec IN krpr_rec_type,

Line 107: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

103: x_krpr_rec OUT NOCOPY krpr_rec_type);
104:
105: PROCEDURE create_k_rate_params(
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: p_krpar_rec IN krpar_rec_type,

Line 116: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

112: x_krpar_rec OUT NOCOPY krpar_rec_type);
113:
114: PROCEDURE create_k_rate_params(
115: p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_krpc_rec IN krpc_rec_type,

Line 126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

122:
123: /* For both UI and contract import */
124: PROCEDURE update_k_rate_params(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_krpv_rec IN krpv_rec_type,

Line 135: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

131: x_krpv_rec OUT NOCOPY krpv_rec_type);
132:
133: PROCEDURE update_k_rate_params(
134: p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_krpr_rec IN krpr_rec_type,

Line 144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

140: x_krpr_rec OUT NOCOPY krpr_rec_type);
141:
142: PROCEDURE update_k_rate_params(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_krpar_rec IN krpar_rec_type,

Line 153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

149: x_krpar_rec OUT NOCOPY krpar_rec_type);
150:
151: PROCEDURE update_k_rate_params(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_krpc_rec IN krpc_rec_type,

Line 162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

158: x_krpc_rec OUT NOCOPY krpc_rec_type);
159:
160: PROCEDURE delete_k_rate_params(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_krpdel_tbl IN krpdel_tbl_type);

Line 171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

167:
168: /* For QA checker to call - stack Error messages and no raise exception*/
169: PROCEDURE validate_k_rate_params(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_khr_id IN okc_k_headers_b.id%type,

Line 182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

178:
179: /* For contract import to call */
180: PROCEDURE validate_k_rate_params(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_product_id IN okl_products_v.id%type,

Line 192: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

188: p_validate_flag IN VARCHAR2 DEFAULT 'Y');
189:
190: Procedure generate_rate_summary(
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
196: p_chr_id IN NUMBER,

Line 201: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

197: x_var_par_tbl OUT NOCOPY var_prm_tbl_type);
198:
199: PROCEDURE default_k_rate_params(
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_deal_type IN okl_product_parameters_v.deal_type%type,

Line 213: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

209: p_krpv_rec IN OUT NOCOPY krpv_rec_type);
210:
211: PROCEDURE cascade_contract_start_date(
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
216: x_msg_data OUT NOCOPY VARCHAR2,
217: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

Line 230: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

226:
227: -- smadhava Bug#4542290 - 22-Aug-2005 - Added - Start
228: PROCEDURE check_rebook_allowed (
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
231: x_return_status OUT NOCOPY VARCHAR2,
232: x_msg_count OUT NOCOPY NUMBER,
233: x_msg_data OUT NOCOPY VARCHAR2,
234: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

Line 249: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

245: x_return_status OUT NOCOPY VARCHAR2);
246:
247: PROCEDURE check_principal_payment(
248: p_api_version IN NUMBER,
249: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2,
253: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

Line 260: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

256: FUNCTION get_formula_id(p_name IN VARCHAR2) RETURN NUMBER ;
257:
258: PROCEDURE copy_k_rate_params(
259: p_api_version IN NUMBER,
260: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
261: x_return_status OUT NOCOPY VARCHAR2,
262: x_msg_count OUT NOCOPY NUMBER,
263: x_msg_data OUT NOCOPY VARCHAR2,
264: p_khr_id IN NUMBER,

Line 272: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

268:
269: -- Bug 4917614
270: PROCEDURE SYNC_BASE_RATE(
271: p_api_version IN NUMBER,
272: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
273: x_return_status OUT NOCOPY VARCHAR2,
274: x_msg_count OUT NOCOPY NUMBER,
275: x_msg_data OUT NOCOPY VARCHAR2,
276: p_khr_id IN NUMBER);