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.

[Home] [Help]

APPS.PA_FIN_PLAN_UTILS dependencies on PA_AMOUNT_TYPES_B

Line 3213: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE) RETURN NUMBER

3209: This function takes in an amount type code and returns the id
3210: associated with it.
3211: ================================================================= */
3212: FUNCTION get_amttype_id
3213: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE) RETURN NUMBER
3214: is
3215: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;
3216: l_amt_code pa_fp_org_fcst_gen_pub.char240_data_type_table; /* manoj: referred to pa_fp_org_fcst_gen_pub */
3217: l_amt_id pa_fp_org_fcst_gen_pub.number_data_type_table; /* manoj: referred to pa_fp_org_fcst_gen_pub */

Line 3215: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;

3211: ================================================================= */
3212: FUNCTION get_amttype_id
3213: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE) RETURN NUMBER
3214: is
3215: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;
3216: l_amt_code pa_fp_org_fcst_gen_pub.char240_data_type_table; /* manoj: referred to pa_fp_org_fcst_gen_pub */
3217: l_amt_id pa_fp_org_fcst_gen_pub.number_data_type_table; /* manoj: referred to pa_fp_org_fcst_gen_pub */
3218:
3219: l_debug_mode VARCHAR2(30);

Line 3224: FROM pa_amount_types_b atb

3220:
3221: CURSOR get_amt_det IS
3222: SELECT atb.amount_type_id
3223: ,atb.amount_type_code
3224: FROM pa_amount_types_b atb
3225: WHERE atb.amount_type_class = 'R';
3226:
3227: l_stage number := 0;
3228: