133: IF l_to_prof_amt_id = FND_API.G_MISS_NUM THEN
134:
135: UPDATE hz_cust_profile_amts
136: SET cust_account_profile_id = p_to_profile_id,
137: last_update_date = hz_utility_pub.last_update_date,
138: last_updated_by = hz_utility_pub.user_id,
139: last_update_login = hz_utility_pub.last_update_login,
140: request_id = hz_utility_pub.request_id,
141: program_application_id = hz_utility_pub.program_application_id,
134:
135: UPDATE hz_cust_profile_amts
136: SET cust_account_profile_id = p_to_profile_id,
137: last_update_date = hz_utility_pub.last_update_date,
138: last_updated_by = hz_utility_pub.user_id,
139: last_update_login = hz_utility_pub.last_update_login,
140: request_id = hz_utility_pub.request_id,
141: program_application_id = hz_utility_pub.program_application_id,
142: program_id = hz_utility_pub.program_id,
135: UPDATE hz_cust_profile_amts
136: SET cust_account_profile_id = p_to_profile_id,
137: last_update_date = hz_utility_pub.last_update_date,
138: last_updated_by = hz_utility_pub.user_id,
139: last_update_login = hz_utility_pub.last_update_login,
140: request_id = hz_utility_pub.request_id,
141: program_application_id = hz_utility_pub.program_application_id,
142: program_id = hz_utility_pub.program_id,
143: program_update_date = sysdate
136: SET cust_account_profile_id = p_to_profile_id,
137: last_update_date = hz_utility_pub.last_update_date,
138: last_updated_by = hz_utility_pub.user_id,
139: last_update_login = hz_utility_pub.last_update_login,
140: request_id = hz_utility_pub.request_id,
141: program_application_id = hz_utility_pub.program_application_id,
142: program_id = hz_utility_pub.program_id,
143: program_update_date = sysdate
144: WHERE cust_acct_profile_amt_id = l_rec.cust_acct_profile_amt_id;
137: last_update_date = hz_utility_pub.last_update_date,
138: last_updated_by = hz_utility_pub.user_id,
139: last_update_login = hz_utility_pub.last_update_login,
140: request_id = hz_utility_pub.request_id,
141: program_application_id = hz_utility_pub.program_application_id,
142: program_id = hz_utility_pub.program_id,
143: program_update_date = sysdate
144: WHERE cust_acct_profile_amt_id = l_rec.cust_acct_profile_amt_id;
145:
138: last_updated_by = hz_utility_pub.user_id,
139: last_update_login = hz_utility_pub.last_update_login,
140: request_id = hz_utility_pub.request_id,
141: program_application_id = hz_utility_pub.program_application_id,
142: program_id = hz_utility_pub.program_id,
143: program_update_date = sysdate
144: WHERE cust_acct_profile_amt_id = l_rec.cust_acct_profile_amt_id;
145:
146: END IF;
204: -- Site Use Level Stuff
205: -- Transfert
206: UPDATE hz_customer_profiles
207: SET party_id = p_to_fk_id,
208: last_update_date = hz_utility_pub.last_update_date,
209: last_updated_by = hz_utility_pub.user_id,
210: last_update_login = hz_utility_pub.last_update_login,
211: request_id = hz_utility_pub.request_id,
212: program_application_id = hz_utility_pub.program_application_id,
205: -- Transfert
206: UPDATE hz_customer_profiles
207: SET party_id = p_to_fk_id,
208: last_update_date = hz_utility_pub.last_update_date,
209: last_updated_by = hz_utility_pub.user_id,
210: last_update_login = hz_utility_pub.last_update_login,
211: request_id = hz_utility_pub.request_id,
212: program_application_id = hz_utility_pub.program_application_id,
213: program_id = hz_utility_pub.program_id,
206: UPDATE hz_customer_profiles
207: SET party_id = p_to_fk_id,
208: last_update_date = hz_utility_pub.last_update_date,
209: last_updated_by = hz_utility_pub.user_id,
210: last_update_login = hz_utility_pub.last_update_login,
211: request_id = hz_utility_pub.request_id,
212: program_application_id = hz_utility_pub.program_application_id,
213: program_id = hz_utility_pub.program_id,
214: program_update_date = sysdate
207: SET party_id = p_to_fk_id,
208: last_update_date = hz_utility_pub.last_update_date,
209: last_updated_by = hz_utility_pub.user_id,
210: last_update_login = hz_utility_pub.last_update_login,
211: request_id = hz_utility_pub.request_id,
212: program_application_id = hz_utility_pub.program_application_id,
213: program_id = hz_utility_pub.program_id,
214: program_update_date = sysdate
215: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
208: last_update_date = hz_utility_pub.last_update_date,
209: last_updated_by = hz_utility_pub.user_id,
210: last_update_login = hz_utility_pub.last_update_login,
211: request_id = hz_utility_pub.request_id,
212: program_application_id = hz_utility_pub.program_application_id,
213: program_id = hz_utility_pub.program_id,
214: program_update_date = sysdate
215: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
216:
209: last_updated_by = hz_utility_pub.user_id,
210: last_update_login = hz_utility_pub.last_update_login,
211: request_id = hz_utility_pub.request_id,
212: program_application_id = hz_utility_pub.program_application_id,
213: program_id = hz_utility_pub.program_id,
214: program_update_date = sysdate
215: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
216:
217:
220: -- Account Level Stuff
221: -- Transfert
222: UPDATE hz_customer_profiles
223: SET party_id = p_to_fk_id,
224: last_update_date = hz_utility_pub.last_update_date,
225: last_updated_by = hz_utility_pub.user_id,
226: last_update_login = hz_utility_pub.last_update_login,
227: request_id = hz_utility_pub.request_id,
228: program_application_id = hz_utility_pub.program_application_id,
221: -- Transfert
222: UPDATE hz_customer_profiles
223: SET party_id = p_to_fk_id,
224: last_update_date = hz_utility_pub.last_update_date,
225: last_updated_by = hz_utility_pub.user_id,
226: last_update_login = hz_utility_pub.last_update_login,
227: request_id = hz_utility_pub.request_id,
228: program_application_id = hz_utility_pub.program_application_id,
229: program_id = hz_utility_pub.program_id,
222: UPDATE hz_customer_profiles
223: SET party_id = p_to_fk_id,
224: last_update_date = hz_utility_pub.last_update_date,
225: last_updated_by = hz_utility_pub.user_id,
226: last_update_login = hz_utility_pub.last_update_login,
227: request_id = hz_utility_pub.request_id,
228: program_application_id = hz_utility_pub.program_application_id,
229: program_id = hz_utility_pub.program_id,
230: program_update_date = sysdate
223: SET party_id = p_to_fk_id,
224: last_update_date = hz_utility_pub.last_update_date,
225: last_updated_by = hz_utility_pub.user_id,
226: last_update_login = hz_utility_pub.last_update_login,
227: request_id = hz_utility_pub.request_id,
228: program_application_id = hz_utility_pub.program_application_id,
229: program_id = hz_utility_pub.program_id,
230: program_update_date = sysdate
231: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
224: last_update_date = hz_utility_pub.last_update_date,
225: last_updated_by = hz_utility_pub.user_id,
226: last_update_login = hz_utility_pub.last_update_login,
227: request_id = hz_utility_pub.request_id,
228: program_application_id = hz_utility_pub.program_application_id,
229: program_id = hz_utility_pub.program_id,
230: program_update_date = sysdate
231: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
232:
225: last_updated_by = hz_utility_pub.user_id,
226: last_update_login = hz_utility_pub.last_update_login,
227: request_id = hz_utility_pub.request_id,
228: program_application_id = hz_utility_pub.program_application_id,
229: program_id = hz_utility_pub.program_id,
230: program_update_date = sysdate
231: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
232:
233: ELSE
240:
241: -- Transfert Party Profile
242: UPDATE hz_customer_profiles
243: SET party_id = p_to_fk_id,
244: last_update_date = hz_utility_pub.last_update_date,
245: last_updated_by = hz_utility_pub.user_id,
246: last_update_login = hz_utility_pub.last_update_login,
247: request_id = hz_utility_pub.request_id,
248: program_application_id = hz_utility_pub.program_application_id,
241: -- Transfert Party Profile
242: UPDATE hz_customer_profiles
243: SET party_id = p_to_fk_id,
244: last_update_date = hz_utility_pub.last_update_date,
245: last_updated_by = hz_utility_pub.user_id,
246: last_update_login = hz_utility_pub.last_update_login,
247: request_id = hz_utility_pub.request_id,
248: program_application_id = hz_utility_pub.program_application_id,
249: program_id = hz_utility_pub.program_id,
242: UPDATE hz_customer_profiles
243: SET party_id = p_to_fk_id,
244: last_update_date = hz_utility_pub.last_update_date,
245: last_updated_by = hz_utility_pub.user_id,
246: last_update_login = hz_utility_pub.last_update_login,
247: request_id = hz_utility_pub.request_id,
248: program_application_id = hz_utility_pub.program_application_id,
249: program_id = hz_utility_pub.program_id,
250: program_update_date = sysdate
243: SET party_id = p_to_fk_id,
244: last_update_date = hz_utility_pub.last_update_date,
245: last_updated_by = hz_utility_pub.user_id,
246: last_update_login = hz_utility_pub.last_update_login,
247: request_id = hz_utility_pub.request_id,
248: program_application_id = hz_utility_pub.program_application_id,
249: program_id = hz_utility_pub.program_id,
250: program_update_date = sysdate
251: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
244: last_update_date = hz_utility_pub.last_update_date,
245: last_updated_by = hz_utility_pub.user_id,
246: last_update_login = hz_utility_pub.last_update_login,
247: request_id = hz_utility_pub.request_id,
248: program_application_id = hz_utility_pub.program_application_id,
249: program_id = hz_utility_pub.program_id,
250: program_update_date = sysdate
251: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
252:
245: last_updated_by = hz_utility_pub.user_id,
246: last_update_login = hz_utility_pub.last_update_login,
247: request_id = hz_utility_pub.request_id,
248: program_application_id = hz_utility_pub.program_application_id,
249: program_id = hz_utility_pub.program_id,
250: program_update_date = sysdate
251: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
252:
253: ELSE
259: END IF;
260:
261: UPDATE hz_customer_profiles
262: SET status = 'M',
263: last_update_date = hz_utility_pub.last_update_date,
264: last_updated_by = hz_utility_pub.user_id,
265: last_update_login = hz_utility_pub.last_update_login,
266: request_id = hz_utility_pub.request_id,
267: program_application_id = hz_utility_pub.program_application_id,
260:
261: UPDATE hz_customer_profiles
262: SET status = 'M',
263: last_update_date = hz_utility_pub.last_update_date,
264: last_updated_by = hz_utility_pub.user_id,
265: last_update_login = hz_utility_pub.last_update_login,
266: request_id = hz_utility_pub.request_id,
267: program_application_id = hz_utility_pub.program_application_id,
268: program_id = hz_utility_pub.program_id,
261: UPDATE hz_customer_profiles
262: SET status = 'M',
263: last_update_date = hz_utility_pub.last_update_date,
264: last_updated_by = hz_utility_pub.user_id,
265: last_update_login = hz_utility_pub.last_update_login,
266: request_id = hz_utility_pub.request_id,
267: program_application_id = hz_utility_pub.program_application_id,
268: program_id = hz_utility_pub.program_id,
269: program_update_date = sysdate
262: SET status = 'M',
263: last_update_date = hz_utility_pub.last_update_date,
264: last_updated_by = hz_utility_pub.user_id,
265: last_update_login = hz_utility_pub.last_update_login,
266: request_id = hz_utility_pub.request_id,
267: program_application_id = hz_utility_pub.program_application_id,
268: program_id = hz_utility_pub.program_id,
269: program_update_date = sysdate
270: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
263: last_update_date = hz_utility_pub.last_update_date,
264: last_updated_by = hz_utility_pub.user_id,
265: last_update_login = hz_utility_pub.last_update_login,
266: request_id = hz_utility_pub.request_id,
267: program_application_id = hz_utility_pub.program_application_id,
268: program_id = hz_utility_pub.program_id,
269: program_update_date = sysdate
270: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
271:
264: last_updated_by = hz_utility_pub.user_id,
265: last_update_login = hz_utility_pub.last_update_login,
266: request_id = hz_utility_pub.request_id,
267: program_application_id = hz_utility_pub.program_application_id,
268: program_id = hz_utility_pub.program_id,
269: program_update_date = sysdate
270: WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;
271:
272: END IF;