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 50: G_STRM_RENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'RENT';

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';
53: G_STRM_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'INTEREST_INCOME';
54: G_STRM_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LOAN_PAYMENT';

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

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';
53: G_STRM_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'INTEREST_INCOME';
54: G_STRM_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LOAN_PAYMENT';
55: G_STRM_VAR_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_INTEREST_INCOME';

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

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';
53: G_STRM_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'INTEREST_INCOME';
54: G_STRM_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LOAN_PAYMENT';
55: G_STRM_VAR_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_INTEREST_INCOME';
56: /* 13394074 */

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

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';
53: G_STRM_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'INTEREST_INCOME';
54: G_STRM_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LOAN_PAYMENT';
55: G_STRM_VAR_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_INTEREST_INCOME';
56: /* 13394074 */
57: G_STRM_VAR_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_LOAN_PAYMENT';

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

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';
53: G_STRM_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'INTEREST_INCOME';
54: G_STRM_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LOAN_PAYMENT';
55: G_STRM_VAR_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_INTEREST_INCOME';
56: /* 13394074 */
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';

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

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';
53: G_STRM_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'INTEREST_INCOME';
54: G_STRM_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LOAN_PAYMENT';
55: G_STRM_VAR_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_INTEREST_INCOME';
56: /* 13394074 */
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';

Line 57: G_STRM_VAR_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_LOAN_PAYMENT';

53: G_STRM_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'INTEREST_INCOME';
54: G_STRM_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LOAN_PAYMENT';
55: G_STRM_VAR_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_INTEREST_INCOME';
56: /* 13394074 */
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';

Line 58: G_STRM_VAR_INT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_INTEREST';

54: G_STRM_LOAN_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'LOAN_PAYMENT';
55: G_STRM_VAR_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_INTEREST_INCOME';
56: /* 13394074 */
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 */

Line 59: G_STRM_PRINCIPAL_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'PRINCIPAL_PAYMENT';

55: G_STRM_VAR_INT_INCOME CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'VARIABLE_INTEREST_INCOME';
56: /* 13394074 */
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:

Line 60: G_STRM_INTEREST_PAYMENT CONSTANT OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE := 'INTEREST_PAYMENT';

56: /* 13394074 */
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;

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

993:
994: --Cursor to query the last billed due date of the stream.
995: CURSOR get_last_billed_due_date(
996: p_chr_id OKC_K_HEADERS_B.ID%TYPE
997: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
998: SELECT MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
999: FROM OKL_STRM_ELEMENTS STE
1000: , OKL_STREAMS STM
1001: , OKL_STRM_TYPE_V STY

Line 1001: , OKL_STRM_TYPE_V STY

997: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
998: SELECT MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
999: FROM OKL_STRM_ELEMENTS STE
1000: , OKL_STREAMS STM
1001: , OKL_STRM_TYPE_V STY
1002: , OKL_K_HEADERS KHR
1003: , OKC_K_HEADERS_B CHR
1004: WHERE STM.ID = STE.STM_ID
1005: AND STY.ID = STM.STY_ID

Line 3712: l_stream_name OKL_STRM_TYPE_V.STYB_PURPOSE_MEANING%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;
3715: l_last_billed_due_date DATE;
3716:

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

3758: --Cursor to query the last accrued due date of the stream.
3759: --Bug# 9058664: Corrected GROUP BY clause
3760: CURSOR get_last_accrued_due_date(
3761: p_chr_id OKC_K_HEADERS_B.ID%TYPE
3762: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
3763: SELECT
3764: MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
3765: , STY.STYB_PURPOSE_MEANING
3766: FROM

Line 3769: , OKL_STRM_TYPE_V STY

3765: , STY.STYB_PURPOSE_MEANING
3766: FROM
3767: OKL_STRM_ELEMENTS STE
3768: , OKL_STREAMS STM
3769: , OKL_STRM_TYPE_V STY
3770: , OKL_K_HEADERS KHR
3771: , OKC_K_HEADERS_B CHR
3772: WHERE
3773: STM.ID = STE.STM_ID

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

3782: --Cursor to query the last billed due date of the stream.
3783: --Bug# 9058664: Corrected GROUP BY clause
3784: CURSOR get_last_billed_due_date(
3785: p_chr_id OKC_K_HEADERS_B.ID%TYPE
3786: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
3787: SELECT
3788: MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
3789: , STY.STYB_PURPOSE_MEANING
3790: FROM

Line 3793: , OKL_STRM_TYPE_V STY

3789: , STY.STYB_PURPOSE_MEANING
3790: FROM
3791: OKL_STRM_ELEMENTS STE
3792: , OKL_STREAMS STM
3793: , OKL_STRM_TYPE_V STY
3794: , OKL_K_HEADERS KHR
3795: , OKC_K_HEADERS_B CHR
3796: WHERE
3797: STM.ID = STE.STM_ID

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

4947:
4948: --Cursor to query the last billed due date of the stream.
4949: CURSOR get_last_billed_due_date(
4950: p_chr_id OKC_K_HEADERS_B.ID%TYPE
4951: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
4952: SELECT
4953: MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
4954: --, STY.STYB_PURPOSE_MEANING
4955: FROM

Line 4958: , OKL_STRM_TYPE_V STY

4954: --, STY.STYB_PURPOSE_MEANING
4955: FROM
4956: OKL_STRM_ELEMENTS STE
4957: , OKL_STREAMS STM
4958: , OKL_STRM_TYPE_V STY
4959: , OKL_K_HEADERS KHR
4960: , OKC_K_HEADERS_B CHR
4961: WHERE
4962: STM.ID = STE.STM_ID