1 PACKAGE CSTPSCWF AUTHID CURRENT_USER AS
2 /* $Header: CSTSCWFS.pls 115.4 2002/11/11 23:53:08 awwang ship $ */
3
4 -- FUNCTION
5 -- START_STD_WF Calls the appropriate Standard 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_SUBINV varchar2
19 -- X_CG_ID number
20 -- X_RES_ID IN number
21
22 -- OUTPUT PARAMETERS
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_STD_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_SUBINV IN VARCHAR2,
40 X_CG_ID IN NUMBER,
41 X_RES_ID IN NUMBER,
42 X_ERR_NUM OUT NOCOPY NUMBER,
43 X_ERR_CODE OUT NOCOPY VARCHAR2,
44 X_ERR_MSG OUT NOCOPY VARCHAR2)
45 RETURN integer ;
46
47 -- Name
48 -- GET_STD_CE
49 -- Purpose
50 -- Returns Cost Element ID.
51 -- Arguments
52 -- Internal Name for the WF Item Type
53 -- WF Item Key
54 -- ID Number of the WF activity
55 -- Result
56
57 PROCEDURE GET_STD_CE(ITEMTYPE IN VARCHAR2,
58 ITEMKEY IN VARCHAR2,
59 ACTID IN NUMBER,
60 FUNCMODE IN VARCHAR2,
61 RESULT OUT NOCOPY VARCHAR2);
62
63 -- Name
64 -- GET_DEF_ACC
65 -- Purpose
66 -- Returns -1 for default accounts.
67 -- Arguments
68 -- Internal Name for the WF Item Type
69 -- WF Item Key
70 -- ID Number of the WF activity
71 -- Result
72
73 PROCEDURE GET_DEF_ACC(ITEMTYPE IN VARCHAR2,
74 ITEMKEY IN VARCHAR2,
75 ACTID IN NUMBER,
76 FUNCMODE IN VARCHAR2,
77 RESULT OUT NOCOPY VARCHAR2);
78
79
80 -- Name
81 -- GET_STD_MTL_PLA
82 -- Purpose
83 -- Returns Material Product line Account for Standard Costing.
84 -- Arguments
85 -- Internal Name for the WF Item Type
86 -- WF Item Key
87 -- ID Number of the WF activity
88 -- Result
89
90 PROCEDURE GET_STD_MTL_PLA(ITEMTYPE IN VARCHAR2,
91 ITEMKEY IN VARCHAR2,
92 ACTID IN NUMBER,
93 FUNCMODE IN VARCHAR2,
94 RESULT OUT NOCOPY VARCHAR2);
95
96
97 -- Name
98 -- GET_STD_MO_PLA
99 -- Purpose
100 -- Returns Material Overhead Product line Account for Standard Costing.
101 -- Arguments
102 -- Internal Name for the WF Item Type
103 -- WF Item Key
104 -- ID Number of the WF activity
105 -- Result
106
107 PROCEDURE GET_STD_MO_PLA(ITEMTYPE IN VARCHAR2,
108 ITEMKEY IN VARCHAR2,
109 ACTID IN NUMBER,
110 FUNCMODE IN VARCHAR2,
111 RESULT OUT NOCOPY VARCHAR2);
112
113 -- Name
114 -- GET_STD_RES_PLA
115 -- Purpose
116 -- Returns Resource Product line Account for Standard Costing.
117 -- Arguments
118 -- Internal Name for the WF Item Type
119 -- WF Item Key
120 -- ID Number of the WF activity
121 -- Result
122
123 PROCEDURE GET_STD_RES_PLA(ITEMTYPE IN VARCHAR2,
124 ITEMKEY IN VARCHAR2,
125 ACTID IN NUMBER,
126 FUNCMODE IN VARCHAR2,
127 RESULT OUT NOCOPY VARCHAR2);
128
129 -- Name
130 -- GET_STD_OSP_PLA
131 -- Purpose
132 -- Returns Outside Processing Product line Account for Standard Costing.
133 -- Arguments
134 -- Internal Name for the WF Item Type
135 -- WF Item Key
136 -- ID Number of the WF activity
137 -- Result
138
139 PROCEDURE GET_STD_OSP_PLA(ITEMTYPE IN VARCHAR2,
140 ITEMKEY IN VARCHAR2,
141 ACTID IN NUMBER,
142 FUNCMODE IN VARCHAR2,
143 RESULT OUT NOCOPY VARCHAR2);
144
145 -- Name
146 -- GET_STD_OVH_PLA
147 -- Purpose
148 -- Returns Overhead Product line Account for Standard Costing.
149 -- Arguments
150 -- Internal Name for the WF Item Type
151 -- WF Item Key
152 -- ID Number of the WF activity
153 -- Result
154
155 PROCEDURE GET_STD_OVH_PLA(ITEMTYPE IN VARCHAR2,
156 ITEMKEY IN VARCHAR2,
157 ACTID IN NUMBER,
158 FUNCMODE IN VARCHAR2,
159 RESULT OUT NOCOPY VARCHAR2);
160
161 END CSTPSCWF;