DBA Data[Home] [Help]

APPS.PA_FP_EDIT_LINE_PKG dependencies on PA_PERIODS

Line 709: l_dummy_period_name pa_periods_all.period_name%TYPE;

705: l_period_set_name pa_proj_period_profiles.period_set_name%TYPE;
706: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
707: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
708: l_project_id pa_projects_all.project_id%TYPE;
709: l_dummy_period_name pa_periods_all.period_name%TYPE;
710:
711: l_msg_count NUMBER := 0;
712: l_msg_data VARCHAR2(2000);
713: l_return_status VARCHAR2(2000);

Line 3029: FROM PA_PERIODS

3025: ,end_date end_date
3026: ,period_name pa_period
3027: ,gl_period_name gl_period
3028: ,period_name period_name
3029: FROM PA_PERIODS
3030: WHERE start_date = p_preceding_prd_start_date;
3031:
3032: END IF;
3033:

Line 3045: FROM PA_PERIODS

3041: ,end_date end_date
3042: ,period_name pa_period
3043: ,gl_period_name gl_period
3044: ,period_name period_name
3045: FROM PA_PERIODS
3046: WHERE start_date BETWEEN p_period_profile_start_date AND p_period_profile_end_date;
3047:
3048: pa_debug.g_err_stage := TO_CHAR(l_stage)||'inserted ' || sql%rowcount || ' records';
3049: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3071: FROM PA_PERIODS

3067: ,end_date end_date
3068: ,period_name pa_period
3069: ,gl_period_name gl_period
3070: ,period_name period_name
3071: FROM PA_PERIODS
3072: WHERE start_date = p_succeeding_prd_start_date;
3073:
3074: END IF;
3075: