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 5289: l_ignore_amount_type pa_proj_periods_denorm.amount_type_code%TYPE;

5285: l_error_msg_code VARCHAR2(2000);
5286: l_msg_index_out NUMBER;
5287: l_return_status VARCHAR2(2000);
5288: l_debug_mode VARCHAR2(30);
5289: l_ignore_amount_type pa_proj_periods_denorm.amount_type_code%TYPE;
5290: l_target_project_id pa_projects.project_id%TYPE;
5291:
5292: BEGIN
5293:

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

5349: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);
5350: END IF;
5351: */
5352: -- Evaluating which records are to be copied using amount type code of
5353: -- pa_proj_periods_denorm and fin paln preference code of the target version
5354:
5355: IF P_PA_DEBUG_MODE = 'Y' THEN
5356: pa_debug.g_err_stage:='Evaluating which records are to be copied';
5357: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);

Line 5379: INSERT INTO PA_PROJ_PERIODS_DENORM(

5375: IF P_PA_DEBUG_MODE = 'Y' THEN
5376: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);
5377: END IF;
5378: */
5379: INSERT INTO PA_PROJ_PERIODS_DENORM(
5380: budget_version_id
5381: ,project_id
5382: ,resource_assignment_id
5383: ,object_id

Line 5531: FROM PA_PROJ_PERIODS_DENORM pppd

5527: ,sysdate
5528: ,fnd_global.user_id
5529: ,fnd_global.login_id
5530: ,pfrmt.parent_assignment_id --parent_assignment_id
5531: FROM PA_PROJ_PERIODS_DENORM pppd
5532: ,PA_FP_RA_MAP_TMP pfrmt
5533: WHERE budget_version_id = p_source_plan_version_id
5534: AND pppd.resource_assignment_id = pfrmt.source_res_assignment_id
5535: AND pppd.object_type_code = PA_FP_CONSTANTS_PKG.G_OBJECT_TYPE_RES_ASSIGNMENT