1 PACKAGE POR_LOAD_LOC_TEMP_TABLE AUTHID CURRENT_USER as
2 /* $Header: PORLLCTS.pls 115.1 2001/05/04 09:50:03 pkm ship $ */
3
4 PROCEDURE insert_update_loc_temp_table (
5 x_location_code IN VARCHAR2,
6 x_business_grp_name IN VARCHAR2,
7 x_effective_date IN DATE,
8 x_description IN VARCHAR2,
9 x_address_style IN VARCHAR2,
10 x_address_line_1 IN VARCHAR2,
11 x_address_line_2 IN VARCHAR2,
12 x_address_line_3 IN VARCHAR2,
13 x_city IN VARCHAR2,
14 x_state IN VARCHAR2,
15 x_county IN VARCHAR2,
16 x_country IN VARCHAR2,
17 x_postal_code IN VARCHAR2,
18 x_telephone_number_1 IN VARCHAR2,
19 x_telephone_number_2 IN VARCHAR2,
20 x_shipToLocation IN VARCHAR2,
21 x_ship_to_flag IN VARCHAR2,
22 x_bill_to_flag IN VARCHAR2,
23 x_receiving_site IN VARCHAR2,
24 x_office_site_flag IN VARCHAR2,
25 x_inv_org IN VARCHAR2,
26 x_tax_name IN VARCHAR2);
27
28 FUNCTION get_location_exists (p_location_code IN VARCHAR2) RETURN BOOLEAN;
29
30 END POR_LOAD_LOC_TEMP_TABLE;
31
[Home] [Help]