DBA Data[Home] [Help]

APPS.PA_FP_ELEMENTS_PUB dependencies on PA_TASK_UTILS

Line 2905: DECODE(pa_task_utils.check_child_exists(pra.task_id),

2901: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST,
2902: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP,
2903: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,
2904: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M,
2905: DECODE(pa_task_utils.check_child_exists(pra.task_id),
2906: 1, PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,
2907: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST)
2908: ),
2909: null

Line 5357: l_child_task_exists := pa_task_utils.check_child_exists(x_task_id => p_task_id);

5353:
5354: --The task is a top task
5355: IF p_task_level = L_TASK_LEVEL_TOP THEN
5356:
5357: l_child_task_exists := pa_task_utils.check_child_exists(x_task_id => p_task_id);
5358:
5359: IF l_child_task_exists = 1 THEN /* Child task exsists */
5360:
5361: /* This is a TOP task which is being created only now. But the planning

Line 5400: pa_debug.g_err_stage:= 'Error returned by pa_task_utils.check_child_exists. Sqlerrcode ' || to_char(l_child_task_exists);

5396:
5397: ELSE
5398:
5399: IF l_debug_mode = 'Y' THEN
5400: pa_debug.g_err_stage:= 'Error returned by pa_task_utils.check_child_exists. Sqlerrcode ' || to_char(l_child_task_exists);
5401: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
5402: END IF;
5403:
5404: RAISE FND_API.G_Exc_Unexpected_Error;

Line 6521: l_child_task_exists := pa_task_utils.check_child_exists(x_task_id => p_task_id);

6517: /* Refer db to know if the impacted_task_id is a middle level task.
6518: Child exists would mean that it is a middle level task (since we have eliminated
6519: top task records in the above condition). */
6520:
6521: l_child_task_exists := pa_task_utils.check_child_exists(x_task_id => p_task_id);
6522:
6523: IF l_child_task_exists = 1 THEN
6524:
6525: /* Child task exists. So, impacted task is a middle level task */

Line 6841: p_top_task_id => pa_task_utils.get_top_task_id(x_task_id => p_impacted_tasks_tbl(i).old_parent_task_id));

6837: /* Calling is_middle_level_task to check if old parent task id is a middle level task */
6838:
6839: l_make_task_plannable :=
6840: is_middle_level_task(p_task_id => p_impacted_tasks_tbl(i).old_parent_task_id,
6841: p_top_task_id => pa_task_utils.get_top_task_id(x_task_id => p_impacted_tasks_tbl(i).old_parent_task_id));
6842:
6843: IF l_debug_mode = 'Y' THEN
6844:
6845: pa_debug.g_err_stage:= 'l_make_task_plannable = ' || l_make_task_plannable;

Line 6922: IF pa_task_utils.get_top_task_id(x_task_id => p_impacted_tasks_tbl(i).new_parent_task_id)

6918: IF NOT(l_tasks_removed_tbl.exists(p_impacted_tasks_tbl(i).new_parent_task_id)) THEN
6919:
6920: /* Check if new_parent_task_id is not a TOP task */
6921:
6922: IF pa_task_utils.get_top_task_id(x_task_id => p_impacted_tasks_tbl(i).new_parent_task_id)
6923: <> p_impacted_tasks_tbl(i).new_parent_task_id THEN
6924:
6925: /* Check if it exists in pa_fp_elements. If yes, then its a lowest task */
6926:

Line 6976: END IF; /* pa_task_utils.get_top_task_id(x_task_id => p_impacted_tasks_tbl(i).new_parent_task_id)

6972: l_tasks_removed_tbl(p_impacted_tasks_tbl(i).new_parent_task_id) := 'Y';
6973:
6974: END IF; /* pa_fin_plan_utils.task_exists_in_option(p_task_id => p_impacted_tasks_tbl(i).new_parent_task_id) = 'Y' */
6975:
6976: END IF; /* pa_task_utils.get_top_task_id(x_task_id => p_impacted_tasks_tbl(i).new_parent_task_id)
6977: <> p_impacted_tasks_tbl(i).new_parent_task_id */
6978:
6979: END IF; /* l_tasks_removed_tbl.exists(p_impacted_tasks_tbl(i).new_parent_task_id) */
6980: