1 PACKAGE ICX_REQ_TEMPLATES AUTHID CURRENT_USER as
2 /* $Header: ICXRQTMS.pls 115.1 99/07/17 03:23:39 porting ship $ */
3
4
5 procedure GetTemplateTop( v_org_id number,
6 v_emergency varchar2 default NULL );
7
8 procedure templates(start_row in number default 1,
9 c_end_row in number default null,
10 p_where in number);
11
12 procedure GetTemplateChildren( p_where in number,
13 nodeId in varchar2 default null,
14 nodeIndex in varchar2 default null);
15
16
17 procedure template_items(p_start_row in number default 1,
18 p_end_row in number default null,
19 p_where in varchar2);
20
21 procedure template_items_display(p_start_row in number default 1,
22 p_end_row in number default null,
23 p_where in varchar2);
24
25 procedure template_items_buttons(p_start_row in number default 1,
26 p_end_row in number default null,
27 p_total_rows in number,
28 p_where in number);
29
30 PROCEDURE submit_items (cartId IN NUMBER,
31 p_start_row IN NUMBER DEFAULT 1,
32 p_end_row IN NUMBER DEFAULT NULL,
33 p_where IN VARCHAR2,
34 v_express_name IN VARCHAR2,
35 p_emergency IN NUMBER DEFAULT NULL,
36 end_row IN NUMBER DEFAULT NULL,
37 p_query_set IN NUMBER DEFAULT NULL,
38 p_row_count IN NUMBER DEFAULT NULL,
39 Quantity IN ICX_OWA_PARMS.ARRAY DEFAULT ICX_OWA_PARMS.empty,
40 v_sequence_num IN ICX_OWA_PARMS.ARRAY DEFAULT ICX_OWA_PARMS.empty);
41
42 PROCEDURE total_page(l_rows_added NUMBER DEFAULT 0,
43 l_rows_updated NUMBER DEFAULT 0,
44 l_qty_added NUMBER DEFAULT 0,
45 l_qty_updated NUMBER DEFAULT 0,
46 l_order_total NUMBER DEFAULT 0,
47 l_dest_org_id NUMBER,
48 v_express_name VARCHAR2 default null,
49 p_start_row NUMBER DEFAULT 1,
50 p_end_row NUMBER DEFAULT NULL,
51 p_where VARCHAR2,
52 end_row NUMBER DEFAULT NULL,
53 p_query_set NUMBER DEFAULT NULL,
54 p_row_count NUMBER DEFAULT NULL);
55
56 end ICX_REQ_TEMPLATES;