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_ISG_UTILS_PVT dependencies on OKL_STRM_TYPE_B

Line 21: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

17: PROCEDURE get_primary_stream_type
18: (
19: p_khr_id IN NUMBER,
20: p_pdt_id IN NUMBER,
21: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
24: x_primary_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE
25: )

Line 23: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,

19: p_khr_id IN NUMBER,
20: p_pdt_id IN NUMBER,
21: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
24: x_primary_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE
25: )
26:
27: IS

Line 139: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

135: PROCEDURE get_primary_stream_type
136: (
137: p_khr_id IN NUMBER,
138: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
139: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
142: x_primary_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE
143: )

Line 141: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,

137: p_khr_id IN NUMBER,
138: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
139: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_primary_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
142: x_primary_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE
143: )
144:
145: IS

Line 262: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

258:
259: PROCEDURE get_dependent_stream_type(
260: p_khr_id IN NUMBER,
261: p_pdt_id IN NUMBER,
262: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
265: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE) AS
266:

Line 264: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,

260: p_khr_id IN NUMBER,
261: p_pdt_id IN NUMBER,
262: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
265: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE) AS
266:
267: /*CURSOR get_k_info_csr (l_khr_id NUMBER)IS
268: SELECT pdt_id, start_date

Line 399: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

395:
396: PROCEDURE get_dependent_stream_type(
397: p_khr_id IN NUMBER,
398: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
399: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
402: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE) AS
403:

Line 401: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,

397: p_khr_id IN NUMBER,
398: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
399: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
402: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE) AS
403:
404: /*CURSOR get_k_info_csr (l_khr_id NUMBER)IS
405: SELECT pdt_id, start_date

Line 615: SELECT STREAM_TYPE_PURPOSE from okl_strm_type_b

611:
612: -- Cursor to get stream_type_purpose
613:
614: cursor l_strm_purpose_code(p_sty_id NUMBER) IS
615: SELECT STREAM_TYPE_PURPOSE from okl_strm_type_b
616: where id = p_sty_id;
617:
618: -- Cursor to get passthrought percentage
619:

Line 667: l_sty_name_purpose OKL_STRM_TYPE_B.stream_type_purpose%TYPE;

663: l_deal_type VARCHAR2(30);
664: l_kle_id NUMBER;
665: l_lty_code VARCHAR(30);
666: l_sty_id NUMBER;
667: l_sty_name_purpose OKL_STRM_TYPE_B.stream_type_purpose%TYPE;
668: l_primary_flag VARCHAR2(3) := OKL_API.G_FALSE;
669: l_dep_flag VARCHAR2(3) := OKL_API.G_FALSE;
670: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
671: l_primary_sty_id okl_strm_type_b.ID%TYPE;

Line 671: l_primary_sty_id okl_strm_type_b.ID%TYPE;

667: l_sty_name_purpose OKL_STRM_TYPE_B.stream_type_purpose%TYPE;
668: l_primary_flag VARCHAR2(3) := OKL_API.G_FALSE;
669: l_dep_flag VARCHAR2(3) := OKL_API.G_FALSE;
670: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
671: l_primary_sty_id okl_strm_type_b.ID%TYPE;
672: l_primary_sty_name OKL_STRM_TYPE_v.name%TYPE;
673: l_dependent_sty_id okl_strm_type_b.ID%TYPE;
674: l_dependent_sty_name OKL_STRM_TYPE_v.name%TYPE;
675: l_fee_type VARCHAR2(30);

Line 673: l_dependent_sty_id okl_strm_type_b.ID%TYPE;

669: l_dep_flag VARCHAR2(3) := OKL_API.G_FALSE;
670: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
671: l_primary_sty_id okl_strm_type_b.ID%TYPE;
672: l_primary_sty_name OKL_STRM_TYPE_v.name%TYPE;
673: l_dependent_sty_id okl_strm_type_b.ID%TYPE;
674: l_dependent_sty_name OKL_STRM_TYPE_v.name%TYPE;
675: l_fee_type VARCHAR2(30);
676: l_recurr_yn VARCHAR2(3):= OKL_API.G_FALSE;
677: l_pass_through_percentage NUMBER;

Line 681: l_lookup_strm_purpose OKL_STRM_TYPE_B.stream_type_purpose%TYPE;

677: l_pass_through_percentage NUMBER;
678: l_rec_period NUMBER;
679: l_expense_amount NUMBER;
680: l_idc NUMBER;
681: l_lookup_strm_purpose OKL_STRM_TYPE_B.stream_type_purpose%TYPE;
682:
683:
684: BEGIN
685: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1256: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,

1252:
1253: PROCEDURE get_dependent_stream_type(
1254: p_khr_id IN NUMBER,
1255: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
1256: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1257: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1258: x_return_status OUT NOCOPY VARCHAR2,
1259: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
1260: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE) AS

Line 1257: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

1253: PROCEDURE get_dependent_stream_type(
1254: p_khr_id IN NUMBER,
1255: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
1256: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1257: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1258: x_return_status OUT NOCOPY VARCHAR2,
1259: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
1260: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE) AS
1261:

Line 1259: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,

1255: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
1256: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1257: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1258: x_return_status OUT NOCOPY VARCHAR2,
1259: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
1260: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE) AS
1261:
1262: CURSOR get_k_info_csr (l_khr_id NUMBER)IS
1263: SELECT pdt_id, start_date

Line 1377: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

1373: -- Functions Added for improving the performance for ISG
1374: PROCEDURE get_dep_stream_type(
1375: p_khr_id IN NUMBER,
1376: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
1377: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1378: x_return_status OUT NOCOPY VARCHAR2,
1379: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
1380: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE,
1381: p_get_k_info_rec IN G_GET_K_INFO_CSR%ROWTYPE) AS

Line 1379: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,

1375: p_khr_id IN NUMBER,
1376: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
1377: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1378: x_return_status OUT NOCOPY VARCHAR2,
1379: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
1380: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE,
1381: p_get_k_info_rec IN G_GET_K_INFO_CSR%ROWTYPE) AS
1382:
1383: CURSOR get_depend_strm_type_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS

Line 1486: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,

1482: -- Overloaded get_dep_stream_type
1483: PROCEDURE get_dep_stream_type(
1484: p_khr_id IN NUMBER,
1485: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
1486: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1487: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1488: x_return_status OUT NOCOPY VARCHAR2,
1489: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
1490: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE,

Line 1487: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

1483: PROCEDURE get_dep_stream_type(
1484: p_khr_id IN NUMBER,
1485: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
1486: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1487: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1488: x_return_status OUT NOCOPY VARCHAR2,
1489: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
1490: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE,
1491: p_get_k_info_rec IN G_GET_K_INFO_CSR%ROWTYPE) AS

Line 1489: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,

1485: p_deal_type IN OKL_ST_GEN_TMPT_SETS.deal_type%TYPE,
1486: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1487: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1488: x_return_status OUT NOCOPY VARCHAR2,
1489: x_dependent_sty_id OUT NOCOPY okl_strm_type_b.ID%TYPE,
1490: x_dependent_sty_name OUT NOCOPY OKL_STRM_TYPE_v.name%TYPE,
1491: p_get_k_info_rec IN G_GET_K_INFO_CSR%ROWTYPE) AS
1492:
1493: CURSOR get_depend_strm_type_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS