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 141: l_uncat_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;

137: l_display_marginpct VARCHAR2(1);
138:
139: -- uncategorized list info
140: l_uncat_resource_list_id pa_resource_lists.resource_list_id%TYPE;
141: l_uncat_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
142: l_track_as_labor_flag pa_resources.track_as_labor_flag%TYPE;
143: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
144:
145: -- Bug 8463760

Line 143: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;

139: -- uncategorized list info
140: l_uncat_resource_list_id pa_resource_lists.resource_list_id%TYPE;
141: l_uncat_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
142: l_track_as_labor_flag pa_resources.track_as_labor_flag%TYPE;
143: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
144:
145: -- Bug 8463760
146: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE;
147:

Line 1178: l_uncat_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;

1174: l_ci_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1175:
1176: -- uncategorized list info
1177: l_uncat_resource_list_id pa_resource_lists.resource_list_id%TYPE;
1178: l_uncat_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
1179: l_track_as_labor_flag pa_resources.track_as_labor_flag%TYPE;
1180: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
1181:
1182: BEGIN

Line 1180: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;

1176: -- uncategorized list info
1177: l_uncat_resource_list_id pa_resource_lists.resource_list_id%TYPE;
1178: l_uncat_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
1179: l_track_as_labor_flag pa_resources.track_as_labor_flag%TYPE;
1180: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
1181:
1182: BEGIN
1183: x_msg_count := 0;
1184: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2708: select * from pa_resource_assignments where budget_version_id=p_budget_version_id;

2704:
2705: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
2706:
2707: cursor l_ra_csr is
2708: select * from pa_resource_assignments where budget_version_id=p_budget_version_id;
2709: l_ra_rec l_ra_csr%ROWTYPE;
2710:
2711: -- the following four cursors are used to find a complementary plan
2712: -- version if our version is 'COST_ONLY' or 'REVENUE_ONLY'

Line 3753: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

3749: is
3750: /* local variables */
3751: l_found_complement BOOLEAN;
3752: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3753: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
3754: l_quantity_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
3755: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
3756: l_cost_row_number NUMBER; -- PERIODS PL/SQL: cost row for calculating margin
3757: l_revenue_row_number NUMBER; -- PERIODS PL/SQL: rev row for calculating margin

Line 3754: l_quantity_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

3750: /* local variables */
3751: l_found_complement BOOLEAN;
3752: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3753: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
3754: l_quantity_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
3755: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
3756: l_cost_row_number NUMBER; -- PERIODS PL/SQL: cost row for calculating margin
3757: l_revenue_row_number NUMBER; -- PERIODS PL/SQL: rev row for calculating margin
3758: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers

Line 3817: from pa_resource_assignments ra

3813: (ra.project_id,
3814: ra.task_id,
3815: ra.resource_list_member_id) as parent_element_name,
3816: ra.unit_of_measure
3817: from pa_resource_assignments ra
3818: where ra.budget_version_id = p_cost_budget_version_id and
3819: ((ra.resource_assignment_type = 'USER_ENTERED' and
3820: exists (select 1 from pa_budget_lines bl
3821: where bl.budget_version_id = ra.budget_version_id and

Line 3866: from pa_resource_assignments ra

3862: (ra.project_id,
3863: ra.task_id,
3864: ra.resource_list_member_id) as parent_element_name,
3865: ra.unit_of_measure
3866: from pa_resource_assignments ra
3867: where ra.budget_version_id = p_rev_budget_version_id and
3868: ((ra.resource_assignment_type = 'USER_ENTERED' and
3869: exists (select 1 from pa_budget_lines bl
3870: where bl.budget_version_id = ra.budget_version_id and

Line 6856: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

6852: is
6853:
6854: /* LOCAL VARIABLES */
6855: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
6856: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
6857: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
6858: l_cost_row_number NUMBER; -- PERIODS PL/SQL: cost row for calculating margin
6859: l_revenue_row_number NUMBER; -- PERIODS PL/SQL: rev row for calculating margin
6860: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers

Line 6948: from pa_resource_assignments ra,

6944: ra.task_id,
6945: ra.resource_list_member_id,
6946: null,
6947: 'A') as has_child_element
6948: from pa_resource_assignments ra,
6949: pa_proj_fp_options po
6950: where ra.budget_version_id = p_budget_version_id and
6951: ra.budget_version_id = po.fin_plan_version_id and
6952: po.fin_plan_option_level_code='PLAN_VERSION' and

Line 8293: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

8289: as
8290:
8291: /* local variables */
8292: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
8293: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
8294: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
8295: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers
8296: l_default_amount_type_code VARCHAR2(30);
8297: l_default_amount_subtype_code VARCHAR2(30);

Line 8364: from pa_resource_assignments ra,

8360: ra.task_id,
8361: ra.resource_list_member_id,
8362: null,
8363: 'A') as has_child_element
8364: from pa_resource_assignments ra,
8365: pa_proj_fp_options po
8366: where ra.budget_version_id = p_budget_version_id and
8367: ra.budget_version_id = po.fin_plan_version_id and
8368: po.fin_plan_option_level_code='PLAN_VERSION' and

Line 8422: from pa_resource_assignments ra,

8418: ra.task_id,
8419: ra.resource_list_member_id,
8420: null,
8421: 'A') as has_child_element
8422: from pa_resource_assignments ra,
8423: pa_proj_fp_options po
8424: where ra.budget_version_id = p_budget_version_id and
8425: ra.budget_version_id = po.fin_plan_version_id and
8426: po.fin_plan_option_level_code='PLAN_VERSION' and

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

10589: -- HISTORY:
10590: -- 20-Feb-2003 dlai created: for Hgrid performance enhancement
10591:
10592: FUNCTION has_child_rows
10593: (p_project_id IN pa_resource_assignments.project_id%TYPE,
10594: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
10595: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
10596: p_task_id IN pa_resource_assignments.task_id%TYPE,
10597: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,

Line 10594: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,

10590: -- 20-Feb-2003 dlai created: for Hgrid performance enhancement
10591:
10592: FUNCTION has_child_rows
10593: (p_project_id IN pa_resource_assignments.project_id%TYPE,
10594: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
10595: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
10596: p_task_id IN pa_resource_assignments.task_id%TYPE,
10597: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
10598: p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,

Line 10595: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,

10591:
10592: FUNCTION has_child_rows
10593: (p_project_id IN pa_resource_assignments.project_id%TYPE,
10594: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
10595: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
10596: p_task_id IN pa_resource_assignments.task_id%TYPE,
10597: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
10598: p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,
10599: p_amt_or_periodic IN VARCHAR2) return VARCHAR2

Line 10596: p_task_id IN pa_resource_assignments.task_id%TYPE,

10592: FUNCTION has_child_rows
10593: (p_project_id IN pa_resource_assignments.project_id%TYPE,
10594: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
10595: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
10596: p_task_id IN pa_resource_assignments.task_id%TYPE,
10597: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
10598: p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,
10599: p_amt_or_periodic IN VARCHAR2) return VARCHAR2
10600: IS

Line 10597: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,

10593: (p_project_id IN pa_resource_assignments.project_id%TYPE,
10594: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
10595: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
10596: p_task_id IN pa_resource_assignments.task_id%TYPE,
10597: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
10598: p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,
10599: p_amt_or_periodic IN VARCHAR2) return VARCHAR2
10600: IS
10601:

Line 10609: from pa_resource_assignments ra,

10605:
10606: cursor project_children_csr is
10607: /* Bug 3106741 rewritten for performance improvement
10608: select ra.task_id -- doesn't matter what we select here
10609: from pa_resource_assignments ra,
10610: pa_tasks t
10611: where (ra.budget_version_id in (p_budget_version_id1, p_budget_version_id2) and
10612: ra.task_id=0 and
10613: not (ra.resource_list_member_id in (0,pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id))) or

Line 10621: from pa_resource_assignments ra

10617: t.parent_task_id is null);
10618: */
10619: select 1 from dual where exists (
10620: select ra.task_id -- doesn't matter what we select here
10621: from pa_resource_assignments ra
10622: where ra.budget_version_id in (p_budget_version_id1, p_budget_version_id2)
10623: and (
10624: ( ra.task_id=0
10625: and not (ra.resource_list_member_id in (0,pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id)))

Line 10638: from pa_resource_assignments ra,

10634:
10635: cursor task_children_csr is
10636: /* Bug 3106741 rewritten for performance improvement
10637: select ra.task_id
10638: from pa_resource_assignments ra,
10639: pa_tasks t
10640: where (ra.budget_version_id in(p_budget_version_id1, p_budget_version_id2) and
10641: ra.task_id=p_task_id and
10642: not (ra.resource_list_member_id in (0,pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id))) or

Line 10648: from pa_resource_assignments ra

10644: ra.task_id = t.task_id and t.parent_task_id = p_task_id);
10645: */
10646: select 1 from dual where exists (
10647: select ra.task_id
10648: from pa_resource_assignments ra
10649: where ra.budget_version_id in(p_budget_version_id1, p_budget_version_id2) and
10650: (
10651: (ra.task_id=p_task_id and
10652: not (ra.resource_list_member_id in