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_ASSET_SUBSIDY_PVT dependencies on OKL_SUBSIDY_POOLS_B

Line 1930: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;

1926: l_chk_required varchar2(1);
1927: l_applicable varchar2(10);
1928:
1929: lx_conversion_rate NUMBER;
1930: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
1931: lx_subsidy_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;
1932: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
1933: lx_sub_pool_balance NUMBER;
1934:

Line 1931: lx_subsidy_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;

1927: l_applicable varchar2(10);
1928:
1929: lx_conversion_rate NUMBER;
1930: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
1931: lx_subsidy_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;
1932: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
1933: lx_sub_pool_balance NUMBER;
1934:
1935: halt_validation exception;

Line 1932: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;

1928:
1929: lx_conversion_rate NUMBER;
1930: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
1931: lx_subsidy_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;
1932: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
1933: lx_sub_pool_balance NUMBER;
1934:
1935: halt_validation exception;
1936:

Line 2490: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;

2486: l_chk_required varchar2(1);
2487: l_applicable varchar2(10);
2488:
2489: lx_conversion_rate NUMBER;
2490: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
2491: lx_subsidy_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;
2492: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
2493: lx_sub_pool_balance NUMBER;
2494:

Line 2491: lx_subsidy_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;

2487: l_applicable varchar2(10);
2488:
2489: lx_conversion_rate NUMBER;
2490: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
2491: lx_subsidy_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;
2492: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
2493: lx_sub_pool_balance NUMBER;
2494:
2495: halt_validation exception;

Line 2492: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;

2488:
2489: lx_conversion_rate NUMBER;
2490: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
2491: lx_subsidy_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;
2492: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
2493: lx_sub_pool_balance NUMBER;
2494:
2495: halt_validation exception;
2496:

Line 2808: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;

2804:
2805:
2806: l_applicable VARCHAR2(10);
2807: lx_conversion_rate NUMBER;
2808: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
2809: lx_subsidy_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;
2810: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
2811: lx_sub_pool_balance NUMBER;
2812: -- local variables for sales quote usage. when called from LA, the p_asset_cle_id is passed and

Line 2809: lx_subsidy_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;

2805:
2806: l_applicable VARCHAR2(10);
2807: lx_conversion_rate NUMBER;
2808: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
2809: lx_subsidy_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;
2810: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
2811: lx_sub_pool_balance NUMBER;
2812: -- local variables for sales quote usage. when called from LA, the p_asset_cle_id is passed and
2813: -- p_ast_date_sq is p_trx_curr_code are null, for SQ, the case is converse

Line 2810: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;

2806: l_applicable VARCHAR2(10);
2807: lx_conversion_rate NUMBER;
2808: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
2809: lx_subsidy_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;
2810: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
2811: lx_sub_pool_balance NUMBER;
2812: -- local variables for sales quote usage. when called from LA, the p_asset_cle_id is passed and
2813: -- p_ast_date_sq is p_trx_curr_code are null, for SQ, the case is converse
2814: lv_asset_curr_code okc_k_lines_b.currency_code%TYPE;

Line 3053: ,x_subsidy_pool_id OUT NOCOPY okl_subsidy_pools_b.id%TYPE

3049: END validate_subsidy_pool_applic;
3050:
3051:
3052: FUNCTION is_sub_assoc_with_pool(p_subsidy_id IN okl_subsidies_b.id%TYPE
3053: ,x_subsidy_pool_id OUT NOCOPY okl_subsidy_pools_b.id%TYPE
3054: ,x_sub_pool_curr_code OUT NOCOPY okl_subsidy_pools_b.currency_code%TYPE) RETURN VARCHAR2 IS
3055: CURSOR c_subsidy_csr IS
3056: SELECT sub.subsidy_pool_id,pool.currency_code
3057: FROM okl_subsidies_b sub

Line 3054: ,x_sub_pool_curr_code OUT NOCOPY okl_subsidy_pools_b.currency_code%TYPE) RETURN VARCHAR2 IS

3050:
3051:
3052: FUNCTION is_sub_assoc_with_pool(p_subsidy_id IN okl_subsidies_b.id%TYPE
3053: ,x_subsidy_pool_id OUT NOCOPY okl_subsidy_pools_b.id%TYPE
3054: ,x_sub_pool_curr_code OUT NOCOPY okl_subsidy_pools_b.currency_code%TYPE) RETURN VARCHAR2 IS
3055: CURSOR c_subsidy_csr IS
3056: SELECT sub.subsidy_pool_id,pool.currency_code
3057: FROM okl_subsidies_b sub
3058: ,okl_subsidy_pools_b pool

Line 3058: ,okl_subsidy_pools_b pool

3054: ,x_sub_pool_curr_code OUT NOCOPY okl_subsidy_pools_b.currency_code%TYPE) RETURN VARCHAR2 IS
3055: CURSOR c_subsidy_csr IS
3056: SELECT sub.subsidy_pool_id,pool.currency_code
3057: FROM okl_subsidies_b sub
3058: ,okl_subsidy_pools_b pool
3059: WHERE sub.id = p_subsidy_id
3060: AND sub.subsidy_pool_id = pool.id;
3061: cv_subsidy c_subsidy_csr%ROWTYPE;
3062: lv_return_status VARCHAR2(1);

Line 3074: FUNCTION is_sub_pool_active(p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE

3070: END IF;
3071: return lv_return_status;
3072: END is_sub_assoc_with_pool;
3073:
3074: FUNCTION is_sub_pool_active(p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
3075: ,x_pool_status OUT NOCOPY okl_subsidy_pools_b.decision_status_code%TYPE) RETURN VARCHAR2 IS
3076: CURSOR c_sub_pool_csr IS
3077: SELECT decision_status_code
3078: ,effective_from_date

Line 3075: ,x_pool_status OUT NOCOPY okl_subsidy_pools_b.decision_status_code%TYPE) RETURN VARCHAR2 IS

3071: return lv_return_status;
3072: END is_sub_assoc_with_pool;
3073:
3074: FUNCTION is_sub_pool_active(p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
3075: ,x_pool_status OUT NOCOPY okl_subsidy_pools_b.decision_status_code%TYPE) RETURN VARCHAR2 IS
3076: CURSOR c_sub_pool_csr IS
3077: SELECT decision_status_code
3078: ,effective_from_date
3079: ,effective_to_date

Line 3080: FROM okl_subsidy_pools_b

3076: CURSOR c_sub_pool_csr IS
3077: SELECT decision_status_code
3078: ,effective_from_date
3079: ,effective_to_date
3080: FROM okl_subsidy_pools_b
3081: WHERE id = p_subsidy_pool_id;
3082: cv_sub_pool c_sub_pool_csr%ROWTYPE;
3083: lv_return_status VARCHAR2(1);
3084: BEGIN

Line 3095: FUNCTION is_sub_pool_active_by_date(p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE

3091: END IF;
3092: return lv_return_status;
3093: END is_sub_pool_active;
3094:
3095: FUNCTION is_sub_pool_active_by_date(p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
3096: ,p_asset_date IN okc_k_lines_b.start_date%TYPE
3097: ) RETURN VARCHAR2 IS
3098: CURSOR c_sub_pool_csr IS
3099: SELECT effective_from_date

Line 3101: FROM okl_subsidy_pools_b

3097: ) RETURN VARCHAR2 IS
3098: CURSOR c_sub_pool_csr IS
3099: SELECT effective_from_date
3100: ,effective_to_date
3101: FROM okl_subsidy_pools_b
3102: WHERE id = p_subsidy_pool_id;
3103: cv_sub_pool c_sub_pool_csr%ROWTYPE;
3104: lv_return_status VARCHAR2(1);
3105: x_return_status VARCHAR2(1);

Line 3118: FUNCTION is_sub_pool_conv_rate_valid(p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE

3114: END IF;
3115: return lv_return_status;
3116: END is_sub_pool_active_by_date;
3117:
3118: FUNCTION is_sub_pool_conv_rate_valid(p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
3119: ,p_asset_date IN okc_k_lines_b.start_date%TYPE
3120: ,p_trx_currency_code IN okc_k_headers_b.currency_code%TYPE
3121: ,x_conversion_rate OUT NOCOPY NUMBER) RETURN VARCHAR2 IS
3122: CURSOR c_sub_pool_csr IS

Line 3125: FROM okl_subsidy_pools_b

3121: ,x_conversion_rate OUT NOCOPY NUMBER) RETURN VARCHAR2 IS
3122: CURSOR c_sub_pool_csr IS
3123: SELECT currency_code
3124: ,currency_conversion_type
3125: FROM okl_subsidy_pools_b
3126: WHERE id = p_subsidy_pool_id;
3127: cv_sub_pool c_sub_pool_csr%ROWTYPE;
3128: lv_return_status VARCHAR2(1);
3129: x_return_status VARCHAR2(1);

Line 3156: FUNCTION is_balance_valid_before_add (p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE

3152: x_conversion_rate := lv_conversion_rate;
3153: return lv_return_status;
3154: END is_sub_pool_conv_rate_valid;
3155:
3156: FUNCTION is_balance_valid_before_add (p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
3157: , x_pool_balance OUT NOCOPY NUMBER) RETURN VARCHAR2 IS
3158: CURSOR c_sub_pool_csr IS
3159: SELECT NVL(total_budgets,0) total_budget_amount
3160: ,NVL(total_subsidy_amount,0) total_subsidy_amount

Line 3161: FROM okl_subsidy_pools_b

3157: , x_pool_balance OUT NOCOPY NUMBER) RETURN VARCHAR2 IS
3158: CURSOR c_sub_pool_csr IS
3159: SELECT NVL(total_budgets,0) total_budget_amount
3160: ,NVL(total_subsidy_amount,0) total_subsidy_amount
3161: FROM okl_subsidy_pools_b
3162: WHERE id = p_subsidy_pool_id;
3163: cv_sub_pool c_sub_pool_csr%ROWTYPE;
3164: lv_return_status VARCHAR2(1);
3165: BEGIN

Line 3212: CURSOR c_get_pool_amount_csr (p_subsidy_pool_id okl_subsidy_pools_b.id%TYPE)IS

3208: FROM okc_k_lines_b
3209: WHERE id = p_asset_id;
3210: cv_get_asset c_get_asset_csr%ROWTYPE;
3211:
3212: CURSOR c_get_pool_amount_csr (p_subsidy_pool_id okl_subsidy_pools_b.id%TYPE)IS
3213: SELECT nvl(total_budgets,0) total_budgets
3214: ,nvl(total_subsidy_amount,0) total_subsidy_amount
3215: , subsidy_pool_name
3216: FROM okl_subsidy_pools_b

Line 3216: FROM okl_subsidy_pools_b

3212: CURSOR c_get_pool_amount_csr (p_subsidy_pool_id okl_subsidy_pools_b.id%TYPE)IS
3213: SELECT nvl(total_budgets,0) total_budgets
3214: ,nvl(total_subsidy_amount,0) total_subsidy_amount
3215: , subsidy_pool_name
3216: FROM okl_subsidy_pools_b
3217: WHERE id = p_subsidy_pool_id;
3218:
3219: --START: 24-Oct-2005 cklee - Fixed bug#4687505 |
3220: CURSOR c_subsidy_name_csr(p_subsidy_id number) IS

Line 3231: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;

3227:
3228: cv_pool_amount c_get_pool_amount_csr%ROWTYPE;
3229:
3230: lv_return_status VARCHAR2(1);
3231: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
3232: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
3233: lx_conversion_rate NUMBER;
3234: lx_conversion_round_amt NUMBER;
3235: l_amount_in_pool_curr NUMBER;

Line 3232: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;

3228: cv_pool_amount c_get_pool_amount_csr%ROWTYPE;
3229:
3230: lv_return_status VARCHAR2(1);
3231: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
3232: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
3233: lx_conversion_rate NUMBER;
3234: lx_conversion_round_amt NUMBER;
3235: l_amount_in_pool_curr NUMBER;
3236: l_api_version CONSTANT NUMBER DEFAULT 1.0;

Line 3426: CURSOR c_get_pool_amount_csr (p_subsidy_pool_id okl_subsidy_pools_b.id%TYPE)IS

3422: ,x_msg_data OUT NOCOPY VARCHAR2
3423: ) IS
3424:
3425:
3426: CURSOR c_get_pool_amount_csr (p_subsidy_pool_id okl_subsidy_pools_b.id%TYPE)IS
3427: SELECT nvl(total_budgets,0) total_budgets
3428: ,nvl(total_subsidy_amount,0) total_subsidy_amount
3429: , subsidy_pool_name
3430: FROM okl_subsidy_pools_b

Line 3430: FROM okl_subsidy_pools_b

3426: CURSOR c_get_pool_amount_csr (p_subsidy_pool_id okl_subsidy_pools_b.id%TYPE)IS
3427: SELECT nvl(total_budgets,0) total_budgets
3428: ,nvl(total_subsidy_amount,0) total_subsidy_amount
3429: , subsidy_pool_name
3430: FROM okl_subsidy_pools_b
3431: WHERE id = p_subsidy_pool_id;
3432:
3433: CURSOR c_subsidy_name_csr(p_subsidy_id number) IS
3434: select sub.name

Line 3443: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;

3439:
3440: cv_pool_amount c_get_pool_amount_csr%ROWTYPE;
3441:
3442: lv_return_status VARCHAR2(1);
3443: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
3444: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
3445: lx_conversion_rate NUMBER;
3446: lx_conversion_round_amt NUMBER;
3447: l_amount_in_pool_curr NUMBER;

Line 3444: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;

3440: cv_pool_amount c_get_pool_amount_csr%ROWTYPE;
3441:
3442: lv_return_status VARCHAR2(1);
3443: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
3444: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
3445: lx_conversion_rate NUMBER;
3446: lx_conversion_round_amt NUMBER;
3447: l_amount_in_pool_curr NUMBER;
3448: l_api_version CONSTANT NUMBER DEFAULT 1.0;