1 package icx_por_track_validate_job_s AUTHID CURRENT_USER as
2 /* $Header: ICXVALJS.pls 115.5 2004/03/31 21:43:38 vkartik ship $ */
3
4
5 procedure update_job_status(p_jobno in number,
6 p_new_status in varchar2,
7 p_loaded_items in number,
8 p_failed_items in number,
9 p_loaded_price in number,
10 p_failed_price in number,
11 p_loaded_header in number,
12 p_failed_header in number,
13 p_user_id IN NUMBER);
14
15
16 FUNCTION create_job(p_supplier_id IN NUMBER,
17 p_supplier_file IN VARCHAR2,
18 p_exchange_file IN VARCHAR2,
19 p_host_ip_address IN VARCHAR2,
20 p_exchange_operator_id IN NUMBER,
21 p_job_type IN VARCHAR2,
22 p_max_failed_lines IN NUMBER) RETURN NUMBER;
23
24
25 FUNCTION delete_job(p_jobno in number) RETURN VARCHAR2;
26
27 PROCEDURE set_debug_channel(p_debug_channel number default 0) ;
28 PROCEDURE init_fnd_debug(p_request_id number);
29
30 /* Procedure to insert the log messages into fnd_log_messages table */
31 PROCEDURE log(p_debug_message VARCHAR2,
32 p_log_type VARCHAR2 DEFAULT 'LOADER' ) ;
33
34 /* This will be set to TRUE when the DEBUG_CHANNEL is ON in the
35 Loader configuration file. This will be set only at the time of
36 starting up the loader */
37 g_debug_channel BOOLEAN := FALSE;
38 g_request_id NUMBER := null;
39 g_module_name VARCHAR2(50) := 'ICX.PLSQL.LOADER.';
40
41 end icx_por_track_validate_job_s;