DBA Data[Home] [Help]

APPS.OKL_POPULATE_PRCENG_RESULT_PUB dependencies on OKC_API

Line 40: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,

36: -- mvasudev, 04/24/2002 added
37: PROCEDURE populate_sif_rets (
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_id OUT NOCOPY NUMBER,
40: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
41: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
42: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
43: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
44: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

Line 41: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,

37: PROCEDURE populate_sif_rets (
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_id OUT NOCOPY NUMBER,
40: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
41: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
42: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
43: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
44: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
45: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 42: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

38: x_return_status OUT NOCOPY VARCHAR2,
39: x_id OUT NOCOPY NUMBER,
40: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
41: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
42: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
43: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
44: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
45: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
46: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 43: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,

39: x_id OUT NOCOPY NUMBER,
40: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
41: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
42: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
43: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
44: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
45: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
46: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
47: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

Line 44: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

40: p_transaction_number IN NUMBER := OKC_API.G_MISS_NUM,
41: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
42: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
43: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
44: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
45: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
46: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
47: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
48: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM

Line 45: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

41: p_srt_code IN OKL_SIF_RETS.SRT_CODE%TYPE := OKC_API.G_MISS_CHAR,
42: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
43: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
44: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
45: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
46: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
47: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
48: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
49: );

Line 46: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

42: p_effective_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
43: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
44: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
45: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
46: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
47: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
48: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
49: );
50: -- mvasudev, 04/24/2002 end

Line 47: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,

43: p_yield_name IN OKL_SIF_RETS.YIELD_NAME%TYPE := OKC_API.G_MISS_CHAR,
44: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
45: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
46: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
47: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
48: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
49: );
50: -- mvasudev, 04/24/2002 end
51:

Line 48: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM

44: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
45: p_effective_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
46: p_nominal_pre_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
47: p_nominal_after_tax_yield IN NUMBER := OKC_API.G_MISS_NUM,
48: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM
49: );
50: -- mvasudev, 04/24/2002 end
51:
52: -- mvasudev, 04/24/2002 added

Line 56: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM);

52: -- mvasudev, 04/24/2002 added
53: PROCEDURE update_sif_rets (
54: x_return_status OUT NOCOPY VARCHAR2,
55: p_id IN NUMBER,
56: p_implicit_interest_rate IN NUMBER := OKC_API.G_MISS_NUM);
57: -- mvasudev, 04/24/2002 end
58:
59: -- mvasudev, 04/24/2002 added
60: PROCEDURE update_sif_rets (

Line 69: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,

65: -- mvasudev, 04/24/2002 end
66:
67: PROCEDURE populate_sif_ret_strms (
68: x_return_status OUT NOCOPY VARCHAR2,
69: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
70: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
71: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
72: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
73: p_amount IN NUMBER := OKC_API.G_MISS_NUM,

Line 70: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,

66:
67: PROCEDURE populate_sif_ret_strms (
68: x_return_status OUT NOCOPY VARCHAR2,
69: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
70: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
71: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
72: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
73: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
74: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM);

Line 71: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

67: PROCEDURE populate_sif_ret_strms (
68: x_return_status OUT NOCOPY VARCHAR2,
69: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
70: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
71: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
72: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
73: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
74: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM);
75:

Line 72: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,

68: x_return_status OUT NOCOPY VARCHAR2,
69: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
70: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
71: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
72: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
73: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
74: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM);
75:
76: -- mvasudev, 04/24/2002 added

Line 73: p_amount IN NUMBER := OKC_API.G_MISS_NUM,

69: p_stream_type_name IN OKL_SIF_RET_STRMS.STREAM_TYPE_NAME%TYPE := OKC_API.G_MISS_CHAR,
70: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
71: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
72: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
73: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
74: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM);
75:
76: -- mvasudev, 04/24/2002 added
77: PROCEDURE populate_sif_ret_errors (

Line 74: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM);

70: p_description IN VARCHAR2 := OKC_API.G_MISS_CHAR,
71: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
72: p_sre_date IN VARCHAR2 := OKC_API.G_MISS_CHAR,
73: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
74: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM);
75:
76: -- mvasudev, 04/24/2002 added
77: PROCEDURE populate_sif_ret_errors (
78: x_return_status OUT NOCOPY VARCHAR2,

Line 80: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,

76: -- mvasudev, 04/24/2002 added
77: PROCEDURE populate_sif_ret_errors (
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_id OUT NOCOPY NUMBER,
80: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
81: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
82: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
83: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
84: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,

Line 81: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,

77: PROCEDURE populate_sif_ret_errors (
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_id OUT NOCOPY NUMBER,
80: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
81: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
82: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
83: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
84: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
85: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,

Line 82: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,

78: x_return_status OUT NOCOPY VARCHAR2,
79: x_id OUT NOCOPY NUMBER,
80: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
81: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
82: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
83: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
84: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
85: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
86: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);

Line 83: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,

79: x_id OUT NOCOPY NUMBER,
80: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
81: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
82: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
83: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
84: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
85: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
86: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
87: -- mvasudev, 04/24/2002 end

Line 84: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,

80: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
81: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
82: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
83: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
84: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
85: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
86: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
87: -- mvasudev, 04/24/2002 end
88:

Line 85: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,

81: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
82: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
83: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
84: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
85: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
86: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
87: -- mvasudev, 04/24/2002 end
88:
89: -- mvasudev, 04/24/2002 added

Line 86: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);

82: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
83: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
84: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
85: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
86: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR);
87: -- mvasudev, 04/24/2002 end
88:
89: -- mvasudev, 04/24/2002 added
90: PROCEDURE populate_insured_residual (

Line 117: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,

113: x_return_status OUT NOCOPY VARCHAR2
114: );
115:
116: PROCEDURE populate_sif_ret_levels (
117: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
118: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
119: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
120: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
121: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,

Line 118: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,

114: );
115:
116: PROCEDURE populate_sif_ret_levels (
117: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
118: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
119: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
120: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
121: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
122: p_amount IN NUMBER := OKC_API.G_MISS_NUM,

Line 119: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,

115:
116: PROCEDURE populate_sif_ret_levels (
117: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
118: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
119: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
120: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
121: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
122: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
123: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,

Line 120: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,

116: PROCEDURE populate_sif_ret_levels (
117: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
118: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
119: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
120: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
121: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
122: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
123: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
124: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,

Line 121: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,

117: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
118: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
119: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
120: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
121: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
122: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
123: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
124: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
125: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,

Line 122: p_amount IN NUMBER := OKC_API.G_MISS_NUM,

118: p_index_number IN NUMBER := OKC_API.G_MISS_NUM,
119: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
120: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
121: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
122: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
123: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
124: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
125: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
126: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,

Line 123: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,

119: p_level_index_number IN NUMBER := OKC_API.G_MISS_NUM,
120: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
121: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
122: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
123: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
124: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
125: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
126: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,
127: p_first_payment_date IN VARCHAR2,

Line 124: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,

120: p_number_of_periods IN NUMBER := OKC_API.G_MISS_NUM,
121: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
122: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
123: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
124: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
125: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
126: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,
127: p_first_payment_date IN VARCHAR2,
128: p_rate IN NUMBER := OKC_API.G_MISS_NUM,

Line 125: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,

121: p_level_type IN OKL_SIF_RET_LEVELS.LEVEL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
122: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
123: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
124: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
125: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
126: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,
127: p_first_payment_date IN VARCHAR2,
128: p_rate IN NUMBER := OKC_API.G_MISS_NUM,
129: x_return_status OUT NOCOPY VARCHAR2

Line 126: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,

122: p_amount IN NUMBER := OKC_API.G_MISS_NUM,
123: p_advance_or_arrears IN OKL_SIF_RET_LEVELS.ADVANCE_OR_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
124: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
125: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
126: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,
127: p_first_payment_date IN VARCHAR2,
128: p_rate IN NUMBER := OKC_API.G_MISS_NUM,
129: x_return_status OUT NOCOPY VARCHAR2
130: );

Line 128: p_rate IN NUMBER := OKC_API.G_MISS_NUM,

124: p_period IN OKL_SIF_RET_LEVELS.PERIOD%TYPE := OKC_API.G_MISS_CHAR,
125: p_lock_level_step IN OKL_SIF_RET_LEVELS.LOCK_LEVEL_STEP%TYPE := OKC_API.G_MISS_CHAR,
126: p_days_in_period IN NUMBER := OKC_API.G_MISS_NUM,
127: p_first_payment_date IN VARCHAR2,
128: p_rate IN NUMBER := OKC_API.G_MISS_NUM,
129: x_return_status OUT NOCOPY VARCHAR2
130: );
131:
132: FUNCTION correct_feb_date (p_date VARCHAR2)