[Home] [Help]
PACKAGE: APPS.HZ_GEO_STRUCT_MAP_PUB_W
Source
1 package hz_geo_struct_map_pub_w AUTHID CURRENT_USER as
2 /* $Header: ARHGNRJS.pls 120.3 2005/10/25 14:12:22 baianand noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy hz_geo_struct_map_pub.geo_struct_map_dtl_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_100
6 );
7 procedure rosetta_table_copy_out_p2(t hz_geo_struct_map_pub.geo_struct_map_dtl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
8 , a1 out nocopy JTF_VARCHAR2_TABLE_100
9 , a2 out nocopy JTF_VARCHAR2_TABLE_100
10 );
11
12 procedure create_geo_struct_mapping(p0_a0 VARCHAR2
13 , p0_a1 VARCHAR2
14 , p0_a2 VARCHAR2
15 , p1_a0 JTF_NUMBER_TABLE
16 , p1_a1 JTF_VARCHAR2_TABLE_100
17 , p1_a2 JTF_VARCHAR2_TABLE_100
18 , p_init_msg_list VARCHAR2
19 , x_map_id out nocopy NUMBER
20 , x_return_status out nocopy VARCHAR2
21 , x_msg_count out nocopy NUMBER
22 , x_msg_data out nocopy VARCHAR2
23 );
24 procedure delete_geo_struct_mapping(p_map_id NUMBER
25 , p_location_table_name VARCHAR2
26 , p_country VARCHAR2
27 , p_address_style VARCHAR2
28 , p4_a0 JTF_NUMBER_TABLE
29 , p4_a1 JTF_VARCHAR2_TABLE_100
30 , p4_a2 JTF_VARCHAR2_TABLE_100
31 , p_init_msg_list VARCHAR2
32 , x_return_status out nocopy VARCHAR2
33 , x_msg_count out nocopy NUMBER
34 , x_msg_data out nocopy VARCHAR2
35 );
36 procedure create_geo_struct_map_dtls(p_map_id NUMBER
37 , p1_a0 JTF_NUMBER_TABLE
38 , p1_a1 JTF_VARCHAR2_TABLE_100
39 , p1_a2 JTF_VARCHAR2_TABLE_100
40 , p_init_msg_list VARCHAR2
41 , x_return_status out nocopy VARCHAR2
42 , x_msg_count out nocopy NUMBER
43 , x_msg_data out nocopy VARCHAR2
44 );
45 procedure update_geo_struct_map_dtls(p_map_id NUMBER
46 , p1_a0 JTF_NUMBER_TABLE
47 , p1_a1 JTF_VARCHAR2_TABLE_100
48 , p1_a2 JTF_VARCHAR2_TABLE_100
49 , p_init_msg_list VARCHAR2
50 , x_return_status out nocopy VARCHAR2
51 , x_msg_count out nocopy NUMBER
52 , x_msg_data out nocopy VARCHAR2
53 );
54 end hz_geo_struct_map_pub_w;