1 PACKAGE po_forward_sv1 AUTHID CURRENT_USER AS
2 /* $Header: POXAPFOS.pls 120.1 2005/07/22 05:26:40 ppaulsam noship $*/
3 /*===========================================================================
4 PROCEDURE NAME: insert_action_history
5
6 DESCRIPTION: Inserts a record into the po_action_history_table
7
8 PARAMETERS: x_object_id IN NUMBER,
9 x_object_type_code IN VARCHAR2,
10 x_object_sub_type_code IN VARCHAR2,
11 x_sequence_num IN NUMBER,
12 x_action_code IN VARCHAR2,
13 x_action_date IN DATE,
14 x_employee_id IN NUMBER,
15 x_approval_path_id IN NUMBER,
16 x_note IN VARCHAR2,
17 x_object_revision_num IN NUMBER,
18 x_offline_code IN VARCHAR2,
19 x_request_id IN NUMBER,
20 x_program_application_id IN NUMBER,
21 x_program_id IN NUMBER,
22 x_program_date IN DATE,
23 x_program_update_date IN DATE,
24 x_user_id IN NUMBER,
25 x_login_id IN NUMBER);
26
27 DESIGN REFERENCES: POXDOFDO.dd
28
29 ALGORITHM:
30
31 NOTES:
32
33 OPEN ISSUES:
34
35 CLOSED ISSUES:
36
37 CHANGE HISTORY: cmok 5/25 created
38 ===========================================================================*/
39
40 PROCEDURE test_insert_action_history (x_object_id IN NUMBER,
41 x_object_type_code IN VARCHAR2,
42 x_object_sub_type_code IN VARCHAR2,
43 x_sequence_num IN NUMBER,
44 x_action_code IN VARCHAR2,
45 x_action_date IN DATE,
46 x_employee_id IN NUMBER,
47 x_approval_path_id IN NUMBER,
48 x_note IN VARCHAR2,
49 x_object_revision_num IN NUMBER,
50 x_offline_code IN VARCHAR2,
51 x_request_id IN NUMBER,
52 x_program_application_id IN NUMBER,
53 x_program_id IN NUMBER,
54 x_program_date IN DATE,
55 x_user_id IN NUMBER,
56 x_login_id IN NUMBER);
57
58 PROCEDURE insert_action_history (x_object_id IN NUMBER,
59 x_object_type_code IN VARCHAR2,
60 x_object_sub_type_code IN VARCHAR2,
61 x_sequence_num IN NUMBER,
62 x_action_code IN VARCHAR2,
63 x_action_date IN DATE,
64 x_employee_id IN NUMBER,
65 x_approval_path_id IN NUMBER,
66 x_note IN VARCHAR2,
67 x_object_revision_num IN NUMBER,
68 x_offline_code IN VARCHAR2,
69 x_request_id IN NUMBER,
70 x_program_application_id IN NUMBER,
71 x_program_id IN NUMBER,
72 x_program_date IN DATE,
73 x_user_id IN NUMBER,
74 x_login_id IN NUMBER);
75
76 -- Added as part of iProcurement R12 AME Integration Phase II Project.
77 -- Added one more input parameter x_approval_group_id.
78 PROCEDURE insert_action_history (x_object_id IN NUMBER,
79 x_object_type_code IN VARCHAR2,
80 x_object_sub_type_code IN VARCHAR2,
81 x_sequence_num IN NUMBER,
82 x_action_code IN VARCHAR2,
83 x_action_date IN DATE,
84 x_employee_id IN NUMBER,
85 x_approval_path_id IN NUMBER,
86 x_note IN VARCHAR2,
87 x_object_revision_num IN NUMBER,
88 x_offline_code IN VARCHAR2,
89 x_request_id IN NUMBER,
90 x_program_application_id IN NUMBER,
91 x_program_id IN NUMBER,
92 x_program_date IN DATE,
93 x_user_id IN NUMBER,
94 x_login_id IN NUMBER,
95 x_approval_group_id IN NUMBER);
96
97 /*===========================================================================
98 PROCEDURE NAME: insert_all_action_history
99
100 DESCRIPTION: This procedure is called by the forward documents
101 form when all documents in one approval queue is
102 forwarded to another approval queue. For each
103 existing record in po_action_history that has
104 employee_id = old_approver_id and null action code, it
105 inserts a new record with new_approver_id.
106 The action_date, action_code and note fields in this new
107 record are null.
108
109 PARAMETERS: x_old_employee_id IN NUMBER,
110 x_new_employee_id IN NUMBER,
111 x_offline_code IN VARCHAR2,
112 x_user_id IN NUMBER,
113 x_login_id IN NUMBER
114
115 DESIGN REFERENCES: POXDOFDO.dd
116
117 ALGORITHM:
118
119 NOTES:
120
121 OPEN ISSUES:
122
123 CLOSED ISSUES:
124
125 CHANGE HISTORY: cmok 5/25 created
126 ===========================================================================*/
127
128 PROCEDURE test_insert_all_action_history (x_old_employee_id IN NUMBER,
129 x_new_employee_id IN NUMBER,
130 x_offline_code IN VARCHAR2,
131 x_user_id IN NUMBER,
132 x_login_id IN NUMBER);
133
134 PROCEDURE insert_all_action_history (x_old_employee_id IN NUMBER,
135 x_new_employee_id IN NUMBER,
136 x_offline_code IN VARCHAR2,
137 x_user_id IN NUMBER,
138 x_login_id IN NUMBER);
139
140 /*===========================================================================
141 PROCEDURE NAME: update_action_history
142
143 DESCRIPTION: This procedure is called when selective documents in
144 an approval queue are forwarded. It updates the
145 existing record in po_action_history that has
146 old_approver_id and NULL action_code with action_code
147 'FORWARD'. It also clears the field offline_code
148 if value is other than 'PRINTED'.
149
150 PARAMETERS: x_object_id IN NUMBER,
151 x_object_type_code IN VARCHAR2,
152 x_old_employee_id IN NUMBER,
153 x_action_code IN VARCHAR2,
154 x_note IN VARCHAR2,
155 x_user_id IN NUMBER,
156 x_login_id IN NUMBER
157
158 DESIGN REFERENCES: POXDOFDO.dd
159
160 ALGORITHM:
161
162 NOTES:
163
164 OPEN ISSUES:
165
166 CLOSED ISSUES:
167
168 CHANGE HISTORY: cmok 5/25 created
169 ===========================================================================*/
170
171 PROCEDURE update_action_history (x_object_id IN NUMBER,
172 x_object_type_code IN VARCHAR2,
173 x_old_employee_id IN NUMBER,
174 x_action_code IN VARCHAR2,
175 x_note IN VARCHAR2,
176 x_user_id IN NUMBER,
177 x_login_id IN NUMBER);
178
179 /*===========================================================================
180 PROCEDURE NAME: update_all_action_history
181
182 DESCRIPTION: This procedure is called by the forward documents
183 form when all documents in one approval queue is
184 forwarded to another approval queue. It updates all
185 existing records in po_action_history that has
186 old_approver_id and NULL action_code with action_code
187 'FORWARD'. It also clears the field offline_code
188 if it does not have value 'PRINTED'.
189
190 PARAMETERS: x_old_employee_id IN NUMBER,
191 x_note IN VARCHAR2,
192 x_user_id IN NUMBER,
193 x_login_id IN NUMBER
194
195 DESIGN REFERENCES: POXDOFDO.dd
196
197 ALGORITHM:
198
199 NOTES:
200
201 OPEN ISSUES:
202
203 CLOSED ISSUES:
204
205 CHANGE HISTORY: cmok 5/25 created
206 ===========================================================================*/
207
208 PROCEDURE test_update_all_action_history (x_old_employee_id IN NUMBER,
209 x_note IN VARCHAR2,
210 x_user_id IN NUMBER,
211 x_login_id IN NUMBER);
212
213 PROCEDURE update_all_action_history (x_old_employee_id IN NUMBER,
214 x_note IN VARCHAR2,
215 x_user_id IN NUMBER,
216 x_login_id IN NUMBER);
217
218 /*===========================================================================
219 PROCEDURE NAME: update_all_action_history
220
221 DESCRIPTION: Locks record in po_action_history. Uses the value
222 of last_update_date to determine whether record
223 has changed.
224
225 PARAMETERS: x_rowid VARCHAR2,
226 x_last_update_date DATE
227
228 DESIGN REFERENCES: POXDOFDO.dd
229
230 ALGORITHM:
231
232 NOTES:
233
234 OPEN ISSUES:
235
236 CLOSED ISSUES:
237
238 CHANGE HISTORY: cmok 5/25 created
239 ===========================================================================*/
240
241 PROCEDURE lock_row (x_rowid VARCHAR2,
242 x_last_update_date DATE);
243
244 END po_forward_sv1;