[Home] [Help]
1687:
1688: Cursor c_disabled_resource_exists IS
1689: select 1 from dual
1690: where exists (select prlm.resource_list_member_id
1691: from pa_resource_list_members prlm, pa_resource_assignments pra, pa_fp_rollup_tmp tmp
1692: where pra.resource_assignment_id = p_resource_assignment_id
1693: and pra.resource_list_member_id= prlm.resource_list_member_id
1694: and nvl(prlm.enabled_flag,'Y') = 'N'
1695: and tmp.resource_assignment_id = pra.resource_assignment_id
2745: PROCEDURE CALL_CLIENT_EXTENSIONS
2746: ( p_project_id IN pa_projects_all.PROJECT_ID%TYPE
2747: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
2748: ,p_task_id IN pa_tasks.TASK_ID%TYPE
2749: ,p_resource_list_member_id IN pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE
2750: ,p_resource_list_id IN pa_resource_lists.RESOURCE_LIST_ID%TYPE
2751: ,p_resource_id IN pa_resources.RESOURCE_ID%TYPE
2752: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
2753: ,p_product_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
3907: AND pra.budget_version_id = pbv.budget_version_id ;
3908:
3909: l_res_assignment_details_rec l_res_assignment_details_csr%ROWTYPE;
3910:
3911: l_resource_alias pa_resource_list_members.alias%TYPE;
3912: l_segment1 pa_projects_all.segment1%TYPE;
3913: l_task_number pa_tasks.task_number%TYPE;
3914: l_debug_level3 CONSTANT NUMBER := 3;
3915: l_debug_level5 CONSTANT NUMBER := 5;
3954: 25);
3955:
3956: SELECT alias
3957: INTO l_resource_alias
3958: FROM pa_resource_list_members
3959: WHERE resource_list_member_id = l_res_assignment_details_rec.resource_list_member_id;
3960:
3961: IF l_debug_mode = 'Y' THEN
3962: pa_debug.g_err_stage:= 'Got the resource alias';