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