APPS.OKL_LA_PAYMENTS_PVT dependencies on OKL_STRMTYP_SOURCE_V

Line 675: FROM OKL_STRMTYP_SOURCE_V STRM

671: l_payment_code varchar2(150) := null;
672: l_slh_id number := null;
673: cursor PAYMENT_TYPE_CSR(P_ID IN VARCHAR2) is
674: SELECT STRM.STREAM_TYPE_PURPOSE
675: FROM OKL_STRMTYP_SOURCE_V STRM
676: WHERE TO_CHAR(STRM.ID1) = P_ID;
677:
678: BEGIN
679: if(p_stream_id is null or p_stream_id = '') then return false; end if;

Line 696: FROM OKL_STRMTYP_SOURCE_V STRM,

692: l_flag varchar2(1) := null;
693: l_slh_id number := null;
694: cursor PAYMENT_TYPE_CSR(P_ID IN VARCHAR2) is
695: SELECT 'Y'
696: FROM OKL_STRMTYP_SOURCE_V STRM,
697: OKC_RULES_B RL
698: WHERE RL.ID = P_ID
699: AND TO_CHAR(STRM.ID1) = RL.OBJECT1_ID1
700: AND STRM.STREAM_TYPE_PURPOSE = 'UNSCHEDULED_PRINCIPAL_PAYMENT';

Line 1879: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,

1875: x_msg_data OUT NOCOPY VARCHAR2,
1876: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
1877: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1878: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1879: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
1880: x_pym_level OUT NOCOPY VARCHAR2,
1881: x_slh_id OUT NOCOPY OKC_RULES_V.ID%TYPE,
1882: x_rgp_id OUT NOCOPY OKC_RULE_GROUPS_V.ID%TYPE,
1883: x_cle_id OUT NOCOPY OKC_K_LINES_B.ID%TYPE) IS

Line 2122: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,

2118: x_msg_data OUT NOCOPY VARCHAR2,
2119: p_chr_id OKC_K_HEADERS_B.ID%TYPE,
2120: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2121: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
2122: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
2123: p_pym_hdr_rec IN pym_hdr_rec_type,
2124: p_pym_tbl IN pym_tbl_type,
2125: p_update_type IN VARCHAR2,
2126: x_rulv_tbl OUT NOCOPY rulv_tbl_type) IS

Line 2883: FROM OKL_STRMTYP_SOURCE_V WHERE

2879:
2880: /*
2881: cursor PAYMENT_TYPE is
2882: SELECT ID1
2883: FROM OKL_STRMTYP_SOURCE_V WHERE
2884: CODE = 'VARIABLE_INTEREST';
2885: */
2886:
2887: begin

Line 3064: p_payment_id IN OKL_STRMTYP_SOURCE_V.ID1%TYPE,

3060: x_msg_data OUT NOCOPY VARCHAR2,
3061: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
3062: p_service_fee_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
3063: p_asset_id IN OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
3064: p_payment_id IN OKL_STRMTYP_SOURCE_V.ID1%TYPE,
3065: p_update_type IN VARCHAR2,
3066: x_rulv_tbl OUT NOCOPY rulv_tbl_type) IS
3067:
3068: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

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

3073: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3074: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3075: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3076: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3077: l_stream_id OKL_STRMTYP_SOURCE_V.ID1%TYPE := OKL_API.G_MISS_NUM;
3078:
3079: lx_rulv_tbl rulv_tbl_type;
3080:
3081: -- R12B Authoring OA Migration