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

Line 1618: ,okl_strm_type_b stb

1614: CURSOR get_billable_flag IS
1615: SELECT stb.stream_type_purpose purpose,
1616: stb.billable_yn
1617: FROM OKL_ST_GEN_TMPT_LNS gtl
1618: ,okl_strm_type_b stb
1619: WHERE
1620: gtl.gtt_id = p_gtt_id
1621: AND gtl.DEPENDENT_STY_ID = stb.id
1622: AND gtl.primary_yn = 'N'

Line 1632: FROM okl_strm_type_b

1628: )
1629: AND gtl.PRIMARY_STY_ID IN
1630: (
1631: SELECT id
1632: FROM okl_strm_type_b
1633: WHERE stream_type_purpose='RENT'
1634: );
1635:
1636: CURSOR get_rent_flag IS

Line 1639: ,okl_strm_type_b stb

1635:
1636: CURSOR get_rent_flag IS
1637: SELECT stb.stream_type_purpose purpose, stb.billable_yn
1638: FROM OKL_ST_GEN_TMPT_LNS gtl
1639: ,okl_strm_type_b stb
1640: WHERE
1641: gtl.gtt_id = p_gtt_id
1642: AND gtl.PRIMARY_STY_ID = stb.id
1643: AND gtl.primary_yn = 'Y'

Line 1648: l_purpose okl_strm_type_b.billable_yn%TYPE;

1644: AND stb.stream_type_purpose ='RENT';
1645: --Local variable declarations
1646: l_interest_calc_meth OKL_ST_GEN_TMPT_SETS.interest_calc_meth_code%TYPE;
1647: l_revenue_recog_meth OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;
1648: l_purpose okl_strm_type_b.billable_yn%TYPE;
1649: l_billable_yn okl_strm_type_b.stream_type_purpose%TYPE;
1650: l_pricing_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%TYPE;
1651: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code %TYPE;
1652: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%TYPE;

Line 1649: l_billable_yn okl_strm_type_b.stream_type_purpose%TYPE;

1645: --Local variable declarations
1646: l_interest_calc_meth OKL_ST_GEN_TMPT_SETS.interest_calc_meth_code%TYPE;
1647: l_revenue_recog_meth OKL_ST_GEN_TMPT_SETS.revenue_recog_meth_code%TYPE;
1648: l_purpose okl_strm_type_b.billable_yn%TYPE;
1649: l_billable_yn okl_strm_type_b.stream_type_purpose%TYPE;
1650: l_pricing_engine OKL_ST_GEN_TMPT_SETS.pricing_engine%TYPE;
1651: l_days_in_month_code OKL_ST_GEN_TMPT_SETS.days_in_month_code %TYPE;
1652: l_days_in_yr_code OKL_ST_GEN_TMPT_SETS.days_in_yr_code%TYPE;
1653: l_days_month_yr_concat VARCHAR2(2700);

Line 2030: , okl_strm_type_b stb

2026: -- insurance stream purposes must be defined.
2027: CURSOR okl_ins_purposes_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2028: SELECT count(*) ins_strms_count
2029: FROM OKL_ST_GEN_TMPT_LNS gtl
2030: , okl_strm_type_b stb
2031: WHERE gtl.primary_sty_id = stb.id
2032: AND GTL.GTT_ID = p_gtt_id
2033: AND GTL.primary_yn = 'Y'
2034: AND stb.stream_type_purpose IN

Line 2056: ,okl_strm_type_b stb

2052: -- SQL statement.
2053: CURSOR fin_only_one_as_primary_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2054: SELECT stb.stream_type_purpose purpose, count(stb.stream_type_purpose)
2055: FROM OKL_ST_GEN_TMPT_LNS gtl
2056: ,okl_strm_type_b stb
2057: WHERE gtl.primary_sty_id = stb.id
2058: AND gtl.primary_yn = 'Y'
2059: AND stb.stream_type_purpose IN
2060: (

Line 2179: , okl_strm_type_b stb

2175: )
2176: MINUS
2177: SELECT distinct stb.stream_type_purpose purpose
2178: FROM OKL_ST_GEN_TMPT_LNS gtl
2179: , okl_strm_type_b stb
2180: WHERE gtl.primary_sty_id = stb.id
2181: AND gtl.primary_yn = 'Y'
2182: AND stb.stream_type_purpose IN
2183: (

Line 2221: , okl_strm_type_b stb

2217: )
2218: MINUS
2219: SELECT distinct stb.stream_type_purpose purpose
2220: FROM OKL_ST_GEN_TMPT_LNS gtl
2221: , okl_strm_type_b stb
2222: WHERE gtl.primary_sty_id = stb.id
2223: AND gtl.primary_yn = 'Y'
2224: AND stb.stream_type_purpose IN
2225: (

Line 2241: , okl_strm_type_b stb

2237: )
2238: MINUS
2239: SELECT distinct stb.stream_type_purpose purpose
2240: FROM OKL_ST_GEN_TMPT_LNS gtl
2241: , okl_strm_type_b stb
2242: WHERE gtl.primary_sty_id = stb.id
2243: AND gtl.primary_yn = 'Y'
2244: AND stb.stream_type_purpose IN
2245: (

Line 2259: , okl_strm_type_b stb

2255: AND LOOKUP_CODE ='VARIABLE_INTEREST_SCHEDULE'
2256: MINUS
2257: SELECT distinct stb.stream_type_purpose purpose
2258: FROM OKL_ST_GEN_TMPT_LNS gtl
2259: , okl_strm_type_b stb
2260: WHERE gtl.primary_sty_id = stb.id
2261: AND gtl.primary_yn = 'Y'
2262: AND stb.stream_type_purpose ='VARIABLE_INTEREST_SCHEDULE'
2263: and GTL.GTT_ID = p_gtt_id;

Line 2279: , okl_strm_type_b stb

2275: )
2276: MINUS
2277: SELECT distinct stb.stream_type_purpose purpose
2278: FROM OKL_ST_GEN_TMPT_LNS gtl
2279: , okl_strm_type_b stb
2280: WHERE gtl.primary_sty_id = stb.id
2281: AND gtl.primary_yn = 'Y'
2282: AND stb.stream_type_purpose IN
2283: (

Line 2299: , okl_strm_type_b stb

2295: )
2296: MINUS
2297: SELECT distinct stb.stream_type_purpose purpose
2298: FROM OKL_ST_GEN_TMPT_LNS gtl
2299: , okl_strm_type_b stb
2300: WHERE gtl.primary_sty_id = stb.id
2301: AND gtl.primary_yn = 'Y'
2302: AND stb.stream_type_purpose IN
2303: (

Line 2324: , okl_strm_type_b stb

2320: )
2321: MINUS
2322: SELECT distinct stb.stream_type_purpose purpose
2323: FROM OKL_ST_GEN_TMPT_LNS gtl
2324: , okl_strm_type_b stb
2325: , okl_strm_type_b sstb
2326: WHERE gtl.dependent_sty_id = stb.id
2327: AND gtl.primary_yn = 'N'
2328: AND stb.stream_type_purpose IN

Line 2325: , okl_strm_type_b sstb

2321: MINUS
2322: SELECT distinct stb.stream_type_purpose purpose
2323: FROM OKL_ST_GEN_TMPT_LNS gtl
2324: , okl_strm_type_b stb
2325: , okl_strm_type_b sstb
2326: WHERE gtl.dependent_sty_id = stb.id
2327: AND gtl.primary_yn = 'N'
2328: AND stb.stream_type_purpose IN
2329: (

Line 2364: , okl_strm_type_b stb

2360: )
2361: MINUS
2362: SELECT distinct stb.stream_type_purpose purpose
2363: FROM OKL_ST_GEN_TMPT_LNS gtl
2364: , okl_strm_type_b stb
2365: , okl_strm_type_b sstb
2366: WHERE gtl.dependent_sty_id = stb.id
2367: AND gtl.primary_yn = 'N'
2368: AND stb.stream_type_purpose IN

Line 2365: , okl_strm_type_b sstb

2361: MINUS
2362: SELECT distinct stb.stream_type_purpose purpose
2363: FROM OKL_ST_GEN_TMPT_LNS gtl
2364: , okl_strm_type_b stb
2365: , okl_strm_type_b sstb
2366: WHERE gtl.dependent_sty_id = stb.id
2367: AND gtl.primary_yn = 'N'
2368: AND stb.stream_type_purpose IN
2369: (

Line 2411: , okl_strm_type_b stb

2407: )
2408: MINUS
2409: SELECT distinct stb.stream_type_purpose purpose
2410: FROM OKL_ST_GEN_TMPT_LNS gtl
2411: , okl_strm_type_b stb
2412: , okl_strm_type_b ptb
2413: WHERE gtl.dependent_sty_id = stb.id
2414: AND gtl.primary_yn = 'N'
2415: AND stb.stream_type_purpose IN

Line 2412: , okl_strm_type_b ptb

2408: MINUS
2409: SELECT distinct stb.stream_type_purpose purpose
2410: FROM OKL_ST_GEN_TMPT_LNS gtl
2411: , okl_strm_type_b stb
2412: , okl_strm_type_b ptb
2413: WHERE gtl.dependent_sty_id = stb.id
2414: AND gtl.primary_yn = 'N'
2415: AND stb.stream_type_purpose IN
2416: (

Line 2452: , okl_strm_type_b stb

2448: )
2449: MINUS
2450: SELECT distinct stb.stream_type_purpose purpose
2451: FROM OKL_ST_GEN_TMPT_LNS gtl
2452: , okl_strm_type_b stb
2453: , okl_strm_type_b ptb
2454: WHERE gtl.dependent_sty_id = stb.id
2455: AND gtl.primary_yn = 'N'
2456: AND stb.stream_type_purpose IN

Line 2453: , okl_strm_type_b ptb

2449: MINUS
2450: SELECT distinct stb.stream_type_purpose purpose
2451: FROM OKL_ST_GEN_TMPT_LNS gtl
2452: , okl_strm_type_b stb
2453: , okl_strm_type_b ptb
2454: WHERE gtl.dependent_sty_id = stb.id
2455: AND gtl.primary_yn = 'N'
2456: AND stb.stream_type_purpose IN
2457: (

Line 2486: , okl_strm_type_b stb

2482: )
2483: MINUS
2484: SELECT distinct stb.stream_type_purpose purpose
2485: FROM OKL_ST_GEN_TMPT_LNS gtl
2486: , okl_strm_type_b stb
2487: , okl_strm_type_b ptb
2488: WHERE gtl.dependent_sty_id = stb.id
2489: AND gtl.primary_yn = 'N'
2490: AND stb.stream_type_purpose IN

Line 2487: , okl_strm_type_b ptb

2483: MINUS
2484: SELECT distinct stb.stream_type_purpose purpose
2485: FROM OKL_ST_GEN_TMPT_LNS gtl
2486: , okl_strm_type_b stb
2487: , okl_strm_type_b ptb
2488: WHERE gtl.dependent_sty_id = stb.id
2489: AND gtl.primary_yn = 'N'
2490: AND stb.stream_type_purpose IN
2491: (

Line 2518: , okl_strm_type_b stb

2514: AND LOOKUP_CODE = 'VARIABLE_INTEREST_INCOME'
2515: MINUS
2516: SELECT distinct stb.stream_type_purpose purpose
2517: FROM OKL_ST_GEN_TMPT_LNS gtl
2518: , okl_strm_type_b stb
2519: , okl_strm_type_b sstb
2520: WHERE gtl.dependent_sty_id = stb.id
2521: AND gtl.primary_yn = 'N'
2522: AND stb.stream_type_purpose = 'VARIABLE_INTEREST_INCOME'

Line 2519: , okl_strm_type_b sstb

2515: MINUS
2516: SELECT distinct stb.stream_type_purpose purpose
2517: FROM OKL_ST_GEN_TMPT_LNS gtl
2518: , okl_strm_type_b stb
2519: , okl_strm_type_b sstb
2520: WHERE gtl.dependent_sty_id = stb.id
2521: AND gtl.primary_yn = 'N'
2522: AND stb.stream_type_purpose = 'VARIABLE_INTEREST_INCOME'
2523: and GTL.GTT_ID = p_gtt_id

Line 2550: , okl_strm_type_b stb

2546: )
2547: MINUS
2548: SELECT distinct stb.stream_type_purpose purpose
2549: FROM OKL_ST_GEN_TMPT_LNS gtl
2550: , okl_strm_type_b stb
2551: , okl_strm_type_b sstb
2552: WHERE gtl.dependent_sty_id = stb.id
2553: AND gtl.primary_yn = 'N'
2554: AND stb.stream_type_purpose IN

Line 2551: , okl_strm_type_b sstb

2547: MINUS
2548: SELECT distinct stb.stream_type_purpose purpose
2549: FROM OKL_ST_GEN_TMPT_LNS gtl
2550: , okl_strm_type_b stb
2551: , okl_strm_type_b sstb
2552: WHERE gtl.dependent_sty_id = stb.id
2553: AND gtl.primary_yn = 'N'
2554: AND stb.stream_type_purpose IN
2555: (

Line 2586: , okl_strm_type_b stb

2582: )
2583: MINUS
2584: SELECT distinct stb.stream_type_purpose purpose
2585: FROM OKL_ST_GEN_TMPT_LNS gtl
2586: , okl_strm_type_b stb
2587: , okl_strm_type_b sstb
2588: WHERE gtl.dependent_sty_id = stb.id
2589: AND gtl.primary_yn = 'N'
2590: AND stb.stream_type_purpose IN

Line 2587: , okl_strm_type_b sstb

2583: MINUS
2584: SELECT distinct stb.stream_type_purpose purpose
2585: FROM OKL_ST_GEN_TMPT_LNS gtl
2586: , okl_strm_type_b stb
2587: , okl_strm_type_b sstb
2588: WHERE gtl.dependent_sty_id = stb.id
2589: AND gtl.primary_yn = 'N'
2590: AND stb.stream_type_purpose IN
2591: (

Line 2628: , okl_strm_type_b stb

2624: )
2625: MINUS
2626: SELECT distinct stb.stream_type_purpose purpose
2627: FROM OKL_ST_GEN_TMPT_LNS gtl
2628: , okl_strm_type_b stb
2629: , okl_strm_type_b sstb
2630: WHERE gtl.dependent_sty_id = stb.id
2631: AND gtl.primary_yn = 'N'
2632: AND stb.stream_type_purpose IN

Line 2629: , okl_strm_type_b sstb

2625: MINUS
2626: SELECT distinct stb.stream_type_purpose purpose
2627: FROM OKL_ST_GEN_TMPT_LNS gtl
2628: , okl_strm_type_b stb
2629: , okl_strm_type_b sstb
2630: WHERE gtl.dependent_sty_id = stb.id
2631: AND gtl.primary_yn = 'N'
2632: AND stb.stream_type_purpose IN
2633: (

Line 2668: , okl_strm_type_b stb

2664: )
2665: MINUS
2666: SELECT distinct stb.stream_type_purpose purpose
2667: FROM OKL_ST_GEN_TMPT_LNS gtl
2668: , okl_strm_type_b stb
2669: , okl_strm_type_b sstb
2670: WHERE gtl.dependent_sty_id = stb.id
2671: AND gtl.primary_yn = 'N'
2672: AND stb.stream_type_purpose IN

Line 2669: , okl_strm_type_b sstb

2665: MINUS
2666: SELECT distinct stb.stream_type_purpose purpose
2667: FROM OKL_ST_GEN_TMPT_LNS gtl
2668: , okl_strm_type_b stb
2669: , okl_strm_type_b sstb
2670: WHERE gtl.dependent_sty_id = stb.id
2671: AND gtl.primary_yn = 'N'
2672: AND stb.stream_type_purpose IN
2673: (

Line 2698: , okl_strm_type_b stb

2694: (
2695: -- Retrieve the List of Primary Stream Purposes in the Template
2696: SELECT distinct stb.stream_type_purpose purpose
2697: FROM OKL_ST_GEN_TMPT_LNS gtl
2698: , okl_strm_type_b stb
2699: WHERE gtl.primary_sty_id = stb.id
2700: AND gtl.primary_yn = 'Y'
2701: AND GTL.GTT_ID = p_gtt_id
2702: UNION

Line 2706: , okl_strm_type_b stb

2702: UNION
2703: -- Retrieve the List of Dependent Stream Purposes in the Template
2704: SELECT distinct stb.stream_type_purpose purpose
2705: FROM OKL_ST_GEN_TMPT_LNS gtl
2706: , okl_strm_type_b stb
2707: WHERE gtl.dependent_sty_id = stb.id
2708: AND gtl.primary_yn = 'N'
2709: and GTL.GTT_ID = p_gtt_id
2710: )

Line 2859: , okl_strm_type_b stb

2855: (
2856: -- Retrieve the List of Primary Stream Purposes in the Template
2857: SELECT distinct stb.stream_type_purpose purpose
2858: FROM OKL_ST_GEN_TMPT_LNS gtl
2859: , okl_strm_type_b stb
2860: WHERE gtl.primary_sty_id = stb.id
2861: AND gtl.primary_yn = 'Y'
2862: AND GTL.GTT_ID = p_gtt_id
2863: UNION

Line 2867: , okl_strm_type_b stb

2863: UNION
2864: -- Retrieve the List of Dependent Stream Purposes in the Template
2865: SELECT distinct stb.stream_type_purpose purpose
2866: FROM OKL_ST_GEN_TMPT_LNS gtl
2867: , okl_strm_type_b stb
2868: WHERE gtl.dependent_sty_id = stb.id
2869: AND gtl.primary_yn = 'N'
2870: and GTL.GTT_ID = p_gtt_id
2871: )

Line 3020: , okl_strm_type_b stb

3016: (
3017: -- Retrieve the List of Primary Stream Purposes in the Template
3018: SELECT distinct stb.stream_type_purpose purpose
3019: FROM OKL_ST_GEN_TMPT_LNS gtl
3020: , okl_strm_type_b stb
3021: WHERE gtl.primary_sty_id = stb.id
3022: AND gtl.primary_yn = 'Y'
3023: AND GTL.GTT_ID = p_gtt_id
3024: UNION

Line 3028: , okl_strm_type_b stb

3024: UNION
3025: -- Retrieve the List of Dependent Stream Purposes in the Template
3026: SELECT distinct stb.stream_type_purpose purpose
3027: FROM OKL_ST_GEN_TMPT_LNS gtl
3028: , okl_strm_type_b stb
3029: WHERE gtl.dependent_sty_id = stb.id
3030: AND gtl.primary_yn = 'N'
3031: and GTL.GTT_ID = p_gtt_id
3032: )

Line 3715: ,okl_strm_type_b stb

3711: -- 1. Only one stream type of the following primary purposes should be defined.
3712: CURSOR inv_only_one_as_primary_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
3713: SELECT stb.stream_type_purpose purpose, count(stb.stream_type_purpose)
3714: FROM OKL_ST_GEN_TMPT_LNS gtl
3715: ,okl_strm_type_b stb
3716: WHERE gtl.primary_sty_id = stb.id
3717: AND gtl.primary_yn = 'Y'
3718: AND stb.stream_type_purpose IN
3719: (

Line 3772: , okl_strm_type_b stb

3768: )
3769: MINUS
3770: SELECT distinct stb.stream_type_purpose purpose
3771: FROM OKL_ST_GEN_TMPT_LNS gtl
3772: , okl_strm_type_b stb
3773: WHERE gtl.primary_sty_id = stb.id
3774: AND gtl.primary_yn = 'Y'
3775: AND stb.stream_type_purpose IN
3776: (

Line 4071: ,OKL_STRM_TYPE_B STB

4067: MINUS
4068: (
4069: SELECT STB.STREAM_TYPE_PURPOSE PURPOSE
4070: FROM OKL_ST_GEN_TMPT_LNS GTL
4071: ,OKL_STRM_TYPE_B STB
4072: WHERE GTL.GTT_ID = p_gtt_id
4073: AND GTL.PRIMARY_YN = 'N'
4074: AND GTL.DEPENDENT_STY_ID = STB.ID
4075: AND GTL.PRIMARY_STY_ID = p_pri_sty_id

Line 4176: ,OKL_STRM_TYPE_B STB

4172: ,STB.CODE STRM_NAME
4173: FROM OKL_ST_GEN_TMPT_LNS GTL
4174: ,OKL_ST_GEN_TMPT_SETS GTS
4175: ,OKL_ST_GEN_TEMPLATES GTT
4176: ,OKL_STRM_TYPE_B STB
4177: WHERE GTL.GTT_ID = p_gtt_id
4178: AND GTL.GTT_ID = GTT.ID
4179: AND GTS.ID = GTT.GTS_ID
4180: AND GTL.PRIMARY_YN = 'Y'

Line 4548: ,okl_Strm_Type_b STY

4544: AND LOOKUP_CODE = STY.STREAM_TYPE_PURPOSE
4545: ) PURPOSE_MEANING,
4546: COUNT( STY.STREAM_TYPE_PURPOSE) streams_count
4547: FROM OKL_ST_GEN_TMPT_LNS GTL
4548: ,okl_Strm_Type_b STY
4549: WHERE GTL.DEPENDENT_STY_ID = STY.ID
4550: AND PRIMARY_YN = 'N'
4551: AND GTL.GTT_ID = p_gtt_id
4552: AND GTL.PRIMARY_STY_ID = p_pri_id

Line 4579: ,OKL_STRM_TYPE_B STY

4575: ,p_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE)
4576: IS
4577: SELECT STY.STREAM_TYPE_PURPOSE PRI_STRM_PURPOSE
4578: FROM OKL_ST_GEN_TMPT_LNS GTL
4579: ,OKL_STRM_TYPE_B STY
4580: WHERE STY.ID = GTL.PRIMARY_sTY_ID
4581: AND GTL.PRIMARY_YN = 'Y'
4582: AND GTL.GTT_ID = p_gtt_id
4583: AND GTL.PRIMARY_STY_ID = p_pri_sty_id;

Line 4587: l_pri_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE;

4583: AND GTL.PRIMARY_STY_ID = p_pri_sty_id;
4584:
4585: l_missing_deps VARCHAR2(32000) := OKL_API.G_MISS_CHAR;
4586: l_show_warn_flag VARCHAR2(1):= OKL_API.G_FALSE;
4587: l_pri_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE;
4588:
4589: -- Modified by RGOOTY
4590: -- Bug 4094361: Start
4591: CURSOR pdt_for_active_sgt_csr( p_gts_id OKL_ST_GEN_TMPT_SETS.ID%TYPE )

Line 4862: ,OKL_STRM_TYPE_B STY

4858: ) DEP_PURPOSE_MEANING,
4859: COUNT( STY.STREAM_TYPE_PURPOSE) streams_count
4860: FROM OKL_ST_GEN_TMPT_LNS GTL
4861: ,OKL_ST_GEN_TMPT_LNS GTLP
4862: ,OKL_STRM_TYPE_B STY
4863: ,OKL_STRM_TYPE_B STYP
4864: WHERE GTL.DEPENDENT_STY_ID = STY.ID
4865: AND GTLP.PRIMARY_STY_ID = STYP.ID
4866: AND GTL.PRIMARY_YN = 'N'

Line 4863: ,OKL_STRM_TYPE_B STYP

4859: COUNT( STY.STREAM_TYPE_PURPOSE) streams_count
4860: FROM OKL_ST_GEN_TMPT_LNS GTL
4861: ,OKL_ST_GEN_TMPT_LNS GTLP
4862: ,OKL_STRM_TYPE_B STY
4863: ,OKL_STRM_TYPE_B STYP
4864: WHERE GTL.DEPENDENT_STY_ID = STY.ID
4865: AND GTLP.PRIMARY_STY_ID = STYP.ID
4866: AND GTL.PRIMARY_YN = 'N'
4867: AND GTLP.PRIMARY_YN = 'Y'

Line 4899: l_pri_stream_name OKL_STRM_TYPE_B.CODE%TYPE;

4895: l_sgt_set_id OKL_ST_GEN_TMPT_SETS.ID%TYPE;
4896: l_pri_purpose_list VARCHAR2(32000);
4897: l_found VARCHAR2(30);
4898: l_msg VARCHAR2(10000);
4899: l_pri_stream_name OKL_STRM_TYPE_B.CODE%TYPE;
4900: l_dep_purp_list VARCHAR2(32000);
4901: BEGIN
4902: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4903: l_return_status := OKL_API.START_ACTIVITY( l_api_name