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

Line 7: pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;

3:
4: /* PL/SQL Table Types. */
5:
6: TYPE l_ra_id_tbl_typ IS TABLE OF
7: pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;
8: TYPE l_par_id_tbl_typ IS TABLE OF
9: pa_resource_assignments.PARENT_ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;
10: TYPE l_task_id_tbl_typ IS TABLE OF
11: pa_tasks.TASK_ID%TYPE INDEX BY BINARY_INTEGER;

Line 9: pa_resource_assignments.PARENT_ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;

5:
6: TYPE l_ra_id_tbl_typ IS TABLE OF
7: pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;
8: TYPE l_par_id_tbl_typ IS TABLE OF
9: pa_resource_assignments.PARENT_ASSIGNMENT_ID%TYPE INDEX BY BINARY_INTEGER;
10: TYPE l_task_id_tbl_typ IS TABLE OF
11: pa_tasks.TASK_ID%TYPE INDEX BY BINARY_INTEGER;
12: TYPE l_top_task_id_tbl_typ IS TABLE OF
13: pa_tasks.TOP_TASK_ID%TYPE INDEX BY BINARY_INTEGER;

Line 15: pa_resource_assignments.RESOURCE_LIST_MEMBER_ID%TYPE INDEX BY BINARY_INTEGER;

11: pa_tasks.TASK_ID%TYPE INDEX BY BINARY_INTEGER;
12: TYPE l_top_task_id_tbl_typ IS TABLE OF
13: pa_tasks.TOP_TASK_ID%TYPE INDEX BY BINARY_INTEGER;
14: TYPE l_res_list_mem_id_tbl_typ IS TABLE OF
15: pa_resource_assignments.RESOURCE_LIST_MEMBER_ID%TYPE INDEX BY BINARY_INTEGER;
16: TYPE l_track_as_labor_flag_tbl_typ IS TABLE OF
17: pa_resource_assignments.TRACK_AS_LABOR_FLAG%TYPE INDEX BY BINARY_INTEGER;
18: TYPE l_plannable_flag_tbl_typ IS TABLE OF
19: pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 17: pa_resource_assignments.TRACK_AS_LABOR_FLAG%TYPE INDEX BY BINARY_INTEGER;

13: pa_tasks.TOP_TASK_ID%TYPE INDEX BY BINARY_INTEGER;
14: TYPE l_res_list_mem_id_tbl_typ IS TABLE OF
15: pa_resource_assignments.RESOURCE_LIST_MEMBER_ID%TYPE INDEX BY BINARY_INTEGER;
16: TYPE l_track_as_labor_flag_tbl_typ IS TABLE OF
17: pa_resource_assignments.TRACK_AS_LABOR_FLAG%TYPE INDEX BY BINARY_INTEGER;
18: TYPE l_plannable_flag_tbl_typ IS TABLE OF
19: pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE INDEX BY BINARY_INTEGER;
20: TYPE l_unit_of_measure_tbl_typ IS TABLE OF
21: pa_resource_assignments.UNIT_OF_MEASURE%TYPE INDEX BY BINARY_INTEGER;

Line 21: pa_resource_assignments.UNIT_OF_MEASURE%TYPE INDEX BY BINARY_INTEGER;

17: pa_resource_assignments.TRACK_AS_LABOR_FLAG%TYPE INDEX BY BINARY_INTEGER;
18: TYPE l_plannable_flag_tbl_typ IS TABLE OF
19: pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE INDEX BY BINARY_INTEGER;
20: TYPE l_unit_of_measure_tbl_typ IS TABLE OF
21: pa_resource_assignments.UNIT_OF_MEASURE%TYPE INDEX BY BINARY_INTEGER;
22: TYPE l_proj_raw_cost_tbl_typ IS TABLE OF
23: pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE INDEX BY BINARY_INTEGER;
24: TYPE l_proj_burd_cost_tbl_typ IS TABLE OF
25: pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE INDEX BY BINARY_INTEGER;

Line 23: pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE INDEX BY BINARY_INTEGER;

19: pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE INDEX BY BINARY_INTEGER;
20: TYPE l_unit_of_measure_tbl_typ IS TABLE OF
21: pa_resource_assignments.UNIT_OF_MEASURE%TYPE INDEX BY BINARY_INTEGER;
22: TYPE l_proj_raw_cost_tbl_typ IS TABLE OF
23: pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE INDEX BY BINARY_INTEGER;
24: TYPE l_proj_burd_cost_tbl_typ IS TABLE OF
25: pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE INDEX BY BINARY_INTEGER;
26: TYPE l_proj_revenue_tbl_typ IS TABLE OF
27: pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE INDEX BY BINARY_INTEGER;

Line 25: pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE INDEX BY BINARY_INTEGER;

21: pa_resource_assignments.UNIT_OF_MEASURE%TYPE INDEX BY BINARY_INTEGER;
22: TYPE l_proj_raw_cost_tbl_typ IS TABLE OF
23: pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE INDEX BY BINARY_INTEGER;
24: TYPE l_proj_burd_cost_tbl_typ IS TABLE OF
25: pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE INDEX BY BINARY_INTEGER;
26: TYPE l_proj_revenue_tbl_typ IS TABLE OF
27: pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE l_projfunc_raw_cost_tbl_typ IS TABLE OF
29: pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE INDEX BY BINARY_INTEGER;

Line 27: pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE INDEX BY BINARY_INTEGER;

23: pa_resource_assignments.TOTAL_PROJECT_RAW_COST%TYPE INDEX BY BINARY_INTEGER;
24: TYPE l_proj_burd_cost_tbl_typ IS TABLE OF
25: pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE INDEX BY BINARY_INTEGER;
26: TYPE l_proj_revenue_tbl_typ IS TABLE OF
27: pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE l_projfunc_raw_cost_tbl_typ IS TABLE OF
29: pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE INDEX BY BINARY_INTEGER;
30: TYPE l_projfunc_burd_cost_tbl_typ IS TABLE OF
31: pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE INDEX BY BINARY_INTEGER;

Line 29: pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE INDEX BY BINARY_INTEGER;

25: pa_resource_assignments.TOTAL_PROJECT_BURDENED_COST%TYPE INDEX BY BINARY_INTEGER;
26: TYPE l_proj_revenue_tbl_typ IS TABLE OF
27: pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE l_projfunc_raw_cost_tbl_typ IS TABLE OF
29: pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE INDEX BY BINARY_INTEGER;
30: TYPE l_projfunc_burd_cost_tbl_typ IS TABLE OF
31: pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE INDEX BY BINARY_INTEGER;
32: TYPE l_projfunc_revenue_tbl_typ IS TABLE OF
33: pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE INDEX BY BINARY_INTEGER;

Line 31: pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE INDEX BY BINARY_INTEGER;

27: pa_resource_assignments.TOTAL_PROJECT_REVENUE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE l_projfunc_raw_cost_tbl_typ IS TABLE OF
29: pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE INDEX BY BINARY_INTEGER;
30: TYPE l_projfunc_burd_cost_tbl_typ IS TABLE OF
31: pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE INDEX BY BINARY_INTEGER;
32: TYPE l_projfunc_revenue_tbl_typ IS TABLE OF
33: pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE INDEX BY BINARY_INTEGER;
34: TYPE l_quantity_tbl_typ IS TABLE OF
35: pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

Line 33: pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE INDEX BY BINARY_INTEGER;

29: pa_resource_assignments.TOTAL_PLAN_RAW_COST%TYPE INDEX BY BINARY_INTEGER;
30: TYPE l_projfunc_burd_cost_tbl_typ IS TABLE OF
31: pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE INDEX BY BINARY_INTEGER;
32: TYPE l_projfunc_revenue_tbl_typ IS TABLE OF
33: pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE INDEX BY BINARY_INTEGER;
34: TYPE l_quantity_tbl_typ IS TABLE OF
35: pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
36:
37: TYPE l_obj_typ_code_tbl_typ IS TABLE OF

Line 35: pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

31: pa_resource_assignments.TOTAL_PLAN_BURDENED_COST%TYPE INDEX BY BINARY_INTEGER;
32: TYPE l_projfunc_revenue_tbl_typ IS TABLE OF
33: pa_resource_assignments.TOTAL_PLAN_REVENUE%TYPE INDEX BY BINARY_INTEGER;
34: TYPE l_quantity_tbl_typ IS TABLE OF
35: pa_resource_assignments.TOTAL_PLAN_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
36:
37: TYPE l_obj_typ_code_tbl_typ IS TABLE OF
38: pa_proj_periods_denorm.object_type_code%TYPE INDEX BY BINARY_INTEGER;
39: TYPE l_object_id_tbl_typ IS TABLE OF

Line 70: p_first_ra_id pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE;

66: /* Exception to be used for Invalid Parameters. */
67: Invalid_Arg_Exc EXCEPTION;
68:
69: /* Global variables */
70: p_first_ra_id pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE;
71:
72:
73: PROCEDURE POPULATE_LOCAL_VARS(
74: p_budget_version_id IN NUMBER