1 PACKAGE pay_pst_utils AUTHID CURRENT_USER AS
2 /* $Header: pypstutl.pkh 120.0 2006/06/07 02:14:40 exjones noship $ */
3 --
4 /* Batch Functions */
5 FUNCTION batch_status(p_batch_id IN NUMBER) RETURN VARCHAR2;
6 FUNCTION percent_complete(p_batch_id IN NUMBER) RETURN NUMBER;
7 FUNCTION process_status(p_batch_id IN NUMBER) RETURN VARCHAR2;
8 FUNCTION total_lines(p_batch_id IN NUMBER) RETURN NUMBER;
9 FUNCTION can_update(p_batch_id IN NUMBER) RETURN VARCHAR2;
10 FUNCTION date_started(p_batch_id IN NUMBER) RETURN DATE;
11 FUNCTION parameter_group(p_batch_id IN NUMBER) RETURN VARCHAR2;
12 FUNCTION validate_only(p_batch_id IN NUMBER) RETURN VARCHAR2;
13 FUNCTION date_completed(p_batch_id IN NUMBER) RETURN DATE;
14 FUNCTION completion_text(p_batch_id IN NUMBER) RETURN VARCHAR2;
15 FUNCTION process_phase(p_batch_id IN NUMBER) RETURN VARCHAR2;
16 FUNCTION last_batch_exception(p_batch_id IN NUMBER) RETURN VARCHAR2;
17 FUNCTION display_view_errors(p_batch_id IN NUMBER) RETURN NUMBER;
18 FUNCTION last_process_date(p_batch_id IN NUMBER) RETURN DATE;
19 --
20 /* API Functions */
21 FUNCTION module_name(p_batch_id IN NUMBER,p_api_id IN NUMBER) RETURN VARCHAR2;
22 FUNCTION module_status(p_batch_id IN NUMBER,p_api_id IN NUMBER) RETURN VARCHAR2;
23 FUNCTION api_unprocessed(p_batch_id IN NUMBER,p_api_id IN NUMBER) RETURN NUMBER;
24 FUNCTION api_validated(p_batch_id IN NUMBER,p_api_id IN NUMBER) RETURN NUMBER;
25 FUNCTION api_error(p_batch_id IN NUMBER,p_api_id IN NUMBER) RETURN NUMBER;
26 FUNCTION api_complete(p_batch_id IN NUMBER,p_api_id IN NUMBER) RETURN NUMBER;
27 --
28 END pay_pst_utils;