DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_BUDGETARY_CONTROL_OPTIONS

Line 383: g_Tfund_control_level pa_budgetary_control_options.fund_control_level_task%type;

379: g_tab_exp_pa_date pa_plsql_datatypes.DateTabTyp; /*9487097 */
380: g_tab_exp_item_id pa_plsql_datatypes.Idtabtyp;
381:
382: /* Bug 5631763 */
383: g_Tfund_control_level pa_budgetary_control_options.fund_control_level_task%type;
384: g_Pfund_control_level pa_budgetary_control_options.fund_control_level_project%type;
385: g_RGfund_control_level pa_budgetary_control_options.fund_control_level_res_grp%type;
386: g_Rfund_control_level pa_budgetary_control_options.fund_control_level_res%type;
387: /* Bug 5631763 */

Line 384: g_Pfund_control_level pa_budgetary_control_options.fund_control_level_project%type;

380: g_tab_exp_item_id pa_plsql_datatypes.Idtabtyp;
381:
382: /* Bug 5631763 */
383: g_Tfund_control_level pa_budgetary_control_options.fund_control_level_task%type;
384: g_Pfund_control_level pa_budgetary_control_options.fund_control_level_project%type;
385: g_RGfund_control_level pa_budgetary_control_options.fund_control_level_res_grp%type;
386: g_Rfund_control_level pa_budgetary_control_options.fund_control_level_res%type;
387: /* Bug 5631763 */
388:

Line 385: g_RGfund_control_level pa_budgetary_control_options.fund_control_level_res_grp%type;

381:
382: /* Bug 5631763 */
383: g_Tfund_control_level pa_budgetary_control_options.fund_control_level_task%type;
384: g_Pfund_control_level pa_budgetary_control_options.fund_control_level_project%type;
385: g_RGfund_control_level pa_budgetary_control_options.fund_control_level_res_grp%type;
386: g_Rfund_control_level pa_budgetary_control_options.fund_control_level_res%type;
387: /* Bug 5631763 */
388:
389: -- Added for R12 ...

Line 386: g_Rfund_control_level pa_budgetary_control_options.fund_control_level_res%type;

382: /* Bug 5631763 */
383: g_Tfund_control_level pa_budgetary_control_options.fund_control_level_task%type;
384: g_Pfund_control_level pa_budgetary_control_options.fund_control_level_project%type;
385: g_RGfund_control_level pa_budgetary_control_options.fund_control_level_res_grp%type;
386: g_Rfund_control_level pa_budgetary_control_options.fund_control_level_res%type;
387: /* Bug 5631763 */
388:
389: -- Added for R12 ...
390: g_tab_burden_method_code pa_plsql_datatypes.char50TabTyp;

Line 6033: pa_budgetary_control_options pb,

6029: FROM
6030: pa_bc_packets pbc,
6031: pa_budget_versions pbv,
6032: pa_budget_entry_methods pm,
6033: pa_budgetary_control_options pb,
6034: pa_projects_all pp,
6035: pa_resource_list_members rlm,
6036: PA_RESOURCE_LISTS_ALL_BG list
6037: WHERE pbc.packet_id = p_packet_id

Line 6961: are defaulted from those defined in pa_budgetary_control_options. If the funds control defined

6957: AND decode(pbc.parent_member_id,0,-1,NVL(pbc.parent_member_id,-1)) = -1
6958: AND NVL(pbc.resource_list_member_id,0) = 0;
6959:
6960: /* Bug 5631763 : If there exists no BC records for the resource group/resource then the funds control levels
6961: are defaulted from those defined in pa_budgetary_control_options. If the funds control defined
6962: in pa_budgetary_control_options for the resource group/resource is "Default from Resource List"
6963: then the funds control levels are derived appropriately from the resource list. */
6964: CURSOR c_res_resgrp_no_bc (c_resource_list_member_id NUMBER) IS
6965: select nvl(rlm.funds_control_level_code,'N')

Line 6962: in pa_budgetary_control_options for the resource group/resource is "Default from Resource List"

6958: AND NVL(pbc.resource_list_member_id,0) = 0;
6959:
6960: /* Bug 5631763 : If there exists no BC records for the resource group/resource then the funds control levels
6961: are defaulted from those defined in pa_budgetary_control_options. If the funds control defined
6962: in pa_budgetary_control_options for the resource group/resource is "Default from Resource List"
6963: then the funds control levels are derived appropriately from the resource list. */
6964: CURSOR c_res_resgrp_no_bc (c_resource_list_member_id NUMBER) IS
6965: select nvl(rlm.funds_control_level_code,'N')
6966: from PA_RESOURCE_LIST_MEMBERS rlm

Line 8342: pa_budgetary_control_options pb

8338: pbc.budget_ccid
8339: FROM pa_bc_packets pbc,
8340: pa_budget_versions bv,
8341: pa_budget_entry_methods pm,
8342: pa_budgetary_control_options pb
8343: WHERE pbc.packet_id = p_packet_id
8344: AND pbc.budget_version_id = bv.budget_version_id
8345: AND bv.budget_entry_method_code = pm.budget_entry_method_code
8346: AND pbc.status_code in ('P','L')

Line 8377: from pa_budgetary_control_options pb,

8373: select fund_control_level_project,
8374: fund_control_level_task ,
8375: fund_control_level_res_grp,
8376: fund_control_level_res
8377: from pa_budgetary_control_options pb,
8378: pa_budget_versions pv
8379: where pv.project_id = pb.project_id
8380: AND pb.BDGT_CNTRL_FLAG = 'Y'
8381: AND pb.BUDGET_TYPE_CODE = pv.budget_type_code