1 PACKAGE CS_SR_UTIL_PKG as
2 /* $Header: cssrutis.pls 120.1 2005/12/19 03:45 appldev ship $ */
3
4 PROCEDURE Get_Default_Values(
5 p_default_type_id IN OUT NOCOPY NUMBER,
6 p_default_type IN OUT NOCOPY VARCHAR2,
7 p_default_type_workflow IN OUT NOCOPY VARCHAR2,
8 p_default_type_workflow_nm IN OUT NOCOPY VARCHAR2,
9 p_default_type_cnt IN OUT NOCOPY NUMBER,
10 p_default_severity_id IN OUT NOCOPY NUMBER,
11 p_default_severity IN OUT NOCOPY VARCHAR2,
12 p_default_urgency_id IN OUT NOCOPY NUMBER,
13 p_default_urgency IN OUT NOCOPY VARCHAR2,
14 p_default_owner_id IN OUT NOCOPY NUMBER,
15 p_default_owner IN OUT NOCOPY VARCHAR2,
16 p_default_status_id IN OUT NOCOPY NUMBER,
17 p_default_status IN OUT NOCOPY VARCHAR2
18 ) ;
19
20
21 -- Procedure overloaded as per sarayu. rmanabat 08/17/01 .
22 PROCEDURE Get_Default_Values(
23 p_default_type_id IN OUT NOCOPY NUMBER,
24 p_default_type IN OUT NOCOPY VARCHAR2,
25 p_default_type_workflow IN OUT NOCOPY VARCHAR2,
26 p_default_type_workflow_nm IN OUT NOCOPY VARCHAR2,
27 p_default_type_cnt IN OUT NOCOPY NUMBER,
28 p_default_severity_id IN OUT NOCOPY NUMBER,
29 p_default_severity IN OUT NOCOPY VARCHAR2,
30 p_default_urgency_id IN OUT NOCOPY NUMBER,
31 p_default_urgency IN OUT NOCOPY VARCHAR2,
32 p_default_owner_id IN OUT NOCOPY NUMBER,
33 p_default_owner IN OUT NOCOPY VARCHAR2,
34 p_default_status_id IN OUT NOCOPY NUMBER,
35 p_default_status IN OUT NOCOPY VARCHAR2,
36 p_default_group_type IN OUT NOCOPY VARCHAR2,
37 p_default_group_type_name IN OUT NOCOPY VARCHAR2,
38 p_default_group_owner_id IN OUT NOCOPY NUMBER,
39 p_default_group_owner IN OUT NOCOPY VARCHAR2,
40 p_group_mandatory IN OUT NOCOPY VARCHAR2,
41 p_default_resource_type IN OUT NOCOPY VARCHAR2,
42 p_default_resource_type_name IN OUT NOCOPY VARCHAR2,
43 p_incident_owner_mandatory IN OUT NOCOPY VARCHAR2,
44 p_default_type_maint_flag IN OUT NOCOPY VARCHAR2,
45 p_default_cmro_flag IN OUT NOCOPY VARCHAR2
46 ) ;
47
48
49
50 FUNCTION Get_Last_Update_Date (
51 p_incident_id IN NUMBER,
52 p_last_update_date IN DATE ) RETURN DATE;
53
54 pragma RESTRICT_REFERENCES (Get_Last_Update_Date, WNDS);
55
56
57 FUNCTION Get_Related_Statuses_Cnt (
58 p_incident_type_id IN NUMBER ) RETURN NUMBER;
59
60 pragma RESTRICT_REFERENCES (Get_Related_Statuses_Cnt, WNDS);
61
62 -- #1520471
63 FUNCTION scheduler_is_installed RETURN varchar2;
64 -- pragma RESTRICT_REFERENCES (scheduler_is_installed, WNDS);
65
66 END CS_SR_UTIL_PKG;