eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_GENERAL_UTILITIES dependencies on HR_GENERAL_UTILITIES

Line 1: PACKAGE BODY HR_GENERAL_UTILITIES AS

1: PACKAGE BODY HR_GENERAL_UTILITIES AS
2: /* $Header: hrgenutw.pkb 115.34 2004/03/18 01:35:54 rmoolave ship $*/
3: -- ----------------------------------------------------------------------------
4: -- |--< VARIABLES >-----------------------------------------------------------|
5: -- ----------------------------------------------------------------------------

Line 57: hr_general_utilities.g_separator := '!#';

53: g_type_attribute := ' TYPE="' || g_replace_string || '"';
54: g_language_attribute := ' LANGUAGE="' || g_replace_string || '"';
55: g_execute_handles.delete;
56: g_string_cache.delete;
57: hr_general_utilities.g_separator := '!#';
58: hr_general_utilities.g_sysdate_char := to_char(trunc(sysdate), 'YYYY-MM-DD');
59: hr_general_utilities.g_current_yr_char :=
60: substr(hr_general_utilities.g_sysdate_char, 1, 4);
61: hr_general_utilities.g_sample_date_char :=

Line 58: hr_general_utilities.g_sysdate_char := to_char(trunc(sysdate), 'YYYY-MM-DD');

54: g_language_attribute := ' LANGUAGE="' || g_replace_string || '"';
55: g_execute_handles.delete;
56: g_string_cache.delete;
57: hr_general_utilities.g_separator := '!#';
58: hr_general_utilities.g_sysdate_char := to_char(trunc(sysdate), 'YYYY-MM-DD');
59: hr_general_utilities.g_current_yr_char :=
60: substr(hr_general_utilities.g_sysdate_char, 1, 4);
61: hr_general_utilities.g_sample_date_char :=
62: hr_general_utilities.g_current_yr_char || '-12-31';

Line 59: hr_general_utilities.g_current_yr_char :=

55: g_execute_handles.delete;
56: g_string_cache.delete;
57: hr_general_utilities.g_separator := '!#';
58: hr_general_utilities.g_sysdate_char := to_char(trunc(sysdate), 'YYYY-MM-DD');
59: hr_general_utilities.g_current_yr_char :=
60: substr(hr_general_utilities.g_sysdate_char, 1, 4);
61: hr_general_utilities.g_sample_date_char :=
62: hr_general_utilities.g_current_yr_char || '-12-31';
63: hr_general_utilities.g_sample_date :=

Line 60: substr(hr_general_utilities.g_sysdate_char, 1, 4);

56: g_string_cache.delete;
57: hr_general_utilities.g_separator := '!#';
58: hr_general_utilities.g_sysdate_char := to_char(trunc(sysdate), 'YYYY-MM-DD');
59: hr_general_utilities.g_current_yr_char :=
60: substr(hr_general_utilities.g_sysdate_char, 1, 4);
61: hr_general_utilities.g_sample_date_char :=
62: hr_general_utilities.g_current_yr_char || '-12-31';
63: hr_general_utilities.g_sample_date :=
64: to_date(hr_general_utilities.g_sample_date_char, 'YYYY-MM-DD');

Line 61: hr_general_utilities.g_sample_date_char :=

57: hr_general_utilities.g_separator := '!#';
58: hr_general_utilities.g_sysdate_char := to_char(trunc(sysdate), 'YYYY-MM-DD');
59: hr_general_utilities.g_current_yr_char :=
60: substr(hr_general_utilities.g_sysdate_char, 1, 4);
61: hr_general_utilities.g_sample_date_char :=
62: hr_general_utilities.g_current_yr_char || '-12-31';
63: hr_general_utilities.g_sample_date :=
64: to_date(hr_general_utilities.g_sample_date_char, 'YYYY-MM-DD');
65: hr_general_utilities.g_date_format :=

Line 62: hr_general_utilities.g_current_yr_char || '-12-31';

58: hr_general_utilities.g_sysdate_char := to_char(trunc(sysdate), 'YYYY-MM-DD');
59: hr_general_utilities.g_current_yr_char :=
60: substr(hr_general_utilities.g_sysdate_char, 1, 4);
61: hr_general_utilities.g_sample_date_char :=
62: hr_general_utilities.g_current_yr_char || '-12-31';
63: hr_general_utilities.g_sample_date :=
64: to_date(hr_general_utilities.g_sample_date_char, 'YYYY-MM-DD');
65: hr_general_utilities.g_date_format :=
66: hr_session_utilities.get_user_date_format;

Line 63: hr_general_utilities.g_sample_date :=

59: hr_general_utilities.g_current_yr_char :=
60: substr(hr_general_utilities.g_sysdate_char, 1, 4);
61: hr_general_utilities.g_sample_date_char :=
62: hr_general_utilities.g_current_yr_char || '-12-31';
63: hr_general_utilities.g_sample_date :=
64: to_date(hr_general_utilities.g_sample_date_char, 'YYYY-MM-DD');
65: hr_general_utilities.g_date_format :=
66: hr_session_utilities.get_user_date_format;
67: hr_general_utilities.g_attribute_application_id := 800;

Line 64: to_date(hr_general_utilities.g_sample_date_char, 'YYYY-MM-DD');

60: substr(hr_general_utilities.g_sysdate_char, 1, 4);
61: hr_general_utilities.g_sample_date_char :=
62: hr_general_utilities.g_current_yr_char || '-12-31';
63: hr_general_utilities.g_sample_date :=
64: to_date(hr_general_utilities.g_sample_date_char, 'YYYY-MM-DD');
65: hr_general_utilities.g_date_format :=
66: hr_session_utilities.get_user_date_format;
67: hr_general_utilities.g_attribute_application_id := 800;
68:

Line 65: hr_general_utilities.g_date_format :=

61: hr_general_utilities.g_sample_date_char :=
62: hr_general_utilities.g_current_yr_char || '-12-31';
63: hr_general_utilities.g_sample_date :=
64: to_date(hr_general_utilities.g_sample_date_char, 'YYYY-MM-DD');
65: hr_general_utilities.g_date_format :=
66: hr_session_utilities.get_user_date_format;
67: hr_general_utilities.g_attribute_application_id := 800;
68:
69: --

Line 67: hr_general_utilities.g_attribute_application_id := 800;

63: hr_general_utilities.g_sample_date :=
64: to_date(hr_general_utilities.g_sample_date_char, 'YYYY-MM-DD');
65: hr_general_utilities.g_date_format :=
66: hr_session_utilities.get_user_date_format;
67: hr_general_utilities.g_attribute_application_id := 800;
68:
69: --
70: END reset_globals;
71: --

Line 634: -- e.g. hr_general_utilities.IFNOTNULL(hr_general_utlities.ConvertToDate(...)..

630: -- |--< Convert_To_Date >-----------------------------------------------------|
631: -- ----------------------------------------------------------------------------
632: -- if converting to date fails (date is not valid), then value returned is null
633: -- logic in calling code can handle this better than raising an exception
634: -- e.g. hr_general_utilities.IFNOTNULL(hr_general_utlities.ConvertToDate(...)..
635: --
636: FUNCTION Convert_To_Date
637: ( p_date_string IN VARCHAR2
638: )

Line 1088: , p_separator IN VARCHAR2 DEFAULT hr_general_utilities.g_separator

1084: -- ----------------------------------------------------------------------------
1085: FUNCTION Add_Separators
1086: ( p_instring IN VARCHAR2
1087: , p_start IN BOOLEAN DEFAULT FALSE
1088: , p_separator IN VARCHAR2 DEFAULT hr_general_utilities.g_separator
1089: )
1090: RETURN VARCHAR2
1091: IS
1092: l_t_str VARCHAR2 (32000);

Line 1133: , p_separator IN VARCHAR2 DEFAULT hr_general_utilities.g_separator

1129: -- ----------------------------------------------------------------------------
1130: FUNCTION Locate_Item_In_Separated_Str
1131: ( p_string IN VARCHAR2
1132: , p_item IN NUMBER
1133: , p_separator IN VARCHAR2 DEFAULT hr_general_utilities.g_separator
1134: )
1135: RETURN NUMBER
1136: IS
1137: --

Line 1162: , p_separator IN VARCHAR2 DEFAULT hr_general_utilities.g_separator

1158: -- ----------------------------------------------------------------------------
1159: FUNCTION Find_Item_In_String
1160: ( p_item IN NUMBER
1161: , p_string IN VARCHAR2
1162: , p_separator IN VARCHAR2 DEFAULT hr_general_utilities.g_separator
1163: )
1164: RETURN VARCHAR2
1165: IS
1166: BeginSep INTEGER;

Line 1240: , p_separator IN VARCHAR2 DEFAULT hr_general_utilities.g_separator

1236: -- ----------------------------------------------------------------------------
1237: FUNCTION Trim_Separator
1238: ( p_string IN VARCHAR2
1239: , p_end IN VARCHAR2 DEFAULT 'RIGHT'
1240: , p_separator IN VARCHAR2 DEFAULT hr_general_utilities.g_separator
1241: )
1242: RETURN VARCHAR2
1243: IS
1244: l_returnval VARCHAR2 (32000);

Line 1328: hr_general_utilities.Find_Item_In_String

1324: hr_utility.set_location('Entering : ' || l_proc, 5);
1325: END IF;
1326:
1327: l_package :=
1328: hr_general_utilities.Find_Item_In_String
1329: ( p_item => 1
1330: , p_string => l_icx_string
1331: );
1332: l_procedure :=

Line 1333: hr_general_utilities.Find_Item_In_String

1329: ( p_item => 1
1330: , p_string => l_icx_string
1331: );
1332: l_procedure :=
1333: hr_general_utilities.Find_Item_In_String
1334: ( p_item => 2
1335: , p_string => l_icx_string
1336: );
1337: l_count :=

Line 1339: ( hr_general_utilities.Find_Item_In_String

1335: , p_string => l_icx_string
1336: );
1337: l_count :=
1338: to_number
1339: ( hr_general_utilities.Find_Item_In_String
1340: ( p_item => 3
1341: , p_string => l_icx_string
1342: )
1343: );

Line 1363: || hr_general_utilities.Find_Item_In_String

1359: END IF;
1360: --
1361: l_sql_string :=
1362: l_sql_string
1363: || hr_general_utilities.Find_Item_In_String
1364: ( p_item => Counter + l_offset
1365: , p_string => l_icx_string
1366: );
1367: BEGIN

Line 1372: ( hr_general_utilities.Find_Item_In_String

1368: l_sql_string :=
1369: l_sql_string
1370: || '=>'
1371: || to_number
1372: ( hr_general_utilities.Find_Item_In_String
1373: ( p_item => Counter + l_offset + 1
1374: , p_string => l_icx_string
1375: )
1376: );

Line 1384: || hr_general_utilities.Find_Item_In_String

1380: l_sql_string :=
1381: l_sql_string
1382: || '=>'
1383: || ''''
1384: || hr_general_utilities.Find_Item_In_String
1385: ( p_item => Counter + l_offset + 1
1386: , p_string => l_icx_string
1387: )
1388: || '''';

Line 1449: ,p_bind_values_tab out nocopy hr_general_utilities.g_vc32k_tab_type

1445: -- | per_appraisal_display_web.aprp01(parm1=> :1, parm2 => :2, ....); |
1446: -- ----------------------------------------------------------------------------
1447: FUNCTION BPFD
1448: ( p_string IN VARCHAR2
1449: ,p_bind_values_tab out nocopy hr_general_utilities.g_vc32k_tab_type
1450: ,p_use_bind_values out nocopy boolean
1451: )
1452: RETURN VARCHAR2
1453: IS

Line 1464: l_bind_values_tab_out hr_general_utilities.g_vc32k_tab_type;

1460: l_tmp_string VARCHAR2 (32000);
1461: l_offset NUMBER := 3; -- i.e. the number of fields before the list
1462: -- of parameter / values
1463: l_proc VARCHAR2 (72) := g_package || ' build_proc_from_decryption';
1464: l_bind_values_tab_out hr_general_utilities.g_vc32k_tab_type;
1465: l_bind_values_count integer := 0;
1466: l_empty_values_tab hr_general_utilities.g_vc32k_tab_type;
1467: l_use_bind_values boolean default null;
1468: --

Line 1466: l_empty_values_tab hr_general_utilities.g_vc32k_tab_type;

1462: -- of parameter / values
1463: l_proc VARCHAR2 (72) := g_package || ' build_proc_from_decryption';
1464: l_bind_values_tab_out hr_general_utilities.g_vc32k_tab_type;
1465: l_bind_values_count integer := 0;
1466: l_empty_values_tab hr_general_utilities.g_vc32k_tab_type;
1467: l_use_bind_values boolean default null;
1468: --
1469: BEGIN
1470: g_debug := hr_utility.debug_enabled;

Line 1476: hr_general_utilities.Find_Item_In_String

1472: hr_utility.set_location('Entering : ' || l_proc, 5);
1473: END IF;
1474:
1475: l_package :=
1476: hr_general_utilities.Find_Item_In_String
1477: ( p_item => 1
1478: , p_string => l_icx_string
1479: );
1480: l_procedure :=

Line 1481: hr_general_utilities.Find_Item_In_String

1477: ( p_item => 1
1478: , p_string => l_icx_string
1479: );
1480: l_procedure :=
1481: hr_general_utilities.Find_Item_In_String
1482: ( p_item => 2
1483: , p_string => l_icx_string
1484: );
1485: l_count :=

Line 1487: ( hr_general_utilities.Find_Item_In_String

1483: , p_string => l_icx_string
1484: );
1485: l_count :=
1486: to_number
1487: ( hr_general_utilities.Find_Item_In_String
1488: ( p_item => 3
1489: , p_string => l_icx_string
1490: )
1491: );

Line 1532: hr_general_utilities.Find_Item_In_String

1528: NULL;
1529: END IF;
1530: --
1531: l_sql_string := l_sql_string ||
1532: hr_general_utilities.Find_Item_In_String
1533: ( p_item => Counter + l_offset
1534: , p_string => l_icx_string
1535: );
1536: --

Line 1539: to_number ( hr_general_utilities.Find_Item_In_String

1535: );
1536: --
1537: BEGIN
1538: l_sql_string := l_sql_string || '=>' ||
1539: to_number ( hr_general_utilities.Find_Item_In_String
1540: ( p_item => Counter + l_offset + 1
1541: , p_string => l_icx_string
1542: )
1543: );

Line 1548: || hr_general_utilities.Find_Item_In_String

1544: EXCEPTION
1545: WHEN OTHERS THEN
1546: -- cannot convert a text string
1547: l_sql_string := l_sql_string || '=>' || ''''
1548: || hr_general_utilities.Find_Item_In_String
1549: ( p_item => Counter + l_offset + 1
1550: , p_string => l_icx_string
1551: ) || '''';
1552: --

Line 1586: hr_general_utilities.Find_Item_In_String

1582: --
1583: l_tmp_string := null;
1584:
1585: l_sql_string := l_sql_string ||
1586: hr_general_utilities.Find_Item_In_String
1587: ( p_item => Counter + l_offset
1588: , p_string => l_icx_string
1589: );
1590:

Line 1604: ( hr_general_utilities.Find_Item_In_String

1600: -----------------------------------------------------------------------
1601: BEGIN
1602: --
1603: l_tmp_string := to_number
1604: ( hr_general_utilities.Find_Item_In_String
1605: ( p_item => Counter + l_offset + 1
1606: , p_string => l_icx_string
1607: )
1608: );

Line 1630: l_tmp_string := hr_general_utilities.Find_Item_In_String

1626: -- per_appraisal_display_web.aprp07(p_calltype => :1, ...); --> The
1627: -- bind value for :1 will be stored in a variable as PAGE and thus
1628: -- no quotes are needed in the bind value.
1629: --
1630: l_tmp_string := hr_general_utilities.Find_Item_In_String
1631: ( p_item => Counter + l_offset + 1
1632: , p_string => l_icx_string);
1633:
1634: -- Bug fix for 2061027 starts

Line 1781: || hr_general_utilities.Add_Separators

1777: -- start the string
1778: --
1779: l_code :=
1780: l_code
1781: || hr_general_utilities.Add_Separators
1782: ( p_instring => p_type
1783: , p_start => TRUE
1784: );
1785: --

Line 1822: || hr_general_utilities.Add_Separators

1818: -- store the row index
1819: --
1820: l_icx_ids :=
1821: l_icx_ids
1822: || hr_general_utilities.Add_Separators
1823: ( p_instring => l_tmp_id
1824: );
1825: --
1826: -- count the number of icx rows

Line 1835: || hr_general_utilities.Add_Separators

1831: -- add the number of rows
1832: --
1833: l_icx_ids :=
1834: l_code
1835: || hr_general_utilities.Add_Separators
1836: ( p_instring => to_char(l_icx_count)
1837: )
1838: || l_icx_ids;
1839: --

Line 1897: || hr_general_utilities.Add_Separators

1893:
1894: IF g_execute_handles.count > 0 THEN
1895: l_string :=
1896: l_string
1897: || hr_general_utilities.Add_Separators
1898: ( p_instring => 'C'
1899: , p_start => TRUE
1900: );
1901: l_string :=

Line 1903: || hr_general_utilities.Add_Separators

1899: , p_start => TRUE
1900: );
1901: l_string :=
1902: l_string
1903: || hr_general_utilities.Add_Separators
1904: ( p_instring => to_char(g_execute_handles.count)
1905: );
1906: FOR Counter IN 1 .. g_execute_handles.count
1907: LOOP

Line 1910: || hr_general_utilities.Add_Separators

1906: FOR Counter IN 1 .. g_execute_handles.count
1907: LOOP
1908: l_string :=
1909: l_string
1910: || hr_general_utilities.Add_Separators
1911: ( p_instring => g_execute_handles(Counter)
1912: );
1913: END LOOP;
1914: ELSE

Line 1975: ( hr_general_utilities.Find_Item_In_String

1971: END IF;
1972: --
1973: l_item2 :=
1974: to_number
1975: ( hr_general_utilities.Find_Item_In_String
1976: ( p_item => 2
1977: , p_string => l_index_string
1978: )
1979: );

Line 1987: hr_general_utilities.Find_Item_In_String

1983: l_string :=
1984: l_string
1985: || icx_call.decrypt2
1986: ( c_text_id =>
1987: hr_general_utilities.Find_Item_In_String
1988: ( p_item => RowCounter + l_offset
1989: , p_string => l_index_string
1990: )
1991: );

Line 2015: l_bind_values_tab hr_general_utilities.g_vc32k_tab_type;

2011: l_item1 VARCHAR2 (2000);
2012: l_item2 NUMBER;
2013: l_proc VARCHAR2 (72):= g_package || ' DExL';
2014: l_bind_values_count integer default 0;
2015: l_bind_values_tab hr_general_utilities.g_vc32k_tab_type;
2016: l_bind_values_list varchar2(32000) default null;
2017: l_use_bind_values boolean default null;
2018:
2019: BEGIN

Line 2029: -- hr_general_utilities.reset_g_cache;

2025: --hrhtml2.debug('entered dex;');
2026: --
2027: -- reset the cache
2028: --
2029: -- hr_general_utilities.reset_g_cache;
2030: --
2031: -- decrypt the index string
2032: --
2033: l_index_string :=

Line 2051: hr_general_utilities.Find_Item_In_String

2047: --
2048: -- extract the first two items to see which process to follow (S, G, C)
2049: --
2050: l_item1 :=
2051: hr_general_utilities.Find_Item_In_String
2052: ( p_item => 1
2053: , p_string => l_index_string
2054: );
2055: --

Line 2058: ( hr_general_utilities.Find_Item_In_String

2054: );
2055: --
2056: l_item2 :=
2057: to_number
2058: ( hr_general_utilities.Find_Item_In_String
2059: ( p_item => 2
2060: , p_string => l_index_string
2061: )
2062: );

Line 2069: hr_general_utilities.DEXL

2065: --
2066: IF l_item1 = 'C' THEN
2067: FOR Counter IN 1 .. l_item2
2068: LOOP
2069: hr_general_utilities.DEXL
2070: ( i =>
2071: hr_general_utilities.Find_Item_In_String
2072: ( p_item => Counter + 2
2073: , p_string => l_index_string

Line 2071: hr_general_utilities.Find_Item_In_String

2067: FOR Counter IN 1 .. l_item2
2068: LOOP
2069: hr_general_utilities.DEXL
2070: ( i =>
2071: hr_general_utilities.Find_Item_In_String
2072: ( p_item => Counter + 2
2073: , p_string => l_index_string
2074: )
2075: );

Line 2089: -- hr_general_utilities.g_string_cache.delete;

2085: -------------------------------------------------------------------------------
2086: --
2087: -- bug 1911463
2088: -- commenting the call to delete as this is causing errors in appraisels
2089: -- hr_general_utilities.g_string_cache.delete;
2090:
2091: g_string_cache (g_string_cache.count + 1) :=
2092: EXPD
2093: ( p_string => l_index_string

Line 2112: l_sql_string := hr_general_utilities.BPFD

2108: -- does not mean that bind variable algorithm was not used, e.g.
2109: -- hr_mee_person_search_tree_web.display_container_bottom_frame()
2110: -- We can use Native Dynamic SQL to make the above invocation.
2111: ------------------------------------------------------------------------
2112: l_sql_string := hr_general_utilities.BPFD
2113: ( p_string => EXPD ( p_string => l_index_string)
2114: ,p_bind_values_tab => l_bind_values_tab
2115: ,p_use_bind_values => l_use_bind_values
2116: );

Line 2332: RETURN 'hr_general_utilities.DEXL?i=';

2328: IF g_debug THEN
2329: hr_utility.set_location('Leaving : ' || l_proc, 10);
2330: END IF;
2331:
2332: RETURN 'hr_general_utilities.DEXL?i=';
2333: END SDER;
2334: -- ----------------------------------------------------------------------------
2335: -- |--< REGS >----------------------------------------------------------------|
2336: -- ----------------------------------------------------------------------------

Line 2591: hr_general_utilities.Use_Message

2587: , APP_SHORT_NAME => l_short_name
2588: , MESSAGE_NAME => l_msg_name
2589: );
2590: l_record.error_text :=
2591: hr_general_utilities.Use_Message
2592: ( p_message_name => l_msg_name
2593: , p_application_id => l_short_name
2594: );
2595: l_record.error_number :=

Line 2660: END HR_GENERAL_UTILITIES;

2656: --
2657: -- bug 748569 fix: validate_session package initialization code eliminated
2658: -- handled by frame drawing procedures only
2659: --
2660: END HR_GENERAL_UTILITIES;