1 PACKAGE PO_SIGNATURE_PVT AS
2 /* $Header: POXVSIGS.pls 120.2 2006/05/15 18:26:12 tpoon noship $ */
3
4 -- Sets the attributes required for the Process
5 PROCEDURE Set_Startup_Values (itemtype IN VARCHAR2,
6 itemkey IN VARCHAR2,
7 actid IN NUMBER,
8 funcmode IN VARCHAR2,
9 resultout OUT NOCOPY VARCHAR2);
10
11
12 -- Sets the Notification Message body of the Signature Notifications for Supplier/Buyer
13 PROCEDURE get_signature_notfn_body (document_id IN VARCHAR2,
14 display_type IN VARCHAR2,
15 document IN OUT NOCOPY CLOB,
16 document_type IN OUT NOCOPY VARCHAR2);
17
18 -- Calls the eRecord APIs to store the eRecord
19 PROCEDURE create_erecord (itemtype IN VARCHAR2,
20 itemkey IN VARCHAR2,
21 actid IN NUMBER,
22 funcmode IN VARCHAR2,
23 resultout OUT NOCOPY VARCHAR2);
24
25 -- Updates relevant PO tables based on the Supplier and Buyers signature response
26 PROCEDURE post_signature(itemtype IN VARCHAR2,
27 itemkey IN VARCHAR2,
28 actid IN NUMBER,
29 funcmode IN VARCHAR2,
30 resultout OUT NOCOPY VARCHAR2);
31
32 -- Sets the supplier response attribute to ACCEPTED
33 PROCEDURE set_accepted_supplier_response(itemtype IN VARCHAR2,
34 itemkey IN VARCHAR2,
35 actid IN NUMBER,
36 funcmode IN VARCHAR2,
37 resultout OUT NOCOPY VARCHAR2);
38
39
40 -- Sets the supplier response attribute to REJECTED
41 PROCEDURE set_rejected_supplier_response(itemtype IN VARCHAR2,
42 itemkey IN VARCHAR2,
43 actid IN NUMBER,
44 funcmode IN VARCHAR2,
45 resultout OUT NOCOPY VARCHAR2);
46
47 -- Sets the buyer notification body when supplier rejected the document
48 PROCEDURE get_buyer_info_notfn_body (document_id IN VARCHAR2,
49 display_type IN VARCHAR2,
50 document IN OUT NOCOPY CLOB,
51 document_type IN OUT NOCOPY VARCHAR2);
52
53 -- Sets the buyer response attribute to ACCEPTED
54 PROCEDURE set_accepted_buyer_response(itemtype IN VARCHAR2,
55 itemkey IN VARCHAR2,
56 actid IN NUMBER,
57 funcmode IN VARCHAR2,
58 resultout OUT NOCOPY VARCHAR2);
59
60 -- Sets the supplier notification body when buyer accepted/rejected the document
61 PROCEDURE get_supplier_info_notfn_body (document_id IN VARCHAR2,
62 display_type IN VARCHAR2,
63 document IN OUT NOCOPY CLOB,
64 document_type IN OUT NOCOPY VARCHAR2);
65
66 -- Sets the buyer response attribute to REJECTED
67 PROCEDURE set_rejected_buyer_response(itemtype IN VARCHAR2,
68 itemkey IN VARCHAR2,
69 actid IN NUMBER,
70 funcmode IN VARCHAR2,
71 resultout OUT NOCOPY VARCHAR2);
72
73 -- Checks if the document requires Signature
74 PROCEDURE Is_Signature_Required(itemtype IN VARCHAR2,
75 itemkey IN VARCHAR2,
76 actid IN NUMBER,
77 funcmode IN VARCHAR2,
78 resultout OUT NOCOPY VARCHAR2);
79
80 -- <BUG 3607009 START>
81 -- Checks if the document requires Signature
82 FUNCTION is_signature_required ( p_itemtype IN VARCHAR2
83 , p_itemkey IN VARCHAR2
84 ) RETURN BOOLEAN;
85 -- <BUG 3607009 END>
86
87 -- Checks if the document was ever Signed
88 FUNCTION Was_Signature_Required(p_document_id IN NUMBER) return BOOLEAN;
89
90 -- Sets the Supplier Notification Id attribute of the Signature Notification
91 PROCEDURE Set_Supplier_Notification_Id(itemtype IN VARCHAR2,
92 itemkey IN VARCHAR2,
93 actid IN NUMBER,
94 funcmode IN VARCHAR2,
95 resultout OUT NOCOPY VARCHAR2);
96
97 -- Sets the Buyer Notification Id attribute of the Signature Notification
98 PROCEDURE Set_Buyer_Notification_Id(itemtype IN VARCHAR2,
99 itemkey IN VARCHAR2,
100 actid IN NUMBER,
101 funcmode IN VARCHAR2,
102 resultout OUT NOCOPY VARCHAR2);
103
104 -- Updates the PO tables
105 PROCEDURE Update_Po_Details(p_po_header_id IN NUMBER,
106 p_status IN VARCHAR2,
107 p_action_code IN VARCHAR2,
108 p_object_type_code IN VARCHAR2,
109 p_object_subtype_code IN VARCHAR2,
110 p_employee_id IN NUMBER,
111 p_revision_num IN NUMBER);
112
113 -- To create Item key for the Document Signature Process
114 PROCEDURE Get_Item_Key(p_po_header_id IN NUMBER,
115 p_revision_num IN NUMBER,
116 p_document_type IN VARCHAR2,
117 x_itemkey OUT NOCOPY VARCHAR2,
118 x_result OUT NOCOPY VARCHAR2);
119
120 -- Returns item key of the active Document Signature Process
121 PROCEDURE Find_Item_Key(p_po_header_id IN NUMBER,
122 p_revision_num IN NUMBER,
123 p_document_type IN VARCHAR2,
124 x_itemkey OUT NOCOPY VARCHAR2,
125 x_result OUT NOCOPY VARCHAR2);
126
127 -- To Abort Document Signature Process after Signatures are completed
128 PROCEDURE Abort_Doc_Sign_Process(p_itemkey IN VARCHAR2,
129 x_result OUT NOCOPY VARCHAR2);
130
131 -- To complete the blocked activities in PO Approval workflow
132 PROCEDURE Complete_Block_Activities(p_itemkey IN VARCHAR2,
133 p_status IN VARCHAR2,
134 x_result OUT NOCOPY VARCHAR2);
135
136 -- To get the last signed document revision number
137 PROCEDURE Get_Last_Signed_Revision(p_po_header_id IN NUMBER,
138 p_revision_num IN NUMBER,
139 x_signed_revision_num OUT NOCOPY NUMBER,
140 x_signed_records OUT NOCOPY VARCHAR2,
141 x_return_status OUT NOCOPY VARCHAR2);
142
143 -- To find out if the eRecord exists for the document revision
144 PROCEDURE Does_Erecord_Exist(p_po_header_id IN NUMBER,
145 p_revision_num IN NUMBER,
146 x_erecord_exist OUT NOCOPY VARCHAR2,
147 x_pending_signature OUT NOCOPY VARCHAR2);
148
149 -- When signatures are complete updates the relevant tables
150 PROCEDURE Post_Forms_Commit( p_po_header_id IN NUMBER,
151 p_revision_num IN NUMBER,
152 x_result OUT NOCOPY VARCHAR2,
153 x_error_msg OUT NOCOPY VARCHAR2,
154 x_msg_data OUT NOCOPY VARCHAR2);
155
156 -- Checks if there are more than one signature records exist in the
157 -- PO_ACCEPTANCES table
158 PROCEDURE Check_For_Multiple_Entries( p_po_header_id IN NUMBER,
159 p_revision_num IN NUMBER,
160 x_result OUT NOCOPY VARCHAR2,
161 x_error_msg OUT NOCOPY VARCHAR2);
162
163
164 -- <BUG 3751927 START>
165 -- Gets rejection type of a document version from action history
166 -- and acceptences. See package body for more info.
167 PROCEDURE get_rejection_type ( p_po_header_id IN NUMBER
168 , p_revision_num IN NUMBER
169 , x_buyer_rejected OUT NOCOPY VARCHAR2
170 , x_supplier_rejected OUT NOCOPY VARCHAR2
171 );
172 -- <BUG 3751927 END>
173 --<Bug#5013783 Start>
174 PROCEDURE if_was_sign_reqd_set_acc_flag(p_document_id IN NUMBER,
175 x_if_acc_flag_updated OUT NOCOPY VARCHAR2);
176 --<Bug#5013783 End>
177
178 -- Bug 5216351
179 PROCEDURE if_rev_and_signed_set_acc_flag (
180 p_document_id IN NUMBER,
181 p_old_revision_num IN NUMBER,
182 x_if_acc_flag_updated OUT NOCOPY VARCHAR2);
183
184 END PO_SIGNATURE_PVT;
185