eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PLANNING_ELEMENT_UTILS dependencies on PA_RESOURCE_ASSIGNMENTS

Line 359: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) return VARCHAR2 is

355: END get_finplan_bvids;
356:
357: FUNCTION get_task_name_and_number
358: (p_project_or_task IN VARCHAR2, -- 'PROJECT' or 'TASK'
359: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) return VARCHAR2 is
360: l_return_value VARCHAR2(2000);
361: BEGIN
362: if p_project_or_task = 'PROJECT' then
363: -- GET PROJECT NAME AND NUMBER

Line 366: from pa_resource_assignments ra,

362: if p_project_or_task = 'PROJECT' then
363: -- GET PROJECT NAME AND NUMBER
364: select pa.name || ' (' || pa.segment1 || ')'
365: into l_return_value
366: from pa_resource_assignments ra,
367: pa_projects_all pa
368: where ra.resource_assignment_id = p_resource_assignment_id and
369: ra.project_id = pa.project_id;
370: else

Line 374: from pa_resource_assignments ra,

370: else
371: -- GET TASK NAME AND NUMBER
372: select pe.name || ' (' || pe.element_number || ')'
373: into l_return_value
374: from pa_resource_assignments ra,
375: pa_proj_elements pe
376: where ra.resource_assignment_id = p_resource_assignment_id and
377: ra.task_id = pe.proj_element_id;
378: end if;

Line 394: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

390: * selects. */
391: -- Bug 4057673. Added a parameter p_fin_plan_level_code. It will be either 'P','L' or 'M'
392: --depending on the planning level of the budget version
393: FUNCTION get_project_task_level
394: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
395: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE) return VARCHAR2 is
396:
397: l_project_id pa_resource_assignments.project_id%TYPE;
398: l_element_version_id pa_resource_assignments.wbs_element_version_id%TYPE;

Line 397: l_project_id pa_resource_assignments.project_id%TYPE;

393: FUNCTION get_project_task_level
394: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
395: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE) return VARCHAR2 is
396:
397: l_project_id pa_resource_assignments.project_id%TYPE;
398: l_element_version_id pa_resource_assignments.wbs_element_version_id%TYPE;
399: l_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
400: l_uncat_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
401: l_summary_task_flag VARCHAR2(1);

Line 398: l_element_version_id pa_resource_assignments.wbs_element_version_id%TYPE;

394: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
395: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE) return VARCHAR2 is
396:
397: l_project_id pa_resource_assignments.project_id%TYPE;
398: l_element_version_id pa_resource_assignments.wbs_element_version_id%TYPE;
399: l_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
400: l_uncat_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
401: l_summary_task_flag VARCHAR2(1);
402: l_return_value VARCHAR2(80);

Line 399: l_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;

395: p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE) return VARCHAR2 is
396:
397: l_project_id pa_resource_assignments.project_id%TYPE;
398: l_element_version_id pa_resource_assignments.wbs_element_version_id%TYPE;
399: l_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
400: l_uncat_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
401: l_summary_task_flag VARCHAR2(1);
402: l_return_value VARCHAR2(80);
403:

Line 420: v_dummy_id pa_resource_assignments.wbs_element_version_id%TYPE;

416: WHERE object_id_to1 = l_element_version_id and
417: rownum < 2 and
418: object_type_from = 'PA_TASKS';
419: */
420: v_dummy_id pa_resource_assignments.wbs_element_version_id%TYPE;
421: --Bug 4057673.This variable will be set to Y for tasks that are both top and lowest
422: l_top_and_lowest_task_flag VARCHAR2(1);
423:
424: BEGIN

Line 436: from pa_resource_assignments ra,

432: ra.project_id
433: into l_element_version_id,
434: l_rlm_id,
435: l_project_id
436: from pa_resource_assignments ra,
437: pa_proj_element_versions pelm
438: where ra.resource_assignment_id = p_resource_assignment_id
439: AND pelm.proj_element_id(+)=ra.task_id
440: AND pelm.parent_structure_Version_id(+)=PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(ra.project_id);

Line 608: (p_mfc_cost_type_id IN pa_resource_assignments.mfc_cost_type_id%TYPE) return VARCHAR2 is

604: return null;
605: END get_spread_curve_name;
606:
607: FUNCTION get_mfc_cost_type_name
608: (p_mfc_cost_type_id IN pa_resource_assignments.mfc_cost_type_id%TYPE) return VARCHAR2 is
609: l_return_value VARCHAR2(80);
610: BEGIN
611: select cost_type
612: into l_return_value

Line 625: l_uncat_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;

621: END get_mfc_cost_type_name;
622:
623: FUNCTION get_project_uncat_rlmid return NUMBER is
624: l_uncat_resource_list_id pa_resource_lists.resource_list_id%TYPE;
625: l_uncat_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
626: l_track_as_labor_flag pa_resources.track_as_labor_flag%TYPE;
627: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
628: l_return_status VARCHAR2(1);
629: l_msg_count NUMBER;

Line 627: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;

623: FUNCTION get_project_uncat_rlmid return NUMBER is
624: l_uncat_resource_list_id pa_resource_lists.resource_list_id%TYPE;
625: l_uncat_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
626: l_track_as_labor_flag pa_resources.track_as_labor_flag%TYPE;
627: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
628: l_return_status VARCHAR2(1);
629: l_msg_count NUMBER;
630: l_msg_data VARCHAR2(2000);
631: BEGIN

Line 672: * pa_resource_assignments

668: * x_schedule_start_date, x_schedule_end_date
669: * 11/16/2004 - dlai - when no budget lines exist for a particular
670: * txn_currency_code (which is not proj or projfunc currency), be
671: * sure to return null for txn amounts, and not rely on the amounts in
672: * pa_resource_assignments
673: * 02/08/2005 - dlai - when looking for match, the records should also have
674: * the same unit_of_measure in addition to task-res-txncurrency
675: * 05/10/2005 - dlai - margin parameters are returned as null if
676: * p_budget_version_id refers to COST_ONLY or REVENUE_ONLY version

Line 680: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

676: * p_budget_version_id refers to COST_ONLY or REVENUE_ONLY version
677: */
678: PROCEDURE get_common_budget_version_info
679: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
680: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
681: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
682: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
683: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
684: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),

Line 687: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895

683: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
684: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
685: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
686: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
687: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
688: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
689: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
690: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
691: x_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895

Line 688: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895

684: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
685: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
686: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
687: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
688: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
689: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
690: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
691: x_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
692: x_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895

Line 689: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895

685: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
686: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
687: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
688: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
689: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
690: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
691: x_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
692: x_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
693: x_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895

Line 690: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895

686: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
687: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
688: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
689: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
690: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
691: x_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
692: x_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
693: x_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
694: x_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895

Line 691: x_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895

687: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
688: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
689: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
690: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
691: x_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
692: x_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
693: x_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
694: x_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
695: x_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895

Line 693: x_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895

689: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
690: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
691: x_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
692: x_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
693: x_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
694: x_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
695: x_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
696: x_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
697: x_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895

Line 694: x_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895

690: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
691: x_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
692: x_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
693: x_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
694: x_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
695: x_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
696: x_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
697: x_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
698: x_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895

Line 696: x_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895

692: x_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
693: x_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
694: x_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
695: x_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
696: x_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
697: x_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
698: x_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
699: x_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
700: x_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895

Line 697: x_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895

693: x_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
694: x_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
695: x_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
696: x_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
697: x_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
698: x_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
699: x_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
700: x_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
701: -- x_burd_multiplier OUT pa_budget_lines.txn_burden_multiplier%TYPE, -- FPM2 data model changes

Line 699: x_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895

695: x_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
696: x_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
697: x_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
698: x_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
699: x_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
700: x_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
701: -- x_burd_multiplier OUT pa_budget_lines.txn_burden_multiplier%TYPE, -- FPM2 data model changes
702: x_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
703: x_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895

Line 700: x_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895

696: x_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
697: x_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
698: x_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
699: x_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
700: x_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
701: -- x_burd_multiplier OUT pa_budget_lines.txn_burden_multiplier%TYPE, -- FPM2 data model changes
702: x_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
703: x_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
704: x_init_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

Line 719: l_project_id pa_resource_assignments.project_id%TYPE;

715: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
716: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
717: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
718:
719: l_project_id pa_resource_assignments.project_id%TYPE;
720: l_task_id pa_resource_assignments.task_id%TYPE;
721: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
722: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
723: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;

Line 720: l_task_id pa_resource_assignments.task_id%TYPE;

716: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
717: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
718:
719: l_project_id pa_resource_assignments.project_id%TYPE;
720: l_task_id pa_resource_assignments.task_id%TYPE;
721: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
722: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
723: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
724:

Line 721: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;

717: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
718:
719: l_project_id pa_resource_assignments.project_id%TYPE;
720: l_task_id pa_resource_assignments.task_id%TYPE;
721: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
722: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
723: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
724:
725: l_budget_lines_exist_flag VARCHAR2(1); -- whether budget lines exist for planning element

Line 722: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

718:
719: l_project_id pa_resource_assignments.project_id%TYPE;
720: l_task_id pa_resource_assignments.task_id%TYPE;
721: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
722: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
723: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
724:
725: l_budget_lines_exist_flag VARCHAR2(1); -- whether budget lines exist for planning element
726:

Line 723: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;

719: l_project_id pa_resource_assignments.project_id%TYPE;
720: l_task_id pa_resource_assignments.task_id%TYPE;
721: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
722: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
723: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
724:
725: l_budget_lines_exist_flag VARCHAR2(1); -- whether budget lines exist for planning element
726:
727: l_start_date pa_budget_lines.start_date%TYPE;

Line 747: from pa_resource_assignments ra

743: l_etc_init_revenue_rate NUMBER;
744:
745: cursor raid_csr is
746: select ra.resource_assignment_id
747: from pa_resource_assignments ra
748: where ra.project_id = l_project_id and
749: ra.budget_version_id = p_budget_version_id and
750: ra.task_id = l_task_id and
751: ra.resource_list_member_id = l_resource_list_member_id and

Line 844: from pa_resource_assignments ra,

840: DECODE(SUM(bl.quantity) - SUM(nvl(init_quantity,0)),
841: 0, 0,
842: null, 0,
843: (SUM(bl.txn_burdened_cost) - SUM(nvl(bl.txn_init_burdened_cost,0)))/(SUM(bl.quantity) - SUM(nvl(init_quantity,0))))
844: from pa_resource_assignments ra,
845: pa_budget_lines bl,
846: pa_budget_versions bv,
847: pa_proj_fp_options po
848: where ra.resource_assignment_id = l_resource_assignment_id and

Line 971: -- FROM pa_resource_assignments ra,

967: -- NULL, 0,
968: -- (SUM(bl.txn_burdened_cost) - SUM(NVL(bl.txn_init_burdened_cost,0)))/(SUM(bl.quantity) - SUM(NVL(init_quantity,0))))
969: -- */
970: -- DECODE(ra.rate_based_flag, 'Y', rac.txn_etc_burden_cost_rate, TO_NUMBER(NULL))
971: -- FROM pa_resource_assignments ra,
972: -- -- pa_budget_lines bl,
973: -- pa_resource_asgn_curr rac,
974: -- pa_budget_versions bv,
975: -- pa_proj_fp_options po

Line 1025: from pa_resource_assignments ra

1021: into l_project_id,
1022: l_task_id,
1023: l_resource_list_member_id,
1024: l_unit_of_measure
1025: from pa_resource_assignments ra
1026: where ra.resource_assignment_id = p_resource_assignment_id;
1027: open raid_csr;
1028: fetch raid_csr into raid_rec;
1029: if raid_csr%NOTFOUND then

Line 1072: -- query pa_resource_assignments only

1068: end if;
1069: close budget_lines_csr;
1070:
1071: if l_budget_lines_exist_flag = 'N' then
1072: -- query pa_resource_assignments only
1073: x_init_rev_rate := null;
1074: x_avg_rev_rate := null;
1075: x_init_raw_cost_rate := null;
1076: x_avg_raw_cost_rate := null;

Line 1079: -- bug 3979904: query pa_resource_assignments only if p_txn_currency_code

1075: x_init_raw_cost_rate := null;
1076: x_avg_raw_cost_rate := null;
1077: x_init_burd_cost_rate := null;
1078: x_avg_burd_cost_rate := null;
1079: -- bug 3979904: query pa_resource_assignments only if p_txn_currency_code
1080: -- is the same as project currency or project functional currency
1081: -- bug 4091886: if no budget lines exist for a particular task-res-currency
1082: -- combination, then even PC and PFC values should be nulled-out
1083: begin

Line 1169: from pa_resource_assignments ra,

1165: x_margin_txn_cur,
1166: x_margin_proj_cur,
1167: x_margin_proj_func_cur,
1168: x_margin_pct
1169: from pa_resource_assignments ra,
1170: pa_budget_versions bv,
1171: pa_proj_fp_options po
1172: where ra.resource_assignment_id = l_resource_assignment_id and
1173: ra.budget_version_id = bv.budget_version_id and

Line 1398: FROM pa_resource_assignments ra,

1394: x_margin_pct,
1395: x_etc_avg_rev_rate,
1396: x_etc_avg_raw_cost_rate,
1397: x_etc_avg_burd_cost_rate
1398: FROM pa_resource_assignments ra,
1399: -- pa_budget_lines bl,
1400: pa_resource_asgn_curr rac,
1401: pa_budget_versions bv,
1402: pa_proj_fp_options po

Line 1503: * pa_resource_assignments

1499: * x_schedule_start_date, x_schedule_end_date
1500: * 12/10/2004 - dlai - when no budget lines exist for a particular
1501: * txn_currency_code (which is not proj or projfunc currency), be
1502: * sure to return null for txn amounts, and not rely on the amounts in
1503: * pa_resource_assignments
1504: * 12/19/2004 removed all references to pa_resource_assignments.init columns
1505: * 02/08/2005 - dlai - when looking for match, the records should also have
1506: * the same unit_of_measure in addition to task-res-txncurrency
1507: * 05/10/2005 - dlai - margin parameters are returned as null if

Line 1504: * 12/19/2004 removed all references to pa_resource_assignments.init columns

1500: * 12/10/2004 - dlai - when no budget lines exist for a particular
1501: * txn_currency_code (which is not proj or projfunc currency), be
1502: * sure to return null for txn amounts, and not rely on the amounts in
1503: * pa_resource_assignments
1504: * 12/19/2004 removed all references to pa_resource_assignments.init columns
1505: * 02/08/2005 - dlai - when looking for match, the records should also have
1506: * the same unit_of_measure in addition to task-res-txncurrency
1507: * 05/10/2005 - dlai - margin parameters are returned as null if
1508: * p_budget_version_id refers to COST_ONLY or REVENUE_ONLY version

Line 1514: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

1510: * are calculate correctly in case the act or fcst amounts are null
1511: */
1512: PROCEDURE get_common_bv_info_fcst
1513: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1514: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
1515: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
1516: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
1517: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
1518: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),

Line 1521: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895

1517: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
1518: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
1519: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
1520: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
1521: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
1522: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
1523: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
1524: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
1525: x_act_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895

Line 1522: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895

1518: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
1519: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
1520: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
1521: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
1522: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
1523: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
1524: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
1525: x_act_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1526: x_etc_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895

Line 1523: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895

1519: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
1520: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
1521: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
1522: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
1523: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
1524: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
1525: x_act_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1526: x_etc_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1527: x_fcst_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895

Line 1524: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895

1520: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
1521: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
1522: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
1523: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
1524: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
1525: x_act_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1526: x_etc_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1527: x_fcst_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1528: x_act_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895

Line 1525: x_act_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895

1521: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
1522: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
1523: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
1524: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
1525: x_act_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1526: x_etc_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1527: x_fcst_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1528: x_act_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1529: x_act_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895

Line 1526: x_etc_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895

1522: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
1523: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
1524: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
1525: x_act_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1526: x_etc_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1527: x_fcst_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1528: x_act_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1529: x_act_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1530: x_act_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895

Line 1527: x_fcst_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895

1523: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
1524: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
1525: x_act_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1526: x_etc_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1527: x_fcst_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1528: x_act_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1529: x_act_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1530: x_act_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1531: x_etc_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895

Line 1529: x_act_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895

1525: x_act_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1526: x_etc_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1527: x_fcst_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1528: x_act_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1529: x_act_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1530: x_act_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1531: x_etc_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1532: x_etc_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1533: x_etc_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895

Line 1530: x_act_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895

1526: x_etc_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1527: x_fcst_quantity OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
1528: x_act_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1529: x_act_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1530: x_act_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1531: x_etc_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1532: x_etc_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1533: x_etc_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1534: x_fcst_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895

Line 1532: x_etc_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895

1528: x_act_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1529: x_act_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1530: x_act_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1531: x_etc_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1532: x_etc_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1533: x_etc_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1534: x_fcst_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1535: x_fcst_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1536: x_fcst_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895

Line 1533: x_etc_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895

1529: x_act_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1530: x_act_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1531: x_etc_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1532: x_etc_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1533: x_etc_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1534: x_fcst_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1535: x_fcst_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1536: x_fcst_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1537: x_act_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895

Line 1535: x_fcst_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895

1531: x_etc_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1532: x_etc_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1533: x_etc_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1534: x_fcst_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1535: x_fcst_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1536: x_fcst_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1537: x_act_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1538: x_act_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1539: x_act_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895

Line 1536: x_fcst_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895

1532: x_etc_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1533: x_etc_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1534: x_fcst_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1535: x_fcst_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1536: x_fcst_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1537: x_act_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1538: x_act_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1539: x_act_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1540: x_etc_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895

Line 1538: x_act_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895

1534: x_fcst_revenue_txn_cur OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
1535: x_fcst_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1536: x_fcst_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1537: x_act_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1538: x_act_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1539: x_act_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1540: x_etc_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1541: x_etc_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1542: x_etc_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895

Line 1539: x_act_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895

1535: x_fcst_revenue_proj_cur OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
1536: x_fcst_revenue_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
1537: x_act_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1538: x_act_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1539: x_act_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1540: x_etc_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1541: x_etc_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1542: x_etc_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1543: x_fcst_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895

Line 1541: x_etc_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895

1537: x_act_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1538: x_act_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1539: x_act_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1540: x_etc_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1541: x_etc_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1542: x_etc_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1543: x_fcst_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1544: x_fcst_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1545: x_fcst_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895

Line 1542: x_etc_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895

1538: x_act_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1539: x_act_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1540: x_etc_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1541: x_etc_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1542: x_etc_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1543: x_fcst_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1544: x_fcst_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1545: x_fcst_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1546: x_act_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895

Line 1544: x_fcst_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895

1540: x_etc_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1541: x_etc_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1542: x_etc_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1543: x_fcst_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1544: x_fcst_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1545: x_fcst_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1546: x_act_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1547: x_act_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1548: x_act_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895

Line 1545: x_fcst_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895

1541: x_etc_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1542: x_etc_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1543: x_fcst_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1544: x_fcst_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1545: x_fcst_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1546: x_act_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1547: x_act_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1548: x_act_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1549: x_etc_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895

Line 1547: x_act_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895

1543: x_fcst_raw_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
1544: x_fcst_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1545: x_fcst_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1546: x_act_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1547: x_act_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1548: x_act_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1549: x_etc_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1550: x_etc_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1551: x_etc_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895

Line 1548: x_act_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895

1544: x_fcst_raw_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
1545: x_fcst_raw_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
1546: x_act_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1547: x_act_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1548: x_act_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1549: x_etc_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1550: x_etc_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1551: x_etc_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1552: x_fcst_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895

Line 1550: x_etc_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895

1546: x_act_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1547: x_act_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1548: x_act_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1549: x_etc_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1550: x_etc_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1551: x_etc_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1552: x_fcst_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1553: x_fcst_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1554: x_fcst_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895

Line 1551: x_etc_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895

1547: x_act_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1548: x_act_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1549: x_etc_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1550: x_etc_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1551: x_etc_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1552: x_fcst_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1553: x_fcst_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1554: x_fcst_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1555: x_act_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895

Line 1553: x_fcst_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895

1549: x_etc_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1550: x_etc_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1551: x_etc_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1552: x_fcst_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1553: x_fcst_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1554: x_fcst_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1555: x_act_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1556: x_etc_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1557: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895

Line 1554: x_fcst_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895

1550: x_etc_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1551: x_etc_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1552: x_fcst_burd_cost_txn_cur OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1553: x_fcst_burd_cost_proj_cur OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1554: x_fcst_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
1555: x_act_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1556: x_etc_init_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1557: x_etc_avg_rev_rate OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
1558: x_act_raw_cost_rate OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895

Line 1580: l_project_id pa_resource_assignments.project_id%TYPE;

1576: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1577: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1578: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
1579:
1580: l_project_id pa_resource_assignments.project_id%TYPE;
1581: l_task_id pa_resource_assignments.task_id%TYPE;
1582: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
1583: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
1584: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;

Line 1581: l_task_id pa_resource_assignments.task_id%TYPE;

1577: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1578: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
1579:
1580: l_project_id pa_resource_assignments.project_id%TYPE;
1581: l_task_id pa_resource_assignments.task_id%TYPE;
1582: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
1583: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
1584: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
1585: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;

Line 1582: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;

1578: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
1579:
1580: l_project_id pa_resource_assignments.project_id%TYPE;
1581: l_task_id pa_resource_assignments.task_id%TYPE;
1582: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
1583: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
1584: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
1585: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1586:

Line 1583: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

1579:
1580: l_project_id pa_resource_assignments.project_id%TYPE;
1581: l_task_id pa_resource_assignments.task_id%TYPE;
1582: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
1583: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
1584: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
1585: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1586:
1587: l_budget_lines_exist_flag VARCHAR2(1); -- whether budget lines exist for planning element

Line 1584: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;

1580: l_project_id pa_resource_assignments.project_id%TYPE;
1581: l_task_id pa_resource_assignments.task_id%TYPE;
1582: l_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
1583: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
1584: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
1585: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
1586:
1587: l_budget_lines_exist_flag VARCHAR2(1); -- whether budget lines exist for planning element
1588:

Line 1609: from pa_resource_assignments ra

1605: l_etc_init_revenue_rate NUMBER;
1606:
1607: cursor raid_csr is
1608: select ra.resource_assignment_id
1609: from pa_resource_assignments ra
1610: where ra.project_id = l_project_id and
1611: ra.budget_version_id = p_budget_version_id and
1612: ra.task_id = l_task_id and
1613: ra.resource_list_member_id = l_resource_list_member_id and

Line 1755: FROM pa_resource_assignments ra,

1751: NULL, -- x_act_margin_pct (TO BE POPULATED)
1752: NULL, -- x_etc_margin_pct (TO BE POPULATED)
1753: NULL, -- x_fcst_margin_pct (TO BE POPULATED)
1754: po.margin_derived_from_code
1755: FROM pa_resource_assignments ra,
1756: -- pa_budget_lines bl,
1757: pa_resource_asgn_curr rac,
1758: pa_budget_versions bv,
1759: pa_proj_fp_options po

Line 1819: from pa_resource_assignments ra

1815: into l_project_id,
1816: l_task_id,
1817: l_resource_list_member_id,
1818: l_unit_of_measure
1819: from pa_resource_assignments ra
1820: where ra.resource_assignment_id = p_resource_assignment_id;
1821: open raid_csr;
1822: fetch raid_csr into raid_rec;
1823: if raid_csr%NOTFOUND then

Line 1895: -- query pa_resource_assignments only

1891: end if;
1892: close budget_lines_csr;
1893:
1894: if l_budget_lines_exist_flag = 'N' then
1895: -- query pa_resource_assignments only
1896: -- bug 3979904: query pa_resource_assignments only if p_txn_currency_code
1897: -- is the same as project currency or project functional currency
1898: begin
1899: select ra.planning_start_date, -- x_planning_start_date

Line 1896: -- bug 3979904: query pa_resource_assignments only if p_txn_currency_code

1892: close budget_lines_csr;
1893:
1894: if l_budget_lines_exist_flag = 'N' then
1895: -- query pa_resource_assignments only
1896: -- bug 3979904: query pa_resource_assignments only if p_txn_currency_code
1897: -- is the same as project currency or project functional currency
1898: begin
1899: select ra.planning_start_date, -- x_planning_start_date
1900: ra.planning_end_date, -- x_planning_end_date

Line 2011: from pa_resource_assignments ra,

2007: x_act_margin_pct,
2008: x_etc_margin_pct,
2009: x_fcst_margin_pct,
2010: l_margin_derived_from_code
2011: from pa_resource_assignments ra,
2012: pa_budget_versions bv,
2013: pa_proj_fp_options po
2014: where ra.resource_assignment_id = l_resource_assignment_id and
2015: ra.budget_version_id = bv.budget_version_id and

Line 2369: FROM pa_resource_assignments ra,

2365: x_act_margin_pct,
2366: x_etc_margin_pct,
2367: x_fcst_margin_pct,
2368: l_margin_derived_from_code
2369: FROM pa_resource_assignments ra,
2370: -- pa_budget_lines bl,
2371: pa_resource_asgn_curr rac,
2372: pa_budget_versions bv,
2373: pa_proj_fp_options po

Line 2526: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,

2522: END get_common_bv_info_fcst;
2523:
2524:
2525: procedure get_initial_budget_line_info
2526: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
2527: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
2528: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
2529: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
2530: x_start_date OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895

Line 2836: FROM PA_BUDGET_LINES PBL,PA_RESOURCE_ASSIGNMENTS PRA,PA_PROJ_ELEMENT_VERSIONS PEV

2832: SELECT 'Y'
2833: INTO l_bl_already_exists
2834: FROM DUAL
2835: WHERE EXISTS ( SELECT 1
2836: FROM PA_BUDGET_LINES PBL,PA_RESOURCE_ASSIGNMENTS PRA,PA_PROJ_ELEMENT_VERSIONS PEV
2837: WHERE PRA.PROJECT_ID = p_project_id
2838: AND PRA.BUDGET_VERSION_ID = p_budget_version_id
2839: AND PRA.RESOURCE_LIST_MEMBER_ID = p_resource_list_member_id_tbl(i)
2840: AND PEV.PROJ_ELEMENT_ID = PRA.TASK_ID

Line 2873: FROM PA_BUDGET_LINES PBL,PA_RESOURCE_ASSIGNMENTS PRA

2869: SELECT 'Y'
2870: INTO l_bl_already_exists
2871: FROM DUAL
2872: WHERE EXISTS ( SELECT 1
2873: FROM PA_BUDGET_LINES PBL,PA_RESOURCE_ASSIGNMENTS PRA
2874: --,PA_PROJ_ELEMENT_VERSIONS PEV /* Bug 4884718; SQL ID 14903213 */
2875: WHERE PRA.PROJECT_ID = p_project_id
2876: AND PRA.BUDGET_VERSION_ID = p_budget_version_id
2877: AND PRA.RESOURCE_LIST_MEMBER_ID = p_resource_list_member_id_tbl(i)

Line 3152: p_wbs_element_version_id IN pa_resource_assignments.wbs_element_version_id%TYPE,

3148: -- or from the proj_element_id. If using proj_element_id, then p_use_element_version_id_flag
3149: -- must be set to 'N'
3150: FUNCTION get_wbs_element_name_from_id
3151: (p_project_id IN pa_projects_all.project_id%TYPE,
3152: p_wbs_element_version_id IN pa_resource_assignments.wbs_element_version_id%TYPE,
3153: p_wbs_project_element_id IN pa_proj_element_versions.proj_element_id%TYPE,
3154: p_use_element_version_flag IN VARCHAR2)
3155: return VARCHAR2
3156: IS