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

Line 111: p_sty_id IN okl_strm_type_b.ID%TYPE,

107: -- Added new procedure for get the streams for reporting and original product
108: PROCEDURE get_primary_pricing_name
109: (
110: p_khr_id IN okl_k_headers_full_v.id%TYPE,
111: p_sty_id IN okl_strm_type_b.ID%TYPE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_primary_pricing_name OUT NOCOPY OKL_ST_GEN_TMPT_LNS.PRICING_NAME%TYPE
114: )
115:

Line 134: FROM okl_strm_type_b

130: AND PRIMARY_STY_ID = p_sty_id;
131:
132: CURSOR sty_csr IS
133: SELECT CODE
134: FROM okl_strm_type_b
135: WHERE id = p_sty_id;
136:
137:
138: l_primary_pricing_name VARCHAR2(30);

Line 142: l_sty_code okl_strm_type_b.code%TYPE;

138: l_primary_pricing_name VARCHAR2(30);
139:
140: l_contract_start_date DATE;
141: l_product_id NUMBER;
142: l_sty_code okl_strm_type_b.code%TYPE;
143:
144: BEGIN
145:
146: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 218: p_sty_id IN okl_strm_type_b.ID%TYPE,

214:
215: PROCEDURE get_dependent_pricing_name
216: (
217: p_khr_id IN okl_k_headers_full_v.id%TYPE,
218: p_sty_id IN okl_strm_type_b.ID%TYPE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_dependent_pricing_name OUT NOCOPY OKL_ST_GEN_TMPT_LNS.PRICING_NAME%TYPE
221: )
222:

Line 242: FROM okl_strm_type_b

238: AND PRICING_NAME IS NOT NULL;
239:
240: CURSOR sty_csr IS
241: SELECT CODE
242: FROM okl_strm_type_b
243: WHERE id = p_sty_id;
244:
245: l_dependent_pricing_name VARCHAR2(40);
246:

Line 249: l_sty_code okl_strm_type_b.code%TYPE;

245: l_dependent_pricing_name VARCHAR2(40);
246:
247: l_contract_start_date DATE;
248: l_product_id NUMBER;
249: l_sty_code okl_strm_type_b.code%TYPE;
250:
251: BEGIN
252:
253: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 327: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

323:
324: PROCEDURE get_primary_stream_type
325: (
326: p_khr_id IN okl_k_headers_full_v.id%TYPE,
327: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
328: x_return_status OUT NOCOPY VARCHAR2,
329: x_primary_sty_id OUT NOCOPY strm_rec_type
330: )
331:

Line 430: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

426: PROCEDURE get_primary_no_prc_stream_type
427: (
428: p_khr_id IN okl_k_headers_full_v.id%TYPE,
429: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
430: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
431: x_return_status OUT NOCOPY VARCHAR2,
432: x_primary_sty_id OUT NOCOPY strm_rec_type
433: )
434:

Line 535: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,

531: PROCEDURE get_dep_no_prc_stream_type
532: (
533: p_khr_id IN okl_k_headers_full_v.id%TYPE,
534: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
535: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
536: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
537: x_return_status OUT NOCOPY VARCHAR2,
538: x_dependent_sty_id OUT NOCOPY strm_rec_type
539: )

Line 536: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,

532: (
533: p_khr_id IN okl_k_headers_full_v.id%TYPE,
534: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
535: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
536: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
537: x_return_status OUT NOCOPY VARCHAR2,
538: x_dependent_sty_id OUT NOCOPY strm_rec_type
539: )
540:

Line 642: p_primary_sty_id IN okl_strm_type_b.id%TYPE,

638: PROCEDURE get_dep_no_prc_stream_type
639: (
640: p_khr_id IN okl_k_headers_full_v.id%TYPE,
641: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
642: p_primary_sty_id IN okl_strm_type_b.id%TYPE,
643: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
644: x_return_status OUT NOCOPY VARCHAR2,
645: x_dependent_sty_id OUT NOCOPY strm_rec_type
646: )

Line 643: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,

639: (
640: p_khr_id IN okl_k_headers_full_v.id%TYPE,
641: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
642: p_primary_sty_id IN okl_strm_type_b.id%TYPE,
643: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
644: x_return_status OUT NOCOPY VARCHAR2,
645: x_dependent_sty_id OUT NOCOPY strm_rec_type
646: )
647:

Line 748: p_primary_sty_id IN okl_strm_type_b.id%TYPE,

744:
745: PROCEDURE get_dep_no_prc_stream_type
746: (
747: p_khr_id IN okl_k_headers_full_v.id%TYPE,
748: p_primary_sty_id IN okl_strm_type_b.id%TYPE,
749: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
750: x_return_status OUT NOCOPY VARCHAR2,
751: x_dependent_sty_id OUT NOCOPY strm_rec_type
752: )

Line 749: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,

745: PROCEDURE get_dep_no_prc_stream_type
746: (
747: p_khr_id IN okl_k_headers_full_v.id%TYPE,
748: p_primary_sty_id IN okl_strm_type_b.id%TYPE,
749: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
750: x_return_status OUT NOCOPY VARCHAR2,
751: x_dependent_sty_id OUT NOCOPY strm_rec_type
752: )
753:

Line 856: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

852: PROCEDURE get_primary_stream_type
853: (
854: p_khr_id IN okl_k_headers_full_v.id%TYPE,
855: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
856: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
857: x_return_status OUT NOCOPY VARCHAR2,
858: x_primary_sty_id OUT NOCOPY strm_rec_type
859: )
860:

Line 961: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

957:
958: PROCEDURE get_primary_stream_types
959: (
960: p_khr_id IN okl_k_headers_full_v.id%TYPE,
961: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
962: x_return_status OUT NOCOPY VARCHAR2,
963: x_primary_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
964: )
965:

Line 1063: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

1059:
1060: PROCEDURE get_dependent_stream_type
1061: (
1062: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1063: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1064: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1065: x_return_status OUT NOCOPY VARCHAR2,
1066: x_dependent_sty_id OUT NOCOPY strm_rec_type
1067: )

Line 1064: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

1060: PROCEDURE get_dependent_stream_type
1061: (
1062: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1063: p_primary_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1064: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1065: x_return_status OUT NOCOPY VARCHAR2,
1066: x_dependent_sty_id OUT NOCOPY strm_rec_type
1067: )
1068:

Line 1167: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,

1163:
1164: PROCEDURE get_dependent_stream_type
1165: (
1166: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1167: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1168: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1169: x_return_status OUT NOCOPY VARCHAR2,
1170: x_dependent_sty_id OUT NOCOPY strm_rec_type
1171: )

Line 1168: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,

1164: PROCEDURE get_dependent_stream_type
1165: (
1166: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1167: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1168: p_dependent_sty_purpose IN okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE,
1169: x_return_status OUT NOCOPY VARCHAR2,
1170: x_dependent_sty_id OUT NOCOPY strm_rec_type
1171: )
1172:

Line 1270: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,

1266: END get_dependent_stream_type;
1267: PROCEDURE get_dependent_stream_types
1268: (
1269: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1270: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1271: x_return_status OUT NOCOPY VARCHAR2,
1272: x_dependent_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
1273: )
1274:

Line 1370: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,

1366: PROCEDURE get_dependent_stream_types
1367: (
1368: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1369: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1370: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1371: x_return_status OUT NOCOPY VARCHAR2,
1372: x_dependent_sty_id OUT NOCOPY okl_strm_type_id_tbl_type
1373: )
1374:

Line 1469: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,

1465: PROCEDURE get_dependent_stream_type
1466: (
1467: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1468: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1469: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1470: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1471: x_return_status OUT NOCOPY VARCHAR2,
1472: x_dependent_sty_id OUT NOCOPY strm_rec_type
1473: )

Line 1470: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,

1466: (
1467: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1468: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1469: p_primary_sty_id IN okl_strm_type_b.ID%TYPE,
1470: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1471: x_return_status OUT NOCOPY VARCHAR2,
1472: x_dependent_sty_id OUT NOCOPY strm_rec_type
1473: )
1474:

Line 1577: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,

1573: PROCEDURE get_dependent_stream_type
1574: (
1575: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1576: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1577: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1578: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1579: x_return_status OUT NOCOPY VARCHAR2,
1580: x_dependent_sty_id OUT NOCOPY strm_rec_type
1581: )

Line 1578: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,

1574: (
1575: p_khr_id IN okl_k_headers_full_v.id%TYPE,
1576: p_pdt_id IN okl_k_headers_full_v.pdt_id%TYPE,
1577: p_primary_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1578: p_dependent_sty_purpose IN okl_strm_type_b.stream_type_purpose%TYPE,
1579: x_return_status OUT NOCOPY VARCHAR2,
1580: x_dependent_sty_id OUT NOCOPY strm_rec_type
1581: )
1582:

Line 2628: l_old_sty_id okl_strm_type_b.ID%TYPE;

2624: l_stmv_rec okl_streams_pub.stmv_rec_type;
2625: lx_stmv_rec okl_streams_pub.stmv_rec_type;
2626: --srsreeni bug 5869271 start add
2627: l_old_cle_id okc_k_lines_b.ID%TYPE;
2628: l_old_sty_id okl_strm_type_b.ID%TYPE;
2629: l_old_str_stmv_rec okl_streams_pub.stmv_rec_type;
2630: l_old_acr_stmv_rec okl_streams_pub.stmv_rec_type;
2631: l_last_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
2632: l_last_acr_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;

Line 3888: okl_strm_type_b sty

3884: IS
3885: SELECT nvl(sum(ele.AMOUNT),0)
3886: FROM okl_strm_elements ele,
3887: okl_streams str,
3888: okl_strm_type_b sty
3889: WHERE str.khr_id = chrId
3890: AND nvl(str.kle_id, -1) = kleid
3891: AND str.sty_id = sty.id
3892: AND str.say_code = 'CURR'

Line 3958: okl_strm_type_b b

3954: IS
3955: SELECT nvl(tl.id,-1) id,
3956: b.stream_type_subclass
3957: FROM okl_strm_type_tl tl,
3958: okl_strm_type_b b
3959: WHERE tl.language = USERENV('LANG')
3960: AND tl.name = p_strm_name
3961: AND tl.id = b.id;
3962:

Line 4488: okl_strm_type_b sty

4484: IS
4485: SELECT NVL(SUM(ele.AMOUNT),0) amount
4486: FROM okl_strm_elements ele,
4487: okl_streams str,
4488: okl_strm_type_b sty
4489: WHERE str.khr_id = p_chr_id
4490: AND NVL(str.kle_id, -1) = p_kle_id
4491: AND str.sty_id = sty.id
4492: AND str.say_code = 'CURR'

Line 4506: okl_strm_type_b sty

4502: IS
4503: SELECT NVL(SUM(ele.AMOUNT),0) amount
4504: FROM okl_strm_elements ele,
4505: okl_streams str,
4506: okl_strm_type_b sty
4507: WHERE str.khr_id = p_chr_id
4508: AND NVL(str.kle_id, -1) = p_kle_id
4509: AND str.sty_id = sty.id
4510: AND str.say_code = 'CURR'

Line 4535: okl_strm_type_b b

4531: IS
4532: SELECT nvl(tl.id,-1) id,
4533: b.stream_type_subclass
4534: FROM okl_strm_type_tl tl,
4535: okl_strm_type_b b
4536: WHERE tl.language = USERENV('LANG')
4537: AND tl.name = p_strm_name
4538: AND tl.id = b.id;
4539:

Line 6482: , OKL_STRM_TYPE_B STY -- vdamerla Forward Ported Bug 6082209

6478: , SEL.SE_LINE_NUMBER
6479: , SEL.COMMENTS -- vdamerla Forward Ported Bug 6344223
6480: FROM OKL_STREAMS STM
6481: , OKL_STRM_ELEMENTS SEL
6482: , OKL_STRM_TYPE_B STY -- vdamerla Forward Ported Bug 6082209
6483: WHERE SEL.STM_ID = STM.ID
6484: AND STM.KHR_ID = cp_chr_id
6485: AND STM.KLE_ID = cp_cle_id
6486: AND (nvl(STM.purpose_code,'ORIG') = (select nvl(si.PURPOSE_CODE,'ORIG') from okl_stream_interfaces si

Line 6581: , OKL_STRM_TYPE_B STY

6577: , SEL.SE_LINE_NUMBER
6578: , SEL.COMMENTS
6579: FROM OKL_STREAMS STM
6580: , OKL_STRM_ELEMENTS SEL
6581: , OKL_STRM_TYPE_B STY
6582: WHERE SEL.STM_ID = STM.ID
6583: AND STM.KHR_ID = cp_chr_id
6584: AND STM.KLE_ID IS NULL
6585: AND (nvl(STM.purpose_code,'ORIG') = (select nvl(si.PURPOSE_CODE,'ORIG') from okl_stream_interfaces si

Line 6626: cp_sty_id OKL_STRM_TYPE_B.ID%TYPE) IS

6622: and ole.id=cle.orig_system_id1;
6623: --smadhava - Bug# 6149951 - Added - End
6624: --Added by vdamerla for bug 6149951
6625: CURSOR c_chk_accrual_sty_on_pdt(cp_pdt_id OKL_PRODUCTS.ID%TYPE,
6626: cp_sty_id OKL_STRM_TYPE_B.ID%TYPE) IS
6627: SELECT 'Y'
6628: FROM OKL_STRM_TYPE_B sty,
6629: OKL_PROD_STRM_TYPES psty
6630: WHERE sty.id = psty.sty_id

Line 6628: FROM OKL_STRM_TYPE_B sty,

6624: --Added by vdamerla for bug 6149951
6625: CURSOR c_chk_accrual_sty_on_pdt(cp_pdt_id OKL_PRODUCTS.ID%TYPE,
6626: cp_sty_id OKL_STRM_TYPE_B.ID%TYPE) IS
6627: SELECT 'Y'
6628: FROM OKL_STRM_TYPE_B sty,
6629: OKL_PROD_STRM_TYPES psty
6630: WHERE sty.id = psty.sty_id
6631: AND psty.pdt_id = cp_pdt_id
6632: AND psty.accrual_yn = 'Y'

Line 8074: FROM okl_strm_type_b stm,

8070: stm.stream_type_class stream_type_class,
8071: tl.description alloc_basis,
8072: stm.capitalize_yn capitalize_yn,
8073: stm.periodic_yn periodic_yn
8074: FROM okl_strm_type_b stm,
8075: okl_strm_type_tl tl
8076: WHERE tl.id = stm.id
8077: AND tl.language = 'US'
8078: AND stm.id = styid;

Line 8173: okl_strm_type_b sty,

8169: IS
8170: SELECT TO_NUMBER(sgn.value) sty_id,
8171: cle.id
8172: FROM okl_sgn_translations sgn,
8173: okl_strm_type_b sty,
8174: okl_subsidies_v sub,
8175: okl_k_lines kle,
8176: okc_statuses_b sts,
8177: okc_line_styles_b lse,

Line 8971: okl_strm_type_b sty_inc,

8967: AND kle.subsidy_id = sub.id;
8968: /*
8969: SELECT sty_inc.code strm_desc
8970: FROM okl_sgn_translations sgn,
8971: okl_strm_type_b sty_inc,
8972: okl_strm_type_b sty,
8973: okl_subsidies_v sub,
8974: okl_k_lines kle,
8975: okc_line_styles_b lse,

Line 8972: okl_strm_type_b sty,

8968: /*
8969: SELECT sty_inc.code strm_desc
8970: FROM okl_sgn_translations sgn,
8971: okl_strm_type_b sty_inc,
8972: okl_strm_type_b sty,
8973: okl_subsidies_v sub,
8974: okl_k_lines kle,
8975: okc_line_styles_b lse,
8976: okc_k_lines_b cle

Line 8989: CURSOR get_strm_type_code (p_sty_id IN okl_strm_type_b.ID%TYPE)

8985: AND sgn.jtot_object1_code = 'OKL_STRMTYP'
8986: AND kle.subsidy_id = sub.id;
8987: */
8988: -- New code for bug 4044089 by HKPATEL 12/02/2004
8989: CURSOR get_strm_type_code (p_sty_id IN okl_strm_type_b.ID%TYPE)
8990: IS
8991:
8992: SELECT code
8993: FROM okl_strm_type_b

Line 8993: FROM okl_strm_type_b

8989: CURSOR get_strm_type_code (p_sty_id IN okl_strm_type_b.ID%TYPE)
8990: IS
8991:
8992: SELECT code
8993: FROM okl_strm_type_b
8994: WHERE id = p_sty_id;
8995:
8996:
8997: BEGIN

Line 9415: --TYPE okl_strm_type_id_tbl_type IS TABLE OF okl_strm_type_b.ID%TYPE

9411:
9412: l_passthru_percent NUMBER := 0;
9413: l_fee_type apps.OKL_K_LINES.FEE_TYPE%TYPE;
9414:
9415: --TYPE okl_strm_type_id_tbl_type IS TABLE OF okl_strm_type_b.ID%TYPE
9416: --INDEX BY BINARY_INTEGER;
9417: l_strm_type_id_tbl okl_strm_type_id_tbl_type;
9418:
9419:

Line 17713: FROM okl_strm_type_b stm,

17709: stm.stream_type_class stream_type_class,
17710: tl.description alloc_basis,
17711: stm.capitalize_yn capitalize_yn,
17712: stm.periodic_yn periodic_yn
17713: FROM okl_strm_type_b stm,
17714: okl_strm_type_tl tl
17715: WHERE tl.id = stm.id
17716: AND tl.language = 'US'
17717: AND stm.id = styid;

Line 22066: FROM okl_strm_type_b stm,

22062: stm.stream_type_purpose,
22063: tl.description alloc_basis,
22064: stm.capitalize_yn capitalize_yn,
22065: stm.periodic_yn periodic_yn
22066: FROM okl_strm_type_b stm,
22067: okl_strm_type_tl tl
22068: WHERE tl.id = stm.id
22069: AND tl.language = 'US'
22070: AND stm.id = styid;

Line 22161: okl_strm_type_b sty

22157: SELECT NVL(kle.amount, 0) total_cap_fee
22158: FROM okl_k_lines kle,
22159: okc_k_lines_b cle,
22160: okc_k_items cim,
22161: okl_strm_type_b sty
22162: WHERE cle.dnz_chr_id = p_chr_id
22163: AND cle.id = kle.id
22164: AND cle.id = cim.cle_id
22165: AND cim.jtot_object1_code = 'OKL_STRMTYP'