[Home] [Help]
343: CURSOR l_lock_old_budget_csr( c_budget_version_id NUMBER )
344: IS
345: SELECT 'x'
346: FROM pa_budget_versions bv
347: ,pa_resource_assignments ra
348: ,pa_budget_lines bl
349: WHERE bv.budget_version_id = c_budget_version_id
350: AND bv.budget_version_id = ra.budget_version_id (+)
351: AND ra.resource_assignment_id = bl.resource_assignment_id (+)
4070: l_raw_cost NUMBER;
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;
5073:
5074: BEGIN
5075: SELECT projfunc_currency_code
5076: INTO l_txn_currency_code
5077: FROM pa_projects_all a, pa_budget_versions b, pa_resource_Assignments c
5078: WHERE a.project_id = b.project_id
5079: AND b.budget_version_id = c.budget_version_id
5080: AND c.resource_assignment_id = p_resource_assignment_id
5081: AND b.ci_id IS NULL; --
5975: l_webadi_ci_id pa_budget_versions.ci_id%TYPE;
5976:
5977: l_period_start_date DATE;
5978: l_period_end_date DATE;
5979: l_plan_start_date pa_resource_assignments.planning_start_date%type;
5980: l_plan_end_date pa_resource_assignments.planning_end_date%type;
5981:
5982: TYPE varchr_32_index_date_tbl_typ IS TABLE OF DATE INDEX BY VARCHAR2(32);
5983: TYPE varchr_32_index_varchr_tbl_typ IS TABLE OF VARCHAR2(100) INDEX BY VARCHAR2(32);
5976:
5977: l_period_start_date DATE;
5978: l_period_end_date DATE;
5979: l_plan_start_date pa_resource_assignments.planning_start_date%type;
5980: l_plan_end_date pa_resource_assignments.planning_end_date%type;
5981:
5982: TYPE varchr_32_index_date_tbl_typ IS TABLE OF DATE INDEX BY VARCHAR2(32);
5983: TYPE varchr_32_index_varchr_tbl_typ IS TABLE OF VARCHAR2(100) INDEX BY VARCHAR2(32);
5984:
7551: SELECT resource_assignment_id,planning_start_date,
7552: planning_end_date,nvl(l_spread_curve_id,spread_curve_id),sp_fixed_date
7553: INTO l_resource_assignment_id,l_planning_start_date,
7554: l_planning_end_date,l_spread_curve_id,l_sp_fixed_date
7555: FROM pa_resource_assignments
7556: WHERE budget_version_id=p_version_info_rec.x_budget_version_id
7557: AND task_id=px_budget_lines_in(i).pa_task_id
7558: AND resource_list_member_id=px_budget_lines_in(i).resource_list_member_id
7559: AND project_id=p_pa_project_id
7797: --that we are reading in the below query.
7798: BEGIN
7799: -- We have to handle the no_data_found exception for this select because this select could be fired for
7800: -- caselike from add_budget_line, the budget_line is being added for first time so there wont be any
7801: --record in pa_resource_assignments when line is added for first time.
7802: SELECT pra.planning_start_date,
7803: pra.planning_end_date,
7804: prlm.alias
7805: INTO l_plan_start_date,
7804: prlm.alias
7805: INTO l_plan_start_date,
7806: l_plan_end_date,
7807: l_resource_alias
7808: FROM pa_resource_assignments pra,
7809: pa_resource_list_members prlm
7810: WHERE pra.budget_version_id = p_version_info_rec.x_budget_version_id
7811: AND pra.resource_list_member_id = px_budget_lines_in(i).resource_list_member_id
7812: AND pra.task_id = px_budget_lines_in(i).pa_task_id
8560: DECODE(bl.other_rejection_code,NULL,
8561: DECODE(bl.pfc_cur_conv_rejection_code,NULL,
8562: DECODE(bl.pc_cur_conv_rejection_code,NULL,NULL,'E')
8563: ,'E'),'E'),'E'),'E'),'E') return_status
8564: FROM pa_resource_assignments ra , pa_budget_lines bl
8565: where ra.budget_version_id = p_fin_plan_version_id
8566: and ra.resource_assignment_id = bl.resource_assignment_id;
8567:
8568: BEGIN