[Home] [Help]
PACKAGE: APPS.CUG_WF_EMAIL_UTIL
Source
1 Package CUG_WF_EMAIL_UTIL AUTHID CURRENT_USER AS
2 /* $Header: CUGWFEUS.pls 115.6 2002/11/24 23:54:50 rhungund noship $ */
3 --
4 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
5 -- directory of SQL Navigator
6 --
7 -- Purpose: Briefly explain the functionality of the package
8 --
9 -- MODIFICATION HISTORY
10 -- Person Date Comments
11 -- --------- ------ ------------------------------------------
12 -- Enter package declarations as shown below
13
14 --
15
16 PROCEDURE Get_SR_Details
17 ( ITEMTYPE IN VARCHAR2
18 ,ITEMKEY IN VARCHAR2
19 ,ACTID IN NUMBER
20 ,FUNCMODE IN VARCHAR2
21 ,RESULTOUT OUT NOCOPY VARCHAR2
22 );
23
24
25 PROCEDURE Get_Task_Attrs_Details
26 (
27 ITEMTYPE IN VARCHAR2
28 , ITEMKEY IN VARCHAR2
29 , INCIDENT_TYPE_ID IN NUMBER
30 , TASK_ID IN NUMBER
31 , TASK_TYPE_ID IN NUMBER
32 , X_RETURN_STATUS OUT NOCOPY VARCHAR2
33 ) ;
34
35 PROCEDURE Get_Incident_Addr_Details
36 (
37 ITEMTYPE IN VARCHAR2
38 , ITEMKEY IN VARCHAR2
39 , INCIDENT_NUMBER IN VARCHAR2
40 ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
41 );
42
43 PROCEDURE Get_SR_Attrs_Details (
44 ITEMTYPE IN VARCHAR2
45 , ITEMKEY IN VARCHAR2
46 , INCIDENT_ID IN NUMBER
47 , INCIDENT_TYPE_ID IN NUMBER
48 , INCIDENT_NUMBER IN VARCHAR2
49 , TASK_NUMBER IN VARCHAR2
50 , X_RETURN_STATUS OUT NOCOPY VARCHAR2
51 );
52
53 PROCEDURE Set_Reminder_Interval
54 ( ITEMTYPE IN VARCHAR2
55 ,ITEMKEY IN VARCHAR2
56 ,ACTID IN NUMBER
57 ,FUNCMODE IN VARCHAR2
58 ,RESULTOUT OUT NOCOPY VARCHAR2
59 );
60
61 PROCEDURE Check_For_CIC_SR
62 ( ITEMTYPE IN VARCHAR2
63 ,ITEMKEY IN VARCHAR2
64 ,ACTID IN NUMBER
65 ,FUNCMODE IN VARCHAR2
66 ,RESULTOUT OUT NOCOPY VARCHAR2
67 );
68
69 PROCEDURE Set_Email_status
70 ( ITEMTYPE IN VARCHAR2
71 ,ITEMKEY IN VARCHAR2
72 ,ACTID IN NUMBER
73 ,FUNCMODE IN VARCHAR2
74 ,RESULTOUT OUT NOCOPY VARCHAR2
75 );
76
77 END; -- Package spec