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_FP_VIEW_PLANS_UTIL dependencies on PA_RESOURCE_ASSIGNMENTS

Line 13: p_project_id IN pa_resource_assignments.project_id%TYPE,

9: */
10:
11: FUNCTION calculate_gl_total
12: (p_amount_code IN pa_amount_types_b.amount_type_code%TYPE,
13: p_project_id IN pa_resource_assignments.project_id%TYPE,
14: p_task_id IN pa_resource_assignments.task_id%TYPE,
15: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
16: return NUMBER
17: is

Line 14: p_task_id IN pa_resource_assignments.task_id%TYPE,

10:
11: FUNCTION calculate_gl_total
12: (p_amount_code IN pa_amount_types_b.amount_type_code%TYPE,
13: p_project_id IN pa_resource_assignments.project_id%TYPE,
14: p_task_id IN pa_resource_assignments.task_id%TYPE,
15: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
16: return NUMBER
17: is
18: l_burdened_cost NUMBER := 0;

Line 15: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)

11: FUNCTION calculate_gl_total
12: (p_amount_code IN pa_amount_types_b.amount_type_code%TYPE,
13: p_project_id IN pa_resource_assignments.project_id%TYPE,
14: p_task_id IN pa_resource_assignments.task_id%TYPE,
15: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
16: return NUMBER
17: is
18: l_burdened_cost NUMBER := 0;
19: l_revenue NUMBER := 0;

Line 81: p_project_id IN pa_resource_assignments.project_id%TYPE,

77: /* ------------------------------------------------------------------ */
78:
79: FUNCTION calculate_pa_total
80: (p_amount_code IN pa_amount_types_b.amount_type_code%TYPE,
81: p_project_id IN pa_resource_assignments.project_id%TYPE,
82: p_task_id IN pa_resource_assignments.task_id%TYPE,
83: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
84: return NUMBER
85: is

Line 82: p_task_id IN pa_resource_assignments.task_id%TYPE,

78:
79: FUNCTION calculate_pa_total
80: (p_amount_code IN pa_amount_types_b.amount_type_code%TYPE,
81: p_project_id IN pa_resource_assignments.project_id%TYPE,
82: p_task_id IN pa_resource_assignments.task_id%TYPE,
83: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
84: return NUMBER
85: is
86: l_burdened_cost NUMBER := 0;

Line 83: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)

79: FUNCTION calculate_pa_total
80: (p_amount_code IN pa_amount_types_b.amount_type_code%TYPE,
81: p_project_id IN pa_resource_assignments.project_id%TYPE,
82: p_task_id IN pa_resource_assignments.task_id%TYPE,
83: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
84: return NUMBER
85: is
86: l_burdened_cost NUMBER := 0;
87: l_revenue NUMBER := 0;

Line 211: (p_project_id IN pa_resource_assignments.project_id%TYPE,

207: end check_compatible_pd_profiles;
208: /* -------------------------------------------------------------------- */
209:
210: FUNCTION assign_row_level
211: (p_project_id IN pa_resource_assignments.project_id%TYPE,
212: p_task_id IN pa_resource_assignments.task_id%TYPE,
213: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
214: return NUMBER
215: is

Line 212: p_task_id IN pa_resource_assignments.task_id%TYPE,

208: /* -------------------------------------------------------------------- */
209:
210: FUNCTION assign_row_level
211: (p_project_id IN pa_resource_assignments.project_id%TYPE,
212: p_task_id IN pa_resource_assignments.task_id%TYPE,
213: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
214: return NUMBER
215: is
216: /* local variables */

Line 213: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)

209:
210: FUNCTION assign_row_level
211: (p_project_id IN pa_resource_assignments.project_id%TYPE,
212: p_task_id IN pa_resource_assignments.task_id%TYPE,
213: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
214: return NUMBER
215: is
216: /* local variables */
217: l_return_value NUMBER;

Line 320: (p_project_id IN pa_resource_assignments.project_id%TYPE,

316: END assign_row_level;
317: /* -------------------------------------------------------------------- */
318:
319: FUNCTION assign_parent_element
320: (p_project_id IN pa_resource_assignments.project_id%TYPE,
321: p_task_id IN pa_resource_assignments.task_id%TYPE,
322: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
323: return VARCHAR2
324: as

Line 321: p_task_id IN pa_resource_assignments.task_id%TYPE,

317: /* -------------------------------------------------------------------- */
318:
319: FUNCTION assign_parent_element
320: (p_project_id IN pa_resource_assignments.project_id%TYPE,
321: p_task_id IN pa_resource_assignments.task_id%TYPE,
322: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
323: return VARCHAR2
324: as
325: /* local variables */

Line 322: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)

318:
319: FUNCTION assign_parent_element
320: (p_project_id IN pa_resource_assignments.project_id%TYPE,
321: p_task_id IN pa_resource_assignments.task_id%TYPE,
322: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
323: return VARCHAR2
324: as
325: /* local variables */
326: l_return_value VARCHAR2(2000);

Line 477: (p_project_id IN pa_resource_assignments.project_id%TYPE,

473: END assign_parent_element;
474: /* --------------------------------------------------------------------- */
475:
476: FUNCTION assign_element_name
477: (p_project_id IN pa_resource_assignments.project_id%TYPE,
478: p_task_id IN pa_resource_assignments.task_id%TYPE,
479: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
480: return VARCHAR2
481: is

Line 478: p_task_id IN pa_resource_assignments.task_id%TYPE,

474: /* --------------------------------------------------------------------- */
475:
476: FUNCTION assign_element_name
477: (p_project_id IN pa_resource_assignments.project_id%TYPE,
478: p_task_id IN pa_resource_assignments.task_id%TYPE,
479: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
480: return VARCHAR2
481: is
482: /* local variables */

Line 479: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)

475:
476: FUNCTION assign_element_name
477: (p_project_id IN pa_resource_assignments.project_id%TYPE,
478: p_task_id IN pa_resource_assignments.task_id%TYPE,
479: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
480: return VARCHAR2
481: is
482: /* local variables */
483: l_return_value VARCHAR2(2000);

Line 562: (p_project_id IN pa_resource_assignments.project_id%TYPE,

558: END assign_element_name;
559: /* --------------------------------------------------------------------- */
560:
561: FUNCTION assign_element_level
562: (p_project_id IN pa_resource_assignments.project_id%TYPE,
563: p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE,
564: p_task_id IN pa_resource_assignments.task_id%TYPE,
565: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
566: return VARCHAR2

Line 563: p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE,

559: /* --------------------------------------------------------------------- */
560:
561: FUNCTION assign_element_level
562: (p_project_id IN pa_resource_assignments.project_id%TYPE,
563: p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE,
564: p_task_id IN pa_resource_assignments.task_id%TYPE,
565: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
566: return VARCHAR2
567: is

Line 564: p_task_id IN pa_resource_assignments.task_id%TYPE,

560:
561: FUNCTION assign_element_level
562: (p_project_id IN pa_resource_assignments.project_id%TYPE,
563: p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE,
564: p_task_id IN pa_resource_assignments.task_id%TYPE,
565: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
566: return VARCHAR2
567: is
568: /* local variables */

Line 565: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)

561: FUNCTION assign_element_level
562: (p_project_id IN pa_resource_assignments.project_id%TYPE,
563: p_budget_version_id IN pa_resource_assignments.budget_version_id%TYPE,
564: p_task_id IN pa_resource_assignments.task_id%TYPE,
565: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE)
566: return VARCHAR2
567: is
568: /* local variables */
569: l_return_value VARCHAR2(2000);

Line 574: l_labor_res_flag pa_resource_assignments.track_as_labor_flag%TYPE;

570: l_parent_task_id pa_tasks.parent_task_id%TYPE;
571: l_parent_wbs_level pa_tasks.wbs_level%TYPE;
572: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
573: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
574: l_labor_res_flag pa_resource_assignments.track_as_labor_flag%TYPE;
575:
576: BEGIN
577: l_return_value := 'dummy element level';
578:

Line 610: from pa_resource_assignments

606: else
607: -- resource is RESOURCE child; need to determine if LABOR or NON_LABOR
608: select nvl(track_as_labor_flag, 'N')
609: into l_labor_res_flag
610: from pa_resource_assignments
611: where project_id = p_project_id and
612: budget_version_id = p_budget_version_id and
613: task_id = p_task_id and
614: resource_list_member_id = p_resource_list_member_id;

Line 630: (p_project_id IN pa_resource_assignments.project_id%TYPE,

626: -- this procedure populates task, resource_group, or resource field for the
627: -- user_entered view (flat hierarchy; no HGrid)
628:
629: FUNCTION assign_flat_element_names
630: (p_project_id IN pa_resource_assignments.project_id%TYPE,
631: p_task_id IN pa_resource_assignments.task_id%TYPE,
632: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
633: p_element_type IN VARCHAR2)
634: return VARCHAR2

Line 631: p_task_id IN pa_resource_assignments.task_id%TYPE,

627: -- user_entered view (flat hierarchy; no HGrid)
628:
629: FUNCTION assign_flat_element_names
630: (p_project_id IN pa_resource_assignments.project_id%TYPE,
631: p_task_id IN pa_resource_assignments.task_id%TYPE,
632: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
633: p_element_type IN VARCHAR2)
634: return VARCHAR2
635: is

Line 632: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,

628:
629: FUNCTION assign_flat_element_names
630: (p_project_id IN pa_resource_assignments.project_id%TYPE,
631: p_task_id IN pa_resource_assignments.task_id%TYPE,
632: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
633: p_element_type IN VARCHAR2)
634: return VARCHAR2
635: is
636: l_return_value VARCHAR2(80);

Line 4775: from pa_resource_assignments

4771: is
4772:
4773: cursor l_ra_csr is
4774: select resource_assignment_id
4775: from pa_resource_assignments
4776: where budget_version_id = p_budget_version_id;
4777: l_ra_rec l_ra_csr%ROWTYPE;
4778:
4779: /* local variables */

Line 4780: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

4776: where budget_version_id = p_budget_version_id;
4777: l_ra_rec l_ra_csr%ROWTYPE;
4778:
4779: /* local variables */
4780: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
4781: l_line_costrev_total pa_resource_assignments.total_plan_revenue%TYPE;
4782: l_line_quantity_total pa_resource_assignments.total_plan_quantity%TYPE;
4783: begin
4784: open l_ra_csr;

Line 4781: l_line_costrev_total pa_resource_assignments.total_plan_revenue%TYPE;

4777: l_ra_rec l_ra_csr%ROWTYPE;
4778:
4779: /* local variables */
4780: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
4781: l_line_costrev_total pa_resource_assignments.total_plan_revenue%TYPE;
4782: l_line_quantity_total pa_resource_assignments.total_plan_quantity%TYPE;
4783: begin
4784: open l_ra_csr;
4785: if p_cost_or_rev = 'REVENUE' then

Line 4782: l_line_quantity_total pa_resource_assignments.total_plan_quantity%TYPE;

4778:
4779: /* local variables */
4780: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
4781: l_line_costrev_total pa_resource_assignments.total_plan_revenue%TYPE;
4782: l_line_quantity_total pa_resource_assignments.total_plan_quantity%TYPE;
4783: begin
4784: open l_ra_csr;
4785: if p_cost_or_rev = 'REVENUE' then
4786: -- roll up the revenue budget version

Line 4797: update pa_resource_assignments

4793: l_line_costrev_total
4794: from pa_budget_lines
4795: where resource_assignment_id = l_ra_rec.resource_assignment_id
4796: group by resource_assignment_id;
4797: update pa_resource_assignments
4798: set total_plan_revenue = l_line_costrev_total,
4799: total_utilization_hours = l_line_quantity_total
4800: where
4801: resource_assignment_id = l_ra_rec.resource_assignment_id;

Line 4815: update pa_resource_assignments

4811: l_line_costrev_total
4812: from pa_budget_lines
4813: where resource_assignment_id = l_ra_rec.resource_assignment_id
4814: group by resource_assignment_id;
4815: update pa_resource_assignments
4816: set total_plan_burdened_cost = l_line_costrev_total,
4817: total_utilization_hours = l_line_quantity_total
4818: where
4819: resource_assignment_id = l_ra_rec.resource_assignment_id;

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

4889: -- FP L: used in View/Edit Plan page whenever navigation option to View/Edit
4890: -- Plan Line page is chosen. If the resource assignment has been deleted by
4891: -- WBS, an error needs to be displayed
4892: procedure check_res_assignment_exists
4893: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
4894: x_res_assignment_exists OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4895: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4896: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4897: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895

Line 4908: from pa_resource_assignments

4904: into l_res_assignment_exists
4905: from dual
4906: where exists
4907: (select resource_assignment_id
4908: from pa_resource_assignments
4909: where resource_assignment_id = p_resource_assignment_id);
4910: if l_res_assignment_exists = 'Y' then
4911: x_res_assignment_exists := 'Y';
4912: else

Line 5058: from pa_resource_assignments ra

5054: /*** PROJECT-LEVEL PLANNING ***/
5055: begin
5056: select ra.resource_list_member_id
5057: into l_prj_rlm_id
5058: from pa_resource_assignments ra
5059: where ra.budget_version_id = p_budget_version_id and
5060: nvl(ra.resource_assignment_type,'USER_ENTERED') = 'USER_ENTERED' and
5061: rownum < 2;
5062: exception