1 PACKAGE ICX_POR_ITEM_UPLOAD AUTHID CURRENT_USER AS
2 /* $Header: ICXIULDS.pls 115.9 2004/03/31 21:43:18 vkartik ship $*/
3
4 -- Use this for mode in move_data if called from edit rejected line
5 EDIT_REJECTED_LINE_MODE CONSTANT VARCHAR2(20) := 'EDIT_REJECTED_LINE';
6 -- Default mode for move_data
7 LOADER_MODE CONSTANT VARCHAR2(20) := 'LOADER';
8
9 -- The flags indicating whether root or local descriptors need to be refreshed
10 gRootDescRefresh BOOLEAN := FALSE;
11 gLocalDescRefresh BOOLEAN := FALSE;
12
13 PROCEDURE move_data(p_app_name IN VARCHAR2, p_request_id IN NUMBER,
14 p_data_type IN VARCHAR2, p_supplier_id IN NUMBER, p_langs IN LANG_ARRAY,
15 p_user_id IN NUMBER, p_user_login IN NUMBER, p_batch_size IN NUMBER,
16 p_succ_line OUT NOCOPY NUMBER, p_failed_line OUT NOCOPY NUMBER,
17 p_max_failed_line IN NUMBER DEFAULT -1,
18 p_catalog_name IN VARCHAR2, --Bug#2611529
19 p_negotiated_price IN VARCHAR2 --Bug#2611529
20 );
21
22 PROCEDURE move_unsaved_failed_lines(p_request_id IN NUMBER,
23 p_data_type IN VARCHAR2, p_supplier_id IN NUMBER,
24 p_user_id IN NUMBER, p_user_login IN NUMBER,
25 p_language IN VARCHAR2, p_lines_to_save_count IN NUMBER,
26 p_failed_lines_saved_count OUT NOCOPY NUMBER);
27
28 PROCEDURE create_price_list(p_price_list_name IN VARCHAR2,
29 p_buyer_id in NUMBER,
30 p_supplier_id IN NUMBER,
31 p_currency IN VARCHAR2,
32 p_begindate IN VARCHAR2,
33 p_enddate IN VARCHAR2,
34 p_user_id IN NUMBER,
35 p_request_id IN NUMBER,
36 p_header_id OUT NOCOPY NUMBER,
37 p_type OUT NOCOPY VARCHAR2);
38
39 PROCEDURE update_price_list( p_header_id IN NUMBER,
40 p_begindate IN VARCHAR2,
41 p_enddate IN VARCHAR2,
42 p_user_id IN NUMBER,
43 p_request_id IN NUMBER);
44
45 -- moved here by sudsubra
46 -- from ICXXJVLS.pls
47
48 PROCEDURE save_failed_price(p_request_id IN NUMBER,
49 p_line_number IN NUMBER,
50 p_action IN VARCHAR2,
51 p_amount IN VARCHAR2,
52 p_currency IN VARCHAR2,
53 p_uom IN VARCHAR2,
54 p_buyer_name IN VARCHAR2,
55 p_supplier_name IN VARCHAR2,
56 p_supplier_part_num IN VARCHAR2,
57 p_price_list_name IN VARCHAR2,
58 p_price_code IN VARCHAR2,
59 p_supplier_comments IN VARCHAR2,
60 p_begin_date IN VARCHAR2,
61 p_end_date IN VARCHAR2,
62 p_supplier_part_auxid IN VARCHAR2, -- Bug#2611529
63 p_supplier_site_code IN VARCHAR2);
64
65 PROCEDURE save_failed_price_list(p_request_id IN NUMBER,
66 p_line_number IN NUMBER,
67 p_action IN VARCHAR2,
68 p_price_list_name IN VARCHAR2,
69 p_currency IN VARCHAR2,
70 p_buyer_name IN VARCHAR2,
71 p_supplier_name IN VARCHAR2,
72 p_begin_date IN VARCHAR2,
73 p_end_date IN VARCHAR2);
74
75 PROCEDURE reject_catalog(p_request_id IN NUMBER,
76 p_line_type IN VARCHAR2,
77 p_descriptor_key IN VARCHAR2,
78 p_descriptor_val IN VARCHAR2,
79 p_error_message IN VARCHAR2
80 );
81
82 PROCEDURE save_failed_admin(p_request_id IN NUMBER,
83 p_line_number IN NUMBER,
84 p_buyer IN VARCHAR2,
85 p_contract_ref_num IN VARCHAR2
86 );
87 PROCEDURE get_contracts_pass_failed( p_request_id IN NUMBER,
88 p_succ_count OUT NOCOPY number,
89 p_failed_count OUT NOCOPY number);
90 PROCEDURE get_global_supplier_currency( p_request_id IN NUMBER,
91 p_supplier OUT NOCOPY VARCHAR,
92 p_currency OUT NOCOPY VARCHAR);
93 PROCEDURE validate_contracts(p_request_id in number, p_line_number in number,
94 p_buyer in varchar2, p_contract in varchar2,
95 p_supplier OUT NOCOPY varchar2, p_currency OUT NOCOPY varchar2,
96 p_error_message OUT NOCOPY varchar2) ;
97 PROCEDURE save_failed_admin_data (p_request_id in number) ;
98
99 procedure Debug(p_message in varchar2) ;
100 FUNCTION can_update(descriptor_key IN VARCHAR2) return boolean;
101 PROCEDURE handle_category_change (p_action IN VARCHAR2);
102 PROCEDURE reject_line(p_row_id IN UROWID, p_row_type IN VARCHAR2,
103 p_error_message IN VARCHAR2);
104
105 END ICX_POR_ITEM_UPLOAD;