69: if l_count = 0 then
70: return;
71: end if;
72:
73: user_id := fnd_global.user_id;
74: login_id := fnd_global.login_id;
75: todays_date := sysdate;
76:
77: for i in 1..l_count loop
70: return;
71: end if;
72:
73: user_id := fnd_global.user_id;
74: login_id := fnd_global.login_id;
75: todays_date := sysdate;
76:
77: for i in 1..l_count loop
78: p_loc_array(i).address1 := upper(p_loc_array(i).address1);
306: procedure set_address_key(p_loc_rec in out nocopy location_rec)
307: is
308: begin
309: p_loc_rec.address_key :=
310: to_char(p_loc_rec.org_id)|| fnd_global.newline ||
311: upper(p_loc_rec.country) ||fnd_global.newline||
312: upper(p_loc_rec.postal_code) ||fnd_global.newline||
313: upper(p_loc_rec.province_state) ||fnd_global.newline||
314: upper(p_loc_rec.city) ||fnd_global.newline||
307: is
308: begin
309: p_loc_rec.address_key :=
310: to_char(p_loc_rec.org_id)|| fnd_global.newline ||
311: upper(p_loc_rec.country) ||fnd_global.newline||
312: upper(p_loc_rec.postal_code) ||fnd_global.newline||
313: upper(p_loc_rec.province_state) ||fnd_global.newline||
314: upper(p_loc_rec.city) ||fnd_global.newline||
315: upper(p_loc_rec.address1) ||fnd_global.newline||
308: begin
309: p_loc_rec.address_key :=
310: to_char(p_loc_rec.org_id)|| fnd_global.newline ||
311: upper(p_loc_rec.country) ||fnd_global.newline||
312: upper(p_loc_rec.postal_code) ||fnd_global.newline||
313: upper(p_loc_rec.province_state) ||fnd_global.newline||
314: upper(p_loc_rec.city) ||fnd_global.newline||
315: upper(p_loc_rec.address1) ||fnd_global.newline||
316: upper(p_loc_rec.address2) ||fnd_global.newline||
309: p_loc_rec.address_key :=
310: to_char(p_loc_rec.org_id)|| fnd_global.newline ||
311: upper(p_loc_rec.country) ||fnd_global.newline||
312: upper(p_loc_rec.postal_code) ||fnd_global.newline||
313: upper(p_loc_rec.province_state) ||fnd_global.newline||
314: upper(p_loc_rec.city) ||fnd_global.newline||
315: upper(p_loc_rec.address1) ||fnd_global.newline||
316: upper(p_loc_rec.address2) ||fnd_global.newline||
317: upper(p_loc_rec.address3) ||fnd_global.newline||
310: to_char(p_loc_rec.org_id)|| fnd_global.newline ||
311: upper(p_loc_rec.country) ||fnd_global.newline||
312: upper(p_loc_rec.postal_code) ||fnd_global.newline||
313: upper(p_loc_rec.province_state) ||fnd_global.newline||
314: upper(p_loc_rec.city) ||fnd_global.newline||
315: upper(p_loc_rec.address1) ||fnd_global.newline||
316: upper(p_loc_rec.address2) ||fnd_global.newline||
317: upper(p_loc_rec.address3) ||fnd_global.newline||
318: upper(p_loc_rec.address4);
311: upper(p_loc_rec.country) ||fnd_global.newline||
312: upper(p_loc_rec.postal_code) ||fnd_global.newline||
313: upper(p_loc_rec.province_state) ||fnd_global.newline||
314: upper(p_loc_rec.city) ||fnd_global.newline||
315: upper(p_loc_rec.address1) ||fnd_global.newline||
316: upper(p_loc_rec.address2) ||fnd_global.newline||
317: upper(p_loc_rec.address3) ||fnd_global.newline||
318: upper(p_loc_rec.address4);
319:
312: upper(p_loc_rec.postal_code) ||fnd_global.newline||
313: upper(p_loc_rec.province_state) ||fnd_global.newline||
314: upper(p_loc_rec.city) ||fnd_global.newline||
315: upper(p_loc_rec.address1) ||fnd_global.newline||
316: upper(p_loc_rec.address2) ||fnd_global.newline||
317: upper(p_loc_rec.address3) ||fnd_global.newline||
318: upper(p_loc_rec.address4);
319:
320: end set_address_key;
313: upper(p_loc_rec.province_state) ||fnd_global.newline||
314: upper(p_loc_rec.city) ||fnd_global.newline||
315: upper(p_loc_rec.address1) ||fnd_global.newline||
316: upper(p_loc_rec.address2) ||fnd_global.newline||
317: upper(p_loc_rec.address3) ||fnd_global.newline||
318: upper(p_loc_rec.address4);
319:
320: end set_address_key;
321: