DBA Data[Home] [Help]

APPS.OKL_K_RATE_PARAMS_PVT dependencies on OKL_PRODUCT_PARAMETERS_V

Line 35: G_BOOK_CLASS_OP CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEOP';

31: G_BOOK_CLASS CONSTANT VARCHAR2(30) := 'BOOK_CLASS';
32: G_INT_CALC_BASIS CONSTANT VARCHAR2(30) := 'INT_CAL';
33: G_STREAM CONSTANT VARCHAR2(30) := 'STREAM';
34:
35: G_BOOK_CLASS_OP CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEOP';
36: G_BOOK_CLASS_DF CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEDF';
37: G_BOOK_CLASS_ST CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEST';
38: G_BOOK_CLASS_LOAN CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LOAN';
39: G_BOOK_CLASS_REVLOAN CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LOAN-REVOLVING';

Line 36: G_BOOK_CLASS_DF CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEDF';

32: G_INT_CALC_BASIS CONSTANT VARCHAR2(30) := 'INT_CAL';
33: G_STREAM CONSTANT VARCHAR2(30) := 'STREAM';
34:
35: G_BOOK_CLASS_OP CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEOP';
36: G_BOOK_CLASS_DF CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEDF';
37: G_BOOK_CLASS_ST CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEST';
38: G_BOOK_CLASS_LOAN CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LOAN';
39: G_BOOK_CLASS_REVLOAN CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LOAN-REVOLVING';
40:

Line 37: G_BOOK_CLASS_ST CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEST';

33: G_STREAM CONSTANT VARCHAR2(30) := 'STREAM';
34:
35: G_BOOK_CLASS_OP CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEOP';
36: G_BOOK_CLASS_DF CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEDF';
37: G_BOOK_CLASS_ST CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEST';
38: G_BOOK_CLASS_LOAN CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LOAN';
39: G_BOOK_CLASS_REVLOAN CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LOAN-REVOLVING';
40:
41: G_ICB_FIXED CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FIXED';

Line 38: G_BOOK_CLASS_LOAN CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LOAN';

34:
35: G_BOOK_CLASS_OP CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEOP';
36: G_BOOK_CLASS_DF CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEDF';
37: G_BOOK_CLASS_ST CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEST';
38: G_BOOK_CLASS_LOAN CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LOAN';
39: G_BOOK_CLASS_REVLOAN CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LOAN-REVOLVING';
40:
41: G_ICB_FIXED CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FIXED';
42: G_ICB_FLOAT_FACTOR CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FLOAT_FACTORS';

Line 39: G_BOOK_CLASS_REVLOAN CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LOAN-REVOLVING';

35: G_BOOK_CLASS_OP CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEOP';
36: G_BOOK_CLASS_DF CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEDF';
37: G_BOOK_CLASS_ST CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEST';
38: G_BOOK_CLASS_LOAN CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LOAN';
39: G_BOOK_CLASS_REVLOAN CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LOAN-REVOLVING';
40:
41: G_ICB_FIXED CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FIXED';
42: G_ICB_FLOAT_FACTOR CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FLOAT_FACTORS';
43: G_ICB_FLOAT CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FLOAT';

Line 41: G_ICB_FIXED CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FIXED';

37: G_BOOK_CLASS_ST CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LEASEST';
38: G_BOOK_CLASS_LOAN CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LOAN';
39: G_BOOK_CLASS_REVLOAN CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LOAN-REVOLVING';
40:
41: G_ICB_FIXED CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FIXED';
42: G_ICB_FLOAT_FACTOR CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FLOAT_FACTORS';
43: G_ICB_FLOAT CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FLOAT';
44: G_ICB_REAMORT CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'REAMORT';
45: G_ICB_CATCHUP_CLEANUP CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'CATCHUP/CLEANUP';

Line 42: G_ICB_FLOAT_FACTOR CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FLOAT_FACTORS';

38: G_BOOK_CLASS_LOAN CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LOAN';
39: G_BOOK_CLASS_REVLOAN CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LOAN-REVOLVING';
40:
41: G_ICB_FIXED CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FIXED';
42: G_ICB_FLOAT_FACTOR CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FLOAT_FACTORS';
43: G_ICB_FLOAT CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FLOAT';
44: G_ICB_REAMORT CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'REAMORT';
45: G_ICB_CATCHUP_CLEANUP CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'CATCHUP/CLEANUP';
46:

Line 43: G_ICB_FLOAT CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FLOAT';

39: G_BOOK_CLASS_REVLOAN CONSTANT OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE := 'LOAN-REVOLVING';
40:
41: G_ICB_FIXED CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FIXED';
42: G_ICB_FLOAT_FACTOR CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FLOAT_FACTORS';
43: G_ICB_FLOAT CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FLOAT';
44: G_ICB_REAMORT CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'REAMORT';
45: G_ICB_CATCHUP_CLEANUP CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'CATCHUP/CLEANUP';
46:
47: G_RRM_EST_ACTUAL CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ESTIMATED_AND_ACTUAL';

Line 44: G_ICB_REAMORT CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'REAMORT';

40:
41: G_ICB_FIXED CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FIXED';
42: G_ICB_FLOAT_FACTOR CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FLOAT_FACTORS';
43: G_ICB_FLOAT CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FLOAT';
44: G_ICB_REAMORT CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'REAMORT';
45: G_ICB_CATCHUP_CLEANUP CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'CATCHUP/CLEANUP';
46:
47: G_RRM_EST_ACTUAL CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ESTIMATED_AND_ACTUAL';
48: G_RRM_ACTUAL CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ACTUAL';

Line 45: G_ICB_CATCHUP_CLEANUP CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'CATCHUP/CLEANUP';

41: G_ICB_FIXED CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FIXED';
42: G_ICB_FLOAT_FACTOR CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FLOAT_FACTORS';
43: G_ICB_FLOAT CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FLOAT';
44: G_ICB_REAMORT CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'REAMORT';
45: G_ICB_CATCHUP_CLEANUP CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'CATCHUP/CLEANUP';
46:
47: G_RRM_EST_ACTUAL CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ESTIMATED_AND_ACTUAL';
48: G_RRM_ACTUAL CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ACTUAL';
49:

Line 47: G_RRM_EST_ACTUAL CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ESTIMATED_AND_ACTUAL';

43: G_ICB_FLOAT CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'FLOAT';
44: G_ICB_REAMORT CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'REAMORT';
45: G_ICB_CATCHUP_CLEANUP CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'CATCHUP/CLEANUP';
46:
47: G_RRM_EST_ACTUAL CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ESTIMATED_AND_ACTUAL';
48: G_RRM_ACTUAL CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ACTUAL';
49:
50: G_STRM_RENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'RENT';
51: G_STRM_RENT_ACCRUAL CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'RENT_ACCRUAL';

Line 48: G_RRM_ACTUAL CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ACTUAL';

44: G_ICB_REAMORT CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'REAMORT';
45: G_ICB_CATCHUP_CLEANUP CONSTANT OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE := 'CATCHUP/CLEANUP';
46:
47: G_RRM_EST_ACTUAL CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ESTIMATED_AND_ACTUAL';
48: G_RRM_ACTUAL CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ACTUAL';
49:
50: G_STRM_RENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'RENT';
51: G_STRM_RENT_ACCRUAL CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'RENT_ACCRUAL';
52: G_STRM_PRE_TAX CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LEASE_INCOME';

Line 61: G_RRM_EST_BILLED CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ESTIMATED_AND_BILLED';

57: G_STRM_VAR_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_LOAN_PAYMENT';
58: G_STRM_VAR_INT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_INTEREST';
59: G_STRM_PRINCIPAL_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'PRINCIPAL_PAYMENT';
60: G_STRM_INTEREST_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'INTEREST_PAYMENT';
61: G_RRM_EST_BILLED CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ESTIMATED_AND_BILLED';
62: /* 13394074 */
63:
64: G_COL_NAME CONSTANT VARCHAR2(30) := OKC_API.G_COL_NAME_TOKEN;
65: G_DUE_DATE CONSTANT VARCHAR2(30) := 'DUE_DATE';

Line 3363: p_deal_type IN okl_product_parameters_v.deal_type%type,

3359: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3360: x_return_status OUT NOCOPY VARCHAR2,
3361: x_msg_count OUT NOCOPY NUMBER,
3362: x_msg_data OUT NOCOPY VARCHAR2,
3363: p_deal_type IN okl_product_parameters_v.deal_type%type,
3364: p_rev_rec_method IN okl_product_parameters_v.revenue_recognition_method%type,
3365: p_int_calc_basis IN okl_product_parameters_v.interest_calculation_basis%type,
3366: p_column_name IN VARCHAR2,
3367: p_krpv_rec IN OUT NOCOPY krpv_rec_type) IS

Line 3364: p_rev_rec_method IN okl_product_parameters_v.revenue_recognition_method%type,

3360: x_return_status OUT NOCOPY VARCHAR2,
3361: x_msg_count OUT NOCOPY NUMBER,
3362: x_msg_data OUT NOCOPY VARCHAR2,
3363: p_deal_type IN okl_product_parameters_v.deal_type%type,
3364: p_rev_rec_method IN okl_product_parameters_v.revenue_recognition_method%type,
3365: p_int_calc_basis IN okl_product_parameters_v.interest_calculation_basis%type,
3366: p_column_name IN VARCHAR2,
3367: p_krpv_rec IN OUT NOCOPY krpv_rec_type) IS
3368: BEGIN

Line 3365: p_int_calc_basis IN okl_product_parameters_v.interest_calculation_basis%type,

3361: x_msg_count OUT NOCOPY NUMBER,
3362: x_msg_data OUT NOCOPY VARCHAR2,
3363: p_deal_type IN okl_product_parameters_v.deal_type%type,
3364: p_rev_rec_method IN okl_product_parameters_v.revenue_recognition_method%type,
3365: p_int_calc_basis IN okl_product_parameters_v.interest_calculation_basis%type,
3366: p_column_name IN VARCHAR2,
3367: p_krpv_rec IN OUT NOCOPY krpv_rec_type) IS
3368: BEGIN
3369: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 3705: l_book_class OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE;

3701: l_api_name VARCHAR2(30) := 'check_rebook_allowed';
3702: l_api_version NUMBER := 1;
3703:
3704: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
3705: l_book_class OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE;
3706: l_book_class_meaning OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE_MEANING%TYPE;
3707: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE;
3708: l_interest_calc_meaning OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_MEANING%TYPE;
3709: l_rev_recog_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE;

Line 3706: l_book_class_meaning OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE_MEANING%TYPE;

3702: l_api_version NUMBER := 1;
3703:
3704: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
3705: l_book_class OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE;
3706: l_book_class_meaning OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE_MEANING%TYPE;
3707: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE;
3708: l_interest_calc_meaning OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_MEANING%TYPE;
3709: l_rev_recog_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE;
3710: --l_rev_recog_meaning OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_MEANING%TYPE;

Line 3707: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE;

3703:
3704: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
3705: l_book_class OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE;
3706: l_book_class_meaning OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE_MEANING%TYPE;
3707: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE;
3708: l_interest_calc_meaning OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_MEANING%TYPE;
3709: l_rev_recog_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE;
3710: --l_rev_recog_meaning OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_MEANING%TYPE;
3711: l_interest_proc_date OKL_K_HEADERS.DATE_LAST_INTERIM_INTEREST_CAL%TYPE;

Line 3708: l_interest_calc_meaning OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_MEANING%TYPE;

3704: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
3705: l_book_class OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE;
3706: l_book_class_meaning OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE_MEANING%TYPE;
3707: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE;
3708: l_interest_calc_meaning OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_MEANING%TYPE;
3709: l_rev_recog_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE;
3710: --l_rev_recog_meaning OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_MEANING%TYPE;
3711: l_interest_proc_date OKL_K_HEADERS.DATE_LAST_INTERIM_INTEREST_CAL%TYPE;
3712: l_stream_name OKL_STRM_TYPE_V.STYB_PURPOSE_MEANING%TYPE;

Line 3709: l_rev_recog_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE;

3705: l_book_class OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE;
3706: l_book_class_meaning OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE_MEANING%TYPE;
3707: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE;
3708: l_interest_calc_meaning OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_MEANING%TYPE;
3709: l_rev_recog_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE;
3710: --l_rev_recog_meaning OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_MEANING%TYPE;
3711: l_interest_proc_date OKL_K_HEADERS.DATE_LAST_INTERIM_INTEREST_CAL%TYPE;
3712: l_stream_name OKL_STRM_TYPE_V.STYB_PURPOSE_MEANING%TYPE;
3713:

Line 3710: --l_rev_recog_meaning OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_MEANING%TYPE;

3706: l_book_class_meaning OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE_MEANING%TYPE;
3707: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE;
3708: l_interest_calc_meaning OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_MEANING%TYPE;
3709: l_rev_recog_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE;
3710: --l_rev_recog_meaning OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_MEANING%TYPE;
3711: l_interest_proc_date OKL_K_HEADERS.DATE_LAST_INTERIM_INTEREST_CAL%TYPE;
3712: l_stream_name OKL_STRM_TYPE_V.STYB_PURPOSE_MEANING%TYPE;
3713:
3714: l_last_accrued_due_date DATE;

Line 4944: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE;

4940: AND rate.khr_id = contract.id
4941: AND contract.id = lease.id;
4942:
4943: -- Bug 4999888
4944: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE;
4945: l_rev_recog_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE;
4946: l_pdt_params_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
4947:
4948: --Cursor to query the last billed due date of the stream.

Line 4945: l_rev_recog_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE;

4941: AND contract.id = lease.id;
4942:
4943: -- Bug 4999888
4944: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE;
4945: l_rev_recog_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE;
4946: l_pdt_params_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
4947:
4948: --Cursor to query the last billed due date of the stream.
4949: CURSOR get_last_billed_due_date(