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: BEGIN

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: BEGIN
146: --hr_utility.trace_on(null, 'dlai');
147: --hr_utility.trace('STARTING');

Line 1082: l_uncat_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;

1078: l_ci_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1079:
1080: -- uncategorized list info
1081: l_uncat_resource_list_id pa_resource_lists.resource_list_id%TYPE;
1082: l_uncat_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
1083: l_track_as_labor_flag pa_resources.track_as_labor_flag%TYPE;
1084: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
1085:
1086: BEGIN

Line 1084: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;

1080: -- uncategorized list info
1081: l_uncat_resource_list_id pa_resource_lists.resource_list_id%TYPE;
1082: l_uncat_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
1083: l_track_as_labor_flag pa_resources.track_as_labor_flag%TYPE;
1084: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
1085:
1086: BEGIN
1087: x_msg_count := 0;
1088: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2586:
2587: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
2588:
2589: cursor l_ra_csr is
2590: select * from pa_resource_assignments where budget_version_id=p_budget_version_id;
2591: l_ra_rec l_ra_csr%ROWTYPE;
2592:
2593: -- the following four cursors are used to find a complementary plan
2594: -- version if our version is 'COST_ONLY' or 'REVENUE_ONLY'

Line 3635: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

3631: is
3632: /* local variables */
3633: l_found_complement BOOLEAN;
3634: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3635: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
3636: l_quantity_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
3637: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
3638: l_cost_row_number NUMBER; -- PERIODS PL/SQL: cost row for calculating margin
3639: l_revenue_row_number NUMBER; -- PERIODS PL/SQL: rev row for calculating margin

Line 3636: l_quantity_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

3632: /* local variables */
3633: l_found_complement BOOLEAN;
3634: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
3635: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
3636: l_quantity_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
3637: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
3638: l_cost_row_number NUMBER; -- PERIODS PL/SQL: cost row for calculating margin
3639: l_revenue_row_number NUMBER; -- PERIODS PL/SQL: rev row for calculating margin
3640: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers

Line 3688: from pa_resource_assignments ra

3684: (ra.project_id,
3685: ra.task_id,
3686: ra.resource_list_member_id) as parent_element_name,
3687: ra.unit_of_measure
3688: from pa_resource_assignments ra
3689: where ra.budget_version_id = p_cost_budget_version_id and
3690: ((ra.resource_assignment_type = 'USER_ENTERED' and
3691: exists (select 1 from pa_budget_lines bl
3692: where bl.budget_version_id = ra.budget_version_id and

Line 3737: from pa_resource_assignments ra

3733: (ra.project_id,
3734: ra.task_id,
3735: ra.resource_list_member_id) as parent_element_name,
3736: ra.unit_of_measure
3737: from pa_resource_assignments ra
3738: where ra.budget_version_id = p_rev_budget_version_id and
3739: ((ra.resource_assignment_type = 'USER_ENTERED' and
3740: exists (select 1 from pa_budget_lines bl
3741: where bl.budget_version_id = ra.budget_version_id and

Line 6257: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

6253: is
6254:
6255: /* LOCAL VARIABLES */
6256: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
6257: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
6258: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
6259: l_cost_row_number NUMBER; -- PERIODS PL/SQL: cost row for calculating margin
6260: l_revenue_row_number NUMBER; -- PERIODS PL/SQL: rev row for calculating margin
6261: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers

Line 6338: from pa_resource_assignments ra,

6334: ra.task_id,
6335: ra.resource_list_member_id,
6336: null,
6337: 'A') as has_child_element
6338: from pa_resource_assignments ra,
6339: pa_proj_fp_options po
6340: where ra.budget_version_id = p_budget_version_id and
6341: ra.budget_version_id = po.fin_plan_version_id and
6342: po.fin_plan_option_level_code='PLAN_VERSION' and

Line 7339: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

7335: as
7336:
7337: /* local variables */
7338: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
7339: l_cur_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
7340: l_row_number NUMBER; -- keep track of number of rows in PERIODS PL/SQL table
7341: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE; -- used to retrieve values for period numbers
7342: l_default_amount_type_code VARCHAR2(30);
7343: l_default_amount_subtype_code VARCHAR2(30);

Line 7395: from pa_resource_assignments ra,

7391: ra.task_id,
7392: ra.resource_list_member_id,
7393: null,
7394: 'A') as has_child_element
7395: from pa_resource_assignments ra,
7396: pa_proj_fp_options po
7397: where ra.budget_version_id = p_budget_version_id and
7398: ra.budget_version_id = po.fin_plan_version_id and
7399: po.fin_plan_option_level_code='PLAN_VERSION' and

Line 7453: from pa_resource_assignments ra,

7449: ra.task_id,
7450: ra.resource_list_member_id,
7451: null,
7452: 'A') as has_child_element
7453: from pa_resource_assignments ra,
7454: pa_proj_fp_options po
7455: where ra.budget_version_id = p_budget_version_id and
7456: ra.budget_version_id = po.fin_plan_version_id and
7457: po.fin_plan_option_level_code='PLAN_VERSION' and

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

8980: -- HISTORY:
8981: -- 20-Feb-2003 dlai created: for Hgrid performance enhancement
8982:
8983: FUNCTION has_child_rows
8984: (p_project_id IN pa_resource_assignments.project_id%TYPE,
8985: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
8986: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
8987: p_task_id IN pa_resource_assignments.task_id%TYPE,
8988: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,

Line 8985: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,

8981: -- 20-Feb-2003 dlai created: for Hgrid performance enhancement
8982:
8983: FUNCTION has_child_rows
8984: (p_project_id IN pa_resource_assignments.project_id%TYPE,
8985: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
8986: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
8987: p_task_id IN pa_resource_assignments.task_id%TYPE,
8988: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
8989: p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,

Line 8986: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,

8982:
8983: FUNCTION has_child_rows
8984: (p_project_id IN pa_resource_assignments.project_id%TYPE,
8985: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
8986: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
8987: p_task_id IN pa_resource_assignments.task_id%TYPE,
8988: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
8989: p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,
8990: p_amt_or_periodic IN VARCHAR2) return VARCHAR2

Line 8987: p_task_id IN pa_resource_assignments.task_id%TYPE,

8983: FUNCTION has_child_rows
8984: (p_project_id IN pa_resource_assignments.project_id%TYPE,
8985: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
8986: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
8987: p_task_id IN pa_resource_assignments.task_id%TYPE,
8988: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
8989: p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,
8990: p_amt_or_periodic IN VARCHAR2) return VARCHAR2
8991: IS

Line 8988: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,

8984: (p_project_id IN pa_resource_assignments.project_id%TYPE,
8985: p_budget_version_id1 IN pa_resource_assignments.budget_version_id%TYPE,
8986: p_budget_version_id2 IN pa_resource_assignments.budget_version_id%TYPE,
8987: p_task_id IN pa_resource_assignments.task_id%TYPE,
8988: p_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
8989: p_amount_subtype_code IN pa_proj_periods_denorm.amount_subtype_code%TYPE,
8990: p_amt_or_periodic IN VARCHAR2) return VARCHAR2
8991: IS
8992:

Line 9000: from pa_resource_assignments ra,

8996:
8997: cursor project_children_csr is
8998: /* Bug 3106741 rewritten for performance improvement
8999: select ra.task_id -- doesn't matter what we select here
9000: from pa_resource_assignments ra,
9001: pa_tasks t
9002: where (ra.budget_version_id in (p_budget_version_id1, p_budget_version_id2) and
9003: ra.task_id=0 and
9004: not (ra.resource_list_member_id in (0,pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id))) or

Line 9012: from pa_resource_assignments ra

9008: t.parent_task_id is null);
9009: */
9010: select 1 from dual where exists (
9011: select ra.task_id -- doesn't matter what we select here
9012: from pa_resource_assignments ra
9013: where ra.budget_version_id in (p_budget_version_id1, p_budget_version_id2)
9014: and (
9015: ( ra.task_id=0
9016: and not (ra.resource_list_member_id in (0,pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id)))

Line 9029: from pa_resource_assignments ra,

9025:
9026: cursor task_children_csr is
9027: /* Bug 3106741 rewritten for performance improvement
9028: select ra.task_id
9029: from pa_resource_assignments ra,
9030: pa_tasks t
9031: where (ra.budget_version_id in(p_budget_version_id1, p_budget_version_id2) and
9032: ra.task_id=p_task_id and
9033: not (ra.resource_list_member_id in (0,pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id))) or

Line 9039: from pa_resource_assignments ra

9035: ra.task_id = t.task_id and t.parent_task_id = p_task_id);
9036: */
9037: select 1 from dual where exists (
9038: select ra.task_id
9039: from pa_resource_assignments ra
9040: where ra.budget_version_id in(p_budget_version_id1, p_budget_version_id2) and
9041: (
9042: (ra.task_id=p_task_id and
9043: not (ra.resource_list_member_id in