APPS.HR_GL_COST_CENTERS dependencies on HR_ALL_ORGANIZATION_UNITS_TL

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 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 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 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 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