1 PACKAGE pay_progress_pkg AUTHID CURRENT_USER AS
2 -- $Header: pyprogpk.pkh 120.0.12010000.1 2008/07/27 23:27:24 appldev ship $
3 --
4 -- Record to return progress info to the 'client' be it a Form
5 -- or another PL/SQL block which we use to create a portlet or
6 -- whatever.
7 -- Sending back a whole record means that changing the information
8 -- here won't break existing clients. As long as we only add
9 -- fields and don't delete what was originally here.
10 --
11 TYPE progress_info_r IS RECORD(
12 timestamp NUMBER,
13 run_description VARCHAR2(240),
14 completed NUMBER,
15 in_error NUMBER,
16 marked_for_retry NUMBER,
17 unprocessed NUMBER,
18 start_time DATE,
19 elapsed_time NUMBER,
20 completion_time DATE,
21 process_rate NUMBER,
22 time_remaining NUMBER,
23 time_per_assignment NUMBER,
24 assignments_per_hour NUMBER,
25 percent_complete NUMBER,
26 percent_in_error NUMBER,
27 message VARCHAR2(240)
28 );
29 --
30 -- Calculate the progress of the supplied payroll action, or update the progress
31 -- of the last payroll action we asked for (if the parameter is NULL or not passed).
32 -- Return a record containing all the progress information.
33 --
34 FUNCTION current_progress(p_payroll_action_id IN NUMBER DEFAULT NULL) RETURN progress_info_r;
35 --
36 END pay_progress_pkg;
[Home] [Help]