1 PACKAGE PO_WF_PO_VARIANCE_ACC AUTHID CURRENT_USER AS
2 /* $Header: POXWPVAS.pls 115.4 2003/10/17 02:57:30 axian ship $ */
3
4 /*=======================================================================+
5 | FILENAME
6 | POXWPVAS.pls
7 |
8 | DESCRIPTION
9 | PL/SQL spec for package: PO_WF_PO_VARIANCE_ACC
10 |
11 | NOTES
12 | MODIFIED IMRAN ALI (09/09/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 -- VA_FROM_ORG
37 -- Get the VA 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 VA_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 -- IS_PO_PROJECT_RELATED
57 --
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 -- TRUE
66 -- FALSE
67 --
68 procedure is_po_project_related ( itemtype in varchar2,
69 itemkey in varchar2,
70 actid in number,
71 funcmode in varchar2,
72 result out NOCOPY varchar2 );
73 --
74
75 --
76 -- GET_CHARGE_ACCOUNT
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 -- SUCCESS
86 -- FAILURE
87 --
88 procedure get_charge_account ( itemtype in varchar2,
89 itemkey in varchar2,
90 actid in number,
91 funcmode in varchar2,
92 result out NOCOPY varchar2 );
93 --
94
95
96 --< Shared Proc FPJ Start >
97
98 PROCEDURE is_dest_variance_acc_null
99 (itemtype IN VARCHAR2,
100 itemkey IN VARCHAR2,
101 actid IN NUMBER,
102 funcmode IN VARCHAR2,
103 result OUT NOCOPY VARCHAR2);
104
105 PROCEDURE get_destination_charge_account
106 (itemtype IN VARCHAR2,
107 itemkey IN VARCHAR2,
108 actid IN NUMBER,
109 funcmode IN VARCHAR2,
110 result OUT NOCOPY VARCHAR2);
111
112 PROCEDURE dest_VA_from_org
113 (itemtype IN VARCHAR2,
114 itemkey IN VARCHAR2,
115 actid IN NUMBER,
116 funcmode IN VARCHAR2,
117 result OUT NOCOPY VARCHAR2);
118
119 --< Shared Proc FPJ End >
120
121 end PO_WF_PO_VARIANCE_ACC;