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 146: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%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:
148: BEGIN
149: --hr_utility.trace_on(null, 'dlai');
150: --hr_utility.trace('STARTING');

Line 718: pa_resource_lists_all_bg rl

714: -- they are dummy ids for internal tracking and this is causing showing of data in twice at lowest level.
715: SELECT NVL(rl.uncategorized_flag, 'N')
716: INTO l_uncategorized_flag
717: FROM pa_budget_versions bv,
718: pa_resource_lists_all_bg rl
719: WHERE bv.budget_version_id = p_orgfcst_version_id AND
720: bv.resource_list_id = rl.resource_list_id;
721:
722:

Line 1165: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

1161: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1162: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1163: l_rv_number pa_budget_versions.record_version_number%TYPE;
1164: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
1165: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1166: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1167:
1168: l_is_cost_locked_by_user VARCHAR2(1);
1169: l_is_rev_locked_by_user VARCHAR2(1);

Line 1166: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

1162: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1163: l_rv_number pa_budget_versions.record_version_number%TYPE;
1164: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
1165: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1166: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
1167:
1168: l_is_cost_locked_by_user VARCHAR2(1);
1169: l_is_rev_locked_by_user VARCHAR2(1);
1170: l_cost_locked_by_person_id NUMBER;

Line 1177: l_uncat_resource_list_id pa_resource_lists.resource_list_id%TYPE;

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

Line 1255: pa_resource_lists_all_bg rl

1251: l_ac_flag,
1252: l_ar_flag,
1253: l_uncategorized_flag
1254: from pa_budget_versions bv,
1255: pa_resource_lists_all_bg rl
1256: where bv.budget_version_id = ci_rec.budget_version_id and
1257: bv.resource_list_id = rl.resource_list_id;
1258:
1259: -- >>>> BUG FIX 2650878: project or projfunc, depending on AR flag <<<<

Line 1387: pa_resource_lists_all_bg rl

1383: l_compl_resource_list_id,
1384: l_compl_rv_number,
1385: l_compl_uncategorized_flag
1386: from pa_budget_versions bv,
1387: pa_resource_lists_all_bg rl
1388: where bv.budget_version_id = ci_rec.budget_version_id and
1389: bv.resource_list_id = rl.resource_list_id;
1390: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := l_ci_budget_version_id;
1391: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := ci_rec.budget_version_id;

Line 1449: pa_resource_lists_all_bg rl

1445: l_compl_resource_list_id,
1446: l_compl_rv_number,
1447: l_compl_uncategorized_flag
1448: from pa_budget_versions bv,
1449: pa_resource_lists_all_bg rl
1450: where bv.budget_version_id = ci_rec.budget_version_id and
1451: bv.resource_list_id = rl.resource_list_id;
1452: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := ci_rec.budget_version_id;
1453: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := l_ci_budget_version_id;

Line 1512: pa_resource_lists_all_bg rl

1508: l_compl_resource_list_id,
1509: l_compl_rv_number,
1510: l_compl_uncategorized_flag
1511: from pa_budget_versions bv,
1512: pa_resource_lists_all_bg rl
1513: where bv.budget_version_id = ci_rec.budget_version_id and
1514: bv.resource_list_id = rl.resource_list_id;
1515: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := ci_rec.budget_version_id;
1516: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := l_ci_budget_version_id;

Line 1574: pa_resource_lists_all_bg rl

1570: l_compl_resource_list_id,
1571: l_compl_rv_number,
1572: l_compl_uncategorized_flag
1573: from pa_budget_versions bv,
1574: pa_resource_lists_all_bg rl
1575: where bv.budget_version_id = ci_rec.budget_version_id and
1576: bv.resource_list_id = rl.resource_list_id;
1577: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := l_ci_budget_version_id;
1578: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := ci_rec.budget_version_id;