PACKAGE: APPS.POR_LOAD_LOCATION

Source

1 PACKAGE POR_LOAD_LOCATION AUTHID CURRENT_USER as
2 /* $Header: PORLLOCS.pls 115.3 2001/07/16 14:51:08 pkm ship        $ */
3 
4 PROCEDURE insert_update_location_info (
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, l_business_grp_id IN NUMBER) RETURN BOOLEAN;
29 
30 FUNCTION get_business_group_id (p_business_group_name IN VARCHAR2) RETURN NUMBER;
31 
32 PROCEDURE get_location_information (p_location_code IN VARCHAR2, p_location_id OUT NUMBER, p_object_version_number OUT NUMBER);
33 
34 FUNCTION get_organization_id (p_organization_name IN VARCHAR2) RETURN NUMBER;
35 
36 FUNCTION get_location_id (p_location_code IN VARCHAR2) RETURN NUMBER;
37 
38 FUNCTION get_address_style_code (p_address_style IN VARCHAR2) RETURN VARCHAR2;
39 
40 FUNCTION get_country_code (p_country_name IN VARCHAR2) RETURN VARCHAR2;
41 
42 END POR_LOAD_LOCATION;