DBA Data[Home] [Help]

APPS.PQH_UTILITY dependencies on PQH_UTILITY

Line 1: package body pqh_utility as

1: package body pqh_utility as
2: /* $Header: pqutilty.pkb 120.7 2008/02/25 10:48:34 brsinha noship $ */
3: --
4: -- Declaring global variables
5: --

Line 12: g_package varchar2(33) := ' pqh_utility'; -- Global package name

8: g_warnings_table warnings_tab;
9: --
10: g_rule_level_cd pqh_rule_sets.rule_level_cd%type;
11: --
12: g_package varchar2(33) := ' pqh_utility'; -- Global package name
13: --
14: g_query_date date := null;
15: --
16: function get_shared_type_name (

Line 1671: l_stmt := REPLACE(l_stmt,'TO_DATE(:$FLEX$.PER_DATES_STANDARD,''YYYY/MM/DD HH24:MI:SS'')','pqh_utility.get_query_date');

1667: hr_utility.set_location('inside date pattern',11);
1668: /**
1669: l_stmt := REPLACE(l_stmt,'TO_DATE(:$FLEX$.PER_DATES_STANDARD,''YYYY/MM/DD HH24:MI:SS'')','trunc(sysdate)');
1670: **/
1671: l_stmt := REPLACE(l_stmt,'TO_DATE(:$FLEX$.PER_DATES_STANDARD,''YYYY/MM/DD HH24:MI:SS'')','pqh_utility.get_query_date');
1672: end if;
1673: hr_utility.set_location(' Now executing :'||l_stmt,909);
1674:
1675: EXECUTE IMMEDIATE l_stmt INTO l_display;

Line 2148: End pqh_utility;

2144: END IF;
2145: RETURN NULL;
2146: END;
2147: --
2148: End pqh_utility;