APPS.PER_IN_ADD_LEG_HOOK dependencies on PER_ADDRESSES

Line 228: UPDATE per_addresses

224: l_get_migrator_status:=hr_general.g_data_migrator_mode;
225:
226: hr_general.g_data_migrator_mode:='Y';
227: IF UPPER(p_add_information14) IN ('DELHI','NEW DELHI','KOLKATA','CHENNAI','MUMBAI') THEN
228: UPDATE per_addresses
229: SET add_information16='Y'
230: WHERE address_id =p_address_id;
231: ELSE
232: UPDATE per_addresses

Line 232: UPDATE per_addresses

228: UPDATE per_addresses
229: SET add_information16='Y'
230: WHERE address_id =p_address_id;
231: ELSE
232: UPDATE per_addresses
233: SET add_information16='N'
234: WHERE address_id =p_address_id;
235: END IF;
236: hr_general.g_data_migrator_mode:=l_get_migrator_status;

Line 324: l_style per_addresses.style%TYPE;

320: ,p_add_information14 IN VARCHAR2
321: ,p_add_information15 IN VARCHAR2
322: ,p_postal_code IN VARCHAR2)
323: IS
324: l_style per_addresses.style%TYPE;
325: l_get_migrator_status VARCHAR2(1);
326: l_proc VARCHAR2(50) ;
327: g_debug BOOLEAN;
328: l_procedure VARCHAR2(100);

Line 333: FROM per_addresses addr

329: l_message VARCHAR2(255);
330:
331: CURSOR csr_addr_style(p_address_id NUMBER)IS
332: SELECT addr.style
333: FROM per_addresses addr
334: WHERE addr.address_id = p_address_id ;
335:
336: BEGIN
337: g_debug := hr_utility.debug_enabled ;

Line 371: UPDATE per_addresses

367: l_get_migrator_status:=hr_general.g_data_migrator_mode;
368:
369: hr_general.g_data_migrator_mode:='Y';
370: IF UPPER(p_add_information14) IN ('DELHI','NEW DELHI','KOLKATA','CHENNAI','MUMBAI') THEN
371: UPDATE per_addresses
372: SET add_information16='Y'
373: WHERE address_id =p_address_id;
374: ELSE
375: UPDATE per_addresses

Line 375: UPDATE per_addresses

371: UPDATE per_addresses
372: SET add_information16='Y'
373: WHERE address_id =p_address_id;
374: ELSE
375: UPDATE per_addresses
376: SET add_information16='N'
377: WHERE address_id =p_address_id;
378: END IF;
379: hr_general.g_data_migrator_mode:=l_get_migrator_status;

Line 412: l_style per_addresses.style%TYPE;

408: PROCEDURE check_loc_address_upd(p_location_id IN NUMBER
409: ,p_loc_information16 IN VARCHAR2 -- State
410: ,p_postal_code IN VARCHAR2)
411: IS
412: l_style per_addresses.style%TYPE;
413: l_proc VARCHAR2(50);
414: g_debug BOOLEAN;
415: l_procedure VARCHAR2(100);
416: l_message VARCHAR2(255);