[Home] [Help]
PACKAGE: APPS.CSI_TXN_ERRORS_PKG
Source
1 PACKAGE csi_txn_errors_pkg AUTHID CURRENT_USER AS
2 /* $Header: csittxes.pls 115.17 2003/09/05 00:04:43 sguthiva ship $ */
3 -- start of comments
4 -- package name : csi_txn_errors_pkg
5 -- purpose :
6 -- history :
7 -- note :
8 -- end of comments
9
10 PROCEDURE insert_row(
11 px_transaction_error_id IN OUT NOCOPY NUMBER ,
12 p_transaction_id NUMBER ,
13 p_message_id NUMBER ,
14 p_error_text VARCHAR2,
15 p_source_type VARCHAR2,
16 p_source_id NUMBER ,
17 p_processed_flag VARCHAR2,
18 p_created_by NUMBER ,
19 p_creation_date DATE ,
20 p_last_updated_by NUMBER ,
21 p_last_update_date DATE ,
22 p_last_update_login NUMBER ,
23 p_object_version_number NUMBER ,
24 p_transaction_type_id NUMBER ,
25 p_source_group_ref VARCHAR2,
26 p_source_group_ref_id NUMBER ,
27 p_source_header_ref VARCHAR2,
28 p_source_header_ref_id NUMBER ,
29 p_source_line_ref VARCHAR2,
30 p_source_line_ref_id NUMBER ,
31 p_source_dist_ref_id1 NUMBER ,
32 p_source_dist_ref_id2 NUMBER ,
33 p_inv_material_transaction_id NUMBER ,
34 p_error_stage VARCHAR2,
35 p_message_string VARCHAR2,
36 p_instance_id NUMBER,
37 p_inventory_item_id NUMBER,
38 p_serial_number VARCHAR2,
39 p_lot_number VARCHAR2,
40 p_transaction_error_date DATE,
41 p_src_serial_num_ctrl_code NUMBER,
42 p_src_location_ctrl_code NUMBER,
43 p_src_lot_ctrl_code NUMBER,
44 p_src_rev_qty_ctrl_code NUMBER,
45 p_dst_serial_num_ctrl_code NUMBER,
46 p_dst_location_ctrl_code NUMBER,
47 p_dst_lot_ctrl_code NUMBER,
48 p_dst_rev_qty_ctrl_code NUMBER,
49 p_comms_nl_trackable_flag VARCHAR2);
50 END csi_txn_errors_pkg;