APPS.PA_BUDGETARY_CONTROLS_PKG dependencies on PA_RESOURCE_LIST_MEMBERS

Line 9: ,x_parent_member_id IN PA_RESOURCE_LIST_MEMBERS.PARENT_MEMBER_ID%type

5: ,x_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type
6: ,x_funds_control_level_code IN PA_BUDGETARY_CONTROLS.FUNDS_CONTROL_LEVEL_CODE%type
7: ,x_top_task_id IN PA_TASKS.TASK_ID%type
8: ,x_task_id IN PA_TASKS.TASK_ID%type
9: ,x_parent_member_id IN PA_RESOURCE_LIST_MEMBERS.PARENT_MEMBER_ID%type
10: ,x_resource_list_member_id IN PA_RESOURCE_LIST_MEMBERS.resource_list_member_id%type
11: ,x_return_status OUT NOCOPY VARCHAR2
12: ,x_msg_count OUT NOCOPY NUMBER
13: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS

Line 10: ,x_resource_list_member_id IN PA_RESOURCE_LIST_MEMBERS.resource_list_member_id%type

6: ,x_funds_control_level_code IN PA_BUDGETARY_CONTROLS.FUNDS_CONTROL_LEVEL_CODE%type
7: ,x_top_task_id IN PA_TASKS.TASK_ID%type
8: ,x_task_id IN PA_TASKS.TASK_ID%type
9: ,x_parent_member_id IN PA_RESOURCE_LIST_MEMBERS.PARENT_MEMBER_ID%type
10: ,x_resource_list_member_id IN PA_RESOURCE_LIST_MEMBERS.resource_list_member_id%type
11: ,x_return_status OUT NOCOPY VARCHAR2
12: ,x_msg_count OUT NOCOPY NUMBER
13: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS
14:

Line 146: ,x_resource_list_id IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%type

142: PROCEDURE create_bc_levels
143: (x_project_id IN PA_PROJECTS_ALL.PROJECT_ID%type
144: ,x_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type
145: ,x_entry_level_code IN PA_BUDGET_ENTRY_METHODS.ENTRY_LEVEL_CODE%type
146: ,x_resource_list_id IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%type
147: ,x_group_resource_type_id IN PA_RESOURCE_LISTS_ALL_BG.GROUP_RESOURCE_TYPE_ID%type
148: ,x_calling_mode IN VARCHAR2
149: ,x_return_status OUT NOCOPY VARCHAR2
150: ,x_msg_count OUT NOCOPY NUMBER

Line 206: FROM PA_RESOURCE_LIST_MEMBERS br

202: 0,decode(v_funds_control_level_res,'D',nvl(funds_control_level_code,'N'),v_funds_control_level_res),
203: decode(v_funds_control_level_res_grp,'D',nvl(funds_control_level_code,'N'),v_funds_control_level_res_grp)),
204: decode(v_funds_control_level_res,'D',nvl(funds_control_level_code,'N'),v_funds_control_level_res)
205: ) funds_control_level
206: FROM PA_RESOURCE_LIST_MEMBERS br
207: WHERE br.ENABLED_FLAG = 'Y'
208: AND br.RESOURCE_LIST_ID = x_resource_list_id
209: AND DECODE(br.RESOURCE_TYPE_CODE, 'UNCLASSIFIED', 'Y', DISPLAY_FLAG) = 'Y'
210: and nvl(br.migration_code, 'M') = 'M'

Line 227: FROM PA_RESOURCE_LIST_MEMBERS br

223: 0,decode(v_funds_control_level_res,'D',nvl(funds_control_level_code,'N'),v_funds_control_level_res),
224: decode(v_funds_control_level_res_grp,'D',nvl(funds_control_level_code,'N'),v_funds_control_level_res_grp)),
225: decode(v_funds_control_level_res,'D',nvl(funds_control_level_code,'N'),v_funds_control_level_res)
226: ) funds_control_level
227: FROM PA_RESOURCE_LIST_MEMBERS br
228: WHERE br.ENABLED_FLAG = 'Y'
229: AND br.RESOURCE_LIST_ID = x_resource_list_id
230: AND DECODE(br.RESOURCE_TYPE_CODE, 'UNCLASSIFIED', 'Y', DISPLAY_FLAG) = 'Y'
231: and nvl(br.migration_code, 'M') = 'M';

Line 732: ,x_resource_list_id IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%type

728: PROCEDURE budg_control_reset
729: (x_project_id IN PA_PROJECTS_ALL.PROJECT_ID%type
730: ,x_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type
731: ,x_entry_level_code IN PA_BUDGET_ENTRY_METHODS.ENTRY_LEVEL_CODE%type
732: ,x_resource_list_id IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_ID%type
733: ,x_group_resource_type_id IN PA_RESOURCE_LISTS_ALL_BG.GROUP_RESOURCE_TYPE_ID%type
734: ,x_calling_mode IN VARCHAR2
735: ,x_return_status OUT NOCOPY VARCHAR2
736: ,x_msg_count OUT NOCOPY NUMBER