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 5366: l_child_task_exists := pa_task_utils.check_child_exists(x_task_id => p_task_id);

5362:
5363: --The task is a top task
5364: IF p_task_level = L_TASK_LEVEL_TOP THEN
5365:
5366: l_child_task_exists := pa_task_utils.check_child_exists(x_task_id => p_task_id);
5367:
5368: IF l_child_task_exists = 1 THEN /* Child task exsists */
5369:
5370: /* This is a TOP task which is being created only now. But the planning

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

5405:
5406: ELSE
5407:
5408: IF l_debug_mode = 'Y' THEN
5409: pa_debug.g_err_stage:= 'Error returned by pa_task_utils.check_child_exists. Sqlerrcode ' || to_char(l_child_task_exists);
5410: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
5411: END IF;
5412:
5413: RAISE FND_API.G_Exc_Unexpected_Error;

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

6526: /* Refer db to know if the impacted_task_id is a middle level task.
6527: Child exists would mean that it is a middle level task (since we have eliminated
6528: top task records in the above condition). */
6529:
6530: l_child_task_exists := pa_task_utils.check_child_exists(x_task_id => p_task_id);
6531:
6532: IF l_child_task_exists = 1 THEN
6533:
6534: /* Child task exists. So, impacted task is a middle level task */

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

6846: /* Calling is_middle_level_task to check if old parent task id is a middle level task */
6847:
6848: l_make_task_plannable :=
6849: is_middle_level_task(p_task_id => p_impacted_tasks_tbl(i).old_parent_task_id,
6850: p_top_task_id => pa_task_utils.get_top_task_id(x_task_id => p_impacted_tasks_tbl(i).old_parent_task_id));
6851:
6852: IF l_debug_mode = 'Y' THEN
6853:
6854: pa_debug.g_err_stage:= 'l_make_task_plannable = ' || l_make_task_plannable;

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

6927: IF NOT(l_tasks_removed_tbl.exists(p_impacted_tasks_tbl(i).new_parent_task_id)) THEN
6928:
6929: /* Check if new_parent_task_id is not a TOP task */
6930:
6931: IF pa_task_utils.get_top_task_id(x_task_id => p_impacted_tasks_tbl(i).new_parent_task_id)
6932: <> p_impacted_tasks_tbl(i).new_parent_task_id THEN
6933:
6934: /* Check if it exists in pa_fp_elements. If yes, then its a lowest task */
6935:

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

6981: l_tasks_removed_tbl(p_impacted_tasks_tbl(i).new_parent_task_id) := 'Y';
6982:
6983: END IF; /* pa_fin_plan_utils.task_exists_in_option(p_task_id => p_impacted_tasks_tbl(i).new_parent_task_id) = 'Y' */
6984:
6985: END IF; /* pa_task_utils.get_top_task_id(x_task_id => p_impacted_tasks_tbl(i).new_parent_task_id)
6986: <> p_impacted_tasks_tbl(i).new_parent_task_id */
6987:
6988: END IF; /* l_tasks_removed_tbl.exists(p_impacted_tasks_tbl(i).new_parent_task_id) */
6989: