DBA Data[Home] [Help]

APPS.PA_BUDGETARY_CONTROLS_PKG dependencies on PA_BUDGET_TYPES

Line 5: ,x_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type

1: PACKAGE BODY PA_BUDGETARY_CONTROLS_PKG AS
2: -- $Header: PAXBCCRB.pls 120.2 2006/04/18 05:22:08 cmishra noship $
3: PROCEDURE insert_rows
4: (x_project_id IN PA_PROJECTS_ALL.PROJECT_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

Line 92: ,p_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type )

88: during budgetary control reset. */
89:
90: PROCEDURE del_bc_rec_for_reset_auto
91: (p_project_id IN NUMBER
92: ,p_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type )
93: IS
94: PRAGMA AUTONOMOUS_TRANSACTION;
95: BEGIN
96:

Line 114: ,p_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type

110: all the dangling records from budgetary controls. */
111:
112: PROCEDURE del_bc_rec_for_task_auto
113: (p_project_id IN NUMBER
114: ,p_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type
115: ,p_entry_level_code IN PA_BUDGET_ENTRY_METHODS.ENTRY_LEVEL_CODE%type)
116: IS
117: PRAGMA AUTONOMOUS_TRANSACTION;
118: BEGIN

Line 144: ,x_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type

140:
141:
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

Line 730: ,x_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type

726:
727:
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

Line 851: ,x_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type

847:
848:
849: FUNCTION budget_ctrl_exists
850: (x_project_id IN PA_PROJECTS_ALL.PROJECT_ID%type
851: ,x_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type
852: )
853: return varchar2 is
854:
855:

Line 977: l_budget_type_code PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type;

973: ( x_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%type)
974: return varchar2 is
975:
976: l_project_id PA_PROJECTS_ALL.PROJECT_ID%type;
977: l_budget_type_code PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type;
978: l_return_status VARCHAR2(10);
979: l_msg_count NUMBER(15);
980: l_msg_data VARCHAR2(2000);
981: