[Home] [Help]
TYPE BODY: APPS.HZ_LOCATION_OBJ
Source
1 TYPE BODY hz_location_obj AS
2
3 STATIC FUNCTION create_object(
4 p_location_id IN NUMBER := NULL,
5 p_orig_system IN VARCHAR2 := NULL,
6 p_orig_system_reference IN VARCHAR2 := NULL,
7 p_country IN VARCHAR2 := NULL,
8 p_address1 IN VARCHAR2 := NULL,
9 p_address2 IN VARCHAR2 := NULL,
10 p_address3 IN VARCHAR2 := NULL,
11 p_address4 IN VARCHAR2 := NULL,
12 p_city IN VARCHAR2 := NULL,
13 p_postal_code IN VARCHAR2 := NULL,
14 p_state IN VARCHAR2 := NULL,
15 p_province IN VARCHAR2 := NULL,
16 p_county IN VARCHAR2 := NULL,
17 p_address_key IN VARCHAR2 := NULL,
18 p_address_style IN VARCHAR2 := NULL,
19 p_validated_flag IN VARCHAR2 := NULL,
20 p_address_lines_phonetic IN VARCHAR2 := NULL,
21 p_postal_plus4_code IN VARCHAR2 := NULL,
22 p_position IN VARCHAR2 := NULL,
23 p_location_directions IN VARCHAR2 := NULL,
24 p_address_effective_date IN DATE := NULL,
25 p_address_expiration_date IN DATE := NULL,
26 p_clli_code IN VARCHAR2 := NULL,
27 p_language IN VARCHAR2 := NULL,
28 p_short_description IN VARCHAR2 := NULL,
29 p_description IN VARCHAR2 := NULL,
30 p_loc_hierarchy_id IN NUMBER := NULL,
31 p_sales_tax_geocode IN VARCHAR2 := NULL,
32 p_sales_tax_inside_city_limits IN VARCHAR2 := NULL,
33 p_fa_location_id IN NUMBER := NULL,
34 p_timezone_id IN NUMBER := NULL,
35 p_attribute_category IN VARCHAR2 := NULL,
36 p_attribute1 IN VARCHAR2 := NULL,
37 p_attribute2 IN VARCHAR2 := NULL,
38 p_attribute3 IN VARCHAR2 := NULL,
39 p_attribute4 IN VARCHAR2 := NULL,
40 p_attribute5 IN VARCHAR2 := NULL,
41 p_attribute6 IN VARCHAR2 := NULL,
42 p_attribute7 IN VARCHAR2 := NULL,
43 p_attribute8 IN VARCHAR2 := NULL,
44 p_attribute9 IN VARCHAR2 := NULL,
45 p_attribute10 IN VARCHAR2 := NULL,
46 p_attribute11 IN VARCHAR2 := NULL,
47 p_attribute12 IN VARCHAR2 := NULL,
48 p_attribute13 IN VARCHAR2 := NULL,
49 p_attribute14 IN VARCHAR2 := NULL,
50 p_attribute15 IN VARCHAR2 := NULL,
51 p_attribute16 IN VARCHAR2 := NULL,
52 p_attribute17 IN VARCHAR2 := NULL,
53 p_attribute18 IN VARCHAR2 := NULL,
54 p_attribute19 IN VARCHAR2 := NULL,
55 p_attribute20 IN VARCHAR2 := NULL,
56 p_delivery_point_code IN VARCHAR2 := NULL,
57 p_actual_content_source IN VARCHAR2 := NULL,
58 p_geometry_status_code IN VARCHAR2 := NULL,
59 p_geometry IN mdsys.sdo_geometry := NULL
60 ) RETURN hz_location_obj AS
61 BEGIN
62 RETURN HZ_LOCATION_OBJ(
63 action_type => NULL,
64 common_obj_id => NULL,
65 location_id => p_location_id,
66 orig_system => p_orig_system,
67 orig_system_reference => p_orig_system_reference,
68 country => p_country,
69 address1 => p_address1,
70 address2 => p_address2,
71 address3 => p_address3,
72 address4 => p_address4,
73 city => p_city,
74 postal_code => p_postal_code,
75 state => p_state,
76 province => p_province,
77 county => p_county,
78 address_key => p_address_key,
79 address_style => p_address_style,
80 validated_flag => p_validated_flag,
81 address_lines_phonetic => p_address_lines_phonetic,
82 postal_plus4_code => p_postal_plus4_code,
83 position => p_position,
84 location_directions => p_location_directions,
85 address_effective_date => p_address_effective_date,
86 address_expiration_date => p_address_expiration_date,
87 clli_code => p_clli_code,
88 language => p_language,
89 short_description => p_short_description,
90 description => p_description,
91 loc_hierarchy_id => p_loc_hierarchy_id,
92 sales_tax_geocode => p_sales_tax_geocode,
93 sales_tax_inside_city_limits => p_sales_tax_inside_city_limits,
94 fa_location_id => p_fa_location_id,
95 attribute_category => p_attribute_category, attribute1 => p_attribute1, attribute2 => p_attribute2,
96 attribute3 => p_attribute3, attribute4 => p_attribute4, attribute5 => p_attribute5, attribute6 => p_attribute6,
97 attribute7 => p_attribute7, attribute8 => p_attribute8, attribute9 => p_attribute9, attribute10 => p_attribute10,
98 attribute11 => p_attribute11, attribute12 => p_attribute12, attribute13 => p_attribute13,
99 attribute14 => p_attribute14, attribute15 => p_attribute15, attribute16 => p_attribute16,
100 attribute17 => p_attribute17, attribute18 => p_attribute18, attribute19 => p_attribute19,
101 attribute20 => p_attribute20,
102 timezone_id => p_timezone_id,
103 program_update_date => NULL,
104 created_by_module => NULL,
105 created_by_name => NULL,
106 creation_date => NULL,
107 last_update_date => NULL,
108 last_updated_by_name => NULL,
109 actual_content_source => p_actual_content_source,
110 delivery_point_code => p_delivery_point_code,
111 geometry_status_code => p_geometry_status_code,
112 geometry => p_geometry,
113 orig_sys_objs => HZ_ORIG_SYS_REF_OBJ_TBL(),
114 ext_attributes_objs => HZ_EXT_ATTRIBUTE_OBJ_TBL()
115 );
116 END create_object;
117 END;