DBA Data[Home] [Help]

APPS.GHR_PROC_FUT_MT dependencies on FND_PROFILE

Line 154: l_parent_request_id := fnd_profile.VALUE ('CONC_REQUEST_ID');

150: -- Initialization of variables.
151: l_batch_counter := 0;
152: l_batch_no := 1;
153: l_session_id := USERENV('SESSIONID');
154: l_parent_request_id := fnd_profile.VALUE ('CONC_REQUEST_ID');
155: l_status := TRUE;
156: g_request_ids.DELETE;
157: g_futr_proc_name := 'GHR_Proc_Futr_Act' || '_' || l_parent_request_id;
158: -- Bug # 7510344

Line 159: l_curr_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');

155: l_status := TRUE;
156: g_request_ids.DELETE;
157: g_futr_proc_name := 'GHR_Proc_Futr_Act' || '_' || l_parent_request_id;
158: -- Bug # 7510344
159: l_curr_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
160:
161: -- Thread size should be minimum of 10.
162: IF p_thread_size IS NULL OR p_thread_size < 10 THEN
163: l_thread_size := 10;

Line 231: fnd_profile.get('USERNAME',l_user_name);

227: l_batch_counter := l_batch_counter + 1;
228: END IF;
229: ELSE
230: --Bug#3726290 close the RPA, if p_result <> 'NOT EXISTS'
231: fnd_profile.get('USERNAME',l_user_name);
232: --bug#4896738
233: --hr_utility.set_location('Intial value of g_skip_grp_box '||decode(g_skip_grp_box,TRUE,1,0),9876);
234: g_skip_grp_box := TRUE;
235: --hr_utility.set_location('value before calling end sf52 g_skip_grp_box '||decode(g_skip_grp_box,TRUE,1,0),9875);

Line 332: fnd_profile.get('USERNAME',l_user_name);

328: l_batch_counter := l_batch_counter + 1;
329: END IF;
330: ELSE
331: --Bug#3726290 close the RPA, if p_result <> 'NOT EXISTS'
332: fnd_profile.get('USERNAME',l_user_name);
333: --bug#4896738
334: --hr_utility.set_location('Intial value of g_skip_grp_box '||g_skip_grp_box,9873);
335: g_skip_grp_box := TRUE;
336: --hr_utility.set_location('value before calling end sf52 g_skip_grp_box '||g_skip_grp_box,9872);

Line 465: if l_curr_business_group_id <> fnd_profile.value('PER_BUSINESS_GROUP_ID') then

461: END IF;
462:
463: -- Bug # 7510344
464: --setting back the business group
465: if l_curr_business_group_id <> fnd_profile.value('PER_BUSINESS_GROUP_ID') then
466: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_curr_business_group_id);
467: end if;
468:
469: -- Delete the temporary table data.

Line 466: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_curr_business_group_id);

462:
463: -- Bug # 7510344
464: --setting back the business group
465: if l_curr_business_group_id <> fnd_profile.value('PER_BUSINESS_GROUP_ID') then
466: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_curr_business_group_id);
467: end if;
468:
469: -- Delete the temporary table data.
470: DELETE FROM GHR_MTS_TEMP

Line 660: if l_bus_group_id <> fnd_profile.value('PER_BUSINESS_GROUP_ID') then

656: exit;
657: end loop;
658: end if;
659:
660: if l_bus_group_id <> fnd_profile.value('PER_BUSINESS_GROUP_ID') then
661: --Putting the BUSINESS GROUP_ID
662: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_bus_group_id);
663: end if;
664: --7510344

Line 662: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_bus_group_id);

658: end if;
659:
660: if l_bus_group_id <> fnd_profile.value('PER_BUSINESS_GROUP_ID') then
661: --Putting the BUSINESS GROUP_ID
662: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_bus_group_id);
663: end if;
664: --7510344
665:
666: