DBA Data[Home] [Help]

APPS.PA_FP_COPY_FROM_PKG dependencies on PA_PROJ_PERIODS_DENORM

Line 570: -- pa_proj_periods_denorm, p_fin_plan_adj_lines, pa_fp_adj_elements,

566: END IF;
567: -- End of changes for bug 2729191
568:
569: -- Calling an api to delete the existing records of target_version in
570: -- pa_proj_periods_denorm, p_fin_plan_adj_lines, pa_fp_adj_elements,
571: -- pa_budget_lines,pa_resource_assignments
572:
573: IF P_PA_DEBUG_MODE = 'Y' THEN
574: pa_debug.g_err_stage:='Calling the delete version api';

Line 5277: l_ignore_amount_type pa_proj_periods_denorm.amount_type_code%TYPE;

5273: l_error_msg_code VARCHAR2(2000);
5274: l_msg_index_out NUMBER;
5275: l_return_status VARCHAR2(2000);
5276: l_debug_mode VARCHAR2(30);
5277: l_ignore_amount_type pa_proj_periods_denorm.amount_type_code%TYPE;
5278: l_target_project_id pa_projects.project_id%TYPE;
5279:
5280: BEGIN
5281:

Line 5341: -- pa_proj_periods_denorm and fin paln preference code of the target version

5337: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);
5338: END IF;
5339: */
5340: -- Evaluating which records are to be copied using amount type code of
5341: -- pa_proj_periods_denorm and fin paln preference code of the target version
5342:
5343: IF P_PA_DEBUG_MODE = 'Y' THEN
5344: pa_debug.g_err_stage:='Evaluating which records are to be copied';
5345: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);

Line 5367: INSERT INTO PA_PROJ_PERIODS_DENORM(

5363: IF P_PA_DEBUG_MODE = 'Y' THEN
5364: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);
5365: END IF;
5366: */
5367: INSERT INTO PA_PROJ_PERIODS_DENORM(
5368: budget_version_id
5369: ,project_id
5370: ,resource_assignment_id
5371: ,object_id

Line 5519: FROM PA_PROJ_PERIODS_DENORM pppd

5515: ,sysdate
5516: ,fnd_global.user_id
5517: ,fnd_global.login_id
5518: ,pfrmt.parent_assignment_id --parent_assignment_id
5519: FROM PA_PROJ_PERIODS_DENORM pppd
5520: ,PA_FP_RA_MAP_TMP pfrmt
5521: WHERE budget_version_id = p_source_plan_version_id
5522: AND pppd.resource_assignment_id = pfrmt.source_res_assignment_id
5523: AND pppd.object_type_code = PA_FP_CONSTANTS_PKG.G_OBJECT_TYPE_RES_ASSIGNMENT