[Home] [Help]
PACKAGE: APPS.POS_ASN_SEARCH_PKG
Source
1 PACKAGE pos_asn_search_pkg AUTHID CURRENT_USER AS
2 /* $Header: POSASNSS.pls 115.2 99/10/01 09:14:54 porting ship $ */
3
4 TYPE t_text_table is table of varchar2(240) index by binary_integer;
5
6 g_dummy t_text_table;
7
8 PROCEDURE search_page(p_query IN VARCHAR2 DEFAULT 'N',
9 p_msg IN VARCHAR2 DEFAULT NULL,
10 p_start_row IN NUMBER DEFAULT 0);
11
12 PROCEDURE criteria_frame(pos_vendor_site_id IN VARCHAR2 DEFAULT NULL,
13 pos_vendor_site_name IN VARCHAR2 DEFAULT NULL,
14 pos_ship_to_location_id IN VARCHAR2 DEFAULT NULL,
15 pos_ship_to_location IN VARCHAR2 DEFAULT NULL,
16 pos_supplier_item_number IN VARCHAR2 DEFAULT NULL,
17 pos_item_description IN VARCHAR2 DEFAULT NULL,
18 pos_po_number IN VARCHAR2 DEFAULT NULL,
19 pos_item_number IN VARCHAR2 DEFAULT NULL,
20 pos_date_start IN VARCHAR2 DEFAULT NULL,
21 pos_date_end IN VARCHAR2 DEFAULT NULL,
22 p_advance_flag IN VARCHAR2 DEFAULT 'N'
23 );
24
25 PROCEDURE result_frame(pos_vendor_site_id IN VARCHAR2 DEFAULT NULL,
26 pos_vendor_site_name IN VARCHAR2 DEFAULT NULL,
27 pos_ship_to_location_id IN VARCHAR2 DEFAULT NULL,
28 pos_ship_to_location IN VARCHAR2 DEFAULT NULL,
29 pos_supplier_item_number IN VARCHAR2 DEFAULT NULL,
30 pos_item_description IN VARCHAR2 DEFAULT NULL,
31 pos_po_number IN VARCHAR2 DEFAULT NULL,
32 pos_item_number IN VARCHAR2 DEFAULT NULL,
33 pos_date_start IN VARCHAR2 DEFAULT NULL,
34 pos_date_end IN VARCHAR2 DEFAULT NULL,
35 p_query IN VARCHAR2 DEFAULT 'Y',
36 p_msg IN VARCHAR2 DEFAULT NULL,
37 p_start_row IN NUMBER DEFAULT 1
38 );
39
40 PROCEDURE counter_frame(p_first IN NUMBER DEFAULT 0,
41 p_last IN NUMBER DEFAULT 0,
42 p_total IN NUMBER DEFAULT 0,
43 p_msg IN VARCHAR2 DEFAULT NULL);
44
45 PROCEDURE add_frame;
46
47 PROCEDURE SwitchResultPage(p_start_row IN VARCHAR2 DEFAULT '1');
48
49 PROCEDURE add_shipments_to_cart(pos_po_shipment_id IN t_text_table DEFAULT g_dummy,
50 pos_select IN t_text_table DEFAULT g_dummy,
51 pos_start_row IN VARCHAR2 DEFAULT '1',
52 pos_submit IN VARCHAR2 DEFAULT 'STAY');
53
54 END pos_asn_search_pkg;