APPS.HR_PROCESS_ADDRESS_SS dependencies on HR_API

Line 8: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

4: -- Package scope global variables.
5: l_transaction_table hr_transaction_ss.transaction_table;
6: l_count INTEGER := 0;
7: l_praddr_ovrlap VARCHAR2(2);
8: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
9: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
10: g_package varchar2(31) := 'HR_PROCESS_ADDRESS_SS';
11: g_data_error exception;
12: l_message_number VARCHAR2(10);

Line 9: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;

5: l_transaction_table hr_transaction_ss.transaction_table;
6: l_count INTEGER := 0;
7: l_praddr_ovrlap VARCHAR2(2);
8: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
9: l_trs_object_version_number hr_api_transaction_steps.object_version_number%type;
10: g_package varchar2(31) := 'HR_PROCESS_ADDRESS_SS';
11: g_data_error exception;
12: l_message_number VARCHAR2(10);
13: p_trans_rec_count integer;

Line 111: ,p_address_type in varchar2 default hr_api.g_varchar2

107: ,p_primary_flag in varchar2
108: ,p_style in varchar2
109: ,p_date_from in date
110: ,p_date_to in date default null
111: ,p_address_type in varchar2 default hr_api.g_varchar2
112: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
113: ,p_comments in long default hr_api.g_varchar2
114: ,p_address_line1 in varchar2 default hr_api.g_varchar2
115: ,p_address_line2 in varchar2 default hr_api.g_varchar2

Line 112: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2

108: ,p_style in varchar2
109: ,p_date_from in date
110: ,p_date_to in date default null
111: ,p_address_type in varchar2 default hr_api.g_varchar2
112: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
113: ,p_comments in long default hr_api.g_varchar2
114: ,p_address_line1 in varchar2 default hr_api.g_varchar2
115: ,p_address_line2 in varchar2 default hr_api.g_varchar2
116: ,p_address_line3 in varchar2 default hr_api.g_varchar2

Line 113: ,p_comments in long default hr_api.g_varchar2

109: ,p_date_from in date
110: ,p_date_to in date default null
111: ,p_address_type in varchar2 default hr_api.g_varchar2
112: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
113: ,p_comments in long default hr_api.g_varchar2
114: ,p_address_line1 in varchar2 default hr_api.g_varchar2
115: ,p_address_line2 in varchar2 default hr_api.g_varchar2
116: ,p_address_line3 in varchar2 default hr_api.g_varchar2
117: ,p_town_or_city in varchar2 default hr_api.g_varchar2

Line 114: ,p_address_line1 in varchar2 default hr_api.g_varchar2

110: ,p_date_to in date default null
111: ,p_address_type in varchar2 default hr_api.g_varchar2
112: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
113: ,p_comments in long default hr_api.g_varchar2
114: ,p_address_line1 in varchar2 default hr_api.g_varchar2
115: ,p_address_line2 in varchar2 default hr_api.g_varchar2
116: ,p_address_line3 in varchar2 default hr_api.g_varchar2
117: ,p_town_or_city in varchar2 default hr_api.g_varchar2
118: ,p_region_1 in varchar2 default hr_api.g_varchar2

Line 115: ,p_address_line2 in varchar2 default hr_api.g_varchar2

111: ,p_address_type in varchar2 default hr_api.g_varchar2
112: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
113: ,p_comments in long default hr_api.g_varchar2
114: ,p_address_line1 in varchar2 default hr_api.g_varchar2
115: ,p_address_line2 in varchar2 default hr_api.g_varchar2
116: ,p_address_line3 in varchar2 default hr_api.g_varchar2
117: ,p_town_or_city in varchar2 default hr_api.g_varchar2
118: ,p_region_1 in varchar2 default hr_api.g_varchar2
119: ,p_region_2 in varchar2 default hr_api.g_varchar2

Line 116: ,p_address_line3 in varchar2 default hr_api.g_varchar2

112: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
113: ,p_comments in long default hr_api.g_varchar2
114: ,p_address_line1 in varchar2 default hr_api.g_varchar2
115: ,p_address_line2 in varchar2 default hr_api.g_varchar2
116: ,p_address_line3 in varchar2 default hr_api.g_varchar2
117: ,p_town_or_city in varchar2 default hr_api.g_varchar2
118: ,p_region_1 in varchar2 default hr_api.g_varchar2
119: ,p_region_2 in varchar2 default hr_api.g_varchar2
120: ,p_region_3 in varchar2 default hr_api.g_varchar2

Line 117: ,p_town_or_city in varchar2 default hr_api.g_varchar2

113: ,p_comments in long default hr_api.g_varchar2
114: ,p_address_line1 in varchar2 default hr_api.g_varchar2
115: ,p_address_line2 in varchar2 default hr_api.g_varchar2
116: ,p_address_line3 in varchar2 default hr_api.g_varchar2
117: ,p_town_or_city in varchar2 default hr_api.g_varchar2
118: ,p_region_1 in varchar2 default hr_api.g_varchar2
119: ,p_region_2 in varchar2 default hr_api.g_varchar2
120: ,p_region_3 in varchar2 default hr_api.g_varchar2
121: ,p_postal_code in varchar2 default hr_api.g_varchar2

Line 118: ,p_region_1 in varchar2 default hr_api.g_varchar2

114: ,p_address_line1 in varchar2 default hr_api.g_varchar2
115: ,p_address_line2 in varchar2 default hr_api.g_varchar2
116: ,p_address_line3 in varchar2 default hr_api.g_varchar2
117: ,p_town_or_city in varchar2 default hr_api.g_varchar2
118: ,p_region_1 in varchar2 default hr_api.g_varchar2
119: ,p_region_2 in varchar2 default hr_api.g_varchar2
120: ,p_region_3 in varchar2 default hr_api.g_varchar2
121: ,p_postal_code in varchar2 default hr_api.g_varchar2
122: ,p_country in varchar2 default hr_api.g_varchar2

Line 119: ,p_region_2 in varchar2 default hr_api.g_varchar2

115: ,p_address_line2 in varchar2 default hr_api.g_varchar2
116: ,p_address_line3 in varchar2 default hr_api.g_varchar2
117: ,p_town_or_city in varchar2 default hr_api.g_varchar2
118: ,p_region_1 in varchar2 default hr_api.g_varchar2
119: ,p_region_2 in varchar2 default hr_api.g_varchar2
120: ,p_region_3 in varchar2 default hr_api.g_varchar2
121: ,p_postal_code in varchar2 default hr_api.g_varchar2
122: ,p_country in varchar2 default hr_api.g_varchar2
123: ,p_country_meaning in varchar2 default hr_api.g_varchar2

Line 120: ,p_region_3 in varchar2 default hr_api.g_varchar2

116: ,p_address_line3 in varchar2 default hr_api.g_varchar2
117: ,p_town_or_city in varchar2 default hr_api.g_varchar2
118: ,p_region_1 in varchar2 default hr_api.g_varchar2
119: ,p_region_2 in varchar2 default hr_api.g_varchar2
120: ,p_region_3 in varchar2 default hr_api.g_varchar2
121: ,p_postal_code in varchar2 default hr_api.g_varchar2
122: ,p_country in varchar2 default hr_api.g_varchar2
123: ,p_country_meaning in varchar2 default hr_api.g_varchar2
124: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

Line 121: ,p_postal_code in varchar2 default hr_api.g_varchar2

117: ,p_town_or_city in varchar2 default hr_api.g_varchar2
118: ,p_region_1 in varchar2 default hr_api.g_varchar2
119: ,p_region_2 in varchar2 default hr_api.g_varchar2
120: ,p_region_3 in varchar2 default hr_api.g_varchar2
121: ,p_postal_code in varchar2 default hr_api.g_varchar2
122: ,p_country in varchar2 default hr_api.g_varchar2
123: ,p_country_meaning in varchar2 default hr_api.g_varchar2
124: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
125: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

Line 122: ,p_country in varchar2 default hr_api.g_varchar2

118: ,p_region_1 in varchar2 default hr_api.g_varchar2
119: ,p_region_2 in varchar2 default hr_api.g_varchar2
120: ,p_region_3 in varchar2 default hr_api.g_varchar2
121: ,p_postal_code in varchar2 default hr_api.g_varchar2
122: ,p_country in varchar2 default hr_api.g_varchar2
123: ,p_country_meaning in varchar2 default hr_api.g_varchar2
124: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
125: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
126: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

Line 123: ,p_country_meaning in varchar2 default hr_api.g_varchar2

119: ,p_region_2 in varchar2 default hr_api.g_varchar2
120: ,p_region_3 in varchar2 default hr_api.g_varchar2
121: ,p_postal_code in varchar2 default hr_api.g_varchar2
122: ,p_country in varchar2 default hr_api.g_varchar2
123: ,p_country_meaning in varchar2 default hr_api.g_varchar2
124: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
125: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
126: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
127: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

Line 124: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

120: ,p_region_3 in varchar2 default hr_api.g_varchar2
121: ,p_postal_code in varchar2 default hr_api.g_varchar2
122: ,p_country in varchar2 default hr_api.g_varchar2
123: ,p_country_meaning in varchar2 default hr_api.g_varchar2
124: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
125: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
126: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
127: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
128: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

Line 125: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

121: ,p_postal_code in varchar2 default hr_api.g_varchar2
122: ,p_country in varchar2 default hr_api.g_varchar2
123: ,p_country_meaning in varchar2 default hr_api.g_varchar2
124: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
125: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
126: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
127: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
128: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
129: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

Line 126: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

122: ,p_country in varchar2 default hr_api.g_varchar2
123: ,p_country_meaning in varchar2 default hr_api.g_varchar2
124: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
125: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
126: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
127: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
128: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
129: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
130: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

Line 127: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

123: ,p_country_meaning in varchar2 default hr_api.g_varchar2
124: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
125: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
126: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
127: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
128: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
129: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
130: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
131: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

Line 128: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

124: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
125: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
126: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
127: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
128: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
129: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
130: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
131: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
132: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

Line 129: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

125: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
126: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
127: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
128: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
129: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
130: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
131: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
132: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
133: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

Line 130: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

126: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
127: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
128: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
129: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
130: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
131: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
132: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
133: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
134: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

Line 131: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

127: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
128: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
129: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
130: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
131: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
132: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
133: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
134: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
135: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

Line 132: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

128: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
129: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
130: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
131: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
132: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
133: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
134: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
135: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
136: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

Line 133: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

129: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
130: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
131: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
132: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
133: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
134: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
135: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
136: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
137: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

Line 134: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

130: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
131: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
132: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
133: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
134: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
135: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
136: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
137: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
138: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

Line 135: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

131: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
132: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
133: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
134: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
135: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
136: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
137: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
138: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
139: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

Line 136: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

132: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
133: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
134: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
135: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
136: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
137: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
138: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
139: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
140: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

Line 137: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

133: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
134: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
135: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
136: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
137: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
138: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
139: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
140: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
141: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

Line 138: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

134: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
135: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
136: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
137: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
138: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
139: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
140: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
141: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
142: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

Line 139: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

135: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
136: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
137: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
138: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
139: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
140: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
141: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
142: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
143: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

Line 140: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

136: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
137: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
138: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
139: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
140: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
141: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
142: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
143: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
144: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

Line 141: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

137: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
138: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
139: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
140: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
141: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
142: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
143: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
144: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
145: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

Line 142: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

138: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
139: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
140: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
141: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
142: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
143: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
144: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
145: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
146: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

Line 143: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

139: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
140: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
141: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
142: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
143: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
144: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
145: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
146: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
147: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

Line 144: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

140: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
141: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
142: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
143: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
144: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
145: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
146: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
147: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
148: ,p_add_information13 in varchar2 default hr_api.g_varchar2

Line 145: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

141: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
142: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
143: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
144: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
145: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
146: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
147: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
148: ,p_add_information13 in varchar2 default hr_api.g_varchar2
149: ,p_add_information14 in varchar2 default hr_api.g_varchar2

Line 146: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

142: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
143: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
144: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
145: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
146: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
147: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
148: ,p_add_information13 in varchar2 default hr_api.g_varchar2
149: ,p_add_information14 in varchar2 default hr_api.g_varchar2
150: ,p_add_information15 in varchar2 default hr_api.g_varchar2

Line 147: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

143: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
144: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
145: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
146: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
147: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
148: ,p_add_information13 in varchar2 default hr_api.g_varchar2
149: ,p_add_information14 in varchar2 default hr_api.g_varchar2
150: ,p_add_information15 in varchar2 default hr_api.g_varchar2
151: ,p_add_information16 in varchar2 default hr_api.g_varchar2

Line 148: ,p_add_information13 in varchar2 default hr_api.g_varchar2

144: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
145: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
146: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
147: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
148: ,p_add_information13 in varchar2 default hr_api.g_varchar2
149: ,p_add_information14 in varchar2 default hr_api.g_varchar2
150: ,p_add_information15 in varchar2 default hr_api.g_varchar2
151: ,p_add_information16 in varchar2 default hr_api.g_varchar2
152: ,p_add_information17 in varchar2 default hr_api.g_varchar2

Line 149: ,p_add_information14 in varchar2 default hr_api.g_varchar2

145: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
146: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
147: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
148: ,p_add_information13 in varchar2 default hr_api.g_varchar2
149: ,p_add_information14 in varchar2 default hr_api.g_varchar2
150: ,p_add_information15 in varchar2 default hr_api.g_varchar2
151: ,p_add_information16 in varchar2 default hr_api.g_varchar2
152: ,p_add_information17 in varchar2 default hr_api.g_varchar2
153: ,p_add_information18 in varchar2 default hr_api.g_varchar2

Line 150: ,p_add_information15 in varchar2 default hr_api.g_varchar2

146: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
147: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
148: ,p_add_information13 in varchar2 default hr_api.g_varchar2
149: ,p_add_information14 in varchar2 default hr_api.g_varchar2
150: ,p_add_information15 in varchar2 default hr_api.g_varchar2
151: ,p_add_information16 in varchar2 default hr_api.g_varchar2
152: ,p_add_information17 in varchar2 default hr_api.g_varchar2
153: ,p_add_information18 in varchar2 default hr_api.g_varchar2
154: ,p_add_information19 in varchar2 default hr_api.g_varchar2

Line 151: ,p_add_information16 in varchar2 default hr_api.g_varchar2

147: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
148: ,p_add_information13 in varchar2 default hr_api.g_varchar2
149: ,p_add_information14 in varchar2 default hr_api.g_varchar2
150: ,p_add_information15 in varchar2 default hr_api.g_varchar2
151: ,p_add_information16 in varchar2 default hr_api.g_varchar2
152: ,p_add_information17 in varchar2 default hr_api.g_varchar2
153: ,p_add_information18 in varchar2 default hr_api.g_varchar2
154: ,p_add_information19 in varchar2 default hr_api.g_varchar2
155: ,p_add_information20 in varchar2 default hr_api.g_varchar2

Line 152: ,p_add_information17 in varchar2 default hr_api.g_varchar2

148: ,p_add_information13 in varchar2 default hr_api.g_varchar2
149: ,p_add_information14 in varchar2 default hr_api.g_varchar2
150: ,p_add_information15 in varchar2 default hr_api.g_varchar2
151: ,p_add_information16 in varchar2 default hr_api.g_varchar2
152: ,p_add_information17 in varchar2 default hr_api.g_varchar2
153: ,p_add_information18 in varchar2 default hr_api.g_varchar2
154: ,p_add_information19 in varchar2 default hr_api.g_varchar2
155: ,p_add_information20 in varchar2 default hr_api.g_varchar2
156: ,p_address_id out nocopy number

Line 153: ,p_add_information18 in varchar2 default hr_api.g_varchar2

149: ,p_add_information14 in varchar2 default hr_api.g_varchar2
150: ,p_add_information15 in varchar2 default hr_api.g_varchar2
151: ,p_add_information16 in varchar2 default hr_api.g_varchar2
152: ,p_add_information17 in varchar2 default hr_api.g_varchar2
153: ,p_add_information18 in varchar2 default hr_api.g_varchar2
154: ,p_add_information19 in varchar2 default hr_api.g_varchar2
155: ,p_add_information20 in varchar2 default hr_api.g_varchar2
156: ,p_address_id out nocopy number
157: ,p_object_version_number out nocopy number

Line 154: ,p_add_information19 in varchar2 default hr_api.g_varchar2

150: ,p_add_information15 in varchar2 default hr_api.g_varchar2
151: ,p_add_information16 in varchar2 default hr_api.g_varchar2
152: ,p_add_information17 in varchar2 default hr_api.g_varchar2
153: ,p_add_information18 in varchar2 default hr_api.g_varchar2
154: ,p_add_information19 in varchar2 default hr_api.g_varchar2
155: ,p_add_information20 in varchar2 default hr_api.g_varchar2
156: ,p_address_id out nocopy number
157: ,p_object_version_number out nocopy number
158: -- StartRegistration

Line 155: ,p_add_information20 in varchar2 default hr_api.g_varchar2

151: ,p_add_information16 in varchar2 default hr_api.g_varchar2
152: ,p_add_information17 in varchar2 default hr_api.g_varchar2
153: ,p_add_information18 in varchar2 default hr_api.g_varchar2
154: ,p_add_information19 in varchar2 default hr_api.g_varchar2
155: ,p_add_information20 in varchar2 default hr_api.g_varchar2
156: ,p_address_id out nocopy number
157: ,p_object_version_number out nocopy number
158: -- StartRegistration
159: ,p_contact_or_person in varchar2 default null

Line 169: , p_contact_relationship_id in number default hr_api.g_number

165: ,p_old_address_id in number default null
166: ,p_old_object_version_number in number default null
167: ,p_save_mode in varchar2 default null
168: ,p_error_message out nocopy long
169: , p_contact_relationship_id in number default hr_api.g_number
170: )
171: IS
172:
173: l_proc varchar2(200) := g_package || 'create_person_address';

Line 943: ,p_date_from in date default hr_api.g_date

939: ,p_effective_date in date
940: ,p_validate_county in number default 1
941: ,p_address_id in number
942: ,p_object_version_number in out nocopy number
943: ,p_date_from in date default hr_api.g_date
944: ,p_date_to in date default hr_api.g_date
945: ,p_address_type in varchar2 default hr_api.g_varchar2
946: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
947: ,p_comments in long default hr_api.g_varchar2

Line 944: ,p_date_to in date default hr_api.g_date

940: ,p_validate_county in number default 1
941: ,p_address_id in number
942: ,p_object_version_number in out nocopy number
943: ,p_date_from in date default hr_api.g_date
944: ,p_date_to in date default hr_api.g_date
945: ,p_address_type in varchar2 default hr_api.g_varchar2
946: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
947: ,p_comments in long default hr_api.g_varchar2
948: ,p_address_line1 in varchar2 default hr_api.g_varchar2

Line 945: ,p_address_type in varchar2 default hr_api.g_varchar2

941: ,p_address_id in number
942: ,p_object_version_number in out nocopy number
943: ,p_date_from in date default hr_api.g_date
944: ,p_date_to in date default hr_api.g_date
945: ,p_address_type in varchar2 default hr_api.g_varchar2
946: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
947: ,p_comments in long default hr_api.g_varchar2
948: ,p_address_line1 in varchar2 default hr_api.g_varchar2
949: ,p_address_line2 in varchar2 default hr_api.g_varchar2

Line 946: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2

942: ,p_object_version_number in out nocopy number
943: ,p_date_from in date default hr_api.g_date
944: ,p_date_to in date default hr_api.g_date
945: ,p_address_type in varchar2 default hr_api.g_varchar2
946: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
947: ,p_comments in long default hr_api.g_varchar2
948: ,p_address_line1 in varchar2 default hr_api.g_varchar2
949: ,p_address_line2 in varchar2 default hr_api.g_varchar2
950: ,p_address_line3 in varchar2 default hr_api.g_varchar2

Line 947: ,p_comments in long default hr_api.g_varchar2

943: ,p_date_from in date default hr_api.g_date
944: ,p_date_to in date default hr_api.g_date
945: ,p_address_type in varchar2 default hr_api.g_varchar2
946: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
947: ,p_comments in long default hr_api.g_varchar2
948: ,p_address_line1 in varchar2 default hr_api.g_varchar2
949: ,p_address_line2 in varchar2 default hr_api.g_varchar2
950: ,p_address_line3 in varchar2 default hr_api.g_varchar2
951: ,p_town_or_city in varchar2 default hr_api.g_varchar2

Line 948: ,p_address_line1 in varchar2 default hr_api.g_varchar2

944: ,p_date_to in date default hr_api.g_date
945: ,p_address_type in varchar2 default hr_api.g_varchar2
946: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
947: ,p_comments in long default hr_api.g_varchar2
948: ,p_address_line1 in varchar2 default hr_api.g_varchar2
949: ,p_address_line2 in varchar2 default hr_api.g_varchar2
950: ,p_address_line3 in varchar2 default hr_api.g_varchar2
951: ,p_town_or_city in varchar2 default hr_api.g_varchar2
952: ,p_region_1 in varchar2 default hr_api.g_varchar2

Line 949: ,p_address_line2 in varchar2 default hr_api.g_varchar2

945: ,p_address_type in varchar2 default hr_api.g_varchar2
946: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
947: ,p_comments in long default hr_api.g_varchar2
948: ,p_address_line1 in varchar2 default hr_api.g_varchar2
949: ,p_address_line2 in varchar2 default hr_api.g_varchar2
950: ,p_address_line3 in varchar2 default hr_api.g_varchar2
951: ,p_town_or_city in varchar2 default hr_api.g_varchar2
952: ,p_region_1 in varchar2 default hr_api.g_varchar2
953: ,p_region_2 in varchar2 default hr_api.g_varchar2

Line 950: ,p_address_line3 in varchar2 default hr_api.g_varchar2

946: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
947: ,p_comments in long default hr_api.g_varchar2
948: ,p_address_line1 in varchar2 default hr_api.g_varchar2
949: ,p_address_line2 in varchar2 default hr_api.g_varchar2
950: ,p_address_line3 in varchar2 default hr_api.g_varchar2
951: ,p_town_or_city in varchar2 default hr_api.g_varchar2
952: ,p_region_1 in varchar2 default hr_api.g_varchar2
953: ,p_region_2 in varchar2 default hr_api.g_varchar2
954: ,p_region_3 in varchar2 default hr_api.g_varchar2

Line 951: ,p_town_or_city in varchar2 default hr_api.g_varchar2

947: ,p_comments in long default hr_api.g_varchar2
948: ,p_address_line1 in varchar2 default hr_api.g_varchar2
949: ,p_address_line2 in varchar2 default hr_api.g_varchar2
950: ,p_address_line3 in varchar2 default hr_api.g_varchar2
951: ,p_town_or_city in varchar2 default hr_api.g_varchar2
952: ,p_region_1 in varchar2 default hr_api.g_varchar2
953: ,p_region_2 in varchar2 default hr_api.g_varchar2
954: ,p_region_3 in varchar2 default hr_api.g_varchar2
955: ,p_postal_code in varchar2 default hr_api.g_varchar2

Line 952: ,p_region_1 in varchar2 default hr_api.g_varchar2

948: ,p_address_line1 in varchar2 default hr_api.g_varchar2
949: ,p_address_line2 in varchar2 default hr_api.g_varchar2
950: ,p_address_line3 in varchar2 default hr_api.g_varchar2
951: ,p_town_or_city in varchar2 default hr_api.g_varchar2
952: ,p_region_1 in varchar2 default hr_api.g_varchar2
953: ,p_region_2 in varchar2 default hr_api.g_varchar2
954: ,p_region_3 in varchar2 default hr_api.g_varchar2
955: ,p_postal_code in varchar2 default hr_api.g_varchar2
956: ,p_country in varchar2 default hr_api.g_varchar2

Line 953: ,p_region_2 in varchar2 default hr_api.g_varchar2

949: ,p_address_line2 in varchar2 default hr_api.g_varchar2
950: ,p_address_line3 in varchar2 default hr_api.g_varchar2
951: ,p_town_or_city in varchar2 default hr_api.g_varchar2
952: ,p_region_1 in varchar2 default hr_api.g_varchar2
953: ,p_region_2 in varchar2 default hr_api.g_varchar2
954: ,p_region_3 in varchar2 default hr_api.g_varchar2
955: ,p_postal_code in varchar2 default hr_api.g_varchar2
956: ,p_country in varchar2 default hr_api.g_varchar2
957: ,p_country_meaning in varchar2 default hr_api.g_varchar2

Line 954: ,p_region_3 in varchar2 default hr_api.g_varchar2

950: ,p_address_line3 in varchar2 default hr_api.g_varchar2
951: ,p_town_or_city in varchar2 default hr_api.g_varchar2
952: ,p_region_1 in varchar2 default hr_api.g_varchar2
953: ,p_region_2 in varchar2 default hr_api.g_varchar2
954: ,p_region_3 in varchar2 default hr_api.g_varchar2
955: ,p_postal_code in varchar2 default hr_api.g_varchar2
956: ,p_country in varchar2 default hr_api.g_varchar2
957: ,p_country_meaning in varchar2 default hr_api.g_varchar2
958: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

Line 955: ,p_postal_code in varchar2 default hr_api.g_varchar2

951: ,p_town_or_city in varchar2 default hr_api.g_varchar2
952: ,p_region_1 in varchar2 default hr_api.g_varchar2
953: ,p_region_2 in varchar2 default hr_api.g_varchar2
954: ,p_region_3 in varchar2 default hr_api.g_varchar2
955: ,p_postal_code in varchar2 default hr_api.g_varchar2
956: ,p_country in varchar2 default hr_api.g_varchar2
957: ,p_country_meaning in varchar2 default hr_api.g_varchar2
958: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
959: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

Line 956: ,p_country in varchar2 default hr_api.g_varchar2

952: ,p_region_1 in varchar2 default hr_api.g_varchar2
953: ,p_region_2 in varchar2 default hr_api.g_varchar2
954: ,p_region_3 in varchar2 default hr_api.g_varchar2
955: ,p_postal_code in varchar2 default hr_api.g_varchar2
956: ,p_country in varchar2 default hr_api.g_varchar2
957: ,p_country_meaning in varchar2 default hr_api.g_varchar2
958: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
959: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
960: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

Line 957: ,p_country_meaning in varchar2 default hr_api.g_varchar2

953: ,p_region_2 in varchar2 default hr_api.g_varchar2
954: ,p_region_3 in varchar2 default hr_api.g_varchar2
955: ,p_postal_code in varchar2 default hr_api.g_varchar2
956: ,p_country in varchar2 default hr_api.g_varchar2
957: ,p_country_meaning in varchar2 default hr_api.g_varchar2
958: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
959: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
960: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
961: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

Line 958: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

954: ,p_region_3 in varchar2 default hr_api.g_varchar2
955: ,p_postal_code in varchar2 default hr_api.g_varchar2
956: ,p_country in varchar2 default hr_api.g_varchar2
957: ,p_country_meaning in varchar2 default hr_api.g_varchar2
958: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
959: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
960: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
961: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
962: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

Line 959: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

955: ,p_postal_code in varchar2 default hr_api.g_varchar2
956: ,p_country in varchar2 default hr_api.g_varchar2
957: ,p_country_meaning in varchar2 default hr_api.g_varchar2
958: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
959: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
960: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
961: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
962: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
963: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

Line 960: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

956: ,p_country in varchar2 default hr_api.g_varchar2
957: ,p_country_meaning in varchar2 default hr_api.g_varchar2
958: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
959: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
960: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
961: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
962: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
963: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
964: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

Line 961: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

957: ,p_country_meaning in varchar2 default hr_api.g_varchar2
958: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
959: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
960: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
961: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
962: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
963: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
964: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
965: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

Line 962: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

958: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
959: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
960: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
961: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
962: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
963: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
964: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
965: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
966: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

Line 963: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

959: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
960: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
961: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
962: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
963: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
964: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
965: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
966: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
967: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

Line 964: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

960: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
961: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
962: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
963: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
964: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
965: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
966: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
967: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
968: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

Line 965: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

961: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
962: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
963: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
964: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
965: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
966: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
967: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
968: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
969: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

Line 966: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

962: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
963: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
964: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
965: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
966: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
967: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
968: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
969: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
970: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

Line 967: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

963: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
964: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
965: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
966: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
967: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
968: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
969: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
970: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
971: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

Line 968: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

964: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
965: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
966: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
967: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
968: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
969: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
970: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
971: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
972: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

Line 969: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

965: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
966: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
967: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
968: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
969: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
970: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
971: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
972: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
973: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

Line 970: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

966: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
967: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
968: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
969: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
970: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
971: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
972: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
973: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
974: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

Line 971: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

967: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
968: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
969: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
970: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
971: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
972: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
973: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
974: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
975: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

Line 972: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

968: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
969: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
970: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
971: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
972: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
973: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
974: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
975: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
976: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

Line 973: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

969: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
970: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
971: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
972: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
973: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
974: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
975: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
976: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
977: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

Line 974: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

970: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
971: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
972: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
973: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
974: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
975: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
976: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
977: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
978: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

Line 975: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

971: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
972: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
973: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
974: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
975: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
976: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
977: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
978: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
979: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

Line 976: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

972: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
973: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
974: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
975: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
976: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
977: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
978: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
979: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
980: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

Line 977: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

973: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
974: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
975: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
976: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
977: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
978: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
979: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
980: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
981: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

Line 978: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

974: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
975: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
976: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
977: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
978: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
979: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
980: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
981: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
982: ,p_add_information13 in varchar2 default hr_api.g_varchar2

Line 979: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

975: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
976: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
977: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
978: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
979: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
980: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
981: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
982: ,p_add_information13 in varchar2 default hr_api.g_varchar2
983: ,p_add_information14 in varchar2 default hr_api.g_varchar2

Line 980: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

976: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
977: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
978: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
979: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
980: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
981: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
982: ,p_add_information13 in varchar2 default hr_api.g_varchar2
983: ,p_add_information14 in varchar2 default hr_api.g_varchar2
984: ,p_add_information15 in varchar2 default hr_api.g_varchar2

Line 981: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

977: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
978: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
979: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
980: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
981: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
982: ,p_add_information13 in varchar2 default hr_api.g_varchar2
983: ,p_add_information14 in varchar2 default hr_api.g_varchar2
984: ,p_add_information15 in varchar2 default hr_api.g_varchar2
985: ,p_add_information16 in varchar2 default hr_api.g_varchar2

Line 982: ,p_add_information13 in varchar2 default hr_api.g_varchar2

978: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
979: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
980: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
981: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
982: ,p_add_information13 in varchar2 default hr_api.g_varchar2
983: ,p_add_information14 in varchar2 default hr_api.g_varchar2
984: ,p_add_information15 in varchar2 default hr_api.g_varchar2
985: ,p_add_information16 in varchar2 default hr_api.g_varchar2
986: ,p_add_information17 in varchar2 default hr_api.g_varchar2

Line 983: ,p_add_information14 in varchar2 default hr_api.g_varchar2

979: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
980: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
981: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
982: ,p_add_information13 in varchar2 default hr_api.g_varchar2
983: ,p_add_information14 in varchar2 default hr_api.g_varchar2
984: ,p_add_information15 in varchar2 default hr_api.g_varchar2
985: ,p_add_information16 in varchar2 default hr_api.g_varchar2
986: ,p_add_information17 in varchar2 default hr_api.g_varchar2
987: ,p_add_information18 in varchar2 default hr_api.g_varchar2

Line 984: ,p_add_information15 in varchar2 default hr_api.g_varchar2

980: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
981: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
982: ,p_add_information13 in varchar2 default hr_api.g_varchar2
983: ,p_add_information14 in varchar2 default hr_api.g_varchar2
984: ,p_add_information15 in varchar2 default hr_api.g_varchar2
985: ,p_add_information16 in varchar2 default hr_api.g_varchar2
986: ,p_add_information17 in varchar2 default hr_api.g_varchar2
987: ,p_add_information18 in varchar2 default hr_api.g_varchar2
988: ,p_add_information19 in varchar2 default hr_api.g_varchar2

Line 985: ,p_add_information16 in varchar2 default hr_api.g_varchar2

981: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
982: ,p_add_information13 in varchar2 default hr_api.g_varchar2
983: ,p_add_information14 in varchar2 default hr_api.g_varchar2
984: ,p_add_information15 in varchar2 default hr_api.g_varchar2
985: ,p_add_information16 in varchar2 default hr_api.g_varchar2
986: ,p_add_information17 in varchar2 default hr_api.g_varchar2
987: ,p_add_information18 in varchar2 default hr_api.g_varchar2
988: ,p_add_information19 in varchar2 default hr_api.g_varchar2
989: ,p_add_information20 in varchar2 default hr_api.g_varchar2

Line 986: ,p_add_information17 in varchar2 default hr_api.g_varchar2

982: ,p_add_information13 in varchar2 default hr_api.g_varchar2
983: ,p_add_information14 in varchar2 default hr_api.g_varchar2
984: ,p_add_information15 in varchar2 default hr_api.g_varchar2
985: ,p_add_information16 in varchar2 default hr_api.g_varchar2
986: ,p_add_information17 in varchar2 default hr_api.g_varchar2
987: ,p_add_information18 in varchar2 default hr_api.g_varchar2
988: ,p_add_information19 in varchar2 default hr_api.g_varchar2
989: ,p_add_information20 in varchar2 default hr_api.g_varchar2
990: ,p_item_type in varchar2

Line 987: ,p_add_information18 in varchar2 default hr_api.g_varchar2

983: ,p_add_information14 in varchar2 default hr_api.g_varchar2
984: ,p_add_information15 in varchar2 default hr_api.g_varchar2
985: ,p_add_information16 in varchar2 default hr_api.g_varchar2
986: ,p_add_information17 in varchar2 default hr_api.g_varchar2
987: ,p_add_information18 in varchar2 default hr_api.g_varchar2
988: ,p_add_information19 in varchar2 default hr_api.g_varchar2
989: ,p_add_information20 in varchar2 default hr_api.g_varchar2
990: ,p_item_type in varchar2
991: ,p_item_key in varchar2

Line 988: ,p_add_information19 in varchar2 default hr_api.g_varchar2

984: ,p_add_information15 in varchar2 default hr_api.g_varchar2
985: ,p_add_information16 in varchar2 default hr_api.g_varchar2
986: ,p_add_information17 in varchar2 default hr_api.g_varchar2
987: ,p_add_information18 in varchar2 default hr_api.g_varchar2
988: ,p_add_information19 in varchar2 default hr_api.g_varchar2
989: ,p_add_information20 in varchar2 default hr_api.g_varchar2
990: ,p_item_type in varchar2
991: ,p_item_key in varchar2
992: ,p_activity_id in number

Line 989: ,p_add_information20 in varchar2 default hr_api.g_varchar2

985: ,p_add_information16 in varchar2 default hr_api.g_varchar2
986: ,p_add_information17 in varchar2 default hr_api.g_varchar2
987: ,p_add_information18 in varchar2 default hr_api.g_varchar2
988: ,p_add_information19 in varchar2 default hr_api.g_varchar2
989: ,p_add_information20 in varchar2 default hr_api.g_varchar2
990: ,p_item_type in varchar2
991: ,p_item_key in varchar2
992: ,p_activity_id in number
993: ,p_person_id in number

Line 1008: , p_contact_relationship_id in number default hr_api.g_number

1004: ,p_style in varchar2
1005: ,p_action in varchar2
1006: ,p_save_mode in varchar2 default null
1007: ,p_error_message out nocopy long
1008: , p_contact_relationship_id in number default hr_api.g_number
1009: )
1010: IS
1011:
1012: l_proc varchar2(200) := g_package || 'update_person_address';

Line 2577: from hr_api_transaction_steps hats1

2573:
2574: BEGIN
2575: select nvl(hats1.transaction_step_id,0)
2576: into l_sfl_g_contact_step_id
2577: from hr_api_transaction_steps hats1
2578: where hats1.item_type = 'HRSSA'
2579: and hats1.item_key =
2580: (select hats2.item_key
2581: from hr_api_transaction_steps hats2

Line 2581: from hr_api_transaction_steps hats2

2577: from hr_api_transaction_steps hats1
2578: where hats1.item_type = 'HRSSA'
2579: and hats1.item_key =
2580: (select hats2.item_key
2581: from hr_api_transaction_steps hats2
2582: where hats2.item_type = 'HRSSA'
2583: and hats2.transaction_step_id = p_transaction_step_id )
2584: and hats1.api_name = 'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API';
2585: