1 package icx_por_job_track_validation_s AUTHID CURRENT_USER as
2 /* $Header: ICXJVALS.pls 115.0 2000/05/02 17:44:05 pkm ship $ */
3
4 procedure update_job_status(p_jobno in number,
5 p_new_status in varchar2,
6 p_loaded_items in number,
7 p_failed_items in number);
8
9 procedure complete_job(p_jobno in number);
10
11 procedure fail_job(p_jobno in number,
12 p_error_message in varchar2);
13
14 function validate_item_price(p_jobno in out number,
15 p_action in varchar2,
16 p_row_type in varchar2,
17 p_supplier_id in number,
18 p_supplier in varchar2,
19 p_supplier_part_num in varchar2,
20 p_description in varchar2,
21 p_unspsc in varchar2,
22 p_lead_time in number,
23 p_availability in varchar2,
24 p_item_type in varchar2,
25 p_buyer in varchar2,
26 p_uom in varchar2,
27 p_price in number,
28 p_currency_code in varchar2,
29 p_line_number in number,
30 p_job_supplier_name in varchar2,
31 p_business_group_id in number,
32 p_supplier_site in varchar2) return varchar2;
33
34 procedure InsertError(p_jobno in out number,
35 p_descriptor_key in varchar2,
36 p_message_name in varchar2,
37 p_line_number in number);
38
39 procedure get_next_job(p_jobno out number,
40 p_exchange_file_name out varchar2,
41 p_supplier_id out number,
42 p_supplier_name out varchar2,
43 p_host_ip_address in varchar2,
44 p_exchange_operator out varchar2);
45
46 function create_job(p_supplier_id in number,
47 p_supplier_file in varchar2,
48 p_exchange_file in varchar2,
49 p_host_ip_address in varchar2,
50 p_exchange_operator in varchar2) return number;
51
52 end icx_por_job_track_validation_s;