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 FND_LOOKUPS

Line 4: FUNCTION GET_LOOKUP_MEANING( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE

1: Package Body okl_strm_gen_template_pvt as
2: /* $Header: OKLRTSGB.pls 120.57 2008/05/21 23:41:25 skkoppul noship $ */
3:
4: FUNCTION GET_LOOKUP_MEANING( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
5: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
6: RETURN VARCHAR
7: IS
8: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type

Line 5: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)

1: Package Body okl_strm_gen_template_pvt as
2: /* $Header: OKLRTSGB.pls 120.57 2008/05/21 23:41:25 skkoppul noship $ */
3:
4: FUNCTION GET_LOOKUP_MEANING( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
5: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
6: RETURN VARCHAR
7: IS
8: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type
9: ,p_lookup_code fnd_lookups.lookup_code%type)

Line 8: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type

4: FUNCTION GET_LOOKUP_MEANING( p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE
5: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
6: RETURN VARCHAR
7: IS
8: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type
9: ,p_lookup_code fnd_lookups.lookup_code%type)
10: IS
11: SELECT MEANING
12: FROM FND_LOOKUPS FND

Line 9: ,p_lookup_code fnd_lookups.lookup_code%type)

5: ,p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
6: RETURN VARCHAR
7: IS
8: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type
9: ,p_lookup_code fnd_lookups.lookup_code%type)
10: IS
11: SELECT MEANING
12: FROM FND_LOOKUPS FND
13: WHERE FND.LOOKUP_TYPE = p_lookup_type

Line 12: FROM FND_LOOKUPS FND

8: CURSOR fnd_lookup_csr( p_lookup_type fnd_lookups.lookup_type%type
9: ,p_lookup_code fnd_lookups.lookup_code%type)
10: IS
11: SELECT MEANING
12: FROM FND_LOOKUPS FND
13: WHERE FND.LOOKUP_TYPE = p_lookup_type
14: AND FND.LOOKUP_CODE = p_lookup_code;
15:
16: l_return_value VARCHAR2(200) := OKL_API.G_MISS_CHAR;

Line 2133: FROM FND_LOOKUPS

2129:
2130: -- 3. All of the following primary purposes must be defined
2131: CURSOR fin_mandatory_pri_all_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2132: SELECT LOOKUP_CODE PURPOSE
2133: FROM FND_LOOKUPS
2134: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2135: AND LOOKUP_CODE IN
2136: (
2137: 'CURE'

Line 2197: FROM FND_LOOKUPS

2193: and GTL.GTT_ID = p_gtt_id;
2194:
2195: CURSOR fin_mandatory_pri_ln_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2196: SELECT LOOKUP_CODE PURPOSE
2197: FROM FND_LOOKUPS
2198: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2199: AND LOOKUP_CODE IN
2200: (
2201: 'VARIABLE_INTEREST'

Line 2217: FROM FND_LOOKUPS

2213: and GTL.GTT_ID = p_gtt_id;
2214:
2215: CURSOR fin_mandatory_pri_ls_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2216: SELECT LOOKUP_CODE PURPOSE
2217: FROM FND_LOOKUPS
2218: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2219: AND LOOKUP_CODE IN
2220: (
2221: 'RESIDUAL_VALUE'

Line 2238: FROM FND_LOOKUPS

2234:
2235: --Bug 5139013 dpsingh start
2236: CURSOR fin_mandatory_pri_ic_float_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2237: SELECT LOOKUP_CODE PURPOSE
2238: FROM FND_LOOKUPS
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

Line 2255: FROM FND_LOOKUPS

2251: -- Modified by RGOOTY
2252: -- Bug 4111081: Start
2253: CURSOR fin_mandatory_pri_op_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2254: SELECT LOOKUP_CODE PURPOSE
2255: FROM FND_LOOKUPS
2256: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2257: AND LOOKUP_CODE IN
2258: (
2259: 'INVESTOR_RENTAL_ACCRUAL'

Line 2275: FROM FND_LOOKUPS

2271: and GTL.GTT_ID = p_gtt_id;
2272:
2273: CURSOR fin_mandatory_pri_df_n_st_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2274: SELECT LOOKUP_CODE PURPOSE
2275: FROM FND_LOOKUPS
2276: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2277: AND LOOKUP_CODE IN
2278: (
2279: 'INVESTOR_PRETAX_INCOME'

Line 2300: FROM FND_LOOKUPS

2296:
2297: -- 4. Mandatory Dependent Streams
2298: CURSOR man_dep_all_rent_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2299: SELECT LOOKUP_CODE PURPOSE
2300: FROM FND_LOOKUPS
2301: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2302: AND LOOKUP_CODE IN
2303: (
2304: 'ADVANCE_RENT'

Line 2334: FROM FND_LOOKUPS

2330: );
2331:
2332: CURSOR man_dep_ln_rent_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2333: SELECT LOOKUP_CODE PURPOSE
2334: FROM FND_LOOKUPS
2335: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2336: AND LOOKUP_CODE IN
2337: (
2338: 'INTEREST_INCOME'

Line 2380: FROM FND_LOOKUPS

2376: );
2377:
2378: CURSOR man_dep_ln_vrs_rent_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2379: SELECT LOOKUP_CODE PURPOSE
2380: FROM FND_LOOKUPS
2381: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2382: AND LOOKUP_CODE IN
2383: (
2384: 'DAILY_INTEREST_PRINCIPAL'

Line 2428: FROM FND_LOOKUPS

2424: );
2425:
2426: CURSOR man_dep_dfstop_vrs_rent_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2427: SELECT LOOKUP_CODE PURPOSE
2428: FROM FND_LOOKUPS
2429: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2430: AND LOOKUP_CODE IN
2431: (
2432: 'FLOAT_FACTOR_ADJUSTMENT'

Line 2462: FROM FND_LOOKUPS

2458: );
2459:
2460: CURSOR man_dep_ln_icc_vrs_rent_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2461: SELECT LOOKUP_CODE PURPOSE
2462: FROM FND_LOOKUPS
2463: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2464: AND LOOKUP_CODE IN
2465: (
2466: 'INTEREST_CATCHUP'

Line 2497: FROM FND_LOOKUPS

2493:
2494: -- rgooty BUG#4290143 start
2495: CURSOR man_dep_ln_var_int_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2496: SELECT LOOKUP_CODE PURPOSE
2497: FROM FND_LOOKUPS
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

Line 2526: FROM FND_LOOKUPS

2522: -- rgooty BUG#4290143 end
2523:
2524: CURSOR man_dep_df_st_rent_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2525: SELECT LOOKUP_CODE PURPOSE
2526: FROM FND_LOOKUPS
2527: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2528: AND LOOKUP_CODE IN
2529: (
2530: 'LEASE_INCOME'

Line 2560: FROM FND_LOOKUPS

2556: );
2557:
2558: CURSOR man_dep_ls_rent_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2559: SELECT LOOKUP_CODE PURPOSE
2560: FROM FND_LOOKUPS
2561: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2562: AND LOOKUP_CODE IN
2563: (
2564: 'PASS_THROUGH_EVERGREEN_RENT'

Line 2598: FROM FND_LOOKUPS

2594: );
2595:
2596: CURSOR man_dep_ls_rv_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2597: SELECT LOOKUP_CODE PURPOSE
2598: FROM FND_LOOKUPS
2599: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2600: AND LOOKUP_CODE IN
2601: (
2602: 'PV_RV'

Line 2644: FROM FND_LOOKUPS

2640: );
2641:
2642: CURSOR man_dep_op_rent_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
2643: SELECT LOOKUP_CODE PURPOSE
2644: FROM FND_LOOKUPS
2645: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2646: AND LOOKUP_CODE IN
2647: (
2648: 'RENT_ACCRUAL'

Line 2698: FROM FND_LOOKUPS

2694: and GTL.GTT_ID = p_gtt_id
2695: )
2696: MINUS
2697: SELECT LOOKUP_CODE
2698: FROM FND_LOOKUPS
2699: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2700: AND LOOKUP_CODE in
2701: (
2702: 'ACCOUNTING'

Line 2859: FROM FND_LOOKUPS

2855: and GTL.GTT_ID = p_gtt_id
2856: )
2857: MINUS
2858: SELECT LOOKUP_CODE
2859: FROM FND_LOOKUPS
2860: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
2861: AND LOOKUP_CODE in
2862: (
2863: 'ACCOUNTING'

Line 3020: FROM FND_LOOKUPS

3016: and GTL.GTT_ID = p_gtt_id
3017: )
3018: MINUS
3019: SELECT LOOKUP_CODE
3020: FROM FND_LOOKUPS
3021: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
3022: AND LOOKUP_CODE in
3023: (
3024: 'ACCOUNTING'

Line 3728: FROM FND_LOOKUPS

3724:
3725: -- 3. All of the following primary purposes must be defined
3726: CURSOR inv_mandatory_primary_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
3727: SELECT LOOKUP_CODE PURPOSE
3728: FROM FND_LOOKUPS
3729: WHERE LOOKUP_TYPE = 'OKL_STREAM_TYPE_PURPOSE'
3730: AND LOOKUP_CODE IN
3731: (
3732: 'INVESTOR_CNTRCT_OBLIGATION_PAY'

Line 4037: FROM FND_LOOKUPS

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
4039: AND LOOKUP_CODE IN
4040: (
4041: 'AMORTIZE_FEE_INCOME'

Line 4527: FND_LOOKUPS

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'
4529: AND LOOKUP_CODE = STY.STREAM_TYPE_PURPOSE
4530: ) PURPOSE_MEANING,
4531: COUNT( STY.STREAM_TYPE_PURPOSE) streams_count

Line 4840: FROM FND_LOOKUPS

4836: STYP.STREAM_TYPE_PURPOSE PRI_STRM_TYPE_PURPOSE,
4837: -- gboomina Bug 4874272 - Added - End
4838: STY.STREAM_TYPE_PURPOSE DEP_PURPOSE_CODE,
4839: ( SELECT MEANING
4840: FROM FND_LOOKUPS
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