APPS.GHR_UTILITY dependencies on GHR_UTILITY

Line 1: PACKAGE BODY ghr_utility AS

1: PACKAGE BODY ghr_utility AS
2: /* $Header: ghutils.pkb 120.21 2011/04/21 10:58:52 vmididho ship $ */
3: --
4: -- Figure out whether GHR is installed or not.
5: -- if GHR_US_ORG_INFORMATION is defined for current business group

Line 8: g_package VARCHAR2(30) := 'ghr_utility.';

4: -- Figure out whether GHR is installed or not.
5: -- if GHR_US_ORG_INFORMATION is defined for current business group
6: -- it is assumed that GHR is installed.
7: --
8: g_package VARCHAR2(30) := 'ghr_utility.';
9: v_current_bg NUMBER;
10: CURSOR c_fed_bg (p_current_bg NUMBER) IS
11: SELECT hoi.org_information_context
12: , hoi.org_information1

Line 220: l_delimiter := ghr_utility.get_flex_delimiter(p_flex_code => 'POS',

216: l_flex_num := get_pos_flex_num(p_bus_org_id=>l_bus_group_id) ;
217:
218: l_flex_recs := get_segments(p_flex_num => l_flex_num,
219: p_flex_code => 'POS');
220: l_delimiter := ghr_utility.get_flex_delimiter(p_flex_code => 'POS',
221: p_flex_num => l_flex_num);
222:
223: ------------------------------------------------
224: -- Storing Position segment details in a rec.

Line 326: l_delimiter := ghr_utility.get_flex_delimiter(p_flex_code => 'POS',

322: fnd_profile.get('PER_BUSINESS_GROUP_ID',l_bus_group_id);
323:
324: l_flex_num := get_pos_flex_num(p_bus_org_id=>l_bus_group_id) ;
325:
326: l_delimiter := ghr_utility.get_flex_delimiter(p_flex_code => 'POS',
327: p_flex_num => l_flex_num);
328: ------------------------------------------------
329: -- Extracting Segment values from Position Name
330: ------------------------------------------------

Line 431: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN

427: from fnd_sessions
428: where session_id = (select userenv('sessionid') from dual);
429:
430: BEGIN
431: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN
432: l_child_exists := FALSE;
433: hr_utility.set_location('Entering: Validate_NFC ',10);
434: -- Get Session Date
435: l_session_date := trunc(sysdate);

Line 501: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN

497:
498: l_child_exists BOOLEAN;
499:
500: BEGIN
501: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN
502: l_child_exists := FALSE;
503: hr_utility.set_location('Entering: Validate_Delete_NFC ',10);
504: -- Raise error if child exists
505: FOR l_check_child IN c_check_child(P_POSITION_ID) LOOP

Line 576: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN

572: from fnd_sessions
573: where session_id = (select userenv('sessionid') from dual);
574:
575: BEGIN
576: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN
577: hr_utility.set_location('Entering: HR_POSITION_BK1.CREATE_POSITION_B', 10);
578: -- Check for the change in the segments
579: -- for c_old_rec in c_old_pos_segments(p_position_id) loop
580: -- Get Session Date

Line 653: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN

649: BEGIN
650: -- Update/Create Position group1 Extra Info
651: --
652: -- EIT GHR_US_POS_GRP1
653: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN
654: l_information_type := 'GHR_US_POS_GRP1';
655: for pos_ei in c_pos_ei(p_position_id,l_information_type)
656: LOOP
657: l_extra_info_id := pos_ei.position_extra_info_id;

Line 698: END IF; -- IF ghr_utility.is_ghr_nfc = 'TRUE' THEN

694: END IF;
695: END LOOP;
696:
697:
698: END IF; -- IF ghr_utility.is_ghr_nfc = 'TRUE' THEN
699:
700: END update_nfc_eit;
701:
702:

Line 1058: end ghr_utility;

1054:
1055: -- DK 2002-11-08 PLSQLSTD
1056: --hr_utility.set_location('Leaving Main Begin' ,1);
1057:
1058: end ghr_utility;