[Home] [Help]
PACKAGE: APPS.CSTPFCHK
Source
1 PACKAGE CSTPFCHK AUTHID CURRENT_USER AS
2 --$Header: CSTFCHKS.pls 120.1.12010000.3 2008/11/10 13:14:27 anjha ship $
3 --+==========================================================================+
4 --| Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5 --| All rights reserved. |
6 --+==========================================================================+
7 --| |
8 --| File Name : CSTFCHKS.pls |
9 --| Description : Cost Method specific processing extension |
10 --| |
11 --| Revision |
12 --| 11/12/98 Jung Ha Creation |
13 --| 10/11/04 vjavli OUT NOCOPY added for GSSC std |
14 --| 10/12/2004 vjavli Header correction for proper version from mainline |
15 --| 11.5.8 |
16 --| 02/07/2008 vjavli Bug 6751847 performance fix: added parameter |
17 --| txn_category in procedures compute_pac_cost_hook, |
18 --| calc_pac_cost_hook, and periodic_cost_update_hook |
19 --+==========================================================================+
20
21 -- FUNCTION
22 -- compute_pac_cost_hook
23 --
24 function compute_pac_cost_hook(
25 I_PAC_PERIOD_ID IN NUMBER,
26 I_ORG_ID IN NUMBER,
27 I_COST_GROUP_ID IN NUMBER,
28 I_COST_TYPE_ID IN NUMBER,
29 I_TXN_ID IN NUMBER,
30 I_COST_LAYER_ID IN NUMBER,
31 I_PAC_RATES_ID IN NUMBER,
32 I_ITEM_ID IN NUMBER,
33 I_TXN_QTY IN NUMBER,
34 I_TXN_ACTION_ID IN NUMBER,
35 I_TXN_SRC_TYPE_ID IN NUMBER,
36 I_INTERORG_REC IN NUMBER,
37 I_ACROSS_CGS IN NUMBER,
38 I_EXP_FLAG IN NUMBER,
39 I_USER_ID IN NUMBER,
40 I_LOGIN_ID IN NUMBER,
41 I_REQ_ID IN NUMBER,
42 I_PRG_APPL_ID IN NUMBER,
43 I_PRG_ID IN NUMBER,
44 I_TXN_CATEGORY IN NUMBER,
45 O_Err_Num OUT NOCOPY NUMBER,
46 O_Err_Code OUT NOCOPY VARCHAR2,
47 O_Err_Msg OUT NOCOPY VARCHAR2
48 )
49 return integer;
50
51
52
53 -- PROCEDURE
54 -- calc_pac_cost_hook
55 --
56 procedure calc_pac_cost_hook(
57 I_PAC_PERIOD_ID IN NUMBER,
58 I_COST_GROUP_ID IN NUMBER,
59 I_COST_TYPE_ID IN NUMBER,
60 I_TXN_ID IN NUMBER,
61 I_COST_LAYER_ID IN NUMBER,
62 I_QTY_LAYER_ID IN NUMBER,
63 I_ITEM_ID IN NUMBER,
64 I_TXN_QTY IN NUMBER,
65 I_ISSUE_QTY IN NUMBER,
66 I_BUY_QTY IN NUMBER,
67 I_MAKE_QTY IN NUMBER,
68 I_USER_ID IN NUMBER,
69 I_LOGIN_ID IN NUMBER,
70 I_REQ_ID IN NUMBER,
71 I_PRG_APPL_ID IN NUMBER,
72 I_PRG_ID IN NUMBER,
73 I_TXN_CATEGORY IN NUMBER,
74 O_Err_Num OUT NOCOPY NUMBER,
75 O_Err_Code OUT NOCOPY VARCHAR2,
76 O_Err_Msg OUT NOCOPY VARCHAR2
77 );
78
79
80
81 -- PROCEDURE
82 -- current_pac_cost_hook
83 --
84 procedure current_pac_cost_hook(
85 I_COST_LAYER_ID IN NUMBER,
86 I_QTY_LAYER_ID IN NUMBER,
87 I_TXN_QTY IN NUMBER,
88 I_ISSUE_QTY IN NUMBER,
89 I_BUY_QTY IN NUMBER,
90 I_MAKE_QTY IN NUMBER,
91 I_TXN_ACTION_ID IN NUMBER,
92 I_EXP_FLAG IN NUMBER,
93 I_NO_UPDATE_QTY IN NUMBER,
94 I_USER_ID IN NUMBER,
95 I_LOGIN_ID IN NUMBER,
96 I_REQ_ID IN NUMBER,
97 I_PRG_APPL_ID IN NUMBER,
98 I_PRG_ID IN NUMBER,
99 O_Err_Num OUT NOCOPY NUMBER,
100 O_Err_Code OUT NOCOPY VARCHAR2,
101 O_Err_Msg OUT NOCOPY VARCHAR2
102 );
103
104
105 FUNCTION pac_wip_issue_cost_hook(
106 I_PAC_PERIOD_ID IN NUMBER,
107 I_ORG_ID IN NUMBER,
108 I_COST_GROUP_ID IN NUMBER,
109 I_COST_TYPE_ID IN NUMBER,
110 I_COST_METHOD IN NUMBER,
111 I_TXN_ID IN NUMBER,
112 I_COST_LAYER_ID IN NUMBER,
113 I_QTY_LAYER_ID IN NUMBER,
114 I_PAC_RATES_ID IN NUMBER,
115 I_ITEM_ID IN NUMBER,
116 I_PRI_QTY IN NUMBER,
117 I_TXN_ACTION_ID IN NUMBER,
118 I_ENTITY_ID IN NUMBER,
119 I_LINE_ID IN NUMBER,
120 I_OP_SEQ IN NUMBER,
121 I_EXP_FLAG IN NUMBER,
122 I_USER_ID IN NUMBER,
123 I_LOGIN_ID IN NUMBER,
124 I_REQ_ID IN NUMBER,
125 I_PRG_APPL_ID IN NUMBER,
126 I_PRG_ID IN NUMBER,
127 O_Err_Num OUT NOCOPY NUMBER,
128 O_Err_Code OUT NOCOPY VARCHAR2,
129 O_Err_Msg OUT NOCOPY VARCHAR2
130 )
131 return integer;
132
133 -- PROCEDURE
134 -- copy_prior_info_hook
135 --
136 procedure copy_prior_info_hook(
137 I_PAC_PERIOD_ID IN NUMBER,
138 I_PRIOR_PAC_PERIOD_ID IN NUMBER,
139 I_LEGAL_ENTITY IN NUMBER,
140 I_COST_TYPE_ID IN NUMBER,
141 I_COST_GROUP_ID IN NUMBER,
142 I_COST_METHOD IN NUMBER,
143 I_USER_ID IN NUMBER,
144 I_LOGIN_ID IN NUMBER,
145 I_REQUEST_ID IN NUMBER,
146 I_PROG_APP_ID IN NUMBER,
147 I_PROG_ID IN NUMBER,
148 O_Err_Num OUT NOCOPY NUMBER,
149 O_Err_Code OUT NOCOPY VARCHAR2,
150 O_Err_Msg OUT NOCOPY VARCHAR2
151 );
152
153 -- ===================================================
154 -- Periodic Cost Update invoked for Incremental LIFO.
155 -- The procedure is a copy from BOM115100 inorder to
156 -- prevent regression. The regression is due to
157 -- cppb insert/update introduced in R12 code
158 -- ===================================================
159 PROCEDURE periodic_cost_update_hook (
160 I_PAC_PERIOD_ID IN NUMBER,
161 I_COST_GROUP_ID IN NUMBER,
162 I_COST_TYPE_ID IN NUMBER,
163 I_TXN_ID IN NUMBER,
164 I_COST_LAYER_ID IN NUMBER,
165 I_QTY_LAYER_ID IN NUMBER,
166 I_ITEM_ID IN NUMBER,
167 I_USER_ID IN NUMBER,
168 I_LOGIN_ID IN NUMBER,
169 I_REQ_ID IN NUMBER,
170 I_PRG_APPL_ID IN NUMBER,
171 I_PRG_ID IN NUMBER,
172 I_TXN_CATEGORY IN NUMBER,
173 I_TXN_QTY IN NUMBER,
174 O_Err_Num OUT NOCOPY NUMBER,
175 O_Err_Code OUT NOCOPY VARCHAR2,
176 O_Err_Msg OUT NOCOPY VARCHAR2);
177
178 END CSTPFCHK;