APPS.AP_WEB_LOCATIONS_PKG dependencies on FND_GLOBAL

Line 73: user_id := fnd_global.user_id;

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

Line 74: login_id := fnd_global.login_id;

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);

Line 310: to_char(p_loc_rec.org_id)|| fnd_global.newline ||

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||

Line 311: upper(p_loc_rec.country) ||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||

Line 312: upper(p_loc_rec.postal_code) ||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||

Line 313: upper(p_loc_rec.province_state) ||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||

Line 314: upper(p_loc_rec.city) ||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);

Line 315: upper(p_loc_rec.address1) ||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);
319:

Line 316: upper(p_loc_rec.address2) ||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:
320: end set_address_key;

Line 317: upper(p_loc_rec.address3) ||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;
321: