1 PACKAGE PO_WF_PO_BUDGET_ACC AUTHID CURRENT_USER AS
2 /* $Header: POXWPBAS.pls 115.2 2002/11/22 22:07:42 sbull ship $ */
3
4 /*=======================================================================+
5 | FILENAME
6 | POXWPBAS.pls
7 |
8 | DESCRIPTION
9 | PL/SQL spec for package: PO_WF_PO_BUDGET_ACC
10 |
11 | NOTES
12 | MODIFIED IMRAN ALI (09/03/97) - Created
13 *=====================================================================*/
14
15 --
16 -- BA_FROM_ITEM_SUB
17 -- Get the BA from item/subinventory relationship set.
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 -- actid - ID no. of activity this process is called from.
22 -- funcmode - Run/Cancel
23 -- OUT
24 -- Result
25 -- FAILURE - Account generation failed
26 -- SUCCESS - Account generation successful
27 --
28 -- DESCRIPTION
29 -- Retrieve the budget account from the item/subinventory relationship set.
30 -- Only use this if the destination type is inventory, and the subinventory
31 -- is provided.
32
33 procedure BA_from_item_sub ( itemtype in varchar2,
34 itemkey in varchar2,
35 actid in number,
36 funcmode in varchar2,
37 result out NOCOPY varchar2 );
38
39 --
40
41 --
42 -- PRE_DEFINED_ITEM
43 -- Is the item a pre-defined item in the item master (item id is not NULL)
44 -- IN
45 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
46 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
47 -- actid - ID no. of activity this process is called from.
48 -- funcmode - Run/Cancel
49 -- OUT
50 -- Result
51 -- TRUE - Item is a pre-defined item.
52 -- FALSE - Item is not a pre-defined item.
53 --
54 procedure pre_defined_item ( itemtype in varchar2,
55 itemkey in varchar2,
56 actid in number,
57 funcmode in varchar2,
58 result out NOCOPY varchar2 );
59 --
60
61 --
62 -- GET_ITEM_BA
63 -- Get the Budget Account for the item.
64 -- IN
65 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
66 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
67 -- actid - ID no. of activity this process is called from.
68 -- funcmode - Run/Cancel
69 -- OUT
70 -- Result
71 -- FAILURE - Account generation failed
72 -- SUCCESS - Account generation successful
73 --
74 procedure get_item_BA ( itemtype in varchar2,
75 itemkey in varchar2,
76 actid in number,
77 funcmode in varchar2,
78 result out NOCOPY varchar2 );
79
80 --
81
82 --
83 -- GET_ORG_BA
84 -- Get the Budget Account for the Org.
85 -- IN
86 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
87 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
88 -- actid - ID no. of activity this process is called from.
89 -- funcmode - Run/Cancel
90 -- OUT
91 -- Result
92 -- FAILURE - Account generation failed
93 -- SUCCESS - Account generation successful
94 --
95 procedure get_org_BA ( itemtype in varchar2,
96 itemkey in varchar2,
97 actid in number,
98 funcmode in varchar2,
99 result out NOCOPY varchar2 );
100 --
101
102 --
103 -- GET_CHARGE_ACCOUNT
104 -- Use Charge Account as Budget Account
105 -- IN
106 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
107 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
108 -- actid - ID no. of activity this process is called from.
109 -- funcmode - Run/Cancel
110 -- OUT
111 -- Result
112 -- FAILURE - Account generation failed
113 -- SUCCESS - Account generation successful
114 --
115 procedure get_charge_account ( itemtype in varchar2,
116 itemkey in varchar2,
117 actid in number,
118 funcmode in varchar2,
119 result out NOCOPY varchar2 );
120 --
121
122 --
123 -- IS_PO_PROJECT_RELATED
124 --
125 -- IN
126 -- itemtype - A valid item type from (WF_ITEM_TYPES table).
127 -- itemkey - A string generated by call to AOL's INITIALIZE routine.
128 -- actid - ID no. of activity this process is called from.
129 -- funcmode - Run/Cancel
130 -- OUT
131 -- Result
132 -- TRUE
133 -- FALSE
134 --
135 procedure is_po_project_related ( itemtype in varchar2,
136 itemkey in varchar2,
137 actid in number,
138 funcmode in varchar2,
139 result out NOCOPY varchar2 );
140 --
141
142
143 PROCEDURE debug_on;
144
145 PROCEDURE debug_off;
146
147 end PO_WF_PO_BUDGET_ACC;