[Home] [Help]
PACKAGE: APPS.AHL_GENERIC_APRV_PVT
Source
1 PACKAGE AHL_GENERIC_APRV_PVT AUTHID CURRENT_USER as
2 /* $Header: AHLVGWFS.pls 115.3 2003/09/26 07:46:36 rroy noship $ */
3
4 Type ObjRecTyp is RECORD
5 ( name VARCHAR2(240),
6 operating_unit_id NUMBER,
7 object_type VARCHAR2(30),
8 priority VARCHAR2(30),
9 start_date DATE,
10 end_date DATE,
11 description VARCHAR2(4000),
12 owner_id NUMBER,
13 priority_desc VARCHAR2(80),
14 application_usg_code VARCHAR2(30)
15 );
16 --======================================================================
17 -- PROCEDURE
18 -- Start_WF_Process
19 --
20 -- PURPOSE
21 -- Start Workflow Process
22 --
23 --======================================================================
24
25 PROCEDURE Start_WF_Process
26 (p_object IN VARCHAR2,
27 p_activity_id IN NUMBER,
28 p_approval_type IN VARCHAR2,
29 p_object_version_number IN NUMBER,
30 p_orig_status_code IN VARCHAR2,
31 p_new_status_code IN VARCHAR2,
32 p_reject_status_code IN VARCHAR2,
33 p_requester_userid IN NUMBER,
34 p_notes_from_requester IN VARCHAR2,
35 p_workflowprocess IN VARCHAR2 DEFAULT NULL,
36 p_item_type IN VARCHAR2 DEFAULT NULL,
37 p_application_usg_code IN VARCHAR2 DEFAULT 'AHL'
38 );
39 /*****************************************************************
40 -- Wrapper APIs
41 *****************************************************************/
42
43
44 PROCEDURE Set_Activity_Details(itemtype IN VARCHAR2,
45 itemkey IN VARCHAR2,
46 actid IN NUMBER,
47 funcmode IN VARCHAR2,
48 resultout OUT NOCOPY VARCHAR2);
49
50 PROCEDURE Prepare_Doc( itemtype in varchar2,
51 itemkey in varchar2,
52 actid in number,
53 funcmode in varchar2,
54 resultout out nocopy varchar2 );
55
56 PROCEDURE Set_Approver_Details( itemtype in varchar2,
57 itemkey in varchar2,
58 actid in number,
59 funcmode in varchar2,
60 resultout out nocopy varchar2 );
61
62 PROCEDURE Set_Further_Approval( itemtype in varchar2,
63 itemkey in varchar2,
64 actid in number,
65 funcmode in varchar2,
66 resultout out nocopy varchar2 );
67
68
69 PROCEDURE Ntf_Approval(document_id in varchar2,
70 display_type in varchar2,
71 document in out nocopy varchar2,
72 document_type in out nocopy varchar2 );
73
74 PROCEDURE Ntf_Error_Act(document_id in varchar2,
75 display_type in varchar2,
76 document in out nocopy varchar2,
77 document_type in out nocopy varchar2 );
78
79 PROCEDURE Ntf_Approval_Reminder(document_id in varchar2,
80 display_type in varchar2,
81 document in out nocopy varchar2,
82 document_type in out nocopy varchar2 );
83
84 PROCEDURE Ntf_Forward_FYI(document_id in varchar2,
85 display_type in varchar2,
86 document in out nocopy varchar2,
87 document_type in out nocopy varchar2 );
88
89 PROCEDURE Ntf_Approved_FYI(document_id in varchar2,
90 display_type in varchar2,
91 document in out nocopy varchar2,
92 document_type in out nocopy varchar2 );
93
94 PROCEDURE Ntf_Rejected_FYI(document_id in varchar2,
95 display_type in varchar2,
96 document in out nocopy varchar2,
97 document_type in out nocopy varchar2 );
98
99 PROCEDURE Ntf_Final_Approval_FYI(document_id in varchar2,
100 display_type in varchar2,
101 document in out nocopy varchar2,
102 document_type in out nocopy varchar2 );
103
104 PROCEDURE Update_Status(itemtype IN varchar2,
105 itemkey IN varchar2,
106 actid in number,
107 funcmode in varchar2,
108 resultout out nocopy varchar2 );
109
110 PROCEDURE Revert_Status( itemtype in varchar2,
111 itemkey in varchar2,
112 actid in number,
113 funcmode in varchar2,
114 resultout out nocopy varchar2 );
115
116
117 /*****************************************************************
118 -- Helper APIs
119 *****************************************************************/
120 PROCEDURE Rejected_Update_Status(itemtype IN varchar2,
121 itemkey IN varchar2,
122 actid in number,
123 funcmode in varchar2,
124 resultout out nocopy varchar2 );
125
126 PROCEDURE Approved_Update_Status(itemtype IN varchar2,
127 itemkey IN varchar2,
128 actid in number,
129 funcmode in varchar2,
130 resultout out nocopy varchar2 );
131
132 PROCEDURE Get_Approval_Details
133 ( p_object IN VARCHAR2,
134 p_approval_type IN VARCHAR2 DEFAULT 'CONCEPT',
135 p_object_details IN ObjRecTyp,
136 x_approval_rule_id OUT NOCOPY NUMBER,
137 x_approver_seq OUT NOCOPY NUMBER,
138 x_return_status OUT NOCOPY VARCHAR2);
139
140 PROCEDURE Get_Approver_Info
141 ( p_rule_id IN NUMBER,
142 p_current_seq IN NUMBER,
143 x_approver_id OUT NOCOPY VARCHAR2,
144 x_approver_type OUT NOCOPY VARCHAR2,
145 x_object_approver_id OUT NOCOPY VARCHAR2,
146 x_return_status OUT NOCOPY VARCHAR2);
147
148 PROCEDURE Get_Api_Name( p_api_used_by in varchar2,
149 p_object in varchar2,
150 p_activity_type in VARCHAR2,
151 p_approval_type in VARCHAR2,
152 x_pkg_name out nocopy varchar2,
153 x_proc_name out nocopy varchar2,
154 x_return_status out nocopy varchar2);
155 PROCEDURE Handle_Error
156 (p_itemtype IN VARCHAR2 ,
157 p_itemkey IN VARCHAR2 ,
158 p_msg_count IN NUMBER , -- Number of error Messages
159 p_msg_data IN VARCHAR2 ,
160 p_attr_name IN VARCHAR2,
161 x_error_msg OUT NOCOPY VARCHAR2
162 );
163 END ahl_generic_aprv_pvt;
164