DBA Data[Home] [Help]

APPS.PAY_SOE_UTIL dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: package body PAY_SOE_UTIL as
2: /* $Header: pysoeutl.pkb 120.1.12010000.2 2009/01/05 11:40:05 parusia ship $ */
3: --
4: g_debug boolean := hr_utility.debug_enabled;
5: --
6: cursor config is
7: select org_information2 elements1
8: , org_information3 elements2

Line 55: hr_utility.trace('colid = ' || name || value);

51: ,firstCol BOOLEAN
52: ,lastCol BOOLEAN) is
53: begin
54: if g_debug then
55: hr_utility.trace('colid = ' || name || value);
56: end if;
57: --
58: dataValueRec.colName := ' COL' || name;
59: dataValueRec.colValue := value;

Line 130: hr_utility.trace(substr(p_sql_string,1,2000));

126: function convertCursor(p_sql_string long) return ref_cursor is
127: l_ref_cursor ref_cursor;
128: begin
129: if g_debug then
130: hr_utility.trace(substr(p_sql_string,1,2000));
131: hr_utility.trace(substr(p_sql_string,2001,2000));
132: hr_utility.trace(substr(p_sql_string,4001,2000));
133: end if;
134: --

Line 131: hr_utility.trace(substr(p_sql_string,2001,2000));

127: l_ref_cursor ref_cursor;
128: begin
129: if g_debug then
130: hr_utility.trace(substr(p_sql_string,1,2000));
131: hr_utility.trace(substr(p_sql_string,2001,2000));
132: hr_utility.trace(substr(p_sql_string,4001,2000));
133: end if;
134: --
135: open l_ref_cursor for p_sql_string;

Line 132: hr_utility.trace(substr(p_sql_string,4001,2000));

128: begin
129: if g_debug then
130: hr_utility.trace(substr(p_sql_string,1,2000));
131: hr_utility.trace(substr(p_sql_string,2001,2000));
132: hr_utility.trace(substr(p_sql_string,4001,2000));
133: end if;
134: --
135: open l_ref_cursor for p_sql_string;
136: return l_ref_cursor;

Line 282: hr_utility.trace('initialized : '||l_init);

278: else
279: l_init := 'false';
280: end if ;
281:
282: hr_utility.trace('initialized : '||l_init);
283: hr_utility.trace('PER_BUSINESS_GROUP_ID : '||l_bgid);
284: hr_utility.trace('PAY_SOE_USER_CATEGORY : '||l_soe_user_cat);
285:
286: -- Bug 7377886

Line 283: hr_utility.trace('PER_BUSINESS_GROUP_ID : '||l_bgid);

279: l_init := 'false';
280: end if ;
281:
282: hr_utility.trace('initialized : '||l_init);
283: hr_utility.trace('PER_BUSINESS_GROUP_ID : '||l_bgid);
284: hr_utility.trace('PAY_SOE_USER_CATEGORY : '||l_soe_user_cat);
285:
286: -- Bug 7377886
287: -- Added the clause bgid_save = l_bgid,

Line 284: hr_utility.trace('PAY_SOE_USER_CATEGORY : '||l_soe_user_cat);

280: end if ;
281:
282: hr_utility.trace('initialized : '||l_init);
283: hr_utility.trace('PER_BUSINESS_GROUP_ID : '||l_bgid);
284: hr_utility.trace('PAY_SOE_USER_CATEGORY : '||l_soe_user_cat);
285:
286: -- Bug 7377886
287: -- Added the clause bgid_save = l_bgid,
288: -- so that the SOE intialization part is skipped only if the BG is not changed

Line 330: hr_utility.trace('Returning '||p_config_type||' : '||l_config_value);

326: elsif p_config_type = 'BALANCES3' then
327: l_config_value := l_config.balances3;
328: end if;
329: --
330: hr_utility.trace('Returning '||p_config_type||' : '||l_config_value);
331: return l_config_value;
332: --
333: end getConfig;
334: --