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_TXN_PUB dependencies on PA_RESOURCE_LISTS

Line 194: -- check pa_resource_lists.uncategorized_flag

190: /* ------------------------------------------------------------- */
191:
192: /* ---------------------- CHANGE HISTORY ----------------------- */
193: -- 10/08/02: x_planned_resources_flag:
194: -- check pa_resource_lists.uncategorized_flag
195: -- 10/10/02: for x_display_from, query PLAN_TYPE planning options
196: -- 10/28/02: make sure resource list global variables are populated
197: -- for resource query to work
198: -- 10/31/02: queries for compl version should make sure ci_id is null

Line 263: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

259: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
260: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
261: l_rv_number pa_budget_versions.record_version_number%TYPE;
262: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
263: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
264: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
265: l_debug_mode VARCHAR2(30);
266: l_is_cost_locked_by_user VARCHAR2(1);
267: l_is_rev_locked_by_user VARCHAR2(1);

Line 264: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

260: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
261: l_rv_number pa_budget_versions.record_version_number%TYPE;
262: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
263: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
264: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
265: l_debug_mode VARCHAR2(30);
266: l_is_cost_locked_by_user VARCHAR2(1);
267: l_is_rev_locked_by_user VARCHAR2(1);
268: l_cost_locked_by_person_id NUMBER;

Line 419: pa_resource_lists_all_bg rl

415: l_rv_number,
416: l_uncategorized_flag,
417: l_c_budget_status_code
418: FROM pa_budget_versions bv,
419: pa_resource_lists_all_bg rl
420: WHERE bv.budget_version_id = p_cost_version_id and
421: bv.resource_list_id = rl.resource_list_id;
422:
423:

Line 462: pa_resource_lists_all_bg rl

458: l_compl_rv_number,
459: l_compl_uncategorized_flag,
460: l_r_budget_status_code
461: FROM pa_budget_versions bv,
462: pa_resource_lists_all_bg rl
463: WHERE bv.budget_version_id = p_rev_version_id and
464: bv.resource_list_id = rl.resource_list_id;
465:
466:

Line 850: -- check pa_resource_lists.uncategorized_flag

846: /* ------------------------------------------------------------- */
847:
848: /* ---------------------- CHANGE HISTORY ----------------------- */
849: -- 10/08/02: x_planned_resources_flag:
850: -- check pa_resource_lists.uncategorized_flag
851: -- 10/28/02: make sure resource list global variables are populated
852: -- for resource query to work
853: -- 11/08/02: x_project_currency = project or projfunc currency, depending if
854: -- plan type = AR

Line 915: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

911: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
912: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
913: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
914: l_version_type pa_budget_versions.version_type%TYPE;
915: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
916: l_resource_level VARCHAR2(1); -- bug 2813661
917:
918: -- local debugging variables
919: l_return_status VARCHAR2(1);

Line 961: pa_resource_lists_all_bg rl

957: l_ac_flag,
958: l_ar_flag,
959: l_uncategorized_flag
960: from pa_budget_versions bv,
961: pa_resource_lists_all_bg rl
962: where bv.budget_version_id = p_budget_version_id and
963: bv.resource_list_id = rl.resource_list_id;
964: pa_fp_view_plans_txn_pub.G_SINGLE_VERSION_ID := p_budget_version_id;
965: -- >>>>> BUG FIX 2602849: need to check only AR flag <<<<<

Line 2430: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

2426: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2427: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2428: l_rv_number pa_budget_versions.record_version_number%TYPE;
2429: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
2430: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
2431: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
2432: l_agreement_id pa_agreements_all.agreement_id%TYPE; -- bug 2984679
2433: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE; -- bug 2984679
2434:

Line 2431: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

2427: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2428: l_rv_number pa_budget_versions.record_version_number%TYPE;
2429: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
2430: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
2431: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
2432: l_agreement_id pa_agreements_all.agreement_id%TYPE; -- bug 2984679
2433: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE; -- bug 2984679
2434:
2435: l_is_cost_locked_by_user VARCHAR2(1);

Line 2516: pa_resource_lists_all_bg rl

2512: l_ar_flag,
2513: l_uncategorized_flag,
2514: l_agreement_id
2515: from pa_budget_versions bv,
2516: pa_resource_lists_all_bg rl
2517: where bv.budget_version_id = ci_rec.budget_version_id and
2518: bv.resource_list_id = rl.resource_list_id;
2519:
2520: -- >>>> BUG FIX 2650878: project or projfunc, depending on AR flag <<<<

Line 2681: pa_resource_lists_all_bg rl

2677: l_compl_resource_list_id,
2678: l_compl_rv_number,
2679: l_compl_uncategorized_flag
2680: from pa_budget_versions bv,
2681: pa_resource_lists_all_bg rl
2682: where bv.budget_version_id = ci_rec.budget_version_id and
2683: bv.resource_list_id = rl.resource_list_id;
2684: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2685: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := ci_rec.budget_version_id;

Line 2739: pa_resource_lists_all_bg rl

2735: l_compl_resource_list_id,
2736: l_compl_rv_number,
2737: l_compl_uncategorized_flag
2738: from pa_budget_versions bv,
2739: pa_resource_lists_all_bg rl
2740: where bv.budget_version_id = ci_rec.budget_version_id and
2741: bv.resource_list_id = rl.resource_list_id;
2742: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := ci_rec.budget_version_id;
2743: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;

Line 2806: pa_resource_lists_all_bg rl

2802: l_compl_resource_list_id,
2803: l_compl_rv_number,
2804: l_compl_uncategorized_flag
2805: from pa_budget_versions bv,
2806: pa_resource_lists_all_bg rl
2807: where bv.budget_version_id = ci_rec.budget_version_id and
2808: bv.resource_list_id = rl.resource_list_id;
2809: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := ci_rec.budget_version_id;
2810: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := l_ci_budget_version_id;

Line 2872: pa_resource_lists_all_bg rl

2868: l_compl_resource_list_id,
2869: l_compl_rv_number,
2870: l_compl_uncategorized_flag
2871: from pa_budget_versions bv,
2872: pa_resource_lists_all_bg rl
2873: where bv.budget_version_id = ci_rec.budget_version_id and
2874: bv.resource_list_id = rl.resource_list_id;
2875: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;
2876: pa_fp_view_plans_txn_pub.G_REV_VERSION_ID := ci_rec.budget_version_id;

Line 3227: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE ;

3223:
3224: l_project_id pa_projects_all.project_id%TYPE ;
3225: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3226: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3227: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE ;
3228: l_resource_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3229: l_txn_currency_code_tbl SYSTEM.pa_varchar2_30_tbl_type ;
3230: l_product_code_tbl SYSTEM.pa_varchar2_30_tbl_type ;
3231: l_start_date_tbl SYSTEM.pa_date_tbl_type ;