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 5031: Bug 2976168. Delete from pa_fp_excluded_elements */

5027: of a BASELINED version since we should not be touching RA table
5028: of BASELINED versions. When plan amounts donot exists, pa_proj_periods_denorm
5029: will not contain any data for that task.
5030:
5031: Bug 2976168. Delete from pa_fp_excluded_elements */
5032:
5033: PROCEDURE Delete_task_elements
5034: ( p_task_id IN pa_tasks.task_id%TYPE
5035: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 5213: FROM pa_fp_excluded_elements pfe

5209: ( c_task_id pa_tasks.task_id%TYPE
5210: ,c_top_task_id pa_tasks.task_id%TYPE)
5211: IS
5212: SELECT 'Y'
5213: FROM pa_fp_excluded_elements pfe
5214: WHERE pfe.proj_fp_options_id = p_proj_fp_options_id
5215: AND pfe.element_type = p_element_type
5216: AND pfe.task_id IN (c_task_id,c_top_task_id);
5217:

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

5301: IF excluded_task_cur%FOUND THEN
5302: l_continue_processing := 'N';
5303: x_task_inclusion_flag := 'N';
5304: IF l_debug_mode = 'Y' THEN
5305: pa_debug.g_err_stage:= 'Task ' ||p_task_id ||' is not processed as it exists in pa_fp_excluded_elements';
5306: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL3);
5307: END IF;
5308: END IF;
5309: CLOSE excluded_task_cur;