1 PACKAGE IEB_SVC_PLANS_PKG as
2 /* $Header: IEBSVCPS.pls 120.2 2005/09/29 06:14:11 appldev noship $ */
3
4 procedure INSERT_ROW_B (
5 P_SVCPLN_ID IN NUMBER,
6 P_SERVICE_PLAN_NAME IN VARCHAR2,
7 P_DIRECTION IN VARCHAR2,
8 P_TREATMENT IN VARCHAR2,
9 P_PLAN_NAME IN VARCHAR2,
10 P_DESCRIPTION IN VARCHAR2,
11 P_OBJECT_VERSION_NUMBER IN NUMBER,
12 P_MEDIA_TYPE_ID IN NUMBER,
13 P_OWNER_ID IN NUMBER,
14 X_ROWID IN OUT NOCOPY VARCHAR2
15 );
16
17 procedure INSERT_ROW_TL (
18 P_SVCPLN_ID IN NUMBER,
19 P_PLAN_NAME IN VARCHAR2,
20 P_DESCRIPTION IN VARCHAR2,
21 P_OBJECT_VERSION_NUMBER IN NUMBER,
22 P_OWNER_ID IN NUMBER,
23 X_ROWID IN OUT NOCOPY VARCHAR2
24 );
25
26 procedure LOCK_ROW (
27 P_SVCPLN_ID IN NUMBER,
28 P_SERVICE_PLAN_NAME IN VARCHAR2,
29 P_DIRECTION IN VARCHAR2,
30 P_TREATMENT IN VARCHAR2,
31 P_PLAN_NAME IN VARCHAR2,
32 P_DESCRIPTION IN VARCHAR2,
33 P_OBJECT_VERSION_NUMBER IN NUMBER,
34 P_MEDIA_TYPE_ID IN NUMBER
35 ) ;
36
37 procedure UPDATE_ROW_B (
38 P_SVCPLN_ID IN NUMBER,
39 P_SERVICE_PLAN_NAME IN VARCHAR2,
40 P_DIRECTION IN VARCHAR2,
41 P_TREATMENT IN VARCHAR2,
42 P_PLAN_NAME IN VARCHAR2,
43 P_DESCRIPTION IN VARCHAR2,
44 P_OBJECT_VERSION_NUMBER IN NUMBER,
45 P_MEDIA_TYPE_ID IN NUMBER,
46 P_OWNER_ID IN NUMBER
47 ) ;
48
49 procedure UPDATE_ROW_TL (
50 P_SVCPLN_ID IN NUMBER,
51 P_PLAN_NAME IN VARCHAR2,
52 P_DESCRIPTION IN VARCHAR2,
53 P_OBJECT_VERSION_NUMBER IN NUMBER,
54 P_OWNER_ID IN NUMBER
55 ) ;
56
57 procedure DELETE_ROW (
58 P_SVCPLN_ID in NUMBER
59 ) ;
60
61 procedure ADD_LANGUAGE;
62
63 procedure TRANSLATE_ROW (
64 P_SVCPLN_ID IN NUMBER,
65 P_PLAN_NAME IN VARCHAR2,
66 P_DESCRIPTION IN VARCHAR2,
67 P_OWNER IN VARCHAR2
68 ) ;
69
70 procedure LOAD_ROW (
71 P_SVCPLN_ID IN NUMBER,
72 P_SERVICE_PLAN_NAME IN VARCHAR2,
73 P_DIRECTION IN VARCHAR2,
74 P_TREATMENT IN VARCHAR2,
75 P_PLAN_NAME IN VARCHAR2,
76 P_DESCRIPTION IN VARCHAR2,
77 P_OBJECT_VERSION_NUMBER IN NUMBER,
78 P_MEDIA_TYPE_ID IN NUMBER,
79 P_OWNER IN VARCHAR2
80 ) ;
81
82 procedure LOAD_SEED_ROW (
83 P_SVCPLN_ID IN NUMBER,
84 P_SERVICE_PLAN_NAME IN VARCHAR2,
85 P_DIRECTION IN VARCHAR2,
86 P_TREATMENT IN VARCHAR2,
87 P_PLAN_NAME IN VARCHAR2,
88 P_DESCRIPTION IN VARCHAR2,
89 P_OBJECT_VERSION_NUMBER IN NUMBER,
90 P_MEDIA_TYPE_ID IN NUMBER,
91 P_OWNER IN VARCHAR2,
92 P_UPLOAD_MODE IN VARCHAR2
93 ) ;
94
95
96 end IEB_SVC_PLANS_PKG;