1 PACKAGE por_util_pkg2_test AUTHID CURRENT_USER AS
2 /* $Header: PORUTL2S.pls 115.0 99/07/17 03:33:09 porting shi $ */
3
4 g_document_type VARCHAR2(20) := 'REQUISITION';
5 g_document_subtype VARCHAR2(20) := 'PURCHASE';
6
7 PROCEDURE get_approval_list(p_document_id IN NUMBER,
8 p_first_approver_id IN NUMBER DEFAULT NULL,
9 p_default_flag IN NUMBER DEFAULT NULL,
10 p_rebuild_flag IN NUMBER DEFAULT NULL,
11 p_approval_list_header_id OUT NUMBER,
12 p_last_update_date OUT VARCHAR2,
13 p_approval_list_string OUT VARCHAR2,
14 p_approval_list_count OUT NUMBER,
15 p_quote_char OUT VARCHAR2,
16 p_field_delimiter OUT VARCHAR2,
17 p_return_code OUT NUMBER,
18 p_error_stack_string OUT VARCHAR2);
19
20
21 PROCEDURE save_approval_list(p_document_id IN NUMBER,
22 p_approval_list_string IN VARCHAR2,
23 p_approval_list_header_id IN OUT NUMBER,
24 p_first_approver_id IN NUMBER,
25 p_last_update_date IN VARCHAR2,
26 p_quote_char IN VARCHAR2,
27 p_field_delimiter IN VARCHAR2,
28 p_return_code OUT NUMBER,
29 p_error_stack_string OUT VARCHAR2);
30
31 END por_util_pkg2_test;