APPS.PA_FP_ELEMENTS_PUB dependencies on PA_FP_EXCLUDED_ELEMENTS

Line 835: PA_FP_EXCLUDED_ELEMENTS_PUB.Copy_Excluded_Elements

831: IF P_PA_DEBUG_MODE = 'Y' THEN
832: pa_debug.write('Copy_Elements: ' || l_module_name,pa_debug.g_err_stage,1);
833: END IF;
834:
835: PA_FP_EXCLUDED_ELEMENTS_PUB.Copy_Excluded_Elements
836: ( p_from_proj_fp_options_id => l_from_proj_fp_option_id
837: ,p_from_element_type => l_from_element_type
838: ,p_to_proj_fp_options_id => p_to_proj_fp_options_id
839: ,p_to_element_type => p_to_element_type

Line 1463: Bug 2976168. Delete from pa_fp_excluded_elements also

1459: - If element_type is BOTH, delete both the cost and revenue planning elements.
1460: - If the element_level is 'TASK', then delete all the task elements and corresponding resources.
1461: - If the element_level is resource, delete on the resources for all the task elements
1462:
1463: Bug 2976168. Delete from pa_fp_excluded_elements also
1464:
1465: ==================================================================================================*/
1466: PROCEDURE Delete_Elements (
1467: p_proj_fp_options_id IN NUMBER

Line 1515: /* For bug 2976168. Delete from pa_fp_excluded_elements also */

1511: WHERE proj_fp_options_id = p_proj_fp_options_id
1512: AND element_type = decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_element_type)
1513: AND p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK ;
1514:
1515: /* For bug 2976168. Delete from pa_fp_excluded_elements also */
1516:
1517: DELETE FROM pa_fp_excluded_elements
1518: WHERE proj_fp_options_id = p_proj_fp_options_id
1519: AND element_type = decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_element_type)

Line 1517: DELETE FROM pa_fp_excluded_elements

1513: AND p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK ;
1514:
1515: /* For bug 2976168. Delete from pa_fp_excluded_elements also */
1516:
1517: DELETE FROM pa_fp_excluded_elements
1518: WHERE proj_fp_options_id = p_proj_fp_options_id
1519: AND element_type = decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_element_type)
1520: AND p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK ;
1521:

Line 5040: Bug 2976168. Delete from pa_fp_excluded_elements */

5036: of a BASELINED version since we should not be touching RA table
5037: of BASELINED versions. When plan amounts donot exists, pa_proj_periods_denorm
5038: will not contain any data for that task.
5039:
5040: Bug 2976168. Delete from pa_fp_excluded_elements */
5041:
5042: PROCEDURE Delete_task_elements
5043: ( p_task_id IN pa_tasks.task_id%TYPE
5044: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 5222: FROM pa_fp_excluded_elements pfe

5218: ( c_task_id pa_tasks.task_id%TYPE
5219: ,c_top_task_id pa_tasks.task_id%TYPE)
5220: IS
5221: SELECT 'Y'
5222: FROM pa_fp_excluded_elements pfe
5223: WHERE pfe.proj_fp_options_id = p_proj_fp_options_id
5224: AND pfe.element_type = p_element_type
5225: AND pfe.task_id IN (c_task_id,c_top_task_id);
5226:

Line 5314: pa_debug.g_err_stage:= 'Task ' ||p_task_id ||' is not processed as it exists in pa_fp_excluded_elements';

5310: IF excluded_task_cur%FOUND THEN
5311: l_continue_processing := 'N';
5312: x_task_inclusion_flag := 'N';
5313: IF l_debug_mode = 'Y' THEN
5314: pa_debug.g_err_stage:= 'Task ' ||p_task_id ||' is not processed as it exists in pa_fp_excluded_elements';
5315: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL3);
5316: END IF;
5317: END IF;
5318: CLOSE excluded_task_cur;