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_STRM_TYPE_V

Line 47: G_STRM_RENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'RENT';

43:
44: G_RRM_EST_ACTUAL CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ESTIMATED_AND_ACTUAL';
45: G_RRM_ACTUAL CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ACTUAL';
46:
47: G_STRM_RENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'RENT';
48: G_STRM_RENT_ACCRUAL CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'RENT_ACCRUAL';
49: G_STRM_PRE_TAX CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LEASE_INCOME';
50: G_STRM_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'INTEREST_INCOME';
51: G_STRM_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LOAN_PAYMENT';

Line 48: G_STRM_RENT_ACCRUAL CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'RENT_ACCRUAL';

44: G_RRM_EST_ACTUAL CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ESTIMATED_AND_ACTUAL';
45: G_RRM_ACTUAL CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ACTUAL';
46:
47: G_STRM_RENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'RENT';
48: G_STRM_RENT_ACCRUAL CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'RENT_ACCRUAL';
49: G_STRM_PRE_TAX CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LEASE_INCOME';
50: G_STRM_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'INTEREST_INCOME';
51: G_STRM_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LOAN_PAYMENT';
52: G_STRM_VAR_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_INTEREST_INCOME';

Line 49: G_STRM_PRE_TAX CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LEASE_INCOME';

45: G_RRM_ACTUAL CONSTANT OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE := 'ACTUAL';
46:
47: G_STRM_RENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'RENT';
48: G_STRM_RENT_ACCRUAL CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'RENT_ACCRUAL';
49: G_STRM_PRE_TAX CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LEASE_INCOME';
50: G_STRM_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'INTEREST_INCOME';
51: G_STRM_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LOAN_PAYMENT';
52: G_STRM_VAR_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_INTEREST_INCOME';
53:

Line 50: G_STRM_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'INTEREST_INCOME';

46:
47: G_STRM_RENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'RENT';
48: G_STRM_RENT_ACCRUAL CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'RENT_ACCRUAL';
49: G_STRM_PRE_TAX CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LEASE_INCOME';
50: G_STRM_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'INTEREST_INCOME';
51: G_STRM_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LOAN_PAYMENT';
52: G_STRM_VAR_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_INTEREST_INCOME';
53:
54: G_COL_NAME CONSTANT VARCHAR2(30) := OKC_API.G_COL_NAME_TOKEN;

Line 51: G_STRM_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LOAN_PAYMENT';

47: G_STRM_RENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'RENT';
48: G_STRM_RENT_ACCRUAL CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'RENT_ACCRUAL';
49: G_STRM_PRE_TAX CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LEASE_INCOME';
50: G_STRM_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'INTEREST_INCOME';
51: G_STRM_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LOAN_PAYMENT';
52: G_STRM_VAR_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_INTEREST_INCOME';
53:
54: G_COL_NAME CONSTANT VARCHAR2(30) := OKC_API.G_COL_NAME_TOKEN;
55: G_DUE_DATE CONSTANT VARCHAR2(30) := 'DUE_DATE';

Line 52: G_STRM_VAR_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_INTEREST_INCOME';

48: G_STRM_RENT_ACCRUAL CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'RENT_ACCRUAL';
49: G_STRM_PRE_TAX CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LEASE_INCOME';
50: G_STRM_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'INTEREST_INCOME';
51: G_STRM_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LOAN_PAYMENT';
52: G_STRM_VAR_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_INTEREST_INCOME';
53:
54: G_COL_NAME CONSTANT VARCHAR2(30) := OKC_API.G_COL_NAME_TOKEN;
55: G_DUE_DATE CONSTANT VARCHAR2(30) := 'DUE_DATE';
56: -- smadhava Bug#4542290 - 22-Aug-2005 - Added - End

Line 987: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS

983:
984: --Cursor to query the last billed due date of the stream.
985: CURSOR get_last_billed_due_date(
986: p_chr_id OKC_K_HEADERS_B.ID%TYPE
987: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
988: SELECT MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
989: FROM OKL_STRM_ELEMENTS STE
990: , OKL_STREAMS STM
991: , OKL_STRM_TYPE_V STY

Line 991: , OKL_STRM_TYPE_V STY

987: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
988: SELECT MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
989: FROM OKL_STRM_ELEMENTS STE
990: , OKL_STREAMS STM
991: , OKL_STRM_TYPE_V STY
992: , OKL_K_HEADERS KHR
993: , OKC_K_HEADERS_B CHR
994: WHERE STM.ID = STE.STM_ID
995: AND STY.ID = STM.STY_ID

Line 3702: l_stream_name OKL_STRM_TYPE_V.STYB_PURPOSE_MEANING%TYPE;

3698: l_interest_calc_meaning OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_MEANING%TYPE;
3699: l_rev_recog_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE;
3700: --l_rev_recog_meaning OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_MEANING%TYPE;
3701: l_interest_proc_date OKL_K_HEADERS.DATE_LAST_INTERIM_INTEREST_CAL%TYPE;
3702: l_stream_name OKL_STRM_TYPE_V.STYB_PURPOSE_MEANING%TYPE;
3703:
3704: l_last_accrued_due_date DATE;
3705: l_last_billed_due_date DATE;
3706:

Line 3751: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS

3747:
3748: --Cursor to query the last accrued due date of the stream.
3749: CURSOR get_last_accrued_due_date(
3750: p_chr_id OKC_K_HEADERS_B.ID%TYPE
3751: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
3752: SELECT
3753: MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
3754: , STY.STYB_PURPOSE_MEANING
3755: FROM

Line 3758: , OKL_STRM_TYPE_V STY

3754: , STY.STYB_PURPOSE_MEANING
3755: FROM
3756: OKL_STRM_ELEMENTS STE
3757: , OKL_STREAMS STM
3758: , OKL_STRM_TYPE_V STY
3759: , OKL_K_HEADERS KHR
3760: , OKC_K_HEADERS_B CHR
3761: WHERE
3762: STM.ID = STE.STM_ID

Line 3774: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS

3770:
3771: --Cursor to query the last billed due date of the stream.
3772: CURSOR get_last_billed_due_date(
3773: p_chr_id OKC_K_HEADERS_B.ID%TYPE
3774: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
3775: SELECT
3776: MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
3777: , STY.STYB_PURPOSE_MEANING
3778: FROM

Line 3781: , OKL_STRM_TYPE_V STY

3777: , STY.STYB_PURPOSE_MEANING
3778: FROM
3779: OKL_STRM_ELEMENTS STE
3780: , OKL_STREAMS STM
3781: , OKL_STRM_TYPE_V STY
3782: , OKL_K_HEADERS KHR
3783: , OKC_K_HEADERS_B CHR
3784: WHERE
3785: STM.ID = STE.STM_ID

Line 4854: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS

4850:
4851: --Cursor to query the last billed due date of the stream.
4852: CURSOR get_last_billed_due_date(
4853: p_chr_id OKC_K_HEADERS_B.ID%TYPE
4854: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
4855: SELECT
4856: MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
4857: --, STY.STYB_PURPOSE_MEANING
4858: FROM

Line 4861: , OKL_STRM_TYPE_V STY

4857: --, STY.STYB_PURPOSE_MEANING
4858: FROM
4859: OKL_STRM_ELEMENTS STE
4860: , OKL_STREAMS STM
4861: , OKL_STRM_TYPE_V STY
4862: , OKL_K_HEADERS KHR
4863: , OKC_K_HEADERS_B CHR
4864: WHERE
4865: STM.ID = STE.STM_ID