1 PACKAGE ICX_POR_ITEM_UPLOAD_VALIDATE AUTHID CURRENT_USER AS
2 /* $Header: ICXIULVS.pls 115.3 2002/05/23 13:19:04 pkm ship $*/
3
4 PROCEDURE validate_interface_data (p_job_supplier_name IN VARCHAR2,
5 p_job_supplier_id IN NUMBER,
6 p_exchange_operator_name IN VARCHAR2,
7 p_table_name IN VARCHAR2,
8 p_language IN VARCHAR2,
9 p_row_count IN NUMBER);
10
11 PROCEDURE validate_interface_data (p_job_supplier_name IN VARCHAR2,
12 p_job_supplier_id IN NUMBER,
13 p_exchange_operator_name IN VARCHAR2,
14 p_table_name IN VARCHAR2,
15 p_language IN VARCHAR2,
16 p_start_row IN NUMBER,
17 p_end_row IN NUMBER);
18
19 PROCEDURE set_debug_channel(p_debug_channel IN number);
20
21 /* Procedure to insert the log messages into fnd_log_messages table */
22 PROCEDURE insert_fnd_log_messages (p_debug_bind_variables VARCHAR2,
23 p_debug_sql_string VARCHAR2);
24
25 /* This will be set to TRUE when the DEBUG_CHANNEL is ON in the
26 Loader configuration file. This will be set only at the time of
27 starting up the loader */
28 g_debug_channel BOOLEAN := FALSE;
29 g_job_number NUMBER := null;
30 g_module_name VARCHAR2(50) := 'ICX.PLSQL.LOADER.';
31
32 END ICX_POR_ITEM_UPLOAD_VALIDATE;