DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_AMOUNT_TYPES_B

Line 67: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE

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;

Line 70: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;

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);

Line 79: FROM pa_amount_types_b atb

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: