1 PACKAGE CSTPACWF AUTHID CURRENT_USER AS
2 /* $Header: CSTACWFS.pls 115.3 2002/11/08 01:10:12 awwang ship $ */
3
4 -- FUNCTION
5 -- START_AVG_WF Calls the appropriate Average Costing Workflow process
6 -- based on the accounting line type.
7 --
8 --
9 -- INPUT PARAMETERS
10 -- X_TXN_ID number
11 -- X_TXN_TYPE_ID number
12 -- X_TXN_ACT_ID number
13 -- X_TXN_SRC_TYPE_ID number
14 -- X_ORG_ID number
15 -- X_ITEM_ID number
16 -- X_CE_ID number
17 -- X_ALT number
18 -- X_CG_ID number
19 -- X_RES_ID IN number
20
21 -- OUTPUT PARAMETERS
22
23 -- X_ERR_NUM number -1 for error, 0 for no error
24 -- X_ERR_CODE varchar2 System error code (SQLCODE)
25 -- X_ERR_MSG varchar2 System error message (SQLERRM)
26
27 -- RETURN VALUES
28 -- integer -1 Use default account.
29 -- >0 This is the User defined account.
30
31 FUNCTION START_AVG_WF(X_TXN_ID IN NUMBER,
32 X_TXN_TYPE_ID IN NUMBER,
33 X_TXN_ACT_ID NUMBER,
34 X_TXN_SRC_TYPE_ID IN NUMBER,
35 X_ORG_ID IN NUMBER,
36 X_ITEM_ID IN NUMBER,
37 X_CE_ID IN NUMBER,
38 X_ALT IN NUMBER,
39 X_CG_ID IN NUMBER,
40 X_RES_ID IN NUMBER,
41 X_ERR_NUM OUT NOCOPY NUMBER,
42 X_ERR_CODE OUT NOCOPY VARCHAR2,
43 X_ERR_MSG OUT NOCOPY VARCHAR2)
44 RETURN integer ;
45
46 -- Name
47 -- GET_AVG_CE
48 -- Purpose
49 -- Returns Cost Element ID.
50 -- Arguments
51 -- Internal Name for the WF Item Type
52 -- WF Item Key
53 -- ID Number of the WF activity
54 -- Result
55
56 PROCEDURE GET_AVG_CE(ITEMTYPE IN VARCHAR2,
57 ITEMKEY IN VARCHAR2,
58 ACTID IN NUMBER,
59 FUNCMODE IN VARCHAR2,
60 RESULT OUT NOCOPY VARCHAR2);
61
62 -- Name
63 -- GET_DEF_ACC
64 -- Purpose
65 -- Returns -1 for default accounts.
66 -- Arguments
67 -- Internal Name for the WF Item Type
68 -- WF Item Key
69 -- ID Number of the WF activity
70 -- Result
71
72 PROCEDURE GET_DEF_ACC(ITEMTYPE IN VARCHAR2,
73 ITEMKEY IN VARCHAR2,
74 ACTID IN NUMBER,
75 FUNCMODE IN VARCHAR2,
76 RESULT OUT NOCOPY VARCHAR2);
77
78
79 -- Name
80 -- GET_AVG_MTL_PLA
81 -- Purpose
82 -- Returns Material Product line Account for Average Costing.
83 -- Arguments
84 -- Internal Name for the WF Item Type
85 -- WF Item Key
86 -- ID Number of the WF activity
87 -- Result
88
89 PROCEDURE GET_AVG_MTL_PLA(ITEMTYPE IN VARCHAR2,
90 ITEMKEY IN VARCHAR2,
91 ACTID IN NUMBER,
92 FUNCMODE IN VARCHAR2,
93 RESULT OUT NOCOPY VARCHAR2);
94
95
96 -- Name
97 -- GET_AVG_MO_PLA
98 -- Purpose
99 -- Returns Material Overhead Product line Account for Average Costing.
100 -- Arguments
101 -- Internal Name for the WF Item Type
102 -- WF Item Key
103 -- ID Number of the WF activity
104 -- Result
105
106 PROCEDURE GET_AVG_MO_PLA(ITEMTYPE IN VARCHAR2,
107 ITEMKEY IN VARCHAR2,
108 ACTID IN NUMBER,
109 FUNCMODE IN VARCHAR2,
110 RESULT OUT NOCOPY VARCHAR2);
111
112 -- Name
113 -- GET_AVG_RES_PLA
114 -- Purpose
115 -- Returns Resource Product line Account for Average Costing.
116 -- Arguments
117 -- Internal Name for the WF Item Type
118 -- WF Item Key
119 -- ID Number of the WF activity
120 -- Result
121
122 PROCEDURE GET_AVG_RES_PLA(ITEMTYPE IN VARCHAR2,
123 ITEMKEY IN VARCHAR2,
124 ACTID IN NUMBER,
125 FUNCMODE IN VARCHAR2,
126 RESULT OUT NOCOPY VARCHAR2);
127
128 -- Name
129 -- GET_AVG_OSP_PLA
130 -- Purpose
131 -- Returns Outside Processing Product line Account for Average Costing.
132 -- Arguments
133 -- Internal Name for the WF Item Type
134 -- WF Item Key
135 -- ID Number of the WF activity
136 -- Result
137
138 PROCEDURE GET_AVG_OSP_PLA(ITEMTYPE IN VARCHAR2,
139 ITEMKEY IN VARCHAR2,
140 ACTID IN NUMBER,
141 FUNCMODE IN VARCHAR2,
142 RESULT OUT NOCOPY VARCHAR2);
143
144 -- Name
145 -- GET_AVG_OVH_PLA
146 -- Purpose
147 -- Returns Overhead Product line Account for Average Costing.
148 -- Arguments
149 -- Internal Name for the WF Item Type
150 -- WF Item Key
151 -- ID Number of the WF activity
152 -- Result
153
154 PROCEDURE GET_AVG_OVH_PLA(ITEMTYPE IN VARCHAR2,
155 ITEMKEY IN VARCHAR2,
156 ACTID IN NUMBER,
157 FUNCMODE IN VARCHAR2,
158 RESULT OUT NOCOPY VARCHAR2);
159
160 END CSTPACWF;