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_GL_COST_CENTERS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 321: l_org_name hr_all_organization_units_tl.name%type := null;

317: l_company_id VARCHAR2(240) := null;
318: l_cost_center_id VARCHAR2(240) := null;
319: l_company_name VARCHAR2(240) := null;
320: l_cost_center_name VARCHAR2(240) := null;
321: l_org_name hr_all_organization_units_tl.name%type := null;
322: l_bg_name hr_all_organization_units_tl.name%type := null;
323: l_dir VARCHAR2(300) := null;
324: l_org_start_date date ; -- Added by FS
325:

Line 322: l_bg_name hr_all_organization_units_tl.name%type := null;

318: l_cost_center_id VARCHAR2(240) := null;
319: l_company_name VARCHAR2(240) := null;
320: l_cost_center_name VARCHAR2(240) := null;
321: l_org_name hr_all_organization_units_tl.name%type := null;
322: l_bg_name hr_all_organization_units_tl.name%type := null;
323: l_dir VARCHAR2(300) := null;
324: l_org_start_date date ; -- Added by FS
325:
326: l_hdr_file utl_file.file_type;

Line 540: l_organization_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

536:
537: l_proc varchar2(50) := g_package||'.create_org_and_classification';
538:
539: l_organization_id number(15) := -1;
540: l_organization_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
541: l_ori_ovn number := -1;
542: l_org_ovn number := -1;
543: l_ori_inf_id number := -1;
544: l_org_inf_id number := -1;

Line 562: l_org_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE := null;

558: type curType is ref cursor;
559: c_list curType;
560: l_dummy varchar2(100);
561:
562: l_org_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE := null;
563: l_orig_org_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE := null;
564: l_org_name_format varchar2(60) := null;
565: l_org_name_suffix varchar2(5) := null;
566: l_message varchar2(2000);

Line 563: l_orig_org_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE := null;

559: c_list curType;
560: l_dummy varchar2(100);
561:
562: l_org_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE := null;
563: l_orig_org_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE := null;
564: l_org_name_format varchar2(60) := null;
565: l_org_name_suffix varchar2(5) := null;
566: l_message varchar2(2000);
567:

Line 579: from hr_all_organization_units

575:
576:
577: cursor csr_chk_org_name is
578: select organization_id
579: from hr_all_organization_units
580: where name = l_org_name
581: and business_group_id = p_bg_id;
582:
583: cursor csr_chk_org_class(p_organization_id number,

Line 671: from hr_all_organization_units_tl units,

667: */
668:
669: l_organization_id := -1;
670: open c_list for 'select units.organization_id, units.name
671: from hr_all_organization_units_tl units,
672: hr_organization_information class,
673: hr_organization_information cc
674: where units.organization_id = class.organization_id
675: and class.org_information_context=''CLASS''

Line 1347: from hr_all_organization_units units,

1343: l_bg_tab number_tab;
1344:
1345: cursor company_bg is
1346: select distinct units.business_group_id
1347: from hr_all_organization_units units,
1348: hr_organization_information class,
1349: hr_organization_information cc
1350: where units.organization_id = class.organization_id
1351: and class.org_information_context='CLASS'

Line 1424: l_org_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE := null;

1420: l_stmt2 varchar2(1000) := null;
1421:
1422: l_org_stmt VARCHAR2(1000) := null;
1423: l_temp_stmt varchar2(300) := null;
1424: l_org_name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE := null;
1425: l_retcode number := 0;
1426: l_retcode1 number :=0;
1427: l_org_name_format varchar2(60) := null;
1428: l_stmt1 varchar2(2000) :=null;

Line 1635: from hr_all_organization_units units,

1631: l_stmt := 'delete from '||p_hr_cc_reporting_temp||' rep
1632: where (company,company_value_set) not in
1633: ( select distinct cc.org_information3,
1634: cc.org_information2
1635: from hr_all_organization_units units,
1636: hr_all_organization_units_tl unitstl,
1637: hr_organization_information class,
1638: hr_organization_information cc
1639: where units.organization_id = class.organization_id

Line 1636: hr_all_organization_units_tl unitstl,

1632: where (company,company_value_set) not in
1633: ( select distinct cc.org_information3,
1634: cc.org_information2
1635: from hr_all_organization_units units,
1636: hr_all_organization_units_tl unitstl,
1637: hr_organization_information class,
1638: hr_organization_information cc
1639: where units.organization_id = class.organization_id
1640: and units.organization_id = unitstl.organization_id

Line 1872: from hr_all_organization_units units,

1868: l_stmt := 'delete from '||p_hr_sync_temp||' rep
1869: where (company,company_vs) not in
1870: ( select distinct cc.org_information3,
1871: cc.org_information2
1872: from hr_all_organization_units units,
1873: hr_all_organization_units_tl unitstl,
1874: hr_organization_information class,
1875: hr_organization_information cc
1876: where units.organization_id = class.organization_id

Line 1873: hr_all_organization_units_tl unitstl,

1869: where (company,company_vs) not in
1870: ( select distinct cc.org_information3,
1871: cc.org_information2
1872: from hr_all_organization_units units,
1873: hr_all_organization_units_tl unitstl,
1874: hr_organization_information class,
1875: hr_organization_information cc
1876: where units.organization_id = class.organization_id
1877: and units.organization_id = unitstl.organization_id

Line 1924: hr_all_organization_units units,

1920: l_stmt := 'create table '||p_hr_sync_ccid||'(ccid, org_id) as
1921: (select sync.ccid,
1922: units.organization_id
1923: from '||p_hr_sync_temp ||' sync ,
1924: hr_all_organization_units units,
1925: hr_organization_information class,
1926: hr_organization_information cc
1927: where units.organization_id = class.organization_id
1928: and units.business_group_id = '||p_bgid||'

Line 2372: from hr_all_organization_units units,

2368: -- This SQL needs to be tuned to use org_information1 rather than the
2369: -- individual segment values.
2370: --
2371: open c_list for 'select units.organization_id
2372: from hr_all_organization_units units,
2373: hr_organization_information class,
2374: hr_organization_information cc
2375: where units.organization_id = class.organization_id
2376: and class.org_information_context=''CLASS''

Line 2459: where trigger_name='HR_ALL_ORGANIZATION_UNITS_UTF8';

2455:
2456: cursor c_derive_name_length is
2457: select 1
2458: from user_triggers
2459: where trigger_name='HR_ALL_ORGANIZATION_UNITS_UTF8';
2460:
2461: BEGIN
2462: hr_utility.set_location('Entering : '||l_proc,10);
2463: /*