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

Line 12: TABLE of pa_resource_assignments.project_id%TYPE index by BINARY_INTEGER;

8: End of Comments
9: */
10:
11: type av_tab_project_id is
12: TABLE of pa_resource_assignments.project_id%TYPE index by BINARY_INTEGER;
13: type av_tab_task_id is
14: TABLE of pa_resource_assignments.task_id%TYPE index by BINARY_INTEGER;
15: type av_tab_resource_list_member_id is
16: TABLE of pa_resource_assignments.resource_list_member_id%TYPE index by BINARY_INTEGER;

Line 14: TABLE of pa_resource_assignments.task_id%TYPE index by BINARY_INTEGER;

10:
11: type av_tab_project_id is
12: TABLE of pa_resource_assignments.project_id%TYPE index by BINARY_INTEGER;
13: type av_tab_task_id is
14: TABLE of pa_resource_assignments.task_id%TYPE index by BINARY_INTEGER;
15: type av_tab_resource_list_member_id is
16: TABLE of pa_resource_assignments.resource_list_member_id%TYPE index by BINARY_INTEGER;
17: type av_tab_cost_budget_version_id is
18: TABLE of pa_resource_assignments.budget_version_id%TYPE index by BINARY_INTEGER;

Line 16: TABLE of pa_resource_assignments.resource_list_member_id%TYPE index by BINARY_INTEGER;

12: TABLE of pa_resource_assignments.project_id%TYPE index by BINARY_INTEGER;
13: type av_tab_task_id is
14: TABLE of pa_resource_assignments.task_id%TYPE index by BINARY_INTEGER;
15: type av_tab_resource_list_member_id is
16: TABLE of pa_resource_assignments.resource_list_member_id%TYPE index by BINARY_INTEGER;
17: type av_tab_cost_budget_version_id is
18: TABLE of pa_resource_assignments.budget_version_id%TYPE index by BINARY_INTEGER;
19: type av_tab_cost_res_assignment_id is
20: TABLE of pa_resource_assignments.resource_assignment_id%TYPE index by BINARY_INTEGER;

Line 18: TABLE of pa_resource_assignments.budget_version_id%TYPE index by BINARY_INTEGER;

14: TABLE of pa_resource_assignments.task_id%TYPE index by BINARY_INTEGER;
15: type av_tab_resource_list_member_id is
16: TABLE of pa_resource_assignments.resource_list_member_id%TYPE index by BINARY_INTEGER;
17: type av_tab_cost_budget_version_id is
18: TABLE of pa_resource_assignments.budget_version_id%TYPE index by BINARY_INTEGER;
19: type av_tab_cost_res_assignment_id is
20: TABLE of pa_resource_assignments.resource_assignment_id%TYPE index by BINARY_INTEGER;
21: type av_tab_rev_budget_version_id is
22: TABLE of pa_resource_assignments.budget_version_id%TYPE index by BINARY_INTEGER;

Line 20: TABLE of pa_resource_assignments.resource_assignment_id%TYPE index by BINARY_INTEGER;

16: TABLE of pa_resource_assignments.resource_list_member_id%TYPE index by BINARY_INTEGER;
17: type av_tab_cost_budget_version_id is
18: TABLE of pa_resource_assignments.budget_version_id%TYPE index by BINARY_INTEGER;
19: type av_tab_cost_res_assignment_id is
20: TABLE of pa_resource_assignments.resource_assignment_id%TYPE index by BINARY_INTEGER;
21: type av_tab_rev_budget_version_id is
22: TABLE of pa_resource_assignments.budget_version_id%TYPE index by BINARY_INTEGER;
23: type av_tab_rev_res_assignment_id is
24: TABLE of pa_resource_assignments.resource_assignment_id%TYPE index by BINARY_INTEGER;

Line 22: TABLE of pa_resource_assignments.budget_version_id%TYPE index by BINARY_INTEGER;

18: TABLE of pa_resource_assignments.budget_version_id%TYPE index by BINARY_INTEGER;
19: type av_tab_cost_res_assignment_id is
20: TABLE of pa_resource_assignments.resource_assignment_id%TYPE index by BINARY_INTEGER;
21: type av_tab_rev_budget_version_id is
22: TABLE of pa_resource_assignments.budget_version_id%TYPE index by BINARY_INTEGER;
23: type av_tab_rev_res_assignment_id is
24: TABLE of pa_resource_assignments.resource_assignment_id%TYPE index by BINARY_INTEGER;
25: type av_tab_element_name is
26: TABLE of VARCHAR2(1000) index by BINARY_INTEGER;

Line 24: TABLE of pa_resource_assignments.resource_assignment_id%TYPE index by BINARY_INTEGER;

20: TABLE of pa_resource_assignments.resource_assignment_id%TYPE index by BINARY_INTEGER;
21: type av_tab_rev_budget_version_id is
22: TABLE of pa_resource_assignments.budget_version_id%TYPE index by BINARY_INTEGER;
23: type av_tab_rev_res_assignment_id is
24: TABLE of pa_resource_assignments.resource_assignment_id%TYPE index by BINARY_INTEGER;
25: type av_tab_element_name is
26: TABLE of VARCHAR2(1000) index by BINARY_INTEGER;
27: type av_tab_element_level is
28: TABLE of VARCHAR2(50) index by BINARY_INTEGER;

Line 30: TABLE of pa_resource_assignments.total_utilization_hours%TYPE index by BINARY_INTEGER; --Bug 7514054

26: TABLE of VARCHAR2(1000) index by BINARY_INTEGER;
27: type av_tab_element_level is
28: TABLE of VARCHAR2(50) index by BINARY_INTEGER;
29: type av_tab_labor_hours is
30: TABLE of pa_resource_assignments.total_utilization_hours%TYPE index by BINARY_INTEGER; --Bug 7514054
31: type av_tab_burdened_cost is
32: TABLE of pa_resource_assignments.total_plan_burdened_cost%TYPE index by BINARY_INTEGER; --Bug 7514054
33: type av_tab_raw_cost is
34: TABLE of pa_resource_assignments.total_plan_raw_cost%TYPE index by BINARY_INTEGER; --Bug 7514054

Line 32: TABLE of pa_resource_assignments.total_plan_burdened_cost%TYPE index by BINARY_INTEGER; --Bug 7514054

28: TABLE of VARCHAR2(50) index by BINARY_INTEGER;
29: type av_tab_labor_hours is
30: TABLE of pa_resource_assignments.total_utilization_hours%TYPE index by BINARY_INTEGER; --Bug 7514054
31: type av_tab_burdened_cost is
32: TABLE of pa_resource_assignments.total_plan_burdened_cost%TYPE index by BINARY_INTEGER; --Bug 7514054
33: type av_tab_raw_cost is
34: TABLE of pa_resource_assignments.total_plan_raw_cost%TYPE index by BINARY_INTEGER; --Bug 7514054
35: type av_tab_revenue is
36: TABLE of pa_resource_assignments.total_plan_revenue%TYPE index by BINARY_INTEGER; --Bug 7514054

Line 34: TABLE of pa_resource_assignments.total_plan_raw_cost%TYPE index by BINARY_INTEGER; --Bug 7514054

30: TABLE of pa_resource_assignments.total_utilization_hours%TYPE index by BINARY_INTEGER; --Bug 7514054
31: type av_tab_burdened_cost is
32: TABLE of pa_resource_assignments.total_plan_burdened_cost%TYPE index by BINARY_INTEGER; --Bug 7514054
33: type av_tab_raw_cost is
34: TABLE of pa_resource_assignments.total_plan_raw_cost%TYPE index by BINARY_INTEGER; --Bug 7514054
35: type av_tab_revenue is
36: TABLE of pa_resource_assignments.total_plan_revenue%TYPE index by BINARY_INTEGER; --Bug 7514054
37: type av_tab_margin is
38: TABLE of pa_resource_assignments.total_plan_revenue%TYPE index by BINARY_INTEGER; --Bug 7514054

Line 36: TABLE of pa_resource_assignments.total_plan_revenue%TYPE index by BINARY_INTEGER; --Bug 7514054

32: TABLE of pa_resource_assignments.total_plan_burdened_cost%TYPE index by BINARY_INTEGER; --Bug 7514054
33: type av_tab_raw_cost is
34: TABLE of pa_resource_assignments.total_plan_raw_cost%TYPE index by BINARY_INTEGER; --Bug 7514054
35: type av_tab_revenue is
36: TABLE of pa_resource_assignments.total_plan_revenue%TYPE index by BINARY_INTEGER; --Bug 7514054
37: type av_tab_margin is
38: TABLE of pa_resource_assignments.total_plan_revenue%TYPE index by BINARY_INTEGER; --Bug 7514054
39: type av_tab_margin_percent is
40: TABLE of pa_resource_assignments.total_utilization_percent%TYPE index by BINARY_INTEGER; --Bug 7514054

Line 38: TABLE of pa_resource_assignments.total_plan_revenue%TYPE index by BINARY_INTEGER; --Bug 7514054

34: TABLE of pa_resource_assignments.total_plan_raw_cost%TYPE index by BINARY_INTEGER; --Bug 7514054
35: type av_tab_revenue is
36: TABLE of pa_resource_assignments.total_plan_revenue%TYPE index by BINARY_INTEGER; --Bug 7514054
37: type av_tab_margin is
38: TABLE of pa_resource_assignments.total_plan_revenue%TYPE index by BINARY_INTEGER; --Bug 7514054
39: type av_tab_margin_percent is
40: TABLE of pa_resource_assignments.total_utilization_percent%TYPE index by BINARY_INTEGER; --Bug 7514054
41: type av_tab_line_editable is
42: TABLE of VARCHAR2(1) index by BINARY_INTEGER;

Line 40: TABLE of pa_resource_assignments.total_utilization_percent%TYPE index by BINARY_INTEGER; --Bug 7514054

36: TABLE of pa_resource_assignments.total_plan_revenue%TYPE index by BINARY_INTEGER; --Bug 7514054
37: type av_tab_margin is
38: TABLE of pa_resource_assignments.total_plan_revenue%TYPE index by BINARY_INTEGER; --Bug 7514054
39: type av_tab_margin_percent is
40: TABLE of pa_resource_assignments.total_utilization_percent%TYPE index by BINARY_INTEGER; --Bug 7514054
41: type av_tab_line_editable is
42: TABLE of VARCHAR2(1) index by BINARY_INTEGER;
43: type av_tab_row_level is
44: TABLE of NUMBER index by BINARY_INTEGER;

Line 56: TABLE of pa_resource_assignments.unit_of_measure%TYPE index by BINARY_INTEGER;

52: TABLE of pa_proj_periods_denorm.amount_type_id%TYPE index by BINARY_INTEGER;
53: type av_tab_amount_subtype_id is
54: TABLE of pa_proj_periods_denorm.amount_subtype_id%TYPE index by BINARY_INTEGER;
55: type av_tab_unit_of_measure is
56: TABLE of pa_resource_assignments.unit_of_measure%TYPE index by BINARY_INTEGER;
57: type av_tab_preceding_amts is
58: TABLE of pa_proj_periods_denorm.preceding_periods_amount%TYPE index by BINARY_INTEGER;
59: type av_tab_succeeding_amts is
60: TABLE of pa_proj_periods_denorm.succeeding_periods_amount%TYPE index by BINARY_INTEGER;

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

336: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
337: );
338:
339: function has_child_rows
340: (p_project_id IN pa_resource_assignments.project_id%TYPE,
341: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
342: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
343: p_task_id IN pa_resource_assignments.task_id%TYPE,
344: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,

Line 341: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,

337: );
338:
339: function has_child_rows
340: (p_project_id IN pa_resource_assignments.project_id%TYPE,
341: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
342: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
343: p_task_id IN pa_resource_assignments.task_id%TYPE,
344: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
345: p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,

Line 342: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,

338:
339: function has_child_rows
340: (p_project_id IN pa_resource_assignments.project_id%TYPE,
341: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
342: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
343: p_task_id IN pa_resource_assignments.task_id%TYPE,
344: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
345: p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,
346: p_amt_or_periodic IN VARCHAR2) return VARCHAR2;

Line 343: p_task_id IN pa_resource_assignments.task_id%TYPE,

339: function has_child_rows
340: (p_project_id IN pa_resource_assignments.project_id%TYPE,
341: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
342: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
343: p_task_id IN pa_resource_assignments.task_id%TYPE,
344: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
345: p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,
346: p_amt_or_periodic IN VARCHAR2) return VARCHAR2;
347:

Line 344: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,

340: (p_project_id IN pa_resource_assignments.project_id%TYPE,
341: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
342: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
343: p_task_id IN pa_resource_assignments.task_id%TYPE,
344: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
345: p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,
346: p_amt_or_periodic IN VARCHAR2) return VARCHAR2;
347:
348: end pa_fp_view_plans_pub;