DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_AMOUNT_TYPES_B

Line 68: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE

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;

Line 71: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;

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

Line 80: FROM pa_amount_types_b atb

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: