[Home] [Help]
PACKAGE: APPS.CSI_DEBUG_PKG
Source
1 PACKAGE csi_debug_pkg as
2 /* $Header: csidbugs.pls 120.4 2005/07/08 17:09:18 brmanesh noship $ */
3
4 g_utl_check_done char := 'N';
5
6 TYPE order_line is RECORD(
7 header_id number,
8 line_number varchar2(30),
9 line_id number,
10 item_id number,
11 item_number varchar2(80),
12 ship_from_org_id number,
13 order_uom varchar2(30),
14 order_qty number,
15 line_status varchar2(30),
16 item_type varchar2(30),
17 identified_item_type varchar2(30),
18 link_to_line_id number,
19 ato_line_id number,
20 top_model_line_id number,
21 ib_trackable_flag varchar2(1),
22 level number,
23 sort_order varchar2(240),
24 sort_flag varchar2(1) := 'N',
25 org_id number,
26 order_type_id number,
27 line_type_id number,
28 ship_to_contact_id number,
29 invoice_to_contact_id number,
30 deliver_to_contact_id number,
31 price_list_id number,
32 unit_selling_price number,
33 creation_date date,
34 comp_seq_id number,
35 line_category_code varchar2(30),
36 cancelled_flag varchar2(1),
37 source_type_code varchar2(30),
38 drop_ship_flag varchar2(1),
39 fulfilled_flag varchar2(1),
40 configuration_id number,
41 config_header_id number,
42 config_rev_nbr number,
43 shippable_flag varchar2(1),
44 fulfillment_date date,
45 shipment_date date,
46 shipped_flag varchar2(1),
47 split_from_line_id number,
48 ship_to_org_id number,
49 invoice_to_org_id number,
50 deliver_to_org_id number,
51 item_revision varchar2(3),
52 fulfilled_quantity number,
53 shipped_quantity number,
54 parent_ato_line_id number,
55 macd_flag varchar2(1) := 'N');
56
57 TYPE order_lines is TABLE OF order_line INDEX BY binary_integer;
58
59 TYPE ato_model_rec IS RECORD(
60 model_line_id number,
61 model_item_id number,
62 config_line_id number,
63 config_item_id number,
64 parent_ato_line_id number,
65 wip_supply_type number,
66 wip_entity_id number,
67 wip_entity_name varchar2(30),
68 organization_id number,
69 phantom_flag varchar2(1),
70 sub_model_flag varchar2(1),
71 make_buy_flag varchar2(1));
72
73 TYPE ato_model_tbl IS TABLE of ato_model_rec INDEX BY binary_integer;
74
75 TYPE item_rec is RECORD(
76 item_id number,
77 item varchar2(240),
78 organization_id number,
79 primary_uom_code varchar2(3),
80 serial_code number,
81 lot_code number,
82 locator_code number,
83 revision_code number,
84 bom_item_type number,
85 shippable_flag varchar2(1),
86 reservable_type number,
87 ib_trackable_flag varchar2(1),
88 base_item_id number,
89 pick_flag varchar2(1),
90 returnable_flag varchar2(1),
91 wip_supply_type number,
92 make_buy_code number,
93 inventory_flag varchar2(1),
94 inv_transactable_flag varchar2(1));
95
96 TYPE item_tbl is TABLE of item_rec INDEX BY binary_integer;
97
98 TYPE mmt_rec is RECORD(
99 mtl_txn_id number,
100 mtl_txn_date date,
101 item_id number,
102 organization_id number,
103 mtl_type_id number,
104 mtl_txn_name varchar2(80),
105 mtl_action_id number,
106 mtl_source_type_id number,
107 mtl_source_id number,
108 mtl_source_line_id number,
109 mtl_txn_qty number,
110 mtl_txn_uom varchar2(30),
111 mtl_pri_qty number,
112 mtl_pri_uom varchar2(30),
113 mtl_type_class number,
114 mtl_xfer_txn_id number,
115 user_defined varchar2(1),
116 status varchar2(30),
117 message_id number,
118 message_code varchar2(30),
119 message_status varchar2(30),
120 csi_txn_id number,
121 csi_txn_date date,
122 error_id number,
123 error_text varchar2(2000));
124
125 TYPE mmt_tbl is TABLE of mmt_rec INDEX BY binary_integer;
126
127 TYPE mut_rec is RECORD(
128 item_id number,
129 serial_number varchar2(80),
130 lot_number varchar2(80),
131 instance_id number,
132 location_type_code varchar2(30),
133 instance_usage_code varchar2(30),
134 instance_in_error varchar2(1) := 'N');
135
136 TYPE mut_tbl IS TABLE of mut_rec INDEX BY binary_integer;
137
138 TYPE job_rec IS record(
139 wip_entity_id number,
140 organization_id number,
141 wip_entity_name varchar2(30),
142 wip_entity_type number,
143 wip_job_status number,
144 primary_item_id number,
145 start_qty number,
146 qty_completed number,
147 qty_scrapped number,
148 over_compl_type number,
149 over_compl_value number,
150 source_code varchar2(30),
151 source_line_id number,
152 maint_obj_source number);
153
154 TYPE wip_req_rec IS record(
155 comp_item varchar2(240),
156 comp_item_id number,
157 oper_seq_num number,
158 comp_seq_id number,
159 qty_per_assy number,
160 required_qty number,
161 qty_issued number,
162 wip_supply_type number,
163 supply_subinv varchar2(80),
164 primary_uom_code varchar2(3),
165 serial_code number,
166 lot_code number);
167
168 TYPE wip_req_tbl IS TABLE of wip_req_rec INDEX BY binary_integer;
169
170 TYPE tld_rec IS record(
171 transaction_line_id number,
172 txn_line_detail_id number,
173 inventory_item_id number,
174 quantity number,
175 serial_number varchar2(80),
176 lot_number varchar2(80),
177 instance_id number,
178 location_type_code varchar2(30),
179 location_id number,
180 processing_status varchar2(30),
181 source_transaction_flag varchar2(1),
182 config_inst_baseline_rev_num number,
183 config_inst_hdr_id number,
184 config_inst_item_id number,
185 config_inst_rev_num number);
186
187 TYPE tld_tbl IS TABLE of tld_rec INDEX BY binary_integer;
188
189 TYPE source_file is RECORD(
190 file_name varchar2(30),
191 integration varchar2(30));
192
193 TYPE source_files IS TABLE of source_file INDEX BY binary_integer;
194
195 TYPE instance_rec IS RECORD(
196 instance_id number);
197
198 TYPE instance_tbl IS TABLE of instance_rec INDEX BY binary_integer;
199
200 PROCEDURE order_status(
201 p_order_number IN number);
202
203 PROCEDURE job_status(
204 p_job_name IN varchar2,
205 p_organization_id IN number);
206
207 PROCEDURE serial_status(
208 p_serial_number IN varchar2,
209 p_item_id IN number,
210 p_standalone_mode IN varchar2 := 'Y');
211
212 PROCEDURE txn_status(
213 p_mtl_txn_id IN number);
214
215 PROCEDURE rma_status(
216 p_rma_number IN number);
217
218 PROCEDURE instance_status(
219 p_instance_id IN number,
220 p_standalone_mode IN varchar2 := 'Y');
221
222 PROCEDURE diagnose(
223 errbuf OUT nocopy varchar2,
224 retcode OUT nocopy number,
225 p_entity IN varchar2,
226 p_parameter1 IN varchar2,
227 p_parameter2 IN varchar2);
228
229 PROCEDURE dump_installation_details(
230 p_order_lines IN order_lines,
231 p_source_table IN varchar2 default 'OE_ORDER_LINES_ALL');
232
233 PROCEDURE get_order_lines(
234 p_order_number IN number,
235 x_order_lines OUT nocopy order_lines);
236
237 PROCEDURE get_ib_trackable_lines(
238 px_order_lines IN OUT nocopy order_lines);
239
240 PROCEDURE dump_file_version(
241 p_file_name IN varchar2,
242 p_subdir IN varchar2 default 'patch/115/sql',
243 p_prod_code IN varchar2 default 'CSI');
244
245 PROCEDURE dump_file_versions(
246 p_source_files IN source_files);
247
248 END csi_debug_pkg;