[Home] [Help]
PACKAGE: APPS.ICX_REQ_SPECIAL_ORD
Source
1 PACKAGE icx_req_special_ord AUTHID CURRENT_USER AS
2 /* $Header: ICXRQSPS.pls 115.1 99/07/17 03:23:33 porting ship $ */
3
4 TYPE special_order_record IS RECORD (
5 cart_id VARCHAR2(20) := NULL,
6 category_id VARCHAR2(20) := NULL,
7 category_name VARCHAR2(85) := NULL,
8 item_description VARCHAR2(240) := NULL,
9 qty_v VARCHAR2(20) := NULL,
10 unit_of_measurement VARCHAR2(25) := NULL,
11 unit_price VARCHAR2(20) := NULL,
12 suggested_vendor_item_num VARCHAR2(85) := NULL,
13 suggested_vendor_name VARCHAR2(85) := NULL,
14 suggested_vendor_site VARCHAR2(85) := NULL,
15 suggested_vendor_contact VARCHAR2(85) := NULL,
16 suggested_vendor_phone VARCHAR2(85) := NULL,
17 line_attribute_1 VARCHAR2(300) := NULL,
18 line_attribute_2 VARCHAR2(300) := NULL,
19 line_attribute_3 VARCHAR2(300) := NULL,
20 line_attribute_4 VARCHAR2(300) := NULL,
21 line_attribute_5 VARCHAR2(300) := NULL,
22 line_attribute_6 VARCHAR2(300) := NULL,
23 line_attribute_7 VARCHAR2(300) := NULL,
24 line_attribute_8 VARCHAR2(300) := NULL,
25 line_attribute_9 VARCHAR2(300) := NULL,
26 line_attribute_10 VARCHAR2(300) := NULL,
27 line_attribute_11 VARCHAR2(300) := NULL,
28 line_attribute_12 VARCHAR2(300) := NULL,
29 line_attribute_13 VARCHAR2(300) := NULL,
30 line_attribute_14 VARCHAR2(300) := NULL,
31 line_attribute_15 VARCHAR2(300) := NULL,
32 line_type_id VARCHAR2(10) := NULL);
33
34 v_empty_special_order_rec special_order_record;
35
36 PROCEDURE special_order(n_org VARCHAR2,
37 v_special_order_rec IN special_order_record
38 DEFAULT v_empty_special_order_rec,
39 v_error_flag IN VARCHAR2 DEFAULT NULL,
40 v_error_text IN VARCHAR2 DEFAULT NULL,
41 v_rows_inserted IN VARCHAR2 DEFAULT NULL,
42 v_order_total_message IN VARCHAR2 DEFAULT NULL);
43
44 PROCEDURE special_order_display(n_org VARCHAR2,
45 v_special_order_rec IN special_order_record
46 DEFAULT v_empty_special_order_rec,
47 v_error_flag IN VARCHAR2 DEFAULT NULL,
48 v_error_text IN VARCHAR2 DEFAULT NULL,
49 v_rows_inserted IN VARCHAR2 DEFAULT NULL,
50 v_order_total_message IN VARCHAR2 DEFAULT NULL);
51
52 PROCEDURE special_order_buttons;
53
54 PROCEDURE add_item_to_cart (n_org IN VARCHAR2,
55 cartId in VARCHAR2,
56 icx_category_id IN VARCHAR2 DEFAULT NULL,
57 icx_category_name IN VARCHAR2 DEFAULT NULL,
58 icx_item_description IN VARCHAR2 DEFAULT NULL,
59 icx_qty_v IN VARCHAR2 DEFAULT NULL,
60 icx_unit_of_measurement IN VARCHAR2 DEFAULT NULL,
61 icx_unit_price IN VARCHAR2 DEFAULT NULL,
62 icx_suggested_vendor_item_num IN VARCHAR2 DEFAULT NULL,
63 icx_suggested_vendor_name IN VARCHAR2 DEFAULT NULL,
64 icx_suggested_vendor_site IN VARCHAR2 DEFAULT NULL,
65 icx_suggested_vendor_contact IN VARCHAR2 DEFAULT NULL,
66 icx_suggested_vendor_phone IN VARCHAR2 DEFAULT NULL,
67 icx_line_attribute_1 IN VARCHAR2 DEFAULT NULL,
68 icx_line_attribute_2 IN VARCHAR2 DEFAULT NULL,
69 icx_line_attribute_3 IN VARCHAR2 DEFAULT NULL,
70 icx_line_attribute_4 IN VARCHAR2 DEFAULT NULL,
71 icx_line_attribute_5 IN VARCHAR2 DEFAULT NULL,
72 icx_line_attribute_6 IN VARCHAR2 DEFAULT NULL,
73 icx_line_attribute_7 IN VARCHAR2 DEFAULT NULL,
74 icx_line_attribute_8 IN VARCHAR2 DEFAULT NULL,
75 icx_line_attribute_9 IN VARCHAR2 DEFAULT NULL,
76 icx_line_attribute_10 IN VARCHAR2 DEFAULT NULL,
77 icx_line_attribute_11 IN VARCHAR2 DEFAULT NULL,
78 icx_line_attribute_12 IN VARCHAR2 DEFAULT NULL,
79 icx_line_attribute_13 IN VARCHAR2 DEFAULT NULL,
80 icx_line_attribute_14 IN VARCHAR2 DEFAULT NULL,
81 icx_line_attribute_15 IN VARCHAR2 DEFAULT NULL,
82 icx_line_type_id IN VARCHAR2 DEFAULT NULL,
83 v_category_pop_list IN VARCHAR2 DEFAULT NULL,
84 v_uom_pop_list IN VARCHAR2 DEFAULT NULL);
85
86
87 PROCEDURE insert_order_to_cart_line (v_special_order_rec
88 IN special_order_record,
89 l_order_total_message
90 OUT VARCHAR2);
91
92 -- remove later
93 procedure chk_vendor_on(v_items_table IN ak_query_pkg.items_table_type,
94 v_on OUT varchar2);
95
96 END icx_req_special_ord;