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.20 2005/12/09 04:37:37 sumarimu noship $ */
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 210: l_delimiter := ghr_utility.get_flex_delimiter(p_flex_code => 'POS',

206: l_flex_num := get_pos_flex_num(p_bus_org_id=>l_bus_group_id) ;
207:
208: l_flex_recs := get_segments(p_flex_num => l_flex_num,
209: p_flex_code => 'POS');
210: l_delimiter := ghr_utility.get_flex_delimiter(p_flex_code => 'POS',
211: p_flex_num => l_flex_num);
212:
213: ------------------------------------------------
214: -- Storing Position segment details in a rec.

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

312: fnd_profile.get('PER_BUSINESS_GROUP_ID',l_bus_group_id);
313:
314: l_flex_num := get_pos_flex_num(p_bus_org_id=>l_bus_group_id) ;
315:
316: l_delimiter := ghr_utility.get_flex_delimiter(p_flex_code => 'POS',
317: p_flex_num => l_flex_num);
318: ------------------------------------------------
319: -- Extracting Segment values from Position Name
320: ------------------------------------------------

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

417: from fnd_sessions
418: where session_id = (select userenv('sessionid') from dual);
419:
420: BEGIN
421: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN
422: l_child_exists := FALSE;
423: hr_utility.set_location('Entering: Validate_NFC ',10);
424: -- Get Session Date
425: l_session_date := trunc(sysdate);

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

487:
488: l_child_exists BOOLEAN;
489:
490: BEGIN
491: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN
492: l_child_exists := FALSE;
493: hr_utility.set_location('Entering: Validate_Delete_NFC ',10);
494: -- Raise error if child exists
495: FOR l_check_child IN c_check_child(P_POSITION_ID) LOOP

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

562: from fnd_sessions
563: where session_id = (select userenv('sessionid') from dual);
564:
565: BEGIN
566: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN
567: hr_utility.set_location('Entering: HR_POSITION_BK1.CREATE_POSITION_B', 10);
568: -- Check for the change in the segments
569: -- for c_old_rec in c_old_pos_segments(p_position_id) loop
570: -- Get Session Date

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

639: BEGIN
640: -- Update/Create Position group1 Extra Info
641: --
642: -- EIT GHR_US_POS_GRP1
643: IF ghr_utility.is_ghr_nfc = 'TRUE' THEN
644: l_information_type := 'GHR_US_POS_GRP1';
645: for pos_ei in c_pos_ei(p_position_id,l_information_type)
646: LOOP
647: l_extra_info_id := pos_ei.position_extra_info_id;

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

684: END IF;
685: END LOOP;
686:
687:
688: END IF; -- IF ghr_utility.is_ghr_nfc = 'TRUE' THEN
689:
690: END update_nfc_eit;
691:
692:

Line 1030: end ghr_utility;

1026:
1027: -- DK 2002-11-08 PLSQLSTD
1028: --hr_utility.set_location('Leaving Main Begin' ,1);
1029:
1030: end ghr_utility;