DBA Data[Home] [Help]

APPS.PER_IN_ADD_LEG_HOOK dependencies on HR_GENERAL

Line 224: l_get_migrator_status:=hr_general.g_data_migrator_mode;

220: pay_in_utils.set_location(g_debug,l_procedure,20);
221: END IF;
222:
223: IF p_style ='IN' THEN
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

Line 226: hr_general.g_data_migrator_mode:='Y';

222:
223: IF p_style ='IN' THEN
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;

Line 236: hr_general.g_data_migrator_mode:=l_get_migrator_status;

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;
237: END IF;
238:
239: IF g_debug THEN
240: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

Line 367: l_get_migrator_status:=hr_general.g_data_migrator_mode;

363: pay_in_utils.set_location(g_debug,l_procedure,30);
364: END IF;
365:
366: IF l_style='IN' THEN
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

Line 369: hr_general.g_data_migrator_mode:='Y';

365:
366: IF l_style='IN' THEN
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;

Line 379: hr_general.g_data_migrator_mode:=l_get_migrator_status;

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;
380: END IF;
381:
382: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);/*
383: EXCEPTION