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_LISTS

Line 140: l_uncat_resource_list_id pa_resource_lists.resource_list_id%TYPE;

136: l_display_margin VARCHAR2(1);
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:

Line 1069: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

1065: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1066: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1067: l_rv_number pa_budget_versions.record_version_number%TYPE;
1068: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
1069: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1070: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1071:
1072: l_is_cost_locked_by_user VARCHAR2(1);
1073: l_is_rev_locked_by_user VARCHAR2(1);

Line 1070: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

1066: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1067: l_rv_number pa_budget_versions.record_version_number%TYPE;
1068: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
1069: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1070: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1071:
1072: l_is_cost_locked_by_user VARCHAR2(1);
1073: l_is_rev_locked_by_user VARCHAR2(1);
1074: l_cost_locked_by_person_id NUMBER;

Line 1081: l_uncat_resource_list_id pa_resource_lists.resource_list_id%TYPE;

1077: l_ci_row_index NUMBER := 0;
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:

Line 1159: pa_resource_lists_all_bg rl

1155: l_ac_flag,
1156: l_ar_flag,
1157: l_uncategorized_flag
1158: from pa_budget_versions bv,
1159: pa_resource_lists_all_bg rl
1160: where bv.budget_version_id = ci_rec.budget_version_id and
1161: bv.resource_list_id = rl.resource_list_id;
1162:
1163: -- >>>> BUG FIX 2650878: project or projfunc, depending on AR flag <<<<

Line 1291: pa_resource_lists_all_bg rl

1287: l_compl_resource_list_id,
1288: l_compl_rv_number,
1289: l_compl_uncategorized_flag
1290: from pa_budget_versions bv,
1291: pa_resource_lists_all_bg rl
1292: where bv.budget_version_id = ci_rec.budget_version_id and
1293: bv.resource_list_id = rl.resource_list_id;
1294: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := l_ci_budget_version_id;
1295: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := ci_rec.budget_version_id;

Line 1353: pa_resource_lists_all_bg rl

1349: l_compl_resource_list_id,
1350: l_compl_rv_number,
1351: l_compl_uncategorized_flag
1352: from pa_budget_versions bv,
1353: pa_resource_lists_all_bg rl
1354: where bv.budget_version_id = ci_rec.budget_version_id and
1355: bv.resource_list_id = rl.resource_list_id;
1356: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := ci_rec.budget_version_id;
1357: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := l_ci_budget_version_id;

Line 1416: pa_resource_lists_all_bg rl

1412: l_compl_resource_list_id,
1413: l_compl_rv_number,
1414: l_compl_uncategorized_flag
1415: from pa_budget_versions bv,
1416: pa_resource_lists_all_bg rl
1417: where bv.budget_version_id = ci_rec.budget_version_id and
1418: bv.resource_list_id = rl.resource_list_id;
1419: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := ci_rec.budget_version_id;
1420: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := l_ci_budget_version_id;

Line 1478: pa_resource_lists_all_bg rl

1474: l_compl_resource_list_id,
1475: l_compl_rv_number,
1476: l_compl_uncategorized_flag
1477: from pa_budget_versions bv,
1478: pa_resource_lists_all_bg rl
1479: where bv.budget_version_id = ci_rec.budget_version_id and
1480: bv.resource_list_id = rl.resource_list_id;
1481: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := l_ci_budget_version_id;
1482: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := ci_rec.budget_version_id;