DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_BUDGETARY_CONTROLS

Line 245: g_fclc_project_id pa_budgetary_controls.project_id%type := null;

241: ------- end of performance varibales declrartions
242:
243: --Bug 5964934
244: g_fclc_budget_version_id pa_budget_versions.budget_version_id%type := null;
245: g_fclc_project_id pa_budgetary_controls.project_id%type := null;
246: g_fclc_top_task_id pa_budgetary_controls.top_task_id%type := null;
247: g_fclc_task_id pa_budgetary_controls.task_id%type := null;
248: g_fclc_parent_member_id pa_budgetary_controls.parent_member_id%type := null;
249: g_fclc_resource_list_member_id pa_budgetary_controls.resource_list_member_id%type := null;

Line 246: g_fclc_top_task_id pa_budgetary_controls.top_task_id%type := null;

242:
243: --Bug 5964934
244: g_fclc_budget_version_id pa_budget_versions.budget_version_id%type := null;
245: g_fclc_project_id pa_budgetary_controls.project_id%type := null;
246: g_fclc_top_task_id pa_budgetary_controls.top_task_id%type := null;
247: g_fclc_task_id pa_budgetary_controls.task_id%type := null;
248: g_fclc_parent_member_id pa_budgetary_controls.parent_member_id%type := null;
249: g_fclc_resource_list_member_id pa_budgetary_controls.resource_list_member_id%type := null;
250: g_p_funds_control_level_code varchar2(1) := null;

Line 247: g_fclc_task_id pa_budgetary_controls.task_id%type := null;

243: --Bug 5964934
244: g_fclc_budget_version_id pa_budget_versions.budget_version_id%type := null;
245: g_fclc_project_id pa_budgetary_controls.project_id%type := null;
246: g_fclc_top_task_id pa_budgetary_controls.top_task_id%type := null;
247: g_fclc_task_id pa_budgetary_controls.task_id%type := null;
248: g_fclc_parent_member_id pa_budgetary_controls.parent_member_id%type := null;
249: g_fclc_resource_list_member_id pa_budgetary_controls.resource_list_member_id%type := null;
250: g_p_funds_control_level_code varchar2(1) := null;
251: g_tt_funds_control_level_code varchar2(1) := null;

Line 248: g_fclc_parent_member_id pa_budgetary_controls.parent_member_id%type := null;

244: g_fclc_budget_version_id pa_budget_versions.budget_version_id%type := null;
245: g_fclc_project_id pa_budgetary_controls.project_id%type := null;
246: g_fclc_top_task_id pa_budgetary_controls.top_task_id%type := null;
247: g_fclc_task_id pa_budgetary_controls.task_id%type := null;
248: g_fclc_parent_member_id pa_budgetary_controls.parent_member_id%type := null;
249: g_fclc_resource_list_member_id pa_budgetary_controls.resource_list_member_id%type := null;
250: g_p_funds_control_level_code varchar2(1) := null;
251: g_tt_funds_control_level_code varchar2(1) := null;
252: g_t_funds_control_level_code varchar2(1) := null;

Line 249: g_fclc_resource_list_member_id pa_budgetary_controls.resource_list_member_id%type := null;

245: g_fclc_project_id pa_budgetary_controls.project_id%type := null;
246: g_fclc_top_task_id pa_budgetary_controls.top_task_id%type := null;
247: g_fclc_task_id pa_budgetary_controls.task_id%type := null;
248: g_fclc_parent_member_id pa_budgetary_controls.parent_member_id%type := null;
249: g_fclc_resource_list_member_id pa_budgetary_controls.resource_list_member_id%type := null;
250: g_p_funds_control_level_code varchar2(1) := null;
251: g_tt_funds_control_level_code varchar2(1) := null;
252: g_t_funds_control_level_code varchar2(1) := null;
253: g_rg_funds_control_level_code varchar2(1) := null;

Line 6724: FROM pa_budgetary_controls pbc

6720: l_p_funds_control_level_code VARCHAR2 ( 1 );
6721:
6722: CURSOR res_fcl IS
6723: SELECT funds_control_level_code
6724: FROM pa_budgetary_controls pbc
6725: ,pa_budget_versions bv
6726: WHERE bv.budget_version_id = p_budget_version_id
6727: AND bv.project_id = pbc.project_id
6728: AND bv.budget_type_code = pbc.budget_type_code

Line 6742: FROM pa_budgetary_controls pbc

6738:
6739:
6740: CURSOR res_grp_fcl IS
6741: SELECT funds_control_level_code
6742: FROM pa_budgetary_controls pbc
6743: ,pa_budget_versions bv
6744: WHERE bv.budget_version_id = p_budget_version_id
6745: AND bv.project_id = pbc.project_id
6746: AND bv.budget_type_code = pbc.budget_type_code

Line 6756: FROM pa_budgetary_controls pbc

6752: /* Bug fix: 2658952 AND NVL(pbc.parent_member_id,0) = 0; */
6753:
6754: CURSOR task_fcl IS
6755: SELECT funds_control_level_code
6756: FROM pa_budgetary_controls pbc
6757: ,pa_budget_versions bv
6758: WHERE bv.budget_version_id = p_budget_version_id
6759: AND bv.project_id = pbc.project_id
6760: AND bv.budget_type_code = pbc.budget_type_code

Line 6769: FROM pa_budgetary_controls pbc

6765: AND NVL(pbc.resource_list_member_id,0) = 0;
6766:
6767: CURSOR top_task_fcl IS
6768: SELECT funds_control_level_code
6769: FROM pa_budgetary_controls pbc
6770: ,pa_budget_versions bv
6771: WHERE bv.budget_version_id = p_budget_version_id
6772: AND bv.project_id = pbc.project_id
6773: AND bv.budget_type_code = pbc.budget_type_code

Line 6782: FROM pa_budgetary_controls pbc

6778: AND NVL(pbc.resource_list_member_id,0) = 0;
6779:
6780: CURSOR project_fcl IS
6781: SELECT funds_control_level_code
6782: FROM pa_budgetary_controls pbc
6783: ,pa_budget_versions bv
6784: WHERE bv.budget_version_id = p_budget_version_id
6785: AND bv.project_id = pbc.project_id
6786: AND bv.budget_type_code = pbc.budget_type_code