1 PACKAGE AMW_GEN_APPROVAL_PVT AUTHID CURRENT_USER as
2 /* $Header: amwvgaps.pls 115.3 2003/06/30 22:17:48 kmuthusw noship $ */
3 --
4 -- NAME
5 -- StartProcess
6 --
7 -- PURPOSE
8 -- This Procedure will Start the flow for the Approval Process
9 --
10 --
11 -- IN
12 -- p_approval_for IN Approval for Object (i.e. CAMP/EVEH,...)
13 -- p_approval_for_id IN Approval for Objectid (i.e. CAMP_id,...)
14 -- p_object_version_number IN Object Version Number
15 -- p_orig_stat_id IN Original User Status Id(e.g. id for 'NEW')
16 -- p_new_stat_id IN New User Status Id(e.g. id for 'AVAILABLE')
17 -- p_requestor_userid IN Userid
18 -- p_workflow_process IN WF Process Name (Default Null)
19 -- p_item_type IN WF Item type(Default Null)
20 -- OUT
21 --
22 -- Used By Activities
23 --
24 -- NOTES
25 -- HISTORY
26 -- 06/30/2003 KARTHI MUTHUSWAMY Changed p_workflowprocess to p_workflow_process
27 -- End of Comments
28 PROCEDURE StartProcess
29 (p_object_type IN VARCHAR2,
30 p_object_id IN NUMBER,
31 p_approval_type IN VARCHAR2 DEFAULT NULL,
32 p_object_version_number IN NUMBER,
33 p_requestor_userid IN NUMBER,
34 p_workflow_process IN VARCHAR2 DEFAULT NULL,
35 p_item_type IN VARCHAR2 DEFAULT NULL,
36 p_gen_process_flag IN VARCHAR2 DEFAULT NULL,
37 x_return_status out nocopy varchar2,
38 x_msg_count out nocopy number,
39 x_msg_data out nocopy varchar2
40 );
41 PROCEDURE Set_object_Details(itemtype IN VARCHAR2,
42 itemkey IN VARCHAR2,
43 actid IN NUMBER,
44 funcmode IN VARCHAR2,
45 resultout OUT NOCOPY VARCHAR2);
46 PROCEDURE Revert_Status( itemtype in varchar2,
47 itemkey in varchar2,
48 actid in number,
49 funcmode in varchar2,
50 resultout OUT NOCOPY varchar2);
51 PROCEDURE Set_Approver_Details( itemtype in varchar2,
52 itemkey in varchar2,
53 actid in number,
54 funcmode in varchar2,
55 resultout OUT NOCOPY varchar2 );
56 /*****************************************************************
57 -- Start of Comments
58 --
59 -- NAME
60 -- AbortProcess
61 --
62 -- PURPOSE
63 -- This Procedure will abort the process of Approvals
64 --
65 -- Used By Activities
66 --
67 -- NOTES
68 --
69 --
70 -- HISTORY
71 -- End of Comments
72 *****************************************************************/
73 PROCEDURE AbortProcess
74 (p_itemkey IN VARCHAR2
75 ,p_workflow_process IN VARCHAR2 DEFAULT NULL
76 ,p_itemtype IN VARCHAR2 DEFAULT NULL
77 );
78 PROCEDURE Get_Api_Name( p_rule_used_by in varchar2,
79 p_rule_used_by_type in varchar2,
80 p_rule_type in VARCHAR2,
81 p_appr_type in VARCHAR2,
82 x_pkg_name OUT NOCOPY varchar2,
83 x_proc_name OUT NOCOPY varchar2,
84 x_return_stat OUT NOCOPY varchar2);
85 PROCEDURE Ntf_Approval(document_id in varchar2,
86 display_type in varchar2,
87 document in OUT NOCOPY varchar2,
88 document_type in OUT NOCOPY varchar2);
89 PROCEDURE Ntf_Approval_reminder(document_id in varchar2,
90 display_type in varchar2,
91 document in OUT NOCOPY varchar2,
92 document_type in OUT NOCOPY varchar2);
93 PROCEDURE Ntf_Forward_FYI( document_id in varchar2,
94 display_type in varchar2,
95 document in OUT NOCOPY varchar2,
96 document_type in OUT NOCOPY varchar2);
97 PROCEDURE Ntf_Approved_FYI(document_id in varchar2,
98 display_type in varchar2,
99 document in OUT NOCOPY varchar2,
100 document_type in OUT NOCOPY varchar2);
101 PROCEDURE Ntf_Rejected_FYI(document_id in varchar2,
102 display_type in varchar2,
103 document in OUT NOCOPY varchar2,
104 document_type in OUT NOCOPY varchar2);
105 PROCEDURE Ntf_Requestor_Of_Error(document_id in varchar2,
106 display_type in varchar2,
107 document in OUT NOCOPY varchar2,
108 document_type in OUT NOCOPY varchar2);
109 PROCEDURE Update_Status(itemtype IN varchar2,
110 itemkey IN varchar2,
111 actid in number,
112 funcmode in varchar2,
113 resultout OUT NOCOPY varchar2);
114 PROCEDURE Reject_Update_Status(itemtype IN varchar2,
115 itemkey IN varchar2,
116 actid in number,
117 funcmode in varchar2,
118 resultout OUT NOCOPY varchar2);
119 PROCEDURE Approved_Update_Status(itemtype IN varchar2,
120 itemkey IN varchar2,
121 actid in number,
122 funcmode in varchar2,
123 resultout OUT NOCOPY varchar2 );
124 PROCEDURE Handle_Err
125 (p_itemtype IN VARCHAR2 ,
126 p_itemkey IN VARCHAR2 ,
127 p_msg_count IN NUMBER , -- Number of error Messages
128 p_msg_data IN VARCHAR2 ,
129 p_attr_name IN VARCHAR2,
130 x_error_msg OUT NOCOPY VARCHAR2
131 );
132 PROCEDURE Approval_Required(itemtype IN VARCHAR2,
133 itemkey IN VARCHAR2,
134 actid IN NUMBER,
135 funcmode IN VARCHAR2,
136 resultout OUT NOCOPY VARCHAR2);
137 END amw_gen_approval_pvt;