DBA Data[Home] [Help]

APPS.HR_GL_COST_CENTERS dependencies on FND_GLOBAL

Line 12: g_newline varchar2(10) := fnd_global.newline;

8: g_org_name_length number;
9:
10: /*
11: cid number;
12: g_newline varchar2(10) := fnd_global.newline;
13: g_tab varchar2(30) := fnd_global.tab;
14:
15:
16: g_log_file utl_file.file_type;

Line 13: g_tab varchar2(30) := fnd_global.tab;

9:
10: /*
11: cid number;
12: g_newline varchar2(10) := fnd_global.newline;
13: g_tab varchar2(30) := fnd_global.tab;
14:
15:
16: g_log_file utl_file.file_type;
17: g_application_short_name VARCHAR2(50) := 'PER';

Line 251: l_tab varchar2(5) := fnd_global.tab;

247: ,p_bgid in NUMBER
248: ,p_datfile in VARCHAR2) IS
249: l_bg_name per_business_groups.name%type := null;
250: l_proc varchar2(50) := g_package||'.writeHeaderFileHeader';
251: l_tab varchar2(5) := fnd_global.tab;
252: BEGIN
253: hr_utility.set_location('Entering : '||l_proc,10);
254: BEGIN
255: SELECT name INTO l_bg_name

Line 281: l_tab varchar2(5) := fnd_global.tab;

277: END;
278:
279: Procedure writeDataFileHeader(p_file IN utl_file.file_type) IS
280: l_proc varchar2(50) := g_package||'.writeDataFileHeader';
281: l_tab varchar2(5) := fnd_global.tab;
282: BEGIN
283: hr_utility.set_location('Entering : '||l_proc,10);
284:
285: utl_file.put_line(P_FILE, 'Descriptor'||l_tab||'Start');

Line 332: l_tab VARCHAR2(5) := fnd_global.tab;

328: l_header_file varchar2(80);
329: l_data_file varchar2(80);
330: l_stmt VARCHAR2(3000) := null;
331: l_retcode NUMBER;
332: l_tab VARCHAR2(5) := fnd_global.tab;
333: BEGIN
334: hr_utility.set_location('Entering : '||l_proc,10);
335: l_dir := fnd_profile.value('PER_DATA_EXCHANGE_DIR');
336:

Line 2188: fnd_global.user_id||

2184: last_update_date,
2185: last_updated_by) =
2186: (select org_id,
2187: sysdate, '||
2188: fnd_global.user_id||
2189: ' from '||p_hr_sync_temp||' sync
2190: where sync.ccid = gcc.code_combination_id
2191: and sync.org_id <> -1
2192: and sync.org_id is not null)

Line 2426: using l_org_id, fnd_global.user_id, p_ccid;

2422: set company_cost_center_org_id=:1,
2423: last_update_date = sysdate,
2424: last_updated_by = :2
2425: where code_combination_id =:3'
2426: using l_org_id, fnd_global.user_id, p_ccid;
2427:
2428: writelog('Updated GL_CODE_COMBINATIONS. Set Company_cost_center_org_id = '||
2429: l_org_id ||' where code_Combination_id = '||p_ccid,'D');
2430: end if;