eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 119: ,p_address_type in varchar2 default hr_api.g_varchar2

115: ,p_primary_flag in varchar2
116: ,p_style in varchar2
117: ,p_date_from in date
118: ,p_date_to in date default null
119: ,p_address_type in varchar2 default hr_api.g_varchar2
120: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
121: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
122: ,p_address_line1 in varchar2 default hr_api.g_varchar2
123: ,p_address_line2 in varchar2 default hr_api.g_varchar2

Line 120: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2

116: ,p_style in varchar2
117: ,p_date_from in date
118: ,p_date_to in date default null
119: ,p_address_type in varchar2 default hr_api.g_varchar2
120: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
121: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
122: ,p_address_line1 in varchar2 default hr_api.g_varchar2
123: ,p_address_line2 in varchar2 default hr_api.g_varchar2
124: ,p_address_line3 in varchar2 default hr_api.g_varchar2

Line 121: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792

117: ,p_date_from in date
118: ,p_date_to in date default null
119: ,p_address_type in varchar2 default hr_api.g_varchar2
120: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
121: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
122: ,p_address_line1 in varchar2 default hr_api.g_varchar2
123: ,p_address_line2 in varchar2 default hr_api.g_varchar2
124: ,p_address_line3 in varchar2 default hr_api.g_varchar2
125: ,p_town_or_city in varchar2 default hr_api.g_varchar2

Line 122: ,p_address_line1 in varchar2 default hr_api.g_varchar2

118: ,p_date_to in date default null
119: ,p_address_type in varchar2 default hr_api.g_varchar2
120: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
121: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
122: ,p_address_line1 in varchar2 default hr_api.g_varchar2
123: ,p_address_line2 in varchar2 default hr_api.g_varchar2
124: ,p_address_line3 in varchar2 default hr_api.g_varchar2
125: ,p_town_or_city in varchar2 default hr_api.g_varchar2
126: ,p_region_1 in varchar2 default hr_api.g_varchar2

Line 123: ,p_address_line2 in varchar2 default hr_api.g_varchar2

119: ,p_address_type in varchar2 default hr_api.g_varchar2
120: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
121: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
122: ,p_address_line1 in varchar2 default hr_api.g_varchar2
123: ,p_address_line2 in varchar2 default hr_api.g_varchar2
124: ,p_address_line3 in varchar2 default hr_api.g_varchar2
125: ,p_town_or_city in varchar2 default hr_api.g_varchar2
126: ,p_region_1 in varchar2 default hr_api.g_varchar2
127: ,p_region_2 in varchar2 default hr_api.g_varchar2

Line 124: ,p_address_line3 in varchar2 default hr_api.g_varchar2

120: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
121: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
122: ,p_address_line1 in varchar2 default hr_api.g_varchar2
123: ,p_address_line2 in varchar2 default hr_api.g_varchar2
124: ,p_address_line3 in varchar2 default hr_api.g_varchar2
125: ,p_town_or_city in varchar2 default hr_api.g_varchar2
126: ,p_region_1 in varchar2 default hr_api.g_varchar2
127: ,p_region_2 in varchar2 default hr_api.g_varchar2
128: ,p_region_3 in varchar2 default hr_api.g_varchar2

Line 125: ,p_town_or_city in varchar2 default hr_api.g_varchar2

121: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
122: ,p_address_line1 in varchar2 default hr_api.g_varchar2
123: ,p_address_line2 in varchar2 default hr_api.g_varchar2
124: ,p_address_line3 in varchar2 default hr_api.g_varchar2
125: ,p_town_or_city in varchar2 default hr_api.g_varchar2
126: ,p_region_1 in varchar2 default hr_api.g_varchar2
127: ,p_region_2 in varchar2 default hr_api.g_varchar2
128: ,p_region_3 in varchar2 default hr_api.g_varchar2
129: ,p_postal_code in varchar2 default hr_api.g_varchar2

Line 126: ,p_region_1 in varchar2 default hr_api.g_varchar2

122: ,p_address_line1 in varchar2 default hr_api.g_varchar2
123: ,p_address_line2 in varchar2 default hr_api.g_varchar2
124: ,p_address_line3 in varchar2 default hr_api.g_varchar2
125: ,p_town_or_city in varchar2 default hr_api.g_varchar2
126: ,p_region_1 in varchar2 default hr_api.g_varchar2
127: ,p_region_2 in varchar2 default hr_api.g_varchar2
128: ,p_region_3 in varchar2 default hr_api.g_varchar2
129: ,p_postal_code in varchar2 default hr_api.g_varchar2
130: ,p_country in varchar2 default hr_api.g_varchar2

Line 127: ,p_region_2 in varchar2 default hr_api.g_varchar2

123: ,p_address_line2 in varchar2 default hr_api.g_varchar2
124: ,p_address_line3 in varchar2 default hr_api.g_varchar2
125: ,p_town_or_city in varchar2 default hr_api.g_varchar2
126: ,p_region_1 in varchar2 default hr_api.g_varchar2
127: ,p_region_2 in varchar2 default hr_api.g_varchar2
128: ,p_region_3 in varchar2 default hr_api.g_varchar2
129: ,p_postal_code in varchar2 default hr_api.g_varchar2
130: ,p_country in varchar2 default hr_api.g_varchar2
131: ,p_country_meaning in varchar2 default hr_api.g_varchar2

Line 128: ,p_region_3 in varchar2 default hr_api.g_varchar2

124: ,p_address_line3 in varchar2 default hr_api.g_varchar2
125: ,p_town_or_city in varchar2 default hr_api.g_varchar2
126: ,p_region_1 in varchar2 default hr_api.g_varchar2
127: ,p_region_2 in varchar2 default hr_api.g_varchar2
128: ,p_region_3 in varchar2 default hr_api.g_varchar2
129: ,p_postal_code in varchar2 default hr_api.g_varchar2
130: ,p_country in varchar2 default hr_api.g_varchar2
131: ,p_country_meaning in varchar2 default hr_api.g_varchar2
132: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

Line 129: ,p_postal_code in varchar2 default hr_api.g_varchar2

125: ,p_town_or_city in varchar2 default hr_api.g_varchar2
126: ,p_region_1 in varchar2 default hr_api.g_varchar2
127: ,p_region_2 in varchar2 default hr_api.g_varchar2
128: ,p_region_3 in varchar2 default hr_api.g_varchar2
129: ,p_postal_code in varchar2 default hr_api.g_varchar2
130: ,p_country in varchar2 default hr_api.g_varchar2
131: ,p_country_meaning in varchar2 default hr_api.g_varchar2
132: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
133: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

Line 130: ,p_country in varchar2 default hr_api.g_varchar2

126: ,p_region_1 in varchar2 default hr_api.g_varchar2
127: ,p_region_2 in varchar2 default hr_api.g_varchar2
128: ,p_region_3 in varchar2 default hr_api.g_varchar2
129: ,p_postal_code in varchar2 default hr_api.g_varchar2
130: ,p_country in varchar2 default hr_api.g_varchar2
131: ,p_country_meaning in varchar2 default hr_api.g_varchar2
132: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
133: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
134: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

Line 131: ,p_country_meaning in varchar2 default hr_api.g_varchar2

127: ,p_region_2 in varchar2 default hr_api.g_varchar2
128: ,p_region_3 in varchar2 default hr_api.g_varchar2
129: ,p_postal_code in varchar2 default hr_api.g_varchar2
130: ,p_country in varchar2 default hr_api.g_varchar2
131: ,p_country_meaning in varchar2 default hr_api.g_varchar2
132: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
133: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
134: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
135: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

Line 132: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

128: ,p_region_3 in varchar2 default hr_api.g_varchar2
129: ,p_postal_code in varchar2 default hr_api.g_varchar2
130: ,p_country in varchar2 default hr_api.g_varchar2
131: ,p_country_meaning in varchar2 default hr_api.g_varchar2
132: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
133: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
134: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
135: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
136: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

Line 133: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

129: ,p_postal_code in varchar2 default hr_api.g_varchar2
130: ,p_country in varchar2 default hr_api.g_varchar2
131: ,p_country_meaning in varchar2 default hr_api.g_varchar2
132: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
133: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
134: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
135: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
136: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
137: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

Line 134: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

130: ,p_country in varchar2 default hr_api.g_varchar2
131: ,p_country_meaning in varchar2 default hr_api.g_varchar2
132: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
133: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
134: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
135: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
136: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
137: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
138: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

Line 135: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

131: ,p_country_meaning in varchar2 default hr_api.g_varchar2
132: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
133: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
134: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
135: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
136: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
137: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
138: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
139: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

Line 136: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

132: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
133: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
134: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
135: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
136: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
137: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
138: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
139: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
140: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

Line 137: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

133: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
134: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
135: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
136: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
137: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
138: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
139: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
140: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
141: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

Line 138: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

134: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
135: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
136: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
137: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
138: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
139: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
140: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
141: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
142: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

Line 139: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

135: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
136: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
137: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
138: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
139: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
140: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
141: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
142: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
143: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

Line 140: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

136: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
137: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
138: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
139: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
140: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
141: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
142: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
143: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
144: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

Line 141: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

137: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
138: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
139: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
140: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
141: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
142: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
143: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
144: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
145: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

Line 142: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

138: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
139: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
140: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
141: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
142: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
143: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
144: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
145: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
146: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

Line 143: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

139: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
140: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
141: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
142: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
143: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
144: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
145: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
146: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
147: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

Line 144: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

140: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
141: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
142: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
143: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
144: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
145: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
146: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
147: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
148: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

Line 145: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

141: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
142: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
143: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
144: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
145: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
146: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
147: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
148: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
149: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

Line 146: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

142: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
143: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
144: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
145: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
146: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
147: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
148: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
149: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
150: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

Line 147: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

143: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
144: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
145: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
146: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
147: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
148: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
149: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
150: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
151: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

Line 148: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

144: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
145: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
146: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
147: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
148: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
149: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
150: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
151: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
152: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

Line 149: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

145: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
146: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
147: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
148: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
149: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
150: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
151: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
152: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
153: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

Line 150: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

146: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
147: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
148: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
149: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
150: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
151: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
152: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
153: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
154: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

Line 151: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

147: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
148: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
149: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
150: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
151: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
152: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
153: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
154: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
155: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

Line 152: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

148: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
149: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
150: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
151: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
152: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
153: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
154: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
155: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
156: ,p_add_information13 in varchar2 default hr_api.g_varchar2

Line 153: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

149: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
150: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
151: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
152: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
153: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
154: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
155: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
156: ,p_add_information13 in varchar2 default hr_api.g_varchar2
157: ,p_add_information14 in varchar2 default hr_api.g_varchar2

Line 154: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

150: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
151: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
152: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
153: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
154: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
155: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
156: ,p_add_information13 in varchar2 default hr_api.g_varchar2
157: ,p_add_information14 in varchar2 default hr_api.g_varchar2
158: ,p_add_information15 in varchar2 default hr_api.g_varchar2

Line 155: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

151: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
152: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
153: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
154: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
155: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
156: ,p_add_information13 in varchar2 default hr_api.g_varchar2
157: ,p_add_information14 in varchar2 default hr_api.g_varchar2
158: ,p_add_information15 in varchar2 default hr_api.g_varchar2
159: ,p_add_information16 in varchar2 default hr_api.g_varchar2

Line 156: ,p_add_information13 in varchar2 default hr_api.g_varchar2

152: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
153: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
154: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
155: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
156: ,p_add_information13 in varchar2 default hr_api.g_varchar2
157: ,p_add_information14 in varchar2 default hr_api.g_varchar2
158: ,p_add_information15 in varchar2 default hr_api.g_varchar2
159: ,p_add_information16 in varchar2 default hr_api.g_varchar2
160: ,p_add_information17 in varchar2 default hr_api.g_varchar2

Line 157: ,p_add_information14 in varchar2 default hr_api.g_varchar2

153: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
154: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
155: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
156: ,p_add_information13 in varchar2 default hr_api.g_varchar2
157: ,p_add_information14 in varchar2 default hr_api.g_varchar2
158: ,p_add_information15 in varchar2 default hr_api.g_varchar2
159: ,p_add_information16 in varchar2 default hr_api.g_varchar2
160: ,p_add_information17 in varchar2 default hr_api.g_varchar2
161: ,p_add_information18 in varchar2 default hr_api.g_varchar2

Line 158: ,p_add_information15 in varchar2 default hr_api.g_varchar2

154: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
155: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
156: ,p_add_information13 in varchar2 default hr_api.g_varchar2
157: ,p_add_information14 in varchar2 default hr_api.g_varchar2
158: ,p_add_information15 in varchar2 default hr_api.g_varchar2
159: ,p_add_information16 in varchar2 default hr_api.g_varchar2
160: ,p_add_information17 in varchar2 default hr_api.g_varchar2
161: ,p_add_information18 in varchar2 default hr_api.g_varchar2
162: ,p_add_information19 in varchar2 default hr_api.g_varchar2

Line 159: ,p_add_information16 in varchar2 default hr_api.g_varchar2

155: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
156: ,p_add_information13 in varchar2 default hr_api.g_varchar2
157: ,p_add_information14 in varchar2 default hr_api.g_varchar2
158: ,p_add_information15 in varchar2 default hr_api.g_varchar2
159: ,p_add_information16 in varchar2 default hr_api.g_varchar2
160: ,p_add_information17 in varchar2 default hr_api.g_varchar2
161: ,p_add_information18 in varchar2 default hr_api.g_varchar2
162: ,p_add_information19 in varchar2 default hr_api.g_varchar2
163: ,p_add_information20 in varchar2 default hr_api.g_varchar2

Line 160: ,p_add_information17 in varchar2 default hr_api.g_varchar2

156: ,p_add_information13 in varchar2 default hr_api.g_varchar2
157: ,p_add_information14 in varchar2 default hr_api.g_varchar2
158: ,p_add_information15 in varchar2 default hr_api.g_varchar2
159: ,p_add_information16 in varchar2 default hr_api.g_varchar2
160: ,p_add_information17 in varchar2 default hr_api.g_varchar2
161: ,p_add_information18 in varchar2 default hr_api.g_varchar2
162: ,p_add_information19 in varchar2 default hr_api.g_varchar2
163: ,p_add_information20 in varchar2 default hr_api.g_varchar2
164: ,p_address_id out nocopy number

Line 161: ,p_add_information18 in varchar2 default hr_api.g_varchar2

157: ,p_add_information14 in varchar2 default hr_api.g_varchar2
158: ,p_add_information15 in varchar2 default hr_api.g_varchar2
159: ,p_add_information16 in varchar2 default hr_api.g_varchar2
160: ,p_add_information17 in varchar2 default hr_api.g_varchar2
161: ,p_add_information18 in varchar2 default hr_api.g_varchar2
162: ,p_add_information19 in varchar2 default hr_api.g_varchar2
163: ,p_add_information20 in varchar2 default hr_api.g_varchar2
164: ,p_address_id out nocopy number
165: ,p_object_version_number out nocopy number

Line 162: ,p_add_information19 in varchar2 default hr_api.g_varchar2

158: ,p_add_information15 in varchar2 default hr_api.g_varchar2
159: ,p_add_information16 in varchar2 default hr_api.g_varchar2
160: ,p_add_information17 in varchar2 default hr_api.g_varchar2
161: ,p_add_information18 in varchar2 default hr_api.g_varchar2
162: ,p_add_information19 in varchar2 default hr_api.g_varchar2
163: ,p_add_information20 in varchar2 default hr_api.g_varchar2
164: ,p_address_id out nocopy number
165: ,p_object_version_number out nocopy number
166: -- StartRegistration

Line 163: ,p_add_information20 in varchar2 default hr_api.g_varchar2

159: ,p_add_information16 in varchar2 default hr_api.g_varchar2
160: ,p_add_information17 in varchar2 default hr_api.g_varchar2
161: ,p_add_information18 in varchar2 default hr_api.g_varchar2
162: ,p_add_information19 in varchar2 default hr_api.g_varchar2
163: ,p_add_information20 in varchar2 default hr_api.g_varchar2
164: ,p_address_id out nocopy number
165: ,p_object_version_number out nocopy number
166: -- StartRegistration
167: ,p_contact_or_person in varchar2 default null

Line 177: , p_contact_relationship_id in number default hr_api.g_number

173: ,p_old_address_id in number default null
174: ,p_old_object_version_number in number default null
175: ,p_save_mode in varchar2 default null
176: ,p_error_message out nocopy long
177: , p_contact_relationship_id in number default hr_api.g_number
178: )
179: IS
180:
181: l_proc varchar2(200) := g_package || 'create_person_address';

Line 951: ,p_date_from in date default hr_api.g_date

947: ,p_effective_date in date
948: ,p_validate_county in number default 1
949: ,p_address_id in number
950: ,p_object_version_number in out nocopy number
951: ,p_date_from in date default hr_api.g_date
952: ,p_date_to in date default hr_api.g_date
953: ,p_address_type in varchar2 default hr_api.g_varchar2
954: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
955: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792

Line 952: ,p_date_to in date default hr_api.g_date

948: ,p_validate_county in number default 1
949: ,p_address_id in number
950: ,p_object_version_number in out nocopy number
951: ,p_date_from in date default hr_api.g_date
952: ,p_date_to in date default hr_api.g_date
953: ,p_address_type in varchar2 default hr_api.g_varchar2
954: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
955: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
956: ,p_address_line1 in varchar2 default hr_api.g_varchar2

Line 953: ,p_address_type in varchar2 default hr_api.g_varchar2

949: ,p_address_id in number
950: ,p_object_version_number in out nocopy number
951: ,p_date_from in date default hr_api.g_date
952: ,p_date_to in date default hr_api.g_date
953: ,p_address_type in varchar2 default hr_api.g_varchar2
954: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
955: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
956: ,p_address_line1 in varchar2 default hr_api.g_varchar2
957: ,p_address_line2 in varchar2 default hr_api.g_varchar2

Line 954: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2

950: ,p_object_version_number in out nocopy number
951: ,p_date_from in date default hr_api.g_date
952: ,p_date_to in date default hr_api.g_date
953: ,p_address_type in varchar2 default hr_api.g_varchar2
954: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
955: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
956: ,p_address_line1 in varchar2 default hr_api.g_varchar2
957: ,p_address_line2 in varchar2 default hr_api.g_varchar2
958: ,p_address_line3 in varchar2 default hr_api.g_varchar2

Line 955: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792

951: ,p_date_from in date default hr_api.g_date
952: ,p_date_to in date default hr_api.g_date
953: ,p_address_type in varchar2 default hr_api.g_varchar2
954: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
955: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
956: ,p_address_line1 in varchar2 default hr_api.g_varchar2
957: ,p_address_line2 in varchar2 default hr_api.g_varchar2
958: ,p_address_line3 in varchar2 default hr_api.g_varchar2
959: ,p_town_or_city in varchar2 default hr_api.g_varchar2

Line 956: ,p_address_line1 in varchar2 default hr_api.g_varchar2

952: ,p_date_to in date default hr_api.g_date
953: ,p_address_type in varchar2 default hr_api.g_varchar2
954: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
955: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
956: ,p_address_line1 in varchar2 default hr_api.g_varchar2
957: ,p_address_line2 in varchar2 default hr_api.g_varchar2
958: ,p_address_line3 in varchar2 default hr_api.g_varchar2
959: ,p_town_or_city in varchar2 default hr_api.g_varchar2
960: ,p_region_1 in varchar2 default hr_api.g_varchar2

Line 957: ,p_address_line2 in varchar2 default hr_api.g_varchar2

953: ,p_address_type in varchar2 default hr_api.g_varchar2
954: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
955: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
956: ,p_address_line1 in varchar2 default hr_api.g_varchar2
957: ,p_address_line2 in varchar2 default hr_api.g_varchar2
958: ,p_address_line3 in varchar2 default hr_api.g_varchar2
959: ,p_town_or_city in varchar2 default hr_api.g_varchar2
960: ,p_region_1 in varchar2 default hr_api.g_varchar2
961: ,p_region_2 in varchar2 default hr_api.g_varchar2

Line 958: ,p_address_line3 in varchar2 default hr_api.g_varchar2

954: ,p_address_type_meaning in varchar2 default hr_api.g_varchar2
955: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
956: ,p_address_line1 in varchar2 default hr_api.g_varchar2
957: ,p_address_line2 in varchar2 default hr_api.g_varchar2
958: ,p_address_line3 in varchar2 default hr_api.g_varchar2
959: ,p_town_or_city in varchar2 default hr_api.g_varchar2
960: ,p_region_1 in varchar2 default hr_api.g_varchar2
961: ,p_region_2 in varchar2 default hr_api.g_varchar2
962: ,p_region_3 in varchar2 default hr_api.g_varchar2

Line 959: ,p_town_or_city in varchar2 default hr_api.g_varchar2

955: ,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
956: ,p_address_line1 in varchar2 default hr_api.g_varchar2
957: ,p_address_line2 in varchar2 default hr_api.g_varchar2
958: ,p_address_line3 in varchar2 default hr_api.g_varchar2
959: ,p_town_or_city in varchar2 default hr_api.g_varchar2
960: ,p_region_1 in varchar2 default hr_api.g_varchar2
961: ,p_region_2 in varchar2 default hr_api.g_varchar2
962: ,p_region_3 in varchar2 default hr_api.g_varchar2
963: ,p_postal_code in varchar2 default hr_api.g_varchar2

Line 960: ,p_region_1 in varchar2 default hr_api.g_varchar2

956: ,p_address_line1 in varchar2 default hr_api.g_varchar2
957: ,p_address_line2 in varchar2 default hr_api.g_varchar2
958: ,p_address_line3 in varchar2 default hr_api.g_varchar2
959: ,p_town_or_city in varchar2 default hr_api.g_varchar2
960: ,p_region_1 in varchar2 default hr_api.g_varchar2
961: ,p_region_2 in varchar2 default hr_api.g_varchar2
962: ,p_region_3 in varchar2 default hr_api.g_varchar2
963: ,p_postal_code in varchar2 default hr_api.g_varchar2
964: ,p_country in varchar2 default hr_api.g_varchar2

Line 961: ,p_region_2 in varchar2 default hr_api.g_varchar2

957: ,p_address_line2 in varchar2 default hr_api.g_varchar2
958: ,p_address_line3 in varchar2 default hr_api.g_varchar2
959: ,p_town_or_city in varchar2 default hr_api.g_varchar2
960: ,p_region_1 in varchar2 default hr_api.g_varchar2
961: ,p_region_2 in varchar2 default hr_api.g_varchar2
962: ,p_region_3 in varchar2 default hr_api.g_varchar2
963: ,p_postal_code in varchar2 default hr_api.g_varchar2
964: ,p_country in varchar2 default hr_api.g_varchar2
965: ,p_country_meaning in varchar2 default hr_api.g_varchar2

Line 962: ,p_region_3 in varchar2 default hr_api.g_varchar2

958: ,p_address_line3 in varchar2 default hr_api.g_varchar2
959: ,p_town_or_city in varchar2 default hr_api.g_varchar2
960: ,p_region_1 in varchar2 default hr_api.g_varchar2
961: ,p_region_2 in varchar2 default hr_api.g_varchar2
962: ,p_region_3 in varchar2 default hr_api.g_varchar2
963: ,p_postal_code in varchar2 default hr_api.g_varchar2
964: ,p_country in varchar2 default hr_api.g_varchar2
965: ,p_country_meaning in varchar2 default hr_api.g_varchar2
966: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

Line 963: ,p_postal_code in varchar2 default hr_api.g_varchar2

959: ,p_town_or_city in varchar2 default hr_api.g_varchar2
960: ,p_region_1 in varchar2 default hr_api.g_varchar2
961: ,p_region_2 in varchar2 default hr_api.g_varchar2
962: ,p_region_3 in varchar2 default hr_api.g_varchar2
963: ,p_postal_code in varchar2 default hr_api.g_varchar2
964: ,p_country in varchar2 default hr_api.g_varchar2
965: ,p_country_meaning in varchar2 default hr_api.g_varchar2
966: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
967: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

Line 964: ,p_country in varchar2 default hr_api.g_varchar2

960: ,p_region_1 in varchar2 default hr_api.g_varchar2
961: ,p_region_2 in varchar2 default hr_api.g_varchar2
962: ,p_region_3 in varchar2 default hr_api.g_varchar2
963: ,p_postal_code in varchar2 default hr_api.g_varchar2
964: ,p_country in varchar2 default hr_api.g_varchar2
965: ,p_country_meaning in varchar2 default hr_api.g_varchar2
966: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
967: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
968: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

Line 965: ,p_country_meaning in varchar2 default hr_api.g_varchar2

961: ,p_region_2 in varchar2 default hr_api.g_varchar2
962: ,p_region_3 in varchar2 default hr_api.g_varchar2
963: ,p_postal_code in varchar2 default hr_api.g_varchar2
964: ,p_country in varchar2 default hr_api.g_varchar2
965: ,p_country_meaning in varchar2 default hr_api.g_varchar2
966: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
967: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
968: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
969: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

Line 966: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

962: ,p_region_3 in varchar2 default hr_api.g_varchar2
963: ,p_postal_code in varchar2 default hr_api.g_varchar2
964: ,p_country in varchar2 default hr_api.g_varchar2
965: ,p_country_meaning in varchar2 default hr_api.g_varchar2
966: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
967: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
968: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
969: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
970: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

Line 967: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

963: ,p_postal_code in varchar2 default hr_api.g_varchar2
964: ,p_country in varchar2 default hr_api.g_varchar2
965: ,p_country_meaning in varchar2 default hr_api.g_varchar2
966: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
967: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
968: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
969: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
970: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
971: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

Line 968: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

964: ,p_country in varchar2 default hr_api.g_varchar2
965: ,p_country_meaning in varchar2 default hr_api.g_varchar2
966: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
967: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
968: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
969: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
970: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
971: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
972: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

Line 969: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

965: ,p_country_meaning in varchar2 default hr_api.g_varchar2
966: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
967: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
968: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
969: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
970: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
971: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
972: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
973: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

Line 970: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

966: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
967: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
968: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
969: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
970: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
971: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
972: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
973: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
974: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

Line 971: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

967: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
968: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
969: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
970: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
971: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
972: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
973: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
974: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
975: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

Line 972: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

968: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
969: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
970: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
971: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
972: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
973: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
974: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
975: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
976: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

Line 973: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

969: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
970: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
971: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
972: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
973: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
974: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
975: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
976: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
977: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

Line 974: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

970: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
971: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
972: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
973: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
974: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
975: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
976: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
977: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
978: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

Line 975: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

971: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
972: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
973: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
974: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
975: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
976: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
977: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
978: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
979: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

Line 976: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

972: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
973: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
974: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
975: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
976: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
977: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
978: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
979: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
980: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

Line 977: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

973: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
974: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
975: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
976: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
977: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
978: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
979: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
980: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
981: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

Line 978: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

974: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
975: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
976: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
977: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
978: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
979: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
980: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
981: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
982: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

Line 979: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

975: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
976: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
977: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
978: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
979: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
980: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
981: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
982: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
983: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

Line 980: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

976: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
977: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
978: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
979: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
980: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
981: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
982: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
983: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
984: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

Line 981: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

977: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
978: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
979: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
980: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
981: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
982: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
983: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
984: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
985: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

Line 982: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

978: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
979: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
980: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
981: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
982: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
983: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
984: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
985: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
986: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

Line 983: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

979: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
980: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
981: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
982: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
983: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
984: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
985: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
986: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
987: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

Line 984: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

980: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
981: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
982: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
983: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
984: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
985: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
986: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
987: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
988: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

Line 985: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

981: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
982: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
983: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
984: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
985: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
986: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
987: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
988: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
989: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

Line 986: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

982: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
983: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
984: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
985: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
986: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
987: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
988: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
989: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
990: ,p_add_information13 in varchar2 default hr_api.g_varchar2

Line 987: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

983: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
984: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
985: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
986: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
987: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
988: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
989: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
990: ,p_add_information13 in varchar2 default hr_api.g_varchar2
991: ,p_add_information14 in varchar2 default hr_api.g_varchar2

Line 988: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

984: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
985: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
986: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
987: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
988: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
989: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
990: ,p_add_information13 in varchar2 default hr_api.g_varchar2
991: ,p_add_information14 in varchar2 default hr_api.g_varchar2
992: ,p_add_information15 in varchar2 default hr_api.g_varchar2

Line 989: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

985: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
986: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
987: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
988: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
989: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
990: ,p_add_information13 in varchar2 default hr_api.g_varchar2
991: ,p_add_information14 in varchar2 default hr_api.g_varchar2
992: ,p_add_information15 in varchar2 default hr_api.g_varchar2
993: ,p_add_information16 in varchar2 default hr_api.g_varchar2

Line 990: ,p_add_information13 in varchar2 default hr_api.g_varchar2

986: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
987: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
988: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
989: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
990: ,p_add_information13 in varchar2 default hr_api.g_varchar2
991: ,p_add_information14 in varchar2 default hr_api.g_varchar2
992: ,p_add_information15 in varchar2 default hr_api.g_varchar2
993: ,p_add_information16 in varchar2 default hr_api.g_varchar2
994: ,p_add_information17 in varchar2 default hr_api.g_varchar2

Line 991: ,p_add_information14 in varchar2 default hr_api.g_varchar2

987: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
988: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
989: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
990: ,p_add_information13 in varchar2 default hr_api.g_varchar2
991: ,p_add_information14 in varchar2 default hr_api.g_varchar2
992: ,p_add_information15 in varchar2 default hr_api.g_varchar2
993: ,p_add_information16 in varchar2 default hr_api.g_varchar2
994: ,p_add_information17 in varchar2 default hr_api.g_varchar2
995: ,p_add_information18 in varchar2 default hr_api.g_varchar2

Line 992: ,p_add_information15 in varchar2 default hr_api.g_varchar2

988: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
989: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
990: ,p_add_information13 in varchar2 default hr_api.g_varchar2
991: ,p_add_information14 in varchar2 default hr_api.g_varchar2
992: ,p_add_information15 in varchar2 default hr_api.g_varchar2
993: ,p_add_information16 in varchar2 default hr_api.g_varchar2
994: ,p_add_information17 in varchar2 default hr_api.g_varchar2
995: ,p_add_information18 in varchar2 default hr_api.g_varchar2
996: ,p_add_information19 in varchar2 default hr_api.g_varchar2

Line 993: ,p_add_information16 in varchar2 default hr_api.g_varchar2

989: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
990: ,p_add_information13 in varchar2 default hr_api.g_varchar2
991: ,p_add_information14 in varchar2 default hr_api.g_varchar2
992: ,p_add_information15 in varchar2 default hr_api.g_varchar2
993: ,p_add_information16 in varchar2 default hr_api.g_varchar2
994: ,p_add_information17 in varchar2 default hr_api.g_varchar2
995: ,p_add_information18 in varchar2 default hr_api.g_varchar2
996: ,p_add_information19 in varchar2 default hr_api.g_varchar2
997: ,p_add_information20 in varchar2 default hr_api.g_varchar2

Line 994: ,p_add_information17 in varchar2 default hr_api.g_varchar2

990: ,p_add_information13 in varchar2 default hr_api.g_varchar2
991: ,p_add_information14 in varchar2 default hr_api.g_varchar2
992: ,p_add_information15 in varchar2 default hr_api.g_varchar2
993: ,p_add_information16 in varchar2 default hr_api.g_varchar2
994: ,p_add_information17 in varchar2 default hr_api.g_varchar2
995: ,p_add_information18 in varchar2 default hr_api.g_varchar2
996: ,p_add_information19 in varchar2 default hr_api.g_varchar2
997: ,p_add_information20 in varchar2 default hr_api.g_varchar2
998: ,p_item_type in varchar2

Line 995: ,p_add_information18 in varchar2 default hr_api.g_varchar2

991: ,p_add_information14 in varchar2 default hr_api.g_varchar2
992: ,p_add_information15 in varchar2 default hr_api.g_varchar2
993: ,p_add_information16 in varchar2 default hr_api.g_varchar2
994: ,p_add_information17 in varchar2 default hr_api.g_varchar2
995: ,p_add_information18 in varchar2 default hr_api.g_varchar2
996: ,p_add_information19 in varchar2 default hr_api.g_varchar2
997: ,p_add_information20 in varchar2 default hr_api.g_varchar2
998: ,p_item_type in varchar2
999: ,p_item_key in varchar2

Line 996: ,p_add_information19 in varchar2 default hr_api.g_varchar2

992: ,p_add_information15 in varchar2 default hr_api.g_varchar2
993: ,p_add_information16 in varchar2 default hr_api.g_varchar2
994: ,p_add_information17 in varchar2 default hr_api.g_varchar2
995: ,p_add_information18 in varchar2 default hr_api.g_varchar2
996: ,p_add_information19 in varchar2 default hr_api.g_varchar2
997: ,p_add_information20 in varchar2 default hr_api.g_varchar2
998: ,p_item_type in varchar2
999: ,p_item_key in varchar2
1000: ,p_activity_id in number

Line 997: ,p_add_information20 in varchar2 default hr_api.g_varchar2

993: ,p_add_information16 in varchar2 default hr_api.g_varchar2
994: ,p_add_information17 in varchar2 default hr_api.g_varchar2
995: ,p_add_information18 in varchar2 default hr_api.g_varchar2
996: ,p_add_information19 in varchar2 default hr_api.g_varchar2
997: ,p_add_information20 in varchar2 default hr_api.g_varchar2
998: ,p_item_type in varchar2
999: ,p_item_key in varchar2
1000: ,p_activity_id in number
1001: ,p_person_id in number

Line 1016: , p_contact_relationship_id in number default hr_api.g_number

1012: ,p_style in varchar2
1013: ,p_action in varchar2
1014: ,p_save_mode in varchar2 default null
1015: ,p_error_message out nocopy long
1016: , p_contact_relationship_id in number default hr_api.g_number
1017: )
1018: IS
1019:
1020: l_proc varchar2(200) := g_package || 'update_person_address';

Line 2585: from hr_api_transaction_steps hats1

2581:
2582: BEGIN
2583: select nvl(hats1.transaction_step_id,0)
2584: into l_sfl_g_contact_step_id
2585: from hr_api_transaction_steps hats1
2586: where hats1.item_type = 'HRSSA'
2587: and hats1.item_key =
2588: (select hats2.item_key
2589: from hr_api_transaction_steps hats2

Line 2589: from hr_api_transaction_steps hats2

2585: from hr_api_transaction_steps hats1
2586: where hats1.item_type = 'HRSSA'
2587: and hats1.item_key =
2588: (select hats2.item_key
2589: from hr_api_transaction_steps hats2
2590: where hats2.item_type = 'HRSSA'
2591: and hats2.transaction_step_id = p_transaction_step_id )
2592: and hats1.api_name = 'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API';
2593: