DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_BUDGETARY_CONTROLS

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

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

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

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

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

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

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

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

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

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

Line 6891: FROM pa_budgetary_controls pbc

6887: l_p_funds_control_level_code VARCHAR2 ( 1 );
6888:
6889: CURSOR res_fcl IS
6890: SELECT funds_control_level_code
6891: FROM pa_budgetary_controls pbc
6892: ,pa_budget_versions bv
6893: WHERE bv.budget_version_id = p_budget_version_id
6894: AND bv.project_id = pbc.project_id
6895: AND bv.budget_type_code = pbc.budget_type_code

Line 6909: FROM pa_budgetary_controls pbc

6905:
6906:
6907: CURSOR res_grp_fcl IS
6908: SELECT funds_control_level_code
6909: FROM pa_budgetary_controls pbc
6910: ,pa_budget_versions bv
6911: WHERE bv.budget_version_id = p_budget_version_id
6912: AND bv.project_id = pbc.project_id
6913: AND bv.budget_type_code = pbc.budget_type_code

Line 6923: FROM pa_budgetary_controls pbc

6919: /* Bug fix: 2658952 AND NVL(pbc.parent_member_id,0) = 0; */
6920:
6921: CURSOR task_fcl IS
6922: SELECT funds_control_level_code
6923: FROM pa_budgetary_controls pbc
6924: ,pa_budget_versions bv
6925: WHERE bv.budget_version_id = p_budget_version_id
6926: AND bv.project_id = pbc.project_id
6927: AND bv.budget_type_code = pbc.budget_type_code

Line 6936: FROM pa_budgetary_controls pbc

6932: AND NVL(pbc.resource_list_member_id,0) = 0;
6933:
6934: CURSOR top_task_fcl IS
6935: SELECT funds_control_level_code
6936: FROM pa_budgetary_controls pbc
6937: ,pa_budget_versions bv
6938: WHERE bv.budget_version_id = p_budget_version_id
6939: AND bv.project_id = pbc.project_id
6940: AND bv.budget_type_code = pbc.budget_type_code

Line 6949: FROM pa_budgetary_controls pbc

6945: AND NVL(pbc.resource_list_member_id,0) = 0;
6946:
6947: CURSOR project_fcl IS
6948: SELECT funds_control_level_code
6949: FROM pa_budgetary_controls pbc
6950: ,pa_budget_versions bv
6951: WHERE bv.budget_version_id = p_budget_version_id
6952: AND bv.project_id = pbc.project_id
6953: AND bv.budget_type_code = pbc.budget_type_code