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 836: CURSOR okl_st_gen_tmpt_lns_csr( p_gtt_id IN OKL_ST_GEN_TMPT_LNS.gtt_id%type

832: ,GTT_ID
833: FROM OKL_ST_GEN_PRC_PARAMS
834: where GTT_ID = p_gtt_id;
835:
836: CURSOR okl_st_gen_tmpt_lns_csr( p_gtt_id IN OKL_ST_GEN_TMPT_LNS.gtt_id%type
837: ,p_primary_yn IN OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE) IS
838: SELECT ID
839: ,GTT_ID
840: ,PRIMARY_YN

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

833: FROM OKL_ST_GEN_PRC_PARAMS
834: where GTT_ID = p_gtt_id;
835:
836: CURSOR okl_st_gen_tmpt_lns_csr( p_gtt_id IN OKL_ST_GEN_TMPT_LNS.gtt_id%type
837: ,p_primary_yn IN OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE) IS
838: SELECT ID
839: ,GTT_ID
840: ,PRIMARY_YN
841: ,PRIMARY_STY_ID

Line 844: FROM OKL_ST_GEN_TMPT_LNS

840: ,PRIMARY_YN
841: ,PRIMARY_STY_ID
842: ,DEPENDENT_STY_ID
843: ,PRICING_NAME
844: FROM OKL_ST_GEN_TMPT_LNS
845: where GTT_ID = p_gtt_id
846: AND PRIMARY_YN = p_primary_yn;
847:
848: CURSOR okl_new_version_date_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS

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

1045: END IF;
1046:
1047: -- Fetch all the primary streams and call the insert API
1048: i := 0;
1049: FOR gtlv_rec_temp IN okl_st_gen_tmpt_lns_csr(l_gtt_id, G_INIT_PRIMARY_YN_YES )
1050: LOOP
1051: l_gtlv_tbl_pri_in(i).primary_yn := G_INIT_PRIMARY_YN_YES;
1052: l_gtlv_tbl_pri_in(i).primary_sty_id := gtlv_rec_temp.primary_sty_id;
1053: -- Dependent Streams wont be present for this Stream

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

1077: END IF;
1078:
1079: -- Fetch all the dependent streams and call the insert API
1080: i := 0;
1081: FOR gtlv_rec_temp IN okl_st_gen_tmpt_lns_csr(l_gtt_id, G_INIT_PRIMARY_YN_NO )
1082: LOOP
1083: l_gtlv_tbl_dep_in(i).primary_yn := G_INIT_PRIMARY_YN_NO;
1084: l_gtlv_tbl_dep_in(i).primary_sty_id := gtlv_rec_temp.primary_sty_id;
1085: l_gtlv_tbl_dep_in(i).dependent_sty_id := gtlv_rec_temp.dependent_sty_id;

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

1265: l_gtlv_pri_tbl_del_in gtlv_tbl_type;
1266: l_gtlv_dep_tbl_del_in gtlv_tbl_type;
1267: i NUMBER := 0;
1268:
1269: CURSOR okl_st_gen_tmpt_dep_lns_csr( p_gtt_id IN OKL_ST_GEN_TMPT_LNS.gtt_id%type
1270: ,p_primary_sty_id IN OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID %type) IS
1271: SELECT ID
1272: ,PRIMARY_STY_ID
1273: ,DEPENDENT_STY_ID

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

1266: l_gtlv_dep_tbl_del_in gtlv_tbl_type;
1267: i NUMBER := 0;
1268:
1269: CURSOR okl_st_gen_tmpt_dep_lns_csr( p_gtt_id IN OKL_ST_GEN_TMPT_LNS.gtt_id%type
1270: ,p_primary_sty_id IN OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID %type) IS
1271: SELECT ID
1272: ,PRIMARY_STY_ID
1273: ,DEPENDENT_STY_ID
1274: ,GTT_ID

Line 1275: FROM OKL_ST_GEN_TMPT_LNS

1271: SELECT ID
1272: ,PRIMARY_STY_ID
1273: ,DEPENDENT_STY_ID
1274: ,GTT_ID
1275: FROM OKL_ST_GEN_TMPT_LNS
1276: WHERE PRIMARY_YN = 'N'
1277: AND PRIMARY_STY_ID = p_primary_sty_id
1278: AND GTT_ID = p_gtt_id;
1279: BEGIN

Line 1617: FROM OKL_ST_GEN_TMPT_LNS gtl

1613:
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

Line 1638: FROM OKL_ST_GEN_TMPT_LNS gtl

1634: );
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

Line 2029: FROM OKL_ST_GEN_TMPT_LNS gtl

2025: -- 1. If user selects one of the following Insurance purposes then all the
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'

Line 2055: FROM OKL_ST_GEN_TMPT_LNS gtl

2051: -- or not. So, If they are not defined then that doesnot violoate the logic of the
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

Line 2178: FROM OKL_ST_GEN_TMPT_LNS gtl

2174: ,'REBOOK_BILLING_ADJUSTMENT' -- VR Upgrade.
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

Line 2220: FROM OKL_ST_GEN_TMPT_LNS gtl

2216: 'VARIABLE_INTEREST'
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

Line 2240: FROM OKL_ST_GEN_TMPT_LNS gtl

2236: 'RESIDUAL_VALUE'
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

Line 2258: FROM OKL_ST_GEN_TMPT_LNS gtl

2254: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
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'

Line 2278: FROM OKL_ST_GEN_TMPT_LNS gtl

2274: 'INVESTOR_RENTAL_ACCRUAL'
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

Line 2298: FROM OKL_ST_GEN_TMPT_LNS gtl

2294: 'INVESTOR_PRETAX_INCOME'
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

Line 2323: FROM OKL_ST_GEN_TMPT_LNS gtl

2319: 'ADVANCE_RENT'
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'

Line 2341: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2337: )
2338: AND EXISTS
2339: (
2340: SELECT 1
2341: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2342: WHERE primary_yn = 'Y'
2343: AND gtlpri.gtt_id = p_gtt_id
2344: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2345: );

Line 2363: FROM OKL_ST_GEN_TMPT_LNS gtl

2359: ,'UNSCHEDULED_PRINCIPAL_PAYMENT'
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'

Line 2387: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2383: )
2384: AND EXISTS
2385: (
2386: SELECT 1
2387: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2388: WHERE primary_yn = 'Y'
2389: AND gtlpri.gtt_id = p_gtt_id
2390: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2391: );

Line 2410: FROM OKL_ST_GEN_TMPT_LNS gtl

2406: ,'ACTUAL_INCOME_ACCRUAL'
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'

Line 2435: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2431: )
2432: AND EXISTS
2433: (
2434: SELECT 1
2435: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2436: WHERE primary_yn = 'Y'
2437: AND gtlpri.gtt_id = p_gtt_id
2438: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2439: );

Line 2451: FROM OKL_ST_GEN_TMPT_LNS gtl

2447: 'FLOAT_FACTOR_ADJUSTMENT'
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'

Line 2469: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2465: )
2466: AND EXISTS
2467: (
2468: SELECT 1
2469: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2470: WHERE primary_yn = 'Y'
2471: AND gtlpri.gtt_id = p_gtt_id
2472: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2473: );

Line 2485: FROM OKL_ST_GEN_TMPT_LNS gtl

2481: 'INTEREST_CATCHUP'
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'

Line 2503: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2499: )
2500: AND EXISTS
2501: (
2502: SELECT 1
2503: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2504: WHERE primary_yn = 'Y'
2505: AND gtlpri.gtt_id = p_gtt_id
2506: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2507: );

Line 2517: FROM OKL_ST_GEN_TMPT_LNS gtl

2513: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
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'

Line 2532: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2528: )
2529: AND EXISTS
2530: (
2531: SELECT 1
2532: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2533: WHERE primary_yn = 'Y'
2534: AND gtlpri.gtt_id = p_gtt_id
2535: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2536: );

Line 2549: FROM OKL_ST_GEN_TMPT_LNS gtl

2545: 'LEASE_INCOME'
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'

Line 2567: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2563: )
2564: AND EXISTS
2565: (
2566: SELECT 1
2567: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2568: WHERE primary_yn = 'Y'
2569: AND gtlpri.gtt_id = p_gtt_id
2570: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2571: );

Line 2585: FROM OKL_ST_GEN_TMPT_LNS gtl

2581: ,'RENEWAL_RENT'
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'

Line 2605: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2601: )
2602: AND EXISTS
2603: (
2604: SELECT 1
2605: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2606: WHERE primary_yn = 'Y'
2607: AND gtlpri.gtt_id = p_gtt_id
2608: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2609: );

Line 2627: FROM OKL_ST_GEN_TMPT_LNS gtl

2623: ,'RV_INSURANCE_PREMIUM'
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'

Line 2651: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2647: )
2648: AND EXISTS
2649: (
2650: SELECT 1
2651: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2652: WHERE primary_yn = 'Y'
2653: AND gtlpri.gtt_id = p_gtt_id
2654: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2655: );

Line 2667: FROM OKL_ST_GEN_TMPT_LNS gtl

2663: 'RENT_ACCRUAL'
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'

Line 2685: FROM OKL_ST_GEN_TMPT_LNS gtlpri

2681: )
2682: AND EXISTS
2683: (
2684: SELECT 1
2685: FROM OKL_ST_GEN_TMPT_LNS gtlpri
2686: WHERE primary_yn = 'Y'
2687: AND gtlpri.gtt_id = p_gtt_id
2688: AND gtlpri.primary_sty_id = gtl.primary_sty_id
2689: );

Line 2697: FROM OKL_ST_GEN_TMPT_LNS gtl

2693: CURSOR purposes_for_df_and_st_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
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

Line 2705: FROM OKL_ST_GEN_TMPT_LNS gtl

2701: AND GTL.GTT_ID = p_gtt_id
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

Line 2858: FROM OKL_ST_GEN_TMPT_LNS gtl

2854: CURSOR purposes_for_op_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
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

Line 2866: FROM OKL_ST_GEN_TMPT_LNS gtl

2862: AND GTL.GTT_ID = p_gtt_id
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

Line 3019: FROM OKL_ST_GEN_TMPT_LNS gtl

3015: CURSOR purposes_for_ln_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
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

Line 3027: FROM OKL_ST_GEN_TMPT_LNS gtl

3023: AND GTL.GTT_ID = p_gtt_id
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

Line 3714: FROM OKL_ST_GEN_TMPT_LNS gtl

3710:
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

Line 3771: FROM OKL_ST_GEN_TMPT_LNS gtl

3767: ,'PV_RV_SECURITIZED'
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

Line 4035: ,p_pri_sty_id IN okl_st_gen_tmpt_lns.primary_Sty_id%type

4031: ,x_return_status OUT NOCOPY VARCHAR2
4032: ,x_msg_count OUT NOCOPY NUMBER
4033: ,x_msg_data OUT NOCOPY VARCHAR2
4034: ,p_gtt_id IN okl_st_gen_templates.id%type
4035: ,p_pri_sty_id IN okl_st_gen_tmpt_lns.primary_Sty_id%type
4036: ,x_missing_deps OUT NOCOPY VARCHAR2
4037: ,x_show_warn_flag OUT NOCOPY VARCHAR2
4038: ,p_deal_type IN VARCHAR2
4039: )IS

Line 4049: ,p_pri_sty_id IN OKL_ST_GEN_TMPT_LNS.primary_sty_id%TYPE

4045: l_purpose_list VARCHAR2(10000);
4046: -- Cursor to fetch the missed dependent streams for a Primary Stream type
4047: -- with purpose as 'Fee Payment'
4048: CURSOR fee_payment_man_dep_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type
4049: ,p_pri_sty_id IN OKL_ST_GEN_TMPT_LNS.primary_sty_id%TYPE
4050: ,p_exclude_fr IN VARCHAR2 ) IS
4051: SELECT LOOKUP_CODE PURPOSE
4052: FROM FND_LOOKUPS
4053: WHERE LOOKUP_TYPE = G_OKL_FIN_DEPENDENT_PURPOSES

Line 4070: FROM OKL_ST_GEN_TMPT_LNS GTL

4066: )
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

Line 4173: FROM OKL_ST_GEN_TMPT_LNS GTL

4169: SELECT GTL.PRIMARY_STY_ID PRI_STY_ID
4170: ,GTS.DEAL_TYPE DEAL_TYPE
4171: ,STB.ID STRM_TYPE_ID
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

Line 4507: ,p_pri_sty_id IN OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE

4503: ,x_return_status OUT NOCOPY VARCHAR2
4504: ,x_msg_count OUT NOCOPY NUMBER
4505: ,x_msg_data OUT NOCOPY VARCHAR2
4506: ,p_gtt_id IN OKL_ST_GEN_TEMPLATES.ID%type
4507: ,p_pri_sty_id IN OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE
4508: ,p_gtlv_tbl IN gtlv_tbl_type
4509: ,x_missing_deps OUT NOCOPY VARCHAR2
4510: ,x_show_warn_flag OUT NOCOPY VARCHAR2
4511: )IS

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

4535:
4536: -- Modified by RGOOTY
4537: -- Bug 4054596: Issue No. 5: Start
4538: CURSOR okl_dep_purpose_dup_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%TYPE
4539: ,p_pri_id IN OKL_ST_GEN_TMPT_LNS.primary_Sty_id%TYPE) IS
4540: SELECT STY.STREAM_TYPE_PURPOSE PURPOSE_CODE,
4541: ( SELECT MEANING FROM
4542: FND_LOOKUPS
4543: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'

Line 4547: FROM OKL_ST_GEN_TMPT_LNS GTL

4543: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
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

Line 4557: l_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE;

4553: GROUP BY STY.STREAM_TYPE_PURPOSE
4554: HAVING COUNT( STREAM_TYPE_PURPOSE) > 1;
4555:
4556: l_found VARCHAR2(1) := OKL_API.G_FALSE;
4557: l_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE;
4558: l_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE;
4559: l_purp_list VARCHAR2(250);
4560: -- Bug 4054596: Issue No. 5: End
4561:

Line 4558: l_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE;

4554: HAVING COUNT( STREAM_TYPE_PURPOSE) > 1;
4555:
4556: l_found VARCHAR2(1) := OKL_API.G_FALSE;
4557: l_gtt_id OKL_ST_GEN_TMPT_LNS.GTT_ID%TYPE;
4558: l_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE;
4559: l_purp_list VARCHAR2(250);
4560: -- Bug 4054596: Issue No. 5: End
4561:
4562: l_tmpt_status OKL_ST_GEN_TEMPLATES.TMPT_STATUS%TYPE;

Line 4575: ,p_pri_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE)

4571: WHERE GTS.ID = GTT.GTS_ID
4572: AND GTT.ID = p_gtt_id;
4573:
4574: CURSOR tmpt_pri_strm_det_csr( p_gtt_id OKL_ST_GEN_TEMPLATES.ID%TYPE
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

Line 4578: FROM OKL_ST_GEN_TMPT_LNS GTL

4574: CURSOR tmpt_pri_strm_det_csr( p_gtt_id OKL_ST_GEN_TEMPLATES.ID%TYPE
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

Line 4860: FROM OKL_ST_GEN_TMPT_LNS GTL

4856: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
4857: AND LOOKUP_CODE = STY.STREAM_TYPE_PURPOSE
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

Line 4861: ,OKL_ST_GEN_TMPT_LNS GTLP

4857: AND LOOKUP_CODE = STY.STREAM_TYPE_PURPOSE
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