APPS.PA_BUDGET_PVT dependencies on PA_TASKS

Line 4075: l_pm_task_ref pa_tasks.pm_task_reference%TYPE;

4071: l_burdened_cost NUMBER;
4072: l_revenue NUMBER;
4073: -- Following local variables added as part of bug 3062294
4074: l_pa_task_id pa_resource_assignments.task_id%TYPE;
4075: l_pm_task_ref pa_tasks.pm_task_reference%TYPE;
4076: l_resource_alias pa_resource_list_members.alias%TYPE; -- bug 3711693
4077: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4078: l_budget_start_date pa_budget_lines.start_date%TYPE;
4079: l_budget_end_date pa_budget_lines.start_date%TYPE;

Line 5817: (c_pa_task_id pa_tasks.task_id%type)

5813:
5814: l_amg_project_rec l_amg_project_csr%ROWTYPE;
5815:
5816: CURSOR l_amg_task_csr
5817: (c_pa_task_id pa_tasks.task_id%type)
5818: IS
5819: SELECT task_number
5820: FROM pa_tasks p
5821: WHERE p.task_id = c_pa_task_id;

Line 5820: FROM pa_tasks p

5816: CURSOR l_amg_task_csr
5817: (c_pa_task_id pa_tasks.task_id%type)
5818: IS
5819: SELECT task_number
5820: FROM pa_tasks p
5821: WHERE p.task_id = c_pa_task_id;
5822:
5823: --This cursor is used to get the approved rev plan type flag of the plan type
5824: --Added as part of the changes for fin plan model in FP L

Line 5884: l_top_task_id pa_tasks.top_task_id%TYPE;

5880: l_txn_curr_code pa_fp_txn_currencies.txn_currency_code%TYPE;
5881: l_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
5882: l_conv_attrs_to_be_validated VARCHAR2(10);
5883: l_module_name VARCHAR2(80);
5884: l_top_task_id pa_tasks.top_task_id%TYPE;
5885: l_dummy VARCHAR2(1);
5886: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
5887: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;
5888: l_project_currency_code pa_projects_all.project_currency_code%TYPE ;

Line 6588: pa_tasks_pkg.verify_lowest_level_task( l_return_status_task,

6584: l_any_error_occurred_flag:='Y';
6585: END IF;
6586: ELSIF p_entry_level_code = 'L' -- then check whether it is lowest task
6587: THEN
6588: pa_tasks_pkg.verify_lowest_level_task( l_return_status_task,
6589: px_budget_lines_in(i).pa_task_id);
6590: IF l_return_status_task <> 0 THEN
6591: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6592: THEN

Line 6626: pa_tasks_pkg.verify_lowest_level_task( l_return_status_task

6622:
6623: l_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP;
6624:
6625: ELSE
6626: pa_tasks_pkg.verify_lowest_level_task( l_return_status_task
6627: , px_budget_lines_in(i).pa_task_id);
6628: IF l_return_status_task <> 0 THEN
6629: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6630: THEN