DBA Data[Home] [Help]

APPS.PA_PRJ_PERIOD_PROFILE_UTILS dependencies on PA_FP_ORG_FCST_GEN_PUB

Line 2258: l_amt_code pa_fp_org_fcst_gen_pub.char240_data_type_table;

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

Line 2259: l_amt_id pa_fp_org_fcst_gen_pub.number_data_type_table;

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

Line 2313: p_pkg_name => 'PA_FP_ORG_FCST_GEN_PUB.get_amttype_id'

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