1 PACKAGE PO_WF_PO_ACCRUAL_ACC AUTHID CURRENT_USER AS
2 /* $Header: POXWPAAS.pls 115.2 2003/08/22 01:08:32 pthapliy ship $ */
3
4 /*=======================================================================+
5 | FILENAME
6 | POXWPAAS.pls
7 |
8 | DESCRIPTION
9 | PL/SQL spec for package: PO_WF_PO_ACCRUAL_ACC
10 |
11 | NOTES
12 | MODIFIED IMRAN ALI (09/08/97) - Created
13 *=====================================================================*/
14
15 --
16 -- Check Destination Type
17 -- Use work item attribute to determine this ( destination_type_code ).
18 -- IN
19 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
20 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
21 -- funcmode - Run/Cancel
22 -- OUT
23 -- Result
24 -- EXPENSE
25 -- INVENTORY
26 -- SHOP_FLOOR
27
28 procedure destination_type ( itemtype in varchar2,
29 itemkey in varchar2,
30 actid in number,
31 funcmode in varchar2,
32 result out NOCOPY varchar2 );
33 --
34
35 --
36 -- AA_FROM_ORG
37 -- Get the AA from the organization level.
38 -- IN
39 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
40 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
41 -- actid - ID no. of activity this process is called from.
42 -- funcmode - Run/Cancel
43 -- OUT
44 -- Result
45 -- FAILURE - Account generation failed
46 -- SUCCESS - Account generation successful
47 --
48 procedure AA_from_org ( itemtype in varchar2,
49 itemkey in varchar2,
50 actid in number,
51 funcmode in varchar2,
52 result out NOCOPY varchar2 );
53 --
54
55 --
56 -- AA_FOR_EXPENSE_ITEM
57 -- Get the Accrual Account for EXPENSE destination type.
58 -- IN
59 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
60 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
61 -- actid - ID no. of activity this process is called from.
62 -- funcmode - Run/Cancel
63 -- OUT
64 -- Result
65 -- FAILURE - Account generation failed
66 -- SUCCESS - Account generation successful
67 --
68 procedure AA_for_expense_item ( itemtype in varchar2,
69 itemkey in varchar2,
70 actid in number,
71 funcmode in varchar2,
72 result out NOCOPY varchar2 );
73 --
74
75 --
76 -- IS_PO_PROJECT_RELATED
77 --
78 -- IN
79 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
80 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
81 -- actid - ID no. of activity this process is called from.
82 -- funcmode - Run/Cancel
83 -- OUT
84 -- Result
85 -- TRUE
86 -- FALSE
87 --
88 procedure is_po_project_related ( itemtype in varchar2,
89 itemkey in varchar2,
90 actid in number,
91 funcmode in varchar2,
92 result out NOCOPY varchar2 );
93 --
94
95 --< Shared Proc FPJ Start >
96
97 PROCEDURE get_SPS_accrual_account
98 (itemtype IN VARCHAR2,
99 itemkey IN VARCHAR2,
100 actid IN NUMBER,
101 funcmode IN VARCHAR2,
102 result OUT NOCOPY VARCHAR2);
103
104 --< Shared Proc FPJ End >
105
106 end PO_WF_PO_ACCRUAL_ACC;