APPS.OKL_LA_PAYMENTS_PVT dependencies on OKL_STRMTYP_SOURCE_V

Line 649: FROM OKL_STRMTYP_SOURCE_V STRM

645: l_payment_code varchar2(150) := null;
646: l_slh_id number := null;
647: cursor PAYMENT_TYPE_CSR(P_ID IN VARCHAR2) is
648: SELECT STRM.STREAM_TYPE_PURPOSE
649: FROM OKL_STRMTYP_SOURCE_V STRM
650: WHERE TO_CHAR(STRM.ID1) = P_ID;
651:
652: BEGIN
653: if(p_stream_id is null or p_stream_id = '') then return false; end if;

Line 670: FROM OKL_STRMTYP_SOURCE_V STRM,

666: l_flag varchar2(1) := null;
667: l_slh_id number := null;
668: cursor PAYMENT_TYPE_CSR(P_ID IN VARCHAR2) is
669: SELECT 'Y'
670: FROM OKL_STRMTYP_SOURCE_V STRM,
671: OKC_RULES_B RL
672: WHERE RL.ID = P_ID
673: AND TO_CHAR(STRM.ID1) = RL.OBJECT1_ID1
674: AND STRM.STREAM_TYPE_PURPOSE = 'UNSCHEDULED_PRINCIPAL_PAYMENT';

Line 1672: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,

1668: x_msg_data OUT NOCOPY VARCHAR2,
1669: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1670: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1671: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1672: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
1673: x_pym_level OUT NOCOPY VARCHAR2,
1674: x_slh_id OUT NOCOPY OKC_RULES_V.ID%TYPE,
1675: x_rgp_id OUT NOCOPY OKC_RULE_GROUPS_V.ID%TYPE,
1676: x_cle_id OUT NOCOPY OKC_K_LINES_B.ID%TYPE) IS

Line 1915: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,

1911: x_msg_data OUT NOCOPY VARCHAR2,
1912: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1913: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1914: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1915: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
1916: p_pym_hdr_rec IN pym_hdr_rec_type,
1917: p_pym_tbl IN pym_tbl_type,
1918: p_update_type IN VARCHAR2,
1919: x_rulv_tbl OUT NOCOPY rulv_tbl_type) IS

Line 2615: FROM OKL_STRMTYP_SOURCE_V WHERE

2611:
2612: /*
2613: cursor PAYMENT_TYPE is
2614: SELECT ID1
2615: FROM OKL_STRMTYP_SOURCE_V WHERE
2616: CODE = 'VARIABLE_INTEREST';
2617: */
2618:
2619: begin

Line 2796: p_payment_id IN OKL_STRMTYP_SOURCE_V.ID1%TYPE,

2792: x_msg_data OUT NOCOPY VARCHAR2,
2793: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
2794: p_service_fee_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2795: p_asset_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2796: p_payment_id IN OKL_STRMTYP_SOURCE_V.ID1%TYPE,
2797: p_update_type IN VARCHAR2,
2798: x_rulv_tbl OUT NOCOPY rulv_tbl_type) IS
2799:
2800: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2809: l_stream_id OKL_STRMTYP_SOURCE_V.ID1%TYPE := OKL_API.G_MISS_NUM;

2805: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2806: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2807: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2808: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2809: l_stream_id OKL_STRMTYP_SOURCE_V.ID1%TYPE := OKL_API.G_MISS_NUM;
2810:
2811: lx_rulv_tbl rulv_tbl_type;
2812:
2813: -- R12B Authoring OA Migration