APPS.PA_BUDGET_PVT dependencies on PA_TASKS

Line 4080: l_pm_task_ref pa_tasks.pm_task_reference%TYPE;

4076: l_burdened_cost NUMBER;
4077: l_revenue NUMBER;
4078: -- Following local variables added as part of bug 3062294
4079: l_pa_task_id pa_resource_assignments.task_id%TYPE;
4080: l_pm_task_ref pa_tasks.pm_task_reference%TYPE;
4081: l_resource_alias pa_resource_list_members.alias%TYPE; -- bug 3711693
4082: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4083: l_cbs_element_id pa_resource_assignments.cbs_element_id%TYPE;--Bug 16604257 : CBS RBS Phase 2 API changes
4084: l_budget_start_date pa_budget_lines.start_date%TYPE;

Line 5834: (c_pa_task_id pa_tasks.task_id%type)

5830:
5831: l_amg_project_rec l_amg_project_csr%ROWTYPE;
5832:
5833: CURSOR l_amg_task_csr
5834: (c_pa_task_id pa_tasks.task_id%type)
5835: IS
5836: SELECT task_number
5837: FROM pa_tasks p
5838: WHERE p.task_id = c_pa_task_id;

Line 5837: FROM pa_tasks p

5833: CURSOR l_amg_task_csr
5834: (c_pa_task_id pa_tasks.task_id%type)
5835: IS
5836: SELECT task_number
5837: FROM pa_tasks p
5838: WHERE p.task_id = c_pa_task_id;
5839:
5840: --This cursor is used to get the approved rev plan type flag of the plan type
5841: --Added as part of the changes for fin plan model in FP L

Line 5901: l_top_task_id pa_tasks.top_task_id%TYPE;

5897: l_txn_curr_code pa_fp_txn_currencies.txn_currency_code%TYPE;
5898: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
5899: l_conv_attrs_to_be_validated VARCHAR2(10);
5900: l_module_name VARCHAR2(80);
5901: l_top_task_id pa_tasks.top_task_id%TYPE;
5902: l_dummy VARCHAR2(1);
5903: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
5904: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5905: l_project_currency_code pa_projects_all.project_currency_code%TYPE ;

Line 6617: pa_tasks_pkg.verify_lowest_level_task( l_return_status_task,

6613: l_any_error_occurred_flag:='Y';
6614: END IF;
6615: ELSIF p_entry_level_code = 'L' -- then check whether it is lowest task
6616: THEN
6617: pa_tasks_pkg.verify_lowest_level_task( l_return_status_task,
6618: px_budget_lines_in(i).pa_task_id);
6619: IF l_return_status_task <> 0 THEN
6620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6621: THEN

Line 6655: pa_tasks_pkg.verify_lowest_level_task( l_return_status_task

6651:
6652: l_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP;
6653:
6654: ELSE
6655: pa_tasks_pkg.verify_lowest_level_task( l_return_status_task
6656: , px_budget_lines_in(i).pa_task_id);
6657: IF l_return_status_task <> 0 THEN
6658: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6659: THEN