1 PACKAGE PON_AWARD_APPROVAL_PKG AUTHID CURRENT_USER AS
2 /* $Header: PONAWAPS.pls 120.1 2006/03/23 03:43:50 ppaulsam noship $ */
3
4 -- constants for integrating with the ame_api package
5 APPLICATION_ID CONSTANT INTEGER := 396;
6 AWARD_TRANSACTION_TYPE CONSTANT VARCHAR2(30) := 'PON_NEGOTIATION_AWARD';
7
8 -- constants used for parsing and formatting approver strings and records
9 APPROVER_FIELD_DELIMITER VARCHAR2(3);
10 APPROVER_RECORD_DELIMITER VARCHAR2(3);
11 INTEGER_DELIMITER CONSTANT VARCHAR2(1) := ':';
12
13 -- constants used to represent the ame_util.approverRecord.api_insertion field
14 API_AUTHORITY_INSERTION CONSTANT NUMBER := -1;
15 API_INSERTION CONSTANT NUMBER := -2;
16 OAM_GENERATED CONSTANT NUMBER := -3;
17
18 -- constants used to represent the ame_util.approverRecord.authority field
19 PRE_APPROVER CONSTANT NUMBER := -4;
20 AUTHORITY_APPROVER CONSTANT NUMBER := -5;
21 POST_APPROVER CONSTANT NUMBER := -6;
22
23 -- constants used to represent the ame_util.approverRecord.approvalStatus field
24 APPROVE_AND_FORWARD_STATUS CONSTANT NUMBER := -7;
25 APPROVED_STATUS CONSTANT NUMBER := -8;
26 CLEAR_EXCEPTIONS_STATUS CONSTANT NUMBER := -9;
27 EXCEPTION_STATUS CONSTANT NUMBER := -10;
28 FORWARD_STATUS CONSTANT NUMBER := -11;
29 NO_RESPONSE_STATUS CONSTANT NUMBER := -12;
30 NOTIFIED_STATUS CONSTANT NUMBER := -13;
31 NULL_STATUS CONSTANT NUMBER := -14;
32 REJECT_STATUS CONSTANT NUMBER := -15;
33 REPEATED_STATUS CONSTANT NUMBER := -16;
34 SUPPRESSED_STATUS CONSTANT NUMBER := -17;
35
36 PROCEDURE setup_oam_transaction(p_auction_header_id IN NUMBER,
37 p_transaction_id IN VARCHAR2,
38 p_user_id IN NUMBER,
39 p_last_update_date OUT NOCOPY DATE,
40 p_error_message OUT NOCOPY VARCHAR2);
41
42 PROCEDURE clear_oam_transaction(p_auction_header_id IN NUMBER,
43 p_user_id IN NUMBER);
44
45 PROCEDURE pre_approval(itemtype IN VARCHAR2,
46 itemkey IN VARCHAR2,
47 actid IN NUMBER,
48 funcmode IN VARCHAR2,
49 resultout OUT NOCOPY VARCHAR2);
50
51 PROCEDURE post_approval(itemtype IN VARCHAR2,
52 itemkey IN VARCHAR2,
53 actid IN NUMBER,
54 funcmode IN VARCHAR2,
55 resultout OUT NOCOPY VARCHAR2);
56
57 PROCEDURE get_next_approver(itemtype IN VARCHAR2,
58 itemkey IN VARCHAR2,
59 actid IN NUMBER,
60 funcmode IN VARCHAR2,
61 resultout OUT NOCOPY VARCHAR2);
62
63 PROCEDURE process_error(itemtype IN VARCHAR2,
64 itemkey IN VARCHAR2,
65 actid IN NUMBER,
66 funcmode IN VARCHAR2,
67 resultout OUT NOCOPY VARCHAR2);
68
69 PROCEDURE is_oam_admin_available(itemtype IN VARCHAR2,
70 itemkey IN VARCHAR2,
71 actid IN NUMBER,
72 funcmode IN VARCHAR2,
73 resultout OUT NOCOPY VARCHAR2);
74
75 PROCEDURE is_oam_error(itemtype IN VARCHAR2,
76 itemkey IN VARCHAR2,
77 actid IN NUMBER,
78 funcmode IN VARCHAR2,
79 resultout OUT NOCOPY VARCHAR2);
80
81 PROCEDURE process_approver_response(itemtype IN VARCHAR2,
82 itemkey IN VARCHAR2,
83 actid IN NUMBER,
84 funcmode IN VARCHAR2,
85 resultout OUT NOCOPY VARCHAR2);
86
87 PROCEDURE document_approved(itemtype IN VARCHAR2,
88 itemkey IN VARCHAR2,
89 actid IN NUMBER,
90 funcmode IN VARCHAR2,
91 resultout OUT NOCOPY VARCHAR2);
92
93 PROCEDURE document_rejected(itemtype IN VARCHAR2,
94 itemkey IN VARCHAR2,
95 actid IN NUMBER,
96 funcmode IN VARCHAR2,
97 resultout OUT NOCOPY VARCHAR2);
98
99 PROCEDURE add_approver(p_auction_header_id IN NUMBER,
100 p_transaction_id IN VARCHAR2,
101 p_approver_string IN VARCHAR2,
102 p_position IN NUMBER,
103 p_last_update_date IN DATE,
104 p_approver_list_string OUT NOCOPY VARCHAR2,
105 p_error_message OUT NOCOPY VARCHAR2);
106
107 PROCEDURE delete_approver(p_auction_header_id IN NUMBER,
108 p_transaction_id IN VARCHAR2,
109 p_approver_string IN VARCHAR2,
110 p_last_update_date IN DATE,
111 p_approver_list_string OUT NOCOPY VARCHAR2,
112 p_error_message OUT NOCOPY VARCHAR2);
113
114 PROCEDURE change_first_approver(p_auction_header_id IN NUMBER,
115 p_transaction_id IN VARCHAR2,
116 p_approver_string IN VARCHAR2,
117 p_last_update_date IN DATE,
118 p_approver_list_string OUT NOCOPY VARCHAR2,
119 p_error_message OUT NOCOPY VARCHAR2);
120
121 PROCEDURE reset_approver_list(p_auction_header_id IN NUMBER,
122 p_transaction_id IN VARCHAR2,
123 p_last_update_date IN DATE,
124 p_approver_list_string OUT NOCOPY VARCHAR2,
125 p_can_delete_oam_approvers OUT NOCOPY VARCHAR2,
126 p_error_message OUT NOCOPY VARCHAR2);
127
128 PROCEDURE submit_for_approval(p_auction_header_id IN NUMBER,
129 p_transaction_id IN VARCHAR2,
130 p_user_id IN NUMBER,
131 p_user_name IN VARCHAR2,
132 p_last_update_date IN DATE,
133 p_note_to_approvers IN VARCHAR2,
134 p_reject_unawarded_responses IN VARCHAR2,
135 p_note_to_rejected_suppliers IN VARCHAR2,
136 p_has_items_flag IN VARCHAR2,
137 p_has_scoring_teams_flag IN VARCHAR2,
138 p_scoring_lock_tpc_id IN NUMBER,
139 p_first_authority_approver_id IN NUMBER,
140 p_error_message OUT NOCOPY VARCHAR2);
141
142 PROCEDURE make_approval_decision(p_auction_header_id IN NUMBER,
143 p_user_name IN VARCHAR2,
144 p_decision IN VARCHAR2,
145 p_note_to_buyer IN VARCHAR2,
146 p_error_message OUT NOCOPY VARCHAR2);
147
148 PROCEDURE make_approval_decision(p_auction_header_id IN NUMBER,
149 p_user_name IN VARCHAR2,
150 p_decision IN VARCHAR2,
151 p_note_to_buyer IN VARCHAR2,
152 p_forwardee_user_name IN VARCHAR2,
153 p_error_message OUT NOCOPY VARCHAR2);
154
155 /***********************************
156 DEBUGGING PROCEDURES AND FUNCTIONS
157 ************************************/
158
159 PROCEDURE log_string(p_module IN VARCHAR2,
160 p_string IN VARCHAR2);
161
162 PROCEDURE log_string(p_level IN NUMBER,
163 p_current_level IN NUMBER,
164 p_module IN VARCHAR2,
165 p_string IN VARCHAR2);
166
167 FUNCTION getAMEFieldDelimiter RETURN VARCHAR2;
168
169 FUNCTION getAMERecordDelimiter RETURN VARCHAR2;
170
171 FUNCTION get_insertion_list_string(p_insertion_list IN ame_util.insertionsTable2) RETURN VARCHAR2;
172
173 FUNCTION get_insertion_string(p_approver IN ame_util.approverRecord2, p_order IN ame_util.insertionRecord2) RETURN VARCHAR2;
174
175 FUNCTION get_api_insertion_string(p_api_insertion IN VARCHAR2) RETURN VARCHAR2;
176
177 FUNCTION get_authority_string(p_authority IN VARCHAR2) RETURN VARCHAR2;
178
179 FUNCTION get_approval_status_string(p_approval_status IN VARCHAR2) RETURN VARCHAR2;
180
181 FUNCTION get_order_type_string(p_order_type IN VARCHAR2) RETURN VARCHAR2;
182
183 FUNCTION get_parameter_string(p_parameter IN VARCHAR2) RETURN VARCHAR2;
184
185 PROCEDURE user_approve(p_auction_header_id IN NUMBER,
186 p_user_name IN VARCHAR2);
187
188 PROCEDURE user_reject(p_auction_header_id IN NUMBER,
189 p_user_name IN VARCHAR2);
190
191 PROCEDURE user_forward(p_auction_header_id IN NUMBER,
192 p_user_name IN VARCHAR2,
193 p_forwardee_user_name IN VARCHAR2);
194
195 PROCEDURE user_approve_and_forward(p_auction_header_id IN NUMBER,
196 p_user_name IN VARCHAR2,
197 p_forwardee_user_name IN VARCHAR2);
198
199 END PON_AWARD_APPROVAL_PKG;