1 PACKAGE GCS_ADJ_APPROVAL_WF_PKG AS
2 /* $Header: gcsameintgs.pls 120.0 2007/11/22 01:39:24 rguerrer ship $ */
3 --------------------------------------------------------------------------------
4 -- PUBLIC BODIES
5 --------------------------------------------------------------------------------
6
7 PROCEDURE Fch_Check_Approvals (p_item_type IN VARCHAR2,
8 p_item_key IN varchar2,
9 p_act_id IN NUMBER,
10 p_funcmode IN VARCHAR2,
11 x_result_out out nocopy varchar2);
12
13 PROCEDURE create_gcsadj_process(p_entry_id IN NUMBER
14 ,p_user_id IN NUMBER
15 ,p_user_name IN VARCHAR2
16 ,p_orig_entry_id IN NUMBER
17 ,p_ledger_id IN NUMBER
18 ,p_cal_period_name IN VARCHAR2
19 ,p_conversion_type IN VARCHAR2
20 ,p_writeback_flag IN VARCHAR2
21 ,p_wfitemkey OUT NOCOPY VARCHAR2);
22 --
23 -- PROCEDURE
24 -- GetNextApprover
25 --
26 -- DESCRIPTION
27 -- Gets the next approver for the approval request.
28 --
29 -- IN
30 -- p_item_type - The workflow item type (GCSADJ)
31 -- p_item_key - The workflow request id (ENTRY ID)
32 -- p_act_id - The function activity
33 -- p_func_mode - Run/Cancel/Timeout
34 --
35 -- OUT
36 -- x_result_out - Indicates completion of workflow activity and it's result
37 --------------------------------------------------------------------------------
38
39 PROCEDURE Get_Next_Approver (
40 p_item_type IN VARCHAR2,
41 p_item_key IN VARCHAR2,
42 p_act_id IN NUMBER,
43 p_funcmode IN VARCHAR2,
44 x_result_out out nocopy varchar2);
45
46 PROCEDURE process_approval(p_item_type IN VARCHAR2,
47 p_item_key IN VARCHAR2,
48 p_actid IN NUMBER,
49 p_funcmode IN VARCHAR2,
50 x_result_out OUT NOCOPY VARCHAR2 );
51
52 PROCEDURE process_rejected(p_item_type IN VARCHAR2,
53 p_item_key IN VARCHAR2,
54 p_actid IN NUMBER,
55 p_funcmode IN VARCHAR2,
56 x_result_out OUT NOCOPY VARCHAR2 );
57
58 PROCEDURE update_adjustment(p_item_type IN VARCHAR2,
59 p_item_key IN VARCHAR2,
60 p_actid IN NUMBER,
61 p_funcmode IN VARCHAR2,
62 x_result_out OUT NOCOPY VARCHAR2 );
63
64 END GCS_ADJ_APPROVAL_WF_PKG;