1 package IEB_SERVICE_LEVELS_PKG as
2 /* $Header: IEBSVCLVLS.pls 120.1 2005/09/16 02:21:47 appldev ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out nocopy VARCHAR2,
6 X_SERVICE_LEVEL_ID in NUMBER,
7 X_DIRECTION in VARCHAR2,
8 X_MANDATORY_FLAG in VARCHAR2,
9 X_HOURLY_QUOTA in NUMBER,
10 X_MIN_AGENTS in NUMBER,
11 X_GOAL_PERCENT in NUMBER,
12 X_GOAL_TIME in NUMBER,
13 X_MAX_WAIT_TIME in NUMBER,
14 X_REROUTE_TIME in NUMBER,
15 X_REROUTE_WARNING_TIME in NUMBER,
16 X_OBJECT_VERSION_NUMBER in NUMBER,
17 X_SECURITY_GROUP_ID in NUMBER,
18 X_LEVEL_NAME in VARCHAR2,
19 X_DESCRIPTION in VARCHAR2,
20 X_CREATION_DATE in DATE,
21 X_CREATED_BY in NUMBER,
22 X_LAST_UPDATE_DATE in DATE,
23 X_LAST_UPDATED_BY in NUMBER,
24 X_LAST_UPDATE_LOGIN in NUMBER);
25
26 procedure LOCK_ROW (
27 X_SERVICE_LEVEL_ID in NUMBER,
28 X_DIRECTION in VARCHAR2,
29 X_MANDATORY_FLAG in VARCHAR2,
30 X_HOURLY_QUOTA in NUMBER,
31 X_MIN_AGENTS in NUMBER,
32 X_GOAL_PERCENT in NUMBER,
33 X_GOAL_TIME in NUMBER,
34 X_MAX_WAIT_TIME in NUMBER,
35 X_REROUTE_TIME in NUMBER,
36 X_REROUTE_WARNING_TIME in NUMBER,
37 X_OBJECT_VERSION_NUMBER in NUMBER,
38 X_SECURITY_GROUP_ID in NUMBER,
39 X_LEVEL_NAME in VARCHAR2,
40 X_DESCRIPTION in VARCHAR2
41 );
42
43 procedure UPDATE_ROW (
44 X_SERVICE_LEVEL_ID in NUMBER,
45 X_DIRECTION in VARCHAR2,
46 X_MANDATORY_FLAG in VARCHAR2,
47 X_HOURLY_QUOTA in NUMBER,
48 X_MIN_AGENTS in NUMBER,
49 X_GOAL_PERCENT in NUMBER,
50 X_GOAL_TIME in NUMBER,
51 X_MAX_WAIT_TIME in NUMBER,
52 X_REROUTE_TIME in NUMBER,
53 X_REROUTE_WARNING_TIME in NUMBER,
54 X_OBJECT_VERSION_NUMBER in NUMBER,
55 X_SECURITY_GROUP_ID in NUMBER,
56 X_LEVEL_NAME in VARCHAR2,
57 X_DESCRIPTION in VARCHAR2,
58 X_LAST_UPDATE_DATE in DATE,
59 X_LAST_UPDATED_BY in NUMBER,
60 X_LAST_UPDATE_LOGIN in NUMBER
61 );
62
63 procedure DELETE_ROW (
64 X_SERVICE_LEVEL_ID in NUMBER
65 );
66
67 procedure LOAD_ROW (
68 p_service_level_id IN NUMBER,
69 p_mandatory_flag IN VARCHAR2,
70 p_direction IN VARCHAR2,
71 p_hourly_quota IN NUMBER,
72 p_min_agents IN NUMBER,
73 p_goal_percent IN NUMBER,
74 p_goal_time IN NUMBER,
75 p_max_wait_time IN NUMBER,
76 p_reroute_time IN NUMBER,
77 p_reroute_warning_time IN NUMBER,
78 p_level_name IN VARCHAR2,
79 p_DESCRIPTION IN VARCHAR2,
80 p_OWNER IN VARCHAR2);
81
82 procedure LOAD_SEED_ROW (
83 p_service_level_id IN NUMBER,
84 p_mandatory_flag IN VARCHAR2,
85 p_direction IN VARCHAR2,
86 p_hourly_quota IN NUMBER,
87 p_min_agents IN NUMBER,
88 p_goal_percent IN NUMBER,
89 p_goal_time IN NUMBER,
90 p_max_wait_time IN NUMBER,
91 p_reroute_time IN NUMBER,
92 p_reroute_warning_time IN NUMBER,
93 p_level_name IN VARCHAR2,
94 p_DESCRIPTION IN VARCHAR2,
95 p_OWNER IN VARCHAR2,
96 p_UPLOAD_MODE IN VARCHAR2);
97
98 procedure TRANSLATE_ROW (
99 X_SERVICE_LEVEL_ID IN NUMBER,
100 X_LEVEL_NAME IN VARCHAR2,
101 X_DESCRIPTION IN VARCHAR2,
102 X_OWNER IN VARCHAR2);
103
104 procedure ADD_LANGUAGE;
105 end IEB_SERVICE_LEVELS_PKG;