1 PACKAGE PO_WF_PO_ACCRUAL_ACC AUTHID CURRENT_USER AS
2 /* $Header: POXWPAAS.pls 120.2 2010/04/02 19:10:28 ssreekum 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 -- Bug 8498318 Added the below procedure to retrieve the FSIO
107 -- Accrual Account if applicable.
108
109 -- FSIO_AA_FOR_EXPENSE_ITEM
110 -- Get the Accrual Account for EXPENSE destination type from FSIO.
111 -- This holds good only in case FV is installed, else, existing accounts
112 -- will be retained. A call would be made to FV and it will be done using
113 -- dynamic sql. This is done because in case FV is not installed, the procedure
114 -- might not exist. In this case, dynamic call will silently die, does not throw
115 -- any error. We do not RAISE the error in the exception block.
116 -- IN
117 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
118 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
119 -- actid - ID no. of activity this process is called from.
120 -- funcmode - Run/Cancel
121 -- OUT
122 -- Result
123 -- FAILURE - Account generation failed
124 -- SUCCESS - Account generation successful
125 --
126 procedure FSIO_AA_for_expense_item (itemtype in varchar2,
127 itemkey in varchar2,
128 actid in number,
129 funcmode in varchar2,
130 result out NOCOPY varchar2);
131
132 end PO_WF_PO_ACCRUAL_ACC;