DBA Data[Home] [Help]

APPS.PA_FP_COPY_FROM_PKG dependencies on PA_BUDGET_VERSIONS_S

Line 84: * Acquire lock on pa_proj_fp_options and pa_budget_versions so that

80: IF P_PA_DEBUG_MODE = 'Y' THEN
81: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
82: END IF;
83: /*
84: * Acquire lock on pa_proj_fp_options and pa_budget_versions so that
85: * no other process would be able to modify these tables and all
86: * underlying child tables
87: */
88:

Line 506: --Acquire lock on pa_proj_fp_options and pa_budget_versions so that

502: INTO l_project_id
503: FROM PA_BUDGET_VERSIONS
504: WHERE budget_version_id = p_target_plan_version_id;
505:
506: --Acquire lock on pa_proj_fp_options and pa_budget_versions so that
507: --no other process would be able to modify these tables and all
508: --underlying child tables
509:
510: Acquire_Locks_For_Copy_Plan(

Line 843: * Acquire lock on pa_proj_fp_options and pa_budget_versions so that

839: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
840: l_debug_mode := NVL(l_debug_mode, 'Y');
841:
842: /*
843: * Acquire lock on pa_proj_fp_options and pa_budget_versions so that
844: * no other process would be able to modify these tables and all
845: * underlying child tables
846: */
847:

Line 1402: SELECT pa_budget_versions_s.NEXTVAL

1398: pa_debug.g_err_stage := 'Fetch new budget version id';
1399: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1400: END IF;
1401:
1402: SELECT pa_budget_versions_s.NEXTVAL
1403: INTO px_target_version_id
1404: FROM DUAL;
1405:
1406: -- For workplan context project structure version id should be populated