1 package pa_plan_res_defaults_pvt AUTHID CURRENT_USER as
2 /* $Header: PARPRDVS.pls 120.1 2005/08/29 20:51:34 sunkalya noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY ROWID,
5 X_PLAN_RES_DEFAULT_ID in out NOCOPY NUMBER ,
6 P_RESOURCE_CLASS_ID in NUMBER ,
7 P_OBJECT_TYPE in VARCHAR2 ,
8 P_OBJECT_ID in NUMBER ,
9 P_SPREAD_CURVE_ID in NUMBER ,
10 P_ETC_METHOD_CODE in VARCHAR2 ,
11 P_EXPENDITURE_TYPE in VARCHAR2 ,
12 P_ITEM_CATEGORY_SET_ID in NUMBER ,
13 P_ITEM_MASTER_ID in NUMBER ,
14 P_MFC_COST_TYPE_ID in NUMBER ,
15 P_ENABLED_FLAG in VARCHAR2 ,
16 X_RECORD_VERSION_NUMBER in out NOCOPY NUMBER ,
17 P_CREATION_DATE in DATE ,
18 P_CREATED_BY in NUMBER ,
19 P_LAST_UPDATE_DATE in DATE ,
20 P_LAST_UPDATED_BY in NUMBER ,
21 P_LAST_UPDATE_LOGIN in NUMBER
22 ) ;
23
24 procedure LOCK_ROW (
25 P_PLAN_RES_DEFAULT_ID in NUMBER,
26 P_RECORD_VERSION_NUMBER in NUMBER
27 ) ;
28
29 procedure UPDATE_ROW (
30 P_PLAN_RES_DEFAULT_ID in NUMBER ,
31 P_RESOURCE_CLASS_ID in NUMBER ,
32 P_OBJECT_TYPE in VARCHAR2 ,
33 P_OBJECT_ID in NUMBER ,
34 P_SPREAD_CURVE_ID in NUMBER ,
35 P_ETC_METHOD_CODE in VARCHAR2 ,
36 P_EXPENDITURE_TYPE in VARCHAR2 ,
37 P_ITEM_CATEGORY_SET_ID in NUMBER ,
38 P_ITEM_MASTER_ID in NUMBER ,
39 P_MFC_COST_TYPE_ID in NUMBER ,
40 P_ENABLED_FLAG in VARCHAR2 ,
41 X_RECORD_VERSION_NUMBER in out NOCOPY NUMBER ,
42 P_LAST_UPDATE_DATE in DATE ,
43 P_LAST_UPDATED_BY in NUMBER ,
44 P_LAST_UPDATE_LOGIN in NUMBER ,
45 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --Bug: 4537865
46 X_MSG_DATA OUT NOCOPY VARCHAR2, --Bug: 4537865
47 X_MSG_COUNT OUT NOCOPY VARCHAR2 --Bug: 4537865
48 ) ;
49
50 procedure DELETE_ROW (
51 P_PLAN_RES_DEFAULT_ID in NUMBER
52 );
53
54 procedure LOAD_ROW(
55 X_PLAN_RES_DEFAULT_ID in out NOCOPY NUMBER ,
56 P_RESOURCE_CLASS_ID in NUMBER ,
57 P_OBJECT_TYPE in VARCHAR2 ,
58 P_OBJECT_ID in NUMBER ,
59 P_SPREAD_CURVE_ID in NUMBER ,
60 P_ETC_METHOD_CODE in VARCHAR2 ,
61 P_EXPENDITURE_TYPE in VARCHAR2 ,
62 P_ITEM_CATEGORY_SET_ID in NUMBER ,
63 P_ITEM_MASTER_ID in NUMBER ,
64 P_MFC_COST_TYPE_ID in NUMBER ,
65 P_ENABLED_FLAG in VARCHAR2 ,
66 X_RECORD_VERSION_NUMBER in out NOCOPY NUMBER ,
67 P_OWNER in VARCHAR2
68 );
69
70 end pa_plan_res_defaults_pvt;