DBA Data[Home] [Help]

APPS.PA_PRJ_PERIOD_PROFILE_UTILS dependencies on PA_FP_ORG_FCST_GEN_PUB

Line 2257: l_amt_code pa_fp_org_fcst_gen_pub.char240_data_type_table;

2253: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE
2254: := NULL
2255: ) RETURN NUMBER IS
2256: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;
2257: l_amt_code pa_fp_org_fcst_gen_pub.char240_data_type_table;
2258: l_amt_id pa_fp_org_fcst_gen_pub.number_data_type_table;
2259:
2260: l_debug_mode VARCHAR2(30);
2261:

Line 2258: l_amt_id pa_fp_org_fcst_gen_pub.number_data_type_table;

2254: := NULL
2255: ) RETURN NUMBER IS
2256: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;
2257: l_amt_code pa_fp_org_fcst_gen_pub.char240_data_type_table;
2258: l_amt_id pa_fp_org_fcst_gen_pub.number_data_type_table;
2259:
2260: l_debug_mode VARCHAR2(30);
2261:
2262: CURSOR get_amt_det IS

Line 2312: p_pkg_name => 'PA_FP_ORG_FCST_GEN_PUB.get_amttype_id'

2308:
2309: EXCEPTION
2310: WHEN OTHERS THEN
2311: FND_MSG_PUB.add_exc_msg(
2312: p_pkg_name => 'PA_FP_ORG_FCST_GEN_PUB.get_amttype_id'
2313: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
2314:
2315: IF P_PA_DEBUG_MODE = 'Y' THEN
2316: pa_debug.write_file('GET_AMTTYPE_ID: ' || SQLERRM);