1 PACKAGE por_approval_list AS
2 /* $Header: PORAPRLS.pls 120.1 2006/06/28 06:25:32 mkohale noship $ */
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 NOCOPY NUMBER,
12 p_last_update_date OUT NOCOPY VARCHAR2,
13 p_approval_list_string OUT NOCOPY VARCHAR2,
14 p_approval_list_count OUT NOCOPY NUMBER,
15 p_quote_char OUT NOCOPY VARCHAR2,
16 p_field_delimiter OUT NOCOPY VARCHAR2,
17 p_return_code OUT NOCOPY NUMBER,
18 p_error_stack_string OUT NOCOPY VARCHAR2,
19 p_preparer_can_approve OUT NOCOPY NUMBER,
20 p_append_saved_approver_flag IN NUMBER DEFAULT NULL,
21 p_checkout_flow_type IN VARCHAR2 DEFAULT NULL);
22
23
24 PROCEDURE save_approval_list(p_document_id IN NUMBER,
25 p_approval_list_string IN VARCHAR2,
26 p_approval_list_header_id IN OUT NOCOPY NUMBER,
27 p_first_approver_id IN NUMBER,
28 p_last_update_date IN OUT NOCOPY VARCHAR2,
29 p_quote_char IN VARCHAR2,
30 p_field_delimiter IN VARCHAR2,
31 p_return_code OUT NOCOPY NUMBER,
32 p_error_stack_string OUT NOCOPY VARCHAR2);
33
34 PROCEDURE temp_get_rebuild_to_work(p_document_id IN NUMBER);
35
36 procedure copy_approval_list(p_existing_requisition_id IN NUMBER,
37 p_new_requisition_id IN NUMBER);
38
39 END por_approval_list;