1: package pa_plan_res_defaults_pub AUTHID CURRENT_USER as
2: /* $Header: PARPRDPS.pls 120.0 2005/06/03 13:34:32 appldev noship $ */
3:
4: procedure UPDATE_RESOURCE_DEFAULTS (
5: P_PLAN_RES_DEF_ID_TBL IN system.pa_num_tbl_type ,
6: P_RESOURCE_CLASS_ID_TBL IN system.pa_num_tbl_type ,
7: P_OBJECT_TYPE_TBL IN system.pa_varchar2_30_tbl_type ,
8: P_OBJECT_ID_TBL IN system.pa_num_tbl_type ,
9: P_SPREAD_CURVE_ID_TBL IN system.pa_num_tbl_type ,
2: /* $Header: PARPRDPS.pls 120.0 2005/06/03 13:34:32 appldev noship $ */
3:
4: procedure UPDATE_RESOURCE_DEFAULTS (
5: P_PLAN_RES_DEF_ID_TBL IN system.pa_num_tbl_type ,
6: P_RESOURCE_CLASS_ID_TBL IN system.pa_num_tbl_type ,
7: P_OBJECT_TYPE_TBL IN system.pa_varchar2_30_tbl_type ,
8: P_OBJECT_ID_TBL IN system.pa_num_tbl_type ,
9: P_SPREAD_CURVE_ID_TBL IN system.pa_num_tbl_type ,
10: P_ETC_METHOD_CODE_TBL IN system.pa_varchar2_30_tbl_type ,
4: procedure UPDATE_RESOURCE_DEFAULTS (
5: P_PLAN_RES_DEF_ID_TBL IN system.pa_num_tbl_type ,
6: P_RESOURCE_CLASS_ID_TBL IN system.pa_num_tbl_type ,
7: P_OBJECT_TYPE_TBL IN system.pa_varchar2_30_tbl_type ,
8: P_OBJECT_ID_TBL IN system.pa_num_tbl_type ,
9: P_SPREAD_CURVE_ID_TBL IN system.pa_num_tbl_type ,
10: P_ETC_METHOD_CODE_TBL IN system.pa_varchar2_30_tbl_type ,
11: P_EXPENDITURE_TYPE_TBL IN system.pa_varchar2_30_tbl_type ,
12: P_ITEM_CATEGORY_SET_ID_TBL IN system.pa_num_tbl_type ,
5: P_PLAN_RES_DEF_ID_TBL IN system.pa_num_tbl_type ,
6: P_RESOURCE_CLASS_ID_TBL IN system.pa_num_tbl_type ,
7: P_OBJECT_TYPE_TBL IN system.pa_varchar2_30_tbl_type ,
8: P_OBJECT_ID_TBL IN system.pa_num_tbl_type ,
9: P_SPREAD_CURVE_ID_TBL IN system.pa_num_tbl_type ,
10: P_ETC_METHOD_CODE_TBL IN system.pa_varchar2_30_tbl_type ,
11: P_EXPENDITURE_TYPE_TBL IN system.pa_varchar2_30_tbl_type ,
12: P_ITEM_CATEGORY_SET_ID_TBL IN system.pa_num_tbl_type ,
13: P_ITEM_MASTER_ID_TBL IN system.pa_num_tbl_type ,
8: P_OBJECT_ID_TBL IN system.pa_num_tbl_type ,
9: P_SPREAD_CURVE_ID_TBL IN system.pa_num_tbl_type ,
10: P_ETC_METHOD_CODE_TBL IN system.pa_varchar2_30_tbl_type ,
11: P_EXPENDITURE_TYPE_TBL IN system.pa_varchar2_30_tbl_type ,
12: P_ITEM_CATEGORY_SET_ID_TBL IN system.pa_num_tbl_type ,
13: P_ITEM_MASTER_ID_TBL IN system.pa_num_tbl_type ,
14: P_MFC_COST_TYPE_ID_TBL IN system.pa_num_tbl_type ,
15: P_ENABLED_FLAG_TBL IN system.pa_varchar2_1_tbl_type ,
16: X_RECORD_VERSION_NUMBER_TBL IN OUT NOCOPY system.pa_num_tbl_type ,
9: P_SPREAD_CURVE_ID_TBL IN system.pa_num_tbl_type ,
10: P_ETC_METHOD_CODE_TBL IN system.pa_varchar2_30_tbl_type ,
11: P_EXPENDITURE_TYPE_TBL IN system.pa_varchar2_30_tbl_type ,
12: P_ITEM_CATEGORY_SET_ID_TBL IN system.pa_num_tbl_type ,
13: P_ITEM_MASTER_ID_TBL IN system.pa_num_tbl_type ,
14: P_MFC_COST_TYPE_ID_TBL IN system.pa_num_tbl_type ,
15: P_ENABLED_FLAG_TBL IN system.pa_varchar2_1_tbl_type ,
16: X_RECORD_VERSION_NUMBER_TBL IN OUT NOCOPY system.pa_num_tbl_type ,
17: x_return_status OUT NOCOPY VARCHAR2,
10: P_ETC_METHOD_CODE_TBL IN system.pa_varchar2_30_tbl_type ,
11: P_EXPENDITURE_TYPE_TBL IN system.pa_varchar2_30_tbl_type ,
12: P_ITEM_CATEGORY_SET_ID_TBL IN system.pa_num_tbl_type ,
13: P_ITEM_MASTER_ID_TBL IN system.pa_num_tbl_type ,
14: P_MFC_COST_TYPE_ID_TBL IN system.pa_num_tbl_type ,
15: P_ENABLED_FLAG_TBL IN system.pa_varchar2_1_tbl_type ,
16: X_RECORD_VERSION_NUMBER_TBL IN OUT NOCOPY system.pa_num_tbl_type ,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
12: P_ITEM_CATEGORY_SET_ID_TBL IN system.pa_num_tbl_type ,
13: P_ITEM_MASTER_ID_TBL IN system.pa_num_tbl_type ,
14: P_MFC_COST_TYPE_ID_TBL IN system.pa_num_tbl_type ,
15: P_ENABLED_FLAG_TBL IN system.pa_varchar2_1_tbl_type ,
16: X_RECORD_VERSION_NUMBER_TBL IN OUT NOCOPY system.pa_num_tbl_type ,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2
20: ) ;