[Home] [Help]
PACKAGE: APPS.MIGRATE_BATCH
Source
1 PACKAGE migrate_batch AS
2 /* $Header: GMEMIGBS.pls 120.1 2005/06/09 08:26:06 appldev $ */
3
4 /***********************************************************/
5 /* Oracle Process Manufacturing Process Execution APIs */
6 /* */
7 /* File Name: GMEMIGBS.pls */
8 /* Contents: Package specification for migration */
9 /* Author: Shrikant Nene */
10 /* Date: January 2001 */
11 /* */
12 /* History */
13 /* ======= */
14 /* 05-JUL-01 Thomas Daniel */
15 /* Added code to process on batch entity row at a time*/
16 /* also added code to write error messages on the */
17 /* occurence of an error */
18 /* 12-NOV-01 Thomas Daniel */
19 /* Added the split_trans_line and is_reversal routines to */
20 /* split the completed default lot line */
21 /* 15-NOV-01 Pawan Kumar Addfunction check product */
22 /* */
23 /* 12-DEC-01 Shyam Sitaraman */
24 /* 1) Created a backup for insert_message */
25 /* => insert_message_into_table */
26 /* 2) Made insert_message a private procedure in PL/SQL it*/
27 /* amounts to removing the this procedure from the pkg */
28 /* specification */
29 /* 3) Created a constructor for this package */
30 /* It performs the following actions - */
31 /* a) Initialize global variables, currently we have */
32 /* g_location that gets the file path were the GME */
33 /* validation log file is created */
34 /* b) Avoids repeated cursors calls. */
35 /* */
36 /* G. Muratore 06/09/2005 Bug 4249832 */
37 /* Removed hard coded schemas per gscc. */
38 /***********************************************************/
39
40 /* Package variable to hold the trans ids of reversal transactions */
41 p_default_loct VARCHAR2 (80) := fnd_profile.VALUE ('IC$DEFAULT_LOCT');
42
43 PROCEDURE initialize_migration;
44
45 FUNCTION get_oprn_id (p_batch_id IN NUMBER, p_batchstep_no IN NUMBER)
46 RETURN NUMBER;
47
48 FUNCTION get_process_qty_uom (p_oprn_id NUMBER)
49 RETURN VARCHAR2;
50
51 FUNCTION get_actual_cost_ind (p_batch_id IN NUMBER)
52 RETURN VARCHAR2;
53
54 FUNCTION get_gl_posted_ind (p_batch_id IN NUMBER)
55 RETURN NUMBER;
56
57 FUNCTION get_poc_data_ind (p_batch_id IN NUMBER)
58 RETURN VARCHAR2;
59
60 FUNCTION get_ref_uom (p_uom_class IN VARCHAR2)
61 RETURN VARCHAR2;
62
63 FUNCTION get_batchstep_id (p_batch_id IN NUMBER, p_batchstep_no IN NUMBER)
64 RETURN NUMBER;
65
66 FUNCTION get_wip_planned_qty (
67 p_batch_id IN NUMBER,
68 p_line_id IN NUMBER,
69 p_actual_qty IN NUMBER
70 )
71 RETURN NUMBER;
72
73 FUNCTION get_planned_qty (
74 p_batch_id IN NUMBER,
75 p_line_id IN NUMBER,
76 p_plan_qty IN NUMBER
77 )
78 RETURN NUMBER;
79
80 FUNCTION get_actual_qty (
81 p_batch_id IN NUMBER,
82 p_line_id IN NUMBER,
83 p_actual_qty IN NUMBER
84 )
85 RETURN NUMBER;
86
87 FUNCTION get_actual_activity_factor (
88 p_batchstep_id IN gme_batch_steps.batchstep_id%TYPE
89 )
90 RETURN gme_batch_step_activities.actual_activity_factor%TYPE;
91
92 FUNCTION get_planned_usage (p_batchstepline_id IN NUMBER)
93 RETURN NUMBER;
94
95 FUNCTION get_actual_usage (p_line_id IN NUMBER)
96 RETURN NUMBER;
97
98 PROCEDURE check_wip_batches (
99 x_return_status OUT NOCOPY VARCHAR2,
100 p_reverse_compl_def_txns IN BOOLEAN DEFAULT FALSE
101 );
102
103 PROCEDURE run (p_commit IN BOOLEAN DEFAULT FALSE);
104
105 PROCEDURE insert_batch_header (x_return_status OUT NOCOPY VARCHAR2);
106
107 PROCEDURE insert_material_details (x_return_status OUT NOCOPY VARCHAR2);
108
109 PROCEDURE insert_batch_steps (x_return_status OUT NOCOPY VARCHAR2);
110
111 PROCEDURE insert_batch_step_dtls (x_return_status OUT NOCOPY VARCHAR2);
112
113 PROCEDURE insert_batch_step_items (x_return_status OUT NOCOPY VARCHAR2);
114
115 PROCEDURE insert_batch_step_dependencies (x_return_status OUT NOCOPY VARCHAR2);
116
117 PROCEDURE insert_resource_txns (x_return_status OUT NOCOPY VARCHAR2);
118
119 PROCEDURE insert_batch_history (x_return_status OUT NOCOPY VARCHAR2);
120
121 PROCEDURE insert_batch_step_transfers (x_return_status OUT NOCOPY VARCHAR2);
122
123 PROCEDURE insert_text_header (x_return_status OUT NOCOPY VARCHAR2);
124
125 PROCEDURE insert_text_dtl (x_return_status OUT NOCOPY VARCHAR2);
126
127 PROCEDURE split_trans_line (x_return_status OUT NOCOPY VARCHAR2);
128
129 /* Commented this procedure to make it Private to this package */
130 /* PROCEDURE insert_message(p_table_name IN VARCHAR2,
131 p_procedure_name IN VARCHAR2,
132 p_parameters IN VARCHAR2,
133 p_message IN VARCHAR2,
134 p_error_type IN VARCHAR2);
135
136 PROCEDURE insert_message_into_table (p_table_name IN VARCHAR2,
137 p_procedure_name IN VARCHAR2,
138 p_parameters IN VARCHAR2,
139 p_message IN VARCHAR2,
140 p_error_type IN VARCHAR2);
141
142 */
143
144 PROCEDURE deduce_transaction_warehouse (
145 p_transaction IN ic_tran_pnd%ROWTYPE,
146 p_item_master IN ic_item_mst%ROWTYPE,
147 x_whse_code OUT NOCOPY ps_whse_eff.whse_code%TYPE
148 );
149
150 PROCEDURE get_default_lot (
151 p_line_id IN pm_matl_dtl_bak.line_id%TYPE,
152 x_def_lot_id OUT NOCOPY ic_tran_pnd.trans_id%TYPE,
153 x_is_plain OUT NOCOPY BOOLEAN,
154 x_return_status OUT NOCOPY VARCHAR2
155 );
156
157 PROCEDURE load_trans (
158 p_batch_row IN pm_btch_hdr_bak%ROWTYPE,
159 x_return_status OUT NOCOPY VARCHAR2
160 );
161
162 PROCEDURE build_gmi_trans (
163 p_ic_tran_row IN ic_tran_pnd%ROWTYPE,
164 x_tran_row OUT NOCOPY gmi_trans_engine_pub.ictran_rec,
165 x_return_status OUT NOCOPY VARCHAR2
166 );
167
168 PROCEDURE insert_inv_txns_gtmp (
169 p_batch_id IN pm_btch_hdr_bak.batch_id%TYPE,
170 p_doc_type IN ic_tran_pnd.doc_type%TYPE,
171 x_return_status OUT NOCOPY VARCHAR2,
172 p_trans_id IN ic_tran_pnd.trans_id%TYPE DEFAULT NULL
173 );
174
175 FUNCTION get_actual_date (p_date IN DATE)
176 RETURN DATE;
177
178 FUNCTION get_rsrc_offset (
179 p_batch_id IN pm_btch_hdr_bak.batch_id%TYPE,
180 p_batchstep_no IN pm_rout_dtl.batchstep_no%TYPE,
181 p_activity IN pm_oprn_dtl.activity%TYPE,
182 p_offset IN pm_oprn_dtl.offset_interval%TYPE
183 )
184 RETURN NUMBER;
185
186 FUNCTION get_min_capacity (
187 p_batch_id pm_btch_hdr_bak.batch_id%TYPE,
188 p_rsrc pm_oprn_dtl.resources%TYPE
189 )
190 RETURN NUMBER;
191
192 FUNCTION get_max_capacity (
193 p_batch_id pm_btch_hdr_bak.batch_id%TYPE,
194 p_rsrc pm_oprn_dtl.resources%TYPE
195 )
196 RETURN NUMBER;
197
198 FUNCTION get_capacity_uom (
199 p_batch_id pm_btch_hdr_bak.batch_id%TYPE,
200 p_rsrc pm_oprn_dtl.resources%TYPE
201 )
202 RETURN VARCHAR2;
203
204 PROCEDURE get_capacity (
205 p_batch_id IN pm_btch_hdr_bak.batch_id%TYPE,
206 p_resources IN pm_oprn_dtl.resources%TYPE,
207 x_min_capacity OUT NOCOPY NUMBER,
208 x_max_capacity OUT NOCOPY NUMBER,
209 x_capacity_uom OUT NOCOPY VARCHAR2,
210 x_return_status OUT NOCOPY VARCHAR2
211 );
212
213 FUNCTION get_activity_id (
214 p_batch_id IN NUMBER,
215 p_batchstep_no IN NUMBER,
216 p_activity IN VARCHAR2
217 )
218 RETURN NUMBER;
219
220 FUNCTION is_table_migrated (p_table_name IN VARCHAR2)
221 RETURN BOOLEAN;
222
223 PROCEDURE set_table_migrated (
224 p_table_name IN VARCHAR2,
225 x_return_status OUT NOCOPY VARCHAR2
226 );
227
228 PROCEDURE renumber_duplicate_line_no;
229
230 PROCEDURE renumber_blank_line_no;
231
232 FUNCTION is_GME_validated RETURN BOOLEAN;
233
234 PROCEDURE set_GME_validated;
235
236 PROCEDURE reset_GME_validated;
237
238 PROCEDURE unlock_all;
239
240 PROCEDURE del_step_dtl_for_del_steps;
241
242 PROCEDURE tablespace_check(
243 p_User IN VARCHAR2,
244 p_pct_free IN NUMBER
245 );
246
247 PROCEDURE report_step_item_orphans;
248
249 PROCEDURE report_step_dep_orphans;
250
251 FUNCTION GME_data_exists RETURN BOOLEAN;
252
253 END migrate_batch;