1 PACKAGE PO_WF_PO_RULE_ACC AUTHID CURRENT_USER AS
2 /* $Header: POXRUACS.pls 120.0.12020000.2 2013/04/09 05:55:52 vsdesai ship $*/
3
4 TYPE t_segment_record IS RECORD (
5 segment_name VARCHAR2(30),
6 SEGMENT_VALUE VARCHAR2(25),
7 segment_num NUMBER(3)
8 );
9
10 TYPE t_segment_table IS TABLE OF t_segment_record INDEX BY BINARY_INTEGER;
11
12 PROCEDURE get_default_requester_acc ( itemtype in varchar2,
13 itemkey in varchar2,
14 actid in number,
15 funcmode in varchar2,
16 result out NOCOPY varchar2 );
17
18 PROCEDURE get_favorite_charge_acc ( itemtype in varchar2,
19 itemkey in varchar2,
20 actid in number,
21 funcmode in varchar2,
22 result out NOCOPY varchar2);
23
24 PROCEDURE if_enforce_expense_acc_rules( itemtype in varchar2,
25 itemkey in varchar2,
26 actid in number,
27 funcmode in varchar2,
28 result out NOCOPY varchar2);
29
30 PROCEDURE IF_RULE_EXIST_FOR_ALL_SEGMENTS (
31 itemtype in varchar2,
32 itemkey in varchar2,
33 actid in number,
34 funcmode in varchar2,
35 result out NOCOPY varchar2);
36
37
38
39 PROCEDURE get_category_account_segment (itemtype in varchar2,
40 itemkey in varchar2,
41 actid in number,
42 funcmode in varchar2,
43 result out NOCOPY varchar2 );
44
45 PROCEDURE get_segment_records ( itemtype in varchar2,
46 itemkey in varchar2,
47 resultout out NOCOPY varchar2);
48
49 --< Shared Proc FPJ Start >
50 PROCEDURE set_expense_rules_org_as_POU(itemtype IN VARCHAR2,
51 itemkey IN VARCHAR2,
52 actid IN NUMBER,
53 funcmode IN VARCHAR2,
54 result OUT NOCOPY VARCHAR2);
55
56 PROCEDURE set_expense_rules_org_as_DOU(itemtype IN VARCHAR2,
57 itemkey IN VARCHAR2,
58 actid IN NUMBER,
59 funcmode IN VARCHAR2,
60 result OUT NOCOPY VARCHAR2);
61 --< Shared Proc FPJ End >
62
63 -- IS_OVERRIDE_CHARGE_ACCOUNT
64 -- Added for Favorite Charge Account ER
65 -- IN
66 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
67 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
68 -- actid - ID no. of activity this process is called from.
69 -- funcmode - Run/Cancel
70 -- OUT
71 -- RESULT
72 -- YES
73 -- NO
74
75
76 PROCEDURE IS_OVERRIDE_CHARGE_ACCOUNT ( itemtype in varchar2,
77 itemkey in varchar2,
78 actid in NUMBER,
79 funcmode in varchar2,
80 result out NOCOPY VARCHAR2 ) ;
81
82
83 END PO_WF_PO_RULE_ACC;