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.PA_FIN_PLAN_UTILS dependencies on PA_AMOUNT_TYPES_B

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

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

Line 3217: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;

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

Line 3226: FROM pa_amount_types_b atb

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