64: RAISE;
65: END budget_version_in_error;
66:
67: FUNCTION get_amttype_id
68: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE
69: := NULL
70: ) RETURN NUMBER IS
71: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;
72: l_amt_code pa_fp_org_fcst_gen_pub.char240_data_type_table;
67: FUNCTION get_amttype_id
68: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE
69: := NULL
70: ) RETURN NUMBER IS
71: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;
72: l_amt_code pa_fp_org_fcst_gen_pub.char240_data_type_table;
73: l_amt_id pa_fp_org_fcst_gen_pub.number_data_type_table;
74:
75: l_debug_mode VARCHAR2(30);
76:
77: CURSOR get_amt_det IS
78: SELECT atb.amount_type_id
79: ,atb.amount_type_code
80: FROM pa_amount_types_b atb
81: WHERE atb.amount_type_class = 'R';
82:
83: l_stage number := 0;
84: