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_ST_GEN_TMPT_LNS

Line 822: CURSOR okl_st_gen_tmpt_lns_csr( p_gtt_id IN OKL_ST_GEN_TMPT_LNS.gtt_id%type

818: ,GTT_ID
819: FROM OKL_ST_GEN_PRC_PARAMS
820: where GTT_ID = p_gtt_id;
821:
822: CURSOR okl_st_gen_tmpt_lns_csr( p_gtt_id IN OKL_ST_GEN_TMPT_LNS.gtt_id%type
823: ,p_primary_yn IN OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE) IS
824: SELECT ID
825: ,GTT_ID
826: ,PRIMARY_YN

Line 823: ,p_primary_yn IN OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE) IS

819: FROM OKL_ST_GEN_PRC_PARAMS
820: where GTT_ID = p_gtt_id;
821:
822: CURSOR okl_st_gen_tmpt_lns_csr( p_gtt_id IN OKL_ST_GEN_TMPT_LNS.gtt_id%type
823: ,p_primary_yn IN OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE) IS
824: SELECT ID
825: ,GTT_ID
826: ,PRIMARY_YN
827: ,PRIMARY_STY_ID

Line 830: FROM OKL_ST_GEN_TMPT_LNS

826: ,PRIMARY_YN
827: ,PRIMARY_STY_ID
828: ,DEPENDENT_STY_ID
829: ,PRICING_NAME
830: FROM OKL_ST_GEN_TMPT_LNS
831: where GTT_ID = p_gtt_id
832: AND PRIMARY_YN = p_primary_yn;
833:
834: CURSOR okl_new_version_date_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS

Line 1035: FOR gtlv_rec_temp IN okl_st_gen_tmpt_lns_csr(l_gtt_id, G_INIT_PRIMARY_YN_YES )

1031: END IF;
1032:
1033: -- Fetch all the primary streams and call the insert API
1034: i := 0;
1035: FOR gtlv_rec_temp IN okl_st_gen_tmpt_lns_csr(l_gtt_id, G_INIT_PRIMARY_YN_YES )
1036: LOOP
1037: l_gtlv_tbl_pri_in(i).primary_yn := G_INIT_PRIMARY_YN_YES;
1038: l_gtlv_tbl_pri_in(i).primary_sty_id := gtlv_rec_temp.primary_sty_id;
1039: -- Dependent Streams wont be present for this Stream

Line 1067: FOR gtlv_rec_temp IN okl_st_gen_tmpt_lns_csr(l_gtt_id, G_INIT_PRIMARY_YN_NO )

1063: END IF;
1064:
1065: -- Fetch all the dependent streams and call the insert API
1066: i := 0;
1067: FOR gtlv_rec_temp IN okl_st_gen_tmpt_lns_csr(l_gtt_id, G_INIT_PRIMARY_YN_NO )
1068: LOOP
1069: l_gtlv_tbl_dep_in(i).primary_yn := G_INIT_PRIMARY_YN_NO;
1070: l_gtlv_tbl_dep_in(i).primary_sty_id := gtlv_rec_temp.primary_sty_id;
1071: l_gtlv_tbl_dep_in(i).dependent_sty_id := gtlv_rec_temp.dependent_sty_id;

Line 1255: CURSOR okl_st_gen_tmpt_dep_lns_csr( p_gtt_id IN OKL_ST_GEN_TMPT_LNS.gtt_id%type

1251: l_gtlv_pri_tbl_del_in gtlv_tbl_type;
1252: l_gtlv_dep_tbl_del_in gtlv_tbl_type;
1253: i NUMBER := 0;
1254:
1255: CURSOR okl_st_gen_tmpt_dep_lns_csr( p_gtt_id IN OKL_ST_GEN_TMPT_LNS.gtt_id%type
1256: ,p_primary_sty_id IN OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID %type) IS
1257: SELECT ID
1258: ,PRIMARY_STY_ID
1259: ,DEPENDENT_STY_ID

Line 1256: ,p_primary_sty_id IN OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID %type) IS

1252: l_gtlv_dep_tbl_del_in gtlv_tbl_type;
1253: i NUMBER := 0;
1254:
1255: CURSOR okl_st_gen_tmpt_dep_lns_csr( p_gtt_id IN OKL_ST_GEN_TMPT_LNS.gtt_id%type
1256: ,p_primary_sty_id IN OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID %type) IS
1257: SELECT ID
1258: ,PRIMARY_STY_ID
1259: ,DEPENDENT_STY_ID
1260: ,GTT_ID

Line 1261: FROM OKL_ST_GEN_TMPT_LNS

1257: SELECT ID
1258: ,PRIMARY_STY_ID
1259: ,DEPENDENT_STY_ID
1260: ,GTT_ID
1261: FROM OKL_ST_GEN_TMPT_LNS
1262: WHERE PRIMARY_YN = 'N'
1263: AND PRIMARY_STY_ID = p_primary_sty_id
1264: AND GTT_ID = p_gtt_id;
1265: BEGIN

Line 1603: FROM OKL_ST_GEN_TMPT_LNS gtl

1599:
1600: CURSOR get_billable_flag IS
1601: SELECT stb.stream_type_purpose purpose,
1602: stb.billable_yn
1603: FROM OKL_ST_GEN_TMPT_LNS gtl
1604: ,okl_strm_type_b stb
1605: WHERE
1606: gtl.gtt_id = p_gtt_id
1607: AND gtl.DEPENDENT_STY_ID = stb.id

Line 1624: FROM OKL_ST_GEN_TMPT_LNS gtl

1620: );
1621:
1622: CURSOR get_rent_flag IS
1623: SELECT stb.stream_type_purpose purpose, stb.billable_yn
1624: FROM OKL_ST_GEN_TMPT_LNS gtl
1625: ,okl_strm_type_b stb
1626: WHERE
1627: gtl.gtt_id = p_gtt_id
1628: AND gtl.PRIMARY_STY_ID = stb.id

Line 2014: FROM OKL_ST_GEN_TMPT_LNS gtl

2010: -- 1. If user selects one of the following Insurance purposes then all the
2011: -- insurance stream purposes must be defined.
2012: CURSOR okl_ins_purposes_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2013: SELECT count(*) ins_strms_count
2014: FROM OKL_ST_GEN_TMPT_LNS gtl
2015: , okl_strm_type_b stb
2016: WHERE gtl.primary_sty_id = stb.id
2017: AND GTL.GTT_ID = p_gtt_id
2018: AND GTL.primary_yn = 'Y'

Line 2040: FROM OKL_ST_GEN_TMPT_LNS gtl

2036: -- or not. So, If they are not defined then that doesnot violoate the logic of the
2037: -- SQL statement.
2038: CURSOR fin_only_one_as_primary_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2039: SELECT stb.stream_type_purpose purpose, count(stb.stream_type_purpose)
2040: FROM OKL_ST_GEN_TMPT_LNS gtl
2041: ,okl_strm_type_b stb
2042: WHERE gtl.primary_sty_id = stb.id
2043: AND gtl.primary_yn = 'Y'
2044: AND stb.stream_type_purpose IN

Line 2163: FROM OKL_ST_GEN_TMPT_LNS gtl

2159: ,'REBOOK_BILLING_ADJUSTMENT' -- VR Upgrade.
2160: )
2161: MINUS
2162: SELECT distinct stb.stream_type_purpose purpose
2163: FROM OKL_ST_GEN_TMPT_LNS gtl
2164: , okl_strm_type_b stb
2165: WHERE gtl.primary_sty_id = stb.id
2166: AND gtl.primary_yn = 'Y'
2167: AND stb.stream_type_purpose IN

Line 2205: FROM OKL_ST_GEN_TMPT_LNS gtl

2201: 'VARIABLE_INTEREST'
2202: )
2203: MINUS
2204: SELECT distinct stb.stream_type_purpose purpose
2205: FROM OKL_ST_GEN_TMPT_LNS gtl
2206: , okl_strm_type_b stb
2207: WHERE gtl.primary_sty_id = stb.id
2208: AND gtl.primary_yn = 'Y'
2209: AND stb.stream_type_purpose IN

Line 2225: FROM OKL_ST_GEN_TMPT_LNS gtl

2221: 'RESIDUAL_VALUE'
2222: )
2223: MINUS
2224: SELECT distinct stb.stream_type_purpose purpose
2225: FROM OKL_ST_GEN_TMPT_LNS gtl
2226: , okl_strm_type_b stb
2227: WHERE gtl.primary_sty_id = stb.id
2228: AND gtl.primary_yn = 'Y'
2229: AND stb.stream_type_purpose IN

Line 2243: FROM OKL_ST_GEN_TMPT_LNS gtl

2239: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2240: AND LOOKUP_CODE ='VARIABLE_INTEREST_SCHEDULE'
2241: MINUS
2242: SELECT distinct stb.stream_type_purpose purpose
2243: FROM OKL_ST_GEN_TMPT_LNS gtl
2244: , okl_strm_type_b stb
2245: WHERE gtl.primary_sty_id = stb.id
2246: AND gtl.primary_yn = 'Y'
2247: AND stb.stream_type_purpose ='VARIABLE_INTEREST_SCHEDULE'

Line 2263: FROM OKL_ST_GEN_TMPT_LNS gtl

2259: 'INVESTOR_RENTAL_ACCRUAL'
2260: )
2261: MINUS
2262: SELECT distinct stb.stream_type_purpose purpose
2263: FROM OKL_ST_GEN_TMPT_LNS gtl
2264: , okl_strm_type_b stb
2265: WHERE gtl.primary_sty_id = stb.id
2266: AND gtl.primary_yn = 'Y'
2267: AND stb.stream_type_purpose IN

Line 2283: FROM OKL_ST_GEN_TMPT_LNS gtl

2279: 'INVESTOR_PRETAX_INCOME'
2280: )
2281: MINUS
2282: SELECT distinct stb.stream_type_purpose purpose
2283: FROM OKL_ST_GEN_TMPT_LNS gtl
2284: , okl_strm_type_b stb
2285: WHERE gtl.primary_sty_id = stb.id
2286: AND gtl.primary_yn = 'Y'
2287: AND stb.stream_type_purpose IN

Line 2308: FROM OKL_ST_GEN_TMPT_LNS gtl

2304: 'ADVANCE_RENT'
2305: )
2306: MINUS
2307: SELECT distinct stb.stream_type_purpose purpose
2308: FROM OKL_ST_GEN_TMPT_LNS gtl
2309: , okl_strm_type_b stb
2310: , okl_strm_type_b sstb
2311: WHERE gtl.dependent_sty_id = stb.id
2312: AND gtl.primary_yn = 'N'

Line 2326: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2322: )
2323: AND EXISTS
2324: (
2325: SELECT 1
2326: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2327: WHERE primary_yn = 'Y'
2328: AND gtlpri.gtt_id = p_gtt_id
2329: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2330: );

Line 2348: FROM OKL_ST_GEN_TMPT_LNS gtl

2344: ,'UNSCHEDULED_PRINCIPAL_PAYMENT'
2345: )
2346: MINUS
2347: SELECT distinct stb.stream_type_purpose purpose
2348: FROM OKL_ST_GEN_TMPT_LNS gtl
2349: , okl_strm_type_b stb
2350: , okl_strm_type_b sstb
2351: WHERE gtl.dependent_sty_id = stb.id
2352: AND gtl.primary_yn = 'N'

Line 2372: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2368: )
2369: AND EXISTS
2370: (
2371: SELECT 1
2372: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2373: WHERE primary_yn = 'Y'
2374: AND gtlpri.gtt_id = p_gtt_id
2375: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2376: );

Line 2395: FROM OKL_ST_GEN_TMPT_LNS gtl

2391: ,'ACTUAL_INCOME_ACCRUAL'
2392: )
2393: MINUS
2394: SELECT distinct stb.stream_type_purpose purpose
2395: FROM OKL_ST_GEN_TMPT_LNS gtl
2396: , okl_strm_type_b stb
2397: , okl_strm_type_b ptb
2398: WHERE gtl.dependent_sty_id = stb.id
2399: AND gtl.primary_yn = 'N'

Line 2420: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2416: )
2417: AND EXISTS
2418: (
2419: SELECT 1
2420: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2421: WHERE primary_yn = 'Y'
2422: AND gtlpri.gtt_id = p_gtt_id
2423: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2424: );

Line 2436: FROM OKL_ST_GEN_TMPT_LNS gtl

2432: 'FLOAT_FACTOR_ADJUSTMENT'
2433: )
2434: MINUS
2435: SELECT distinct stb.stream_type_purpose purpose
2436: FROM OKL_ST_GEN_TMPT_LNS gtl
2437: , okl_strm_type_b stb
2438: , okl_strm_type_b ptb
2439: WHERE gtl.dependent_sty_id = stb.id
2440: AND gtl.primary_yn = 'N'

Line 2454: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2450: )
2451: AND EXISTS
2452: (
2453: SELECT 1
2454: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2455: WHERE primary_yn = 'Y'
2456: AND gtlpri.gtt_id = p_gtt_id
2457: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2458: );

Line 2470: FROM OKL_ST_GEN_TMPT_LNS gtl

2466: 'INTEREST_CATCHUP'
2467: )
2468: MINUS
2469: SELECT distinct stb.stream_type_purpose purpose
2470: FROM OKL_ST_GEN_TMPT_LNS gtl
2471: , okl_strm_type_b stb
2472: , okl_strm_type_b ptb
2473: WHERE gtl.dependent_sty_id = stb.id
2474: AND gtl.primary_yn = 'N'

Line 2488: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2484: )
2485: AND EXISTS
2486: (
2487: SELECT 1
2488: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2489: WHERE primary_yn = 'Y'
2490: AND gtlpri.gtt_id = p_gtt_id
2491: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2492: );

Line 2502: FROM OKL_ST_GEN_TMPT_LNS gtl

2498: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2499: AND LOOKUP_CODE = 'VARIABLE_INTEREST_INCOME'
2500: MINUS
2501: SELECT distinct stb.stream_type_purpose purpose
2502: FROM OKL_ST_GEN_TMPT_LNS gtl
2503: , okl_strm_type_b stb
2504: , okl_strm_type_b sstb
2505: WHERE gtl.dependent_sty_id = stb.id
2506: AND gtl.primary_yn = 'N'

Line 2517: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2513: )
2514: AND EXISTS
2515: (
2516: SELECT 1
2517: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2518: WHERE primary_yn = 'Y'
2519: AND gtlpri.gtt_id = p_gtt_id
2520: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2521: );

Line 2534: FROM OKL_ST_GEN_TMPT_LNS gtl

2530: 'LEASE_INCOME'
2531: )
2532: MINUS
2533: SELECT distinct stb.stream_type_purpose purpose
2534: FROM OKL_ST_GEN_TMPT_LNS gtl
2535: , okl_strm_type_b stb
2536: , okl_strm_type_b sstb
2537: WHERE gtl.dependent_sty_id = stb.id
2538: AND gtl.primary_yn = 'N'

Line 2552: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2548: )
2549: AND EXISTS
2550: (
2551: SELECT 1
2552: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2553: WHERE primary_yn = 'Y'
2554: AND gtlpri.gtt_id = p_gtt_id
2555: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2556: );

Line 2570: FROM OKL_ST_GEN_TMPT_LNS gtl

2566: ,'RENEWAL_RENT'
2567: )
2568: MINUS
2569: SELECT distinct stb.stream_type_purpose purpose
2570: FROM OKL_ST_GEN_TMPT_LNS gtl
2571: , okl_strm_type_b stb
2572: , okl_strm_type_b sstb
2573: WHERE gtl.dependent_sty_id = stb.id
2574: AND gtl.primary_yn = 'N'

Line 2590: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2586: )
2587: AND EXISTS
2588: (
2589: SELECT 1
2590: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2591: WHERE primary_yn = 'Y'
2592: AND gtlpri.gtt_id = p_gtt_id
2593: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2594: );

Line 2612: FROM OKL_ST_GEN_TMPT_LNS gtl

2608: ,'RV_INSURANCE_PREMIUM'
2609: )
2610: MINUS
2611: SELECT distinct stb.stream_type_purpose purpose
2612: FROM OKL_ST_GEN_TMPT_LNS gtl
2613: , okl_strm_type_b stb
2614: , okl_strm_type_b sstb
2615: WHERE gtl.dependent_sty_id = stb.id
2616: AND gtl.primary_yn = 'N'

Line 2636: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2632: )
2633: AND EXISTS
2634: (
2635: SELECT 1
2636: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2637: WHERE primary_yn = 'Y'
2638: AND gtlpri.gtt_id = p_gtt_id
2639: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2640: );

Line 2652: FROM OKL_ST_GEN_TMPT_LNS gtl

2648: 'RENT_ACCRUAL'
2649: )
2650: MINUS
2651: SELECT distinct stb.stream_type_purpose purpose
2652: FROM OKL_ST_GEN_TMPT_LNS gtl
2653: , okl_strm_type_b stb
2654: , okl_strm_type_b sstb
2655: WHERE gtl.dependent_sty_id = stb.id
2656: AND gtl.primary_yn = 'N'

Line 2670: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2666: )
2667: AND EXISTS
2668: (
2669: SELECT 1
2670: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2671: WHERE primary_yn = 'Y'
2672: AND gtlpri.gtt_id = p_gtt_id
2673: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2674: );

Line 2682: FROM OKL_ST_GEN_TMPT_LNS gtl

2678: CURSOR purposes_for_df_and_st_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2679: (
2680: -- Retrieve the List of Primary Stream Purposes in the Template
2681: SELECT distinct stb.stream_type_purpose purpose
2682: FROM OKL_ST_GEN_TMPT_LNS gtl
2683: , okl_strm_type_b stb
2684: WHERE gtl.primary_sty_id = stb.id
2685: AND gtl.primary_yn = 'Y'
2686: AND GTL.GTT_ID = p_gtt_id

Line 2690: FROM OKL_ST_GEN_TMPT_LNS gtl

2686: AND GTL.GTT_ID = p_gtt_id
2687: UNION
2688: -- Retrieve the List of Dependent Stream Purposes in the Template
2689: SELECT distinct stb.stream_type_purpose purpose
2690: FROM OKL_ST_GEN_TMPT_LNS gtl
2691: , okl_strm_type_b stb
2692: WHERE gtl.dependent_sty_id = stb.id
2693: AND gtl.primary_yn = 'N'
2694: and GTL.GTT_ID = p_gtt_id

Line 2843: FROM OKL_ST_GEN_TMPT_LNS gtl

2839: CURSOR purposes_for_op_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2840: (
2841: -- Retrieve the List of Primary Stream Purposes in the Template
2842: SELECT distinct stb.stream_type_purpose purpose
2843: FROM OKL_ST_GEN_TMPT_LNS gtl
2844: , okl_strm_type_b stb
2845: WHERE gtl.primary_sty_id = stb.id
2846: AND gtl.primary_yn = 'Y'
2847: AND GTL.GTT_ID = p_gtt_id

Line 2851: FROM OKL_ST_GEN_TMPT_LNS gtl

2847: AND GTL.GTT_ID = p_gtt_id
2848: UNION
2849: -- Retrieve the List of Dependent Stream Purposes in the Template
2850: SELECT distinct stb.stream_type_purpose purpose
2851: FROM OKL_ST_GEN_TMPT_LNS gtl
2852: , okl_strm_type_b stb
2853: WHERE gtl.dependent_sty_id = stb.id
2854: AND gtl.primary_yn = 'N'
2855: and GTL.GTT_ID = p_gtt_id

Line 3004: FROM OKL_ST_GEN_TMPT_LNS gtl

3000: CURSOR purposes_for_ln_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
3001: (
3002: -- Retrieve the List of Primary Stream Purposes in the Template
3003: SELECT distinct stb.stream_type_purpose purpose
3004: FROM OKL_ST_GEN_TMPT_LNS gtl
3005: , okl_strm_type_b stb
3006: WHERE gtl.primary_sty_id = stb.id
3007: AND gtl.primary_yn = 'Y'
3008: AND GTL.GTT_ID = p_gtt_id

Line 3012: FROM OKL_ST_GEN_TMPT_LNS gtl

3008: AND GTL.GTT_ID = p_gtt_id
3009: UNION
3010: -- Retrieve the List of Dependent Stream Purposes in the Template
3011: SELECT distinct stb.stream_type_purpose purpose
3012: FROM OKL_ST_GEN_TMPT_LNS gtl
3013: , okl_strm_type_b stb
3014: WHERE gtl.dependent_sty_id = stb.id
3015: AND gtl.primary_yn = 'N'
3016: and GTL.GTT_ID = p_gtt_id

Line 3699: FROM OKL_ST_GEN_TMPT_LNS gtl

3695:
3696: -- 1. Only one stream type of the following primary purposes should be defined.
3697: CURSOR inv_only_one_as_primary_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
3698: SELECT stb.stream_type_purpose purpose, count(stb.stream_type_purpose)
3699: FROM OKL_ST_GEN_TMPT_LNS gtl
3700: ,okl_strm_type_b stb
3701: WHERE gtl.primary_sty_id = stb.id
3702: AND gtl.primary_yn = 'Y'
3703: AND stb.stream_type_purpose IN

Line 3756: FROM OKL_ST_GEN_TMPT_LNS gtl

3752: ,'PV_RV_SECURITIZED'
3753: )
3754: MINUS
3755: SELECT distinct stb.stream_type_purpose purpose
3756: FROM OKL_ST_GEN_TMPT_LNS gtl
3757: , okl_strm_type_b stb
3758: WHERE gtl.primary_sty_id = stb.id
3759: AND gtl.primary_yn = 'Y'
3760: AND stb.stream_type_purpose IN

Line 4020: ,p_pri_sty_id IN okl_st_gen_tmpt_lns.primary_Sty_id%type

4016: ,x_return_status OUT NOCOPY VARCHAR2
4017: ,x_msg_count OUT NOCOPY NUMBER
4018: ,x_msg_data OUT NOCOPY VARCHAR2
4019: ,p_gtt_id IN okl_st_gen_templates.id%type
4020: ,p_pri_sty_id IN okl_st_gen_tmpt_lns.primary_Sty_id%type
4021: ,x_missing_deps OUT NOCOPY VARCHAR2
4022: ,x_show_warn_flag OUT NOCOPY VARCHAR2
4023: ,p_deal_type IN VARCHAR2
4024: )IS

Line 4034: ,p_pri_sty_id IN OKL_ST_GEN_TMPT_LNS.primary_sty_id%TYPE

4030: l_purpose_list VARCHAR2(10000);
4031: -- Cursor to fetch the missed dependent streams for a Primary Stream type
4032: -- with purpose as 'Fee Payment'
4033: CURSOR fee_payment_man_dep_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type
4034: ,p_pri_sty_id IN OKL_ST_GEN_TMPT_LNS.primary_sty_id%TYPE
4035: ,p_exclude_fr IN VARCHAR2 ) IS
4036: SELECT LOOKUP_CODE PURPOSE
4037: FROM FND_LOOKUPS
4038: WHERE LOOKUP_TYPE = G_OKL_FIN_DEPENDENT_PURPOSES

Line 4055: FROM OKL_ST_GEN_TMPT_LNS GTL

4051: )
4052: MINUS
4053: (
4054: SELECT STB.STREAM_TYPE_PURPOSE PURPOSE
4055: FROM OKL_ST_GEN_TMPT_LNS GTL
4056: ,OKL_STRM_TYPE_B STB
4057: WHERE GTL.GTT_ID = p_gtt_id
4058: AND GTL.PRIMARY_YN = 'N'
4059: AND GTL.DEPENDENT_STY_ID = STB.ID

Line 4158: FROM OKL_ST_GEN_TMPT_LNS GTL

4154: SELECT GTL.PRIMARY_STY_ID PRI_STY_ID
4155: ,GTS.DEAL_TYPE DEAL_TYPE
4156: ,STB.ID STRM_TYPE_ID
4157: ,STB.CODE STRM_NAME
4158: FROM OKL_ST_GEN_TMPT_LNS GTL
4159: ,OKL_ST_GEN_TMPT_SETS GTS
4160: ,OKL_ST_GEN_TEMPLATES GTT
4161: ,OKL_STRM_TYPE_B STB
4162: WHERE GTL.GTT_ID = p_gtt_id

Line 4492: ,p_pri_sty_id IN OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE

4488: ,x_return_status OUT NOCOPY VARCHAR2
4489: ,x_msg_count OUT NOCOPY NUMBER
4490: ,x_msg_data OUT NOCOPY VARCHAR2
4491: ,p_gtt_id IN OKL_ST_GEN_TEMPLATES.ID%type
4492: ,p_pri_sty_id IN OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE
4493: ,p_gtlv_tbl IN gtlv_tbl_type
4494: ,x_missing_deps OUT NOCOPY VARCHAR2
4495: ,x_show_warn_flag OUT NOCOPY VARCHAR2
4496: )IS

Line 4524: ,p_pri_id IN OKL_ST_GEN_TMPT_LNS.primary_Sty_id%TYPE) IS

4520:
4521: -- Modified by RGOOTY
4522: -- Bug 4054596: Issue No. 5: Start
4523: CURSOR okl_dep_purpose_dup_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%TYPE
4524: ,p_pri_id IN OKL_ST_GEN_TMPT_LNS.primary_Sty_id%TYPE) IS
4525: SELECT STY.STREAM_TYPE_PURPOSE PURPOSE_CODE,
4526: ( SELECT MEANING FROM
4527: FND_LOOKUPS
4528: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'

Line 4532: FROM OKL_ST_GEN_TMPT_LNS GTL

4528: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
4529: AND LOOKUP_CODE = STY.STREAM_TYPE_PURPOSE
4530: ) PURPOSE_MEANING,
4531: COUNT( STY.STREAM_TYPE_PURPOSE) streams_count
4532: FROM OKL_ST_GEN_TMPT_LNS GTL
4533: ,okl_Strm_Type_b STY
4534: WHERE GTL.DEPENDENT_STY_ID = STY.ID
4535: AND PRIMARY_YN = 'N'
4536: AND GTL.GTT_ID = p_gtt_id

Line 4542: l_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE;

4538: GROUP BY STY.STREAM_TYPE_PURPOSE
4539: HAVING COUNT( STREAM_TYPE_PURPOSE) > 1;
4540:
4541: l_found VARCHAR2(1) := OKL_API.G_FALSE;
4542: l_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE;
4543: l_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE;
4544: l_purp_list VARCHAR2(250);
4545: -- Bug 4054596: Issue No. 5: End
4546:

Line 4543: l_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE;

4539: HAVING COUNT( STREAM_TYPE_PURPOSE) > 1;
4540:
4541: l_found VARCHAR2(1) := OKL_API.G_FALSE;
4542: l_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE;
4543: l_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE;
4544: l_purp_list VARCHAR2(250);
4545: -- Bug 4054596: Issue No. 5: End
4546:
4547: l_tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE;

Line 4560: ,p_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE)

4556: WHERE GTS.ID = GTT.GTS_ID
4557: AND GTT.ID = p_gtt_id;
4558:
4559: CURSOR tmpt_pri_strm_det_csr( p_gtt_id OKL_ST_GEN_TEMPLATES.ID%TYPE
4560: ,p_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE)
4561: IS
4562: SELECT STY.STREAM_TYPE_PURPOSE PRI_STRM_PURPOSE
4563: FROM OKL_ST_GEN_TMPT_LNS GTL
4564: ,OKL_STRM_TYPE_B STY

Line 4563: FROM OKL_ST_GEN_TMPT_LNS GTL

4559: CURSOR tmpt_pri_strm_det_csr( p_gtt_id OKL_ST_GEN_TEMPLATES.ID%TYPE
4560: ,p_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE)
4561: IS
4562: SELECT STY.STREAM_TYPE_PURPOSE PRI_STRM_PURPOSE
4563: FROM OKL_ST_GEN_TMPT_LNS GTL
4564: ,OKL_STRM_TYPE_B STY
4565: WHERE STY.ID = GTL.PRIMARY_sTY_ID
4566: AND GTL.PRIMARY_YN = 'Y'
4567: AND GTL.GTT_ID = p_gtt_id

Line 4845: FROM OKL_ST_GEN_TMPT_LNS GTL

4841: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
4842: AND LOOKUP_CODE = STY.STREAM_TYPE_PURPOSE
4843: ) DEP_PURPOSE_MEANING,
4844: COUNT( STY.STREAM_TYPE_PURPOSE) streams_count
4845: FROM OKL_ST_GEN_TMPT_LNS GTL
4846: ,OKL_ST_GEN_TMPT_LNS GTLP
4847: ,OKL_STRM_TYPE_B STY
4848: ,OKL_STRM_TYPE_B STYP
4849: WHERE GTL.DEPENDENT_STY_ID = STY.ID

Line 4846: ,OKL_ST_GEN_TMPT_LNS GTLP

4842: AND LOOKUP_CODE = STY.STREAM_TYPE_PURPOSE
4843: ) DEP_PURPOSE_MEANING,
4844: COUNT( STY.STREAM_TYPE_PURPOSE) streams_count
4845: FROM OKL_ST_GEN_TMPT_LNS GTL
4846: ,OKL_ST_GEN_TMPT_LNS GTLP
4847: ,OKL_STRM_TYPE_B STY
4848: ,OKL_STRM_TYPE_B STYP
4849: WHERE GTL.DEPENDENT_STY_ID = STY.ID
4850: AND GTLP.PRIMARY_STY_ID = STYP.ID