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

Line 657: FROM hr_all_organization_units UNITS

653: CURSOR c_bg_id( cp_co_vs_id IN NUMBER
654: , cp_co IN VARCHAR2
655: ) IS
656: SELECT DISTINCT UNITS.business_group_id
657: FROM hr_all_organization_units UNITS
658: , hr_organization_information CLASS
659: , hr_organization_information CC
660: WHERE UNITS.organization_id = CLASS.organization_id
661: AND CLASS.org_information_context = 'CLASS'

Line 1203: FROM hr_all_organization_units

1199:
1200: -- Cursor to test if ORG with given name already exists.
1201: CURSOR c_chk_org_name IS
1202: SELECT organization_id
1203: FROM hr_all_organization_units
1204: WHERE name = p_org_name
1205: AND business_group_id = p_bg_id;
1206:
1207: BEGIN

Line 1479: l_org_name hr_all_organization_units.name%TYPE;

1475:
1476: -- Local variables
1477: l_proc VARCHAR2(50) := g_package||'.gen_org_co_cc_class';
1478: l_retcode NUMBER := 0;
1479: l_org_name hr_all_organization_units.name%TYPE;
1480: l_new_org_name hr_all_organization_units.name%TYPE;
1481: l_org_start_date fnd_flex_values_vl.start_date_active%TYPE;
1482: l_org_end_date fnd_flex_values_vl.end_date_active%TYPE;
1483: l_class_enabled hr_organization_information.org_information2%TYPE;

Line 1480: l_new_org_name hr_all_organization_units.name%TYPE;

1476: -- Local variables
1477: l_proc VARCHAR2(50) := g_package||'.gen_org_co_cc_class';
1478: l_retcode NUMBER := 0;
1479: l_org_name hr_all_organization_units.name%TYPE;
1480: l_new_org_name hr_all_organization_units.name%TYPE;
1481: l_org_start_date fnd_flex_values_vl.start_date_active%TYPE;
1482: l_org_end_date fnd_flex_values_vl.end_date_active%TYPE;
1483: l_class_enabled hr_organization_information.org_information2%TYPE;
1484: l_class_id hr_organization_information.org_information_id%TYPE;

Line 1723: l_org_name hr_all_organization_units.name%TYPE;

1719: l_co_vs_id NUMBER(15); -- Id of company value set
1720: l_cc_vs_id NUMBER(15); -- Id of cost center value set
1721: l_co_desc fnd_flex_values_vl.description%TYPE;
1722: l_cc_desc fnd_flex_values_vl.description%TYPE;
1723: l_org_name hr_all_organization_units.name%TYPE;
1724: l_org_start_date fnd_flex_values_vl.start_date_active%TYPE;
1725: l_org_end_date fnd_flex_values_vl.end_date_active%TYPE;
1726: l_co_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;
1727: l_cc_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;

Line 1844: l_org_id hr_all_organization_units.organization_id%type;

1840: l_updrowcount number := 0;
1841: l_retcode number := 0;
1842: l_co_vs_id number; -- Company value set id
1843: l_cc_vs_id number; -- Cost Center value set id
1844: l_org_id hr_all_organization_units.organization_id%type;
1845: l_org_name hr_all_organization_units.name%type;
1846: l_name hr_all_organization_units.name%type;
1847: l_start hr_all_organization_units.date_from%type;
1848: l_end hr_all_organization_units.date_to%type;

Line 1845: l_org_name hr_all_organization_units.name%type;

1841: l_retcode number := 0;
1842: l_co_vs_id number; -- Company value set id
1843: l_cc_vs_id number; -- Cost Center value set id
1844: l_org_id hr_all_organization_units.organization_id%type;
1845: l_org_name hr_all_organization_units.name%type;
1846: l_name hr_all_organization_units.name%type;
1847: l_start hr_all_organization_units.date_from%type;
1848: l_end hr_all_organization_units.date_to%type;
1849: l_cc_desc fnd_flex_values_vl.description%type;

Line 1846: l_name hr_all_organization_units.name%type;

1842: l_co_vs_id number; -- Company value set id
1843: l_cc_vs_id number; -- Cost Center value set id
1844: l_org_id hr_all_organization_units.organization_id%type;
1845: l_org_name hr_all_organization_units.name%type;
1846: l_name hr_all_organization_units.name%type;
1847: l_start hr_all_organization_units.date_from%type;
1848: l_end hr_all_organization_units.date_to%type;
1849: l_cc_desc fnd_flex_values_vl.description%type;
1850: l_co_desc fnd_flex_values_vl.description%type;

Line 1847: l_start hr_all_organization_units.date_from%type;

1843: l_cc_vs_id number; -- Cost Center value set id
1844: l_org_id hr_all_organization_units.organization_id%type;
1845: l_org_name hr_all_organization_units.name%type;
1846: l_name hr_all_organization_units.name%type;
1847: l_start hr_all_organization_units.date_from%type;
1848: l_end hr_all_organization_units.date_to%type;
1849: l_cc_desc fnd_flex_values_vl.description%type;
1850: l_co_desc fnd_flex_values_vl.description%type;
1851: l_org_start_date fnd_flex_values_vl.start_date_active%type;

Line 1848: l_end hr_all_organization_units.date_to%type;

1844: l_org_id hr_all_organization_units.organization_id%type;
1845: l_org_name hr_all_organization_units.name%type;
1846: l_name hr_all_organization_units.name%type;
1847: l_start hr_all_organization_units.date_from%type;
1848: l_end hr_all_organization_units.date_to%type;
1849: l_cc_desc fnd_flex_values_vl.description%type;
1850: l_co_desc fnd_flex_values_vl.description%type;
1851: l_org_start_date fnd_flex_values_vl.start_date_active%type;
1852: l_org_end_date fnd_flex_values_vl.end_date_active%type;

Line 1881: ' hr_all_organization_units units'||

1877: ' t.co_vs_id, t.co, t.cc_vs_id, t.cc'||
1878: ' from '|| g_temp_table_name ||' t , '||
1879: ' hr_organization_information cc,'||
1880: ' hr_organization_information class,'||
1881: ' hr_all_organization_units units'||
1882: ' where to_char(t.co_vs_id) = cc.org_information2 '||
1883: ' and t.co = cc.org_information3 '||
1884: ' and to_char(t.cc_vs_id) = cc.org_information4 '||
1885: ' and t.cc = cc.org_information5 '||

Line 1924: update hr_all_organization_units units

1920: nvl(l_org_end_date, hr_api.g_sot) <> nvl(l_end, hr_api.g_sot) then
1921: --
1922: hr_utility.set_location(l_proc, 50);
1923: --
1924: update hr_all_organization_units units
1925: set units.name = l_org_name,
1926: units.date_from = l_org_start_date,
1927: units.date_to = l_org_end_date
1928: where units.rowid = l_rowid;

Line 1930: update hr_all_organization_units_tl

1926: units.date_from = l_org_start_date,
1927: units.date_to = l_org_end_date
1928: where units.rowid = l_rowid;
1929: --
1930: update hr_all_organization_units_tl
1931: set name= l_org_name
1932: where organization_id = l_org_id
1933: and language in (language, source_lang);
1934: --

Line 1945: update hr_all_organization_units units

1941: if l_org_name <> l_name then
1942: --
1943: hr_utility.set_location(l_proc, 60);
1944: --
1945: update hr_all_organization_units units
1946: set units.name = l_org_name
1947: where units.rowid = l_rowid;
1948: --
1949: update hr_all_organization_units_tl

Line 1949: update hr_all_organization_units_tl

1945: update hr_all_organization_units units
1946: set units.name = l_org_name
1947: where units.rowid = l_rowid;
1948: --
1949: update hr_all_organization_units_tl
1950: set name=l_org_name
1951: where organization_id = l_org_id
1952: and language in (language, source_lang);
1953: --

Line 1965: update hr_all_organization_units units

1961: nvl(l_org_end_date, hr_api.g_sot) <> nvl(l_end, hr_api.g_sot) then
1962: --
1963: hr_utility.set_location(l_proc, 70);
1964: --
1965: update hr_all_organization_units units
1966: set units.date_from = l_org_start_date,
1967: units.date_to = l_org_end_date
1968: where units.rowid = l_rowid;
1969: --

Line 2037: from hr_all_organization_units units,

2033: cursor c_companies(cp_co in varchar2
2034: ,cp_business_group_id in number
2035: ,cp_co_vs_id in number) is
2036: select distinct cc.org_information3 company_code
2037: from hr_all_organization_units units,
2038: hr_organization_information class,
2039: hr_organization_information cc
2040: where units.organization_id = class.organization_id
2041: and class.org_information_context = 'CLASS'

Line 2162: ' from hr_all_organization_units units,'||

2158: --
2159: execute immediate 'delete from '||g_temp_table_name||
2160: ' where (co,to_char(co_vs_id)) not in ('||
2161: ' select distinct cc.org_information3, cc.org_information2'||
2162: ' from hr_all_organization_units units,'||
2163: ' hr_organization_information class,'||
2164: ' hr_organization_information cc'||
2165: ' where units.organization_id = class.organization_id'||
2166: ' and class.org_information_context = ''CLASS'''||

Line 2309: ' FROM hr_all_organization_units UNITS,'||

2305: ' WHERE (TO_CHAR(co_vs_id), co'||
2306: ', TO_CHAR(cc_vs_id), cc) IN ('||
2307: ' SELECT CC.org_information2, CC.org_information3,'||
2308: ' CC.org_information4, CC.org_information5'||
2309: ' FROM hr_all_organization_units UNITS,'||
2310: ' hr_organization_information CLASS,'||
2311: ' hr_organization_information CC'||
2312: ' WHERE UNITS.organization_id = CLASS.organization_id'||
2313: ' AND CLASS.org_information_context = ''CLASS'''||

Line 2399: l_org_name hr_all_organization_units.name%TYPE;

2395: l_cc_vs_id NUMBER; -- Cost Center value set id
2396:
2397: l_rowid ROWID;
2398: l_sql_num NUMBER(3);
2399: l_org_name hr_all_organization_units.name%TYPE;
2400: l_name hr_all_organization_units.name%TYPE;
2401: l_start hr_all_organization_units.date_from%TYPE;
2402: l_end hr_all_organization_units.date_to%TYPE;
2403: l_cc VARCHAR2(240); -- Cost Center value

Line 2400: l_name hr_all_organization_units.name%TYPE;

2396:
2397: l_rowid ROWID;
2398: l_sql_num NUMBER(3);
2399: l_org_name hr_all_organization_units.name%TYPE;
2400: l_name hr_all_organization_units.name%TYPE;
2401: l_start hr_all_organization_units.date_from%TYPE;
2402: l_end hr_all_organization_units.date_to%TYPE;
2403: l_cc VARCHAR2(240); -- Cost Center value
2404: l_cc_desc fnd_flex_values_vl.description%TYPE;

Line 2401: l_start hr_all_organization_units.date_from%TYPE;

2397: l_rowid ROWID;
2398: l_sql_num NUMBER(3);
2399: l_org_name hr_all_organization_units.name%TYPE;
2400: l_name hr_all_organization_units.name%TYPE;
2401: l_start hr_all_organization_units.date_from%TYPE;
2402: l_end hr_all_organization_units.date_to%TYPE;
2403: l_cc VARCHAR2(240); -- Cost Center value
2404: l_cc_desc fnd_flex_values_vl.description%TYPE;
2405: l_co VARCHAR2(240); -- Company value

Line 2402: l_end hr_all_organization_units.date_to%TYPE;

2398: l_sql_num NUMBER(3);
2399: l_org_name hr_all_organization_units.name%TYPE;
2400: l_name hr_all_organization_units.name%TYPE;
2401: l_start hr_all_organization_units.date_from%TYPE;
2402: l_end hr_all_organization_units.date_to%TYPE;
2403: l_cc VARCHAR2(240); -- Cost Center value
2404: l_cc_desc fnd_flex_values_vl.description%TYPE;
2405: l_co VARCHAR2(240); -- Company value
2406: l_co_desc fnd_flex_values_vl.description%TYPE;

Line 2424: FROM hr_all_organization_units UNITS

2420: , cp_business_group_id IN NUMBER
2421: , cp_co_vs_id IN NUMBER
2422: ) IS
2423: SELECT DISTINCT CC.org_information3 company_code
2424: FROM hr_all_organization_units UNITS
2425: ,hr_organization_information CLASS
2426: ,hr_organization_information CC
2427: WHERE UNITS.organization_id = CLASS.organization_id
2428: AND CLASS.org_information_context = 'CLASS'

Line 2560: ' FROM hr_all_organization_units UNITS,'||

2556:
2557: EXECUTE IMMEDIATE 'DELETE FROM '||g_temp_table_name||
2558: ' WHERE (co,TO_CHAR(co_vs_id)) NOT IN ('||
2559: ' SELECT DISTINCT CC.org_information3, CC.org_information2'||
2560: ' FROM hr_all_organization_units UNITS,'||
2561: ' hr_organization_information CLASS,'||
2562: ' hr_organization_information CC'||
2563: ' WHERE UNITS.organization_id = CLASS.organization_id'||
2564: ' AND CLASS.org_information_context = ''CLASS'''||

Line 2619: ' hr_all_organization_units UNITS'||

2615: ' t.CO_VS_ID, t.CO, t.CC_VS_ID, t.CC'||
2616: ' FROM '|| g_temp_table_name ||' t , '||
2617: ' hr_organization_information CC,'||
2618: ' hr_organization_information CLASS,'||
2619: ' hr_all_organization_units UNITS'||
2620: ' WHERE TO_CHAR(t.co_vs_id) = CC.org_information2 '||
2621: ' AND t.co = CC.org_information3 '||
2622: ' AND TO_CHAR(t.cc_vs_id) = CC.org_information4 '||
2623: ' AND t.cc = CC.org_information5 '||

Line 2653: UPDATE hr_all_organization_units UNITS

2649: IF l_sql_num = 1 THEN
2650: IF l_org_name <> l_name OR l_org_start_date <> l_start OR
2651: nvl(l_org_end_date,hr_api.g_sot) <> nvl(l_end,hr_api.g_sot) THEN
2652:
2653: UPDATE hr_all_organization_units UNITS
2654: SET UNITS.name = l_org_name,
2655: UNITS.date_from = l_org_start_date,
2656: UNITS.date_to = l_org_end_date
2657: WHERE UNITS.rowid = l_rowid;

Line 2664: UPDATE hr_all_organization_units UNITS

2660: END IF;
2661: ELSIF l_sql_num = 2 THEN
2662: IF l_org_name <> l_name THEN
2663:
2664: UPDATE hr_all_organization_units UNITS
2665: SET UNITS.name = l_org_name
2666: WHERE UNITS.rowid = l_rowid;
2667:
2668: l_updrowcount := l_updrowcount+1;

Line 2674: UPDATE hr_all_organization_units UNITS

2670: ELSIF l_sql_num = 3 THEN
2671: IF l_org_start_date <> l_start OR
2672: nvl(l_org_end_date,hr_api.g_sot) <> nvl(l_end,hr_api.g_sot) THEN
2673:
2674: UPDATE hr_all_organization_units UNITS
2675: SET UNITS.date_from = l_org_start_date,
2676: UNITS.date_to = l_org_end_date
2677: WHERE UNITS.rowid = l_rowid;
2678:

Line 2748: ' FROM hr_all_organization_units UNITS,'||

2744: ' WHERE (TO_CHAR(co_vs_id), co'||
2745: ', TO_CHAR(cc_vs_id), cc) IN ('||
2746: ' SELECT CC.org_information2, CC.org_information3,'||
2747: ' CC.org_information4, CC.org_information5'||
2748: ' FROM hr_all_organization_units UNITS,'||
2749: ' hr_organization_information CLASS,'||
2750: ' hr_organization_information CC'||
2751: ' WHERE UNITS.organization_id = CLASS.organization_id'||
2752: ' AND CLASS.org_information_context = ''CLASS'''||

Line 2905: ' FROM hr_all_organization_units UNITS'||

2901: ' (SELECT DISTINCT CC.org_information2'||
2902: ', CC.org_information3'||
2903: ', CC.org_information4'||
2904: ', CC.org_information5'||
2905: ' FROM hr_all_organization_units UNITS'||
2906: ', hr_organization_information CLASS'||
2907: ', hr_organization_information CC'||
2908: ' WHERE UNITS.organization_id = CLASS.organization_id'||
2909: ' AND CLASS.org_information_context = ''CLASS'''||

Line 2940: ' FROM hr_all_organization_units UNITS'||

2936: ' (SELECT CC.org_information2'||
2937: ', CC.org_information3'||
2938: ', CC.org_information4'||
2939: ', CC.org_information5'||
2940: ' FROM hr_all_organization_units UNITS'||
2941: ', hr_organization_information CLASS'||
2942: ', hr_organization_information CC'||
2943: ' WHERE UNITS.organization_id = CLASS.organization_id'||
2944: ' AND CLASS.org_information_context = ''CLASS'''||

Line 3068: l_org_name hr_all_organization_units.name%TYPE;

3064: l_proc VARCHAR2(50) := g_package||'.write_dat_file';
3065: l_retcode NUMBER := 0;
3066: l_tab VARCHAR2(5) := fnd_global.tab;
3067: l_dat_rec_count NUMBER := 0;
3068: l_org_name hr_all_organization_units.name%TYPE;
3069: l_cc VARCHAR2(240); -- Cost Center value
3070: l_cc_desc fnd_flex_values_vl.description%TYPE;
3071: l_co VARCHAR2(240); -- Company value
3072: l_co_desc fnd_flex_values_vl.description%TYPE;

Line 3266: l_org_id hr_all_organization_units.organization_id%TYPE := -1;

3262: l_co_start_date fnd_flex_values_vl.start_date_active%TYPE;
3263: l_cc_start_date fnd_flex_values_vl.start_date_active%TYPE;
3264: l_co VARCHAR2(240);
3265: l_cc VARCHAR2(240);
3266: l_org_id hr_all_organization_units.organization_id%TYPE := -1;
3267: l_bg_id hr_all_organization_units.business_group_id%TYPE := -1;
3268:
3269: TYPE cur_type IS REF CURSOR;
3270: c_list cur_type;

Line 3267: l_bg_id hr_all_organization_units.business_group_id%TYPE := -1;

3263: l_cc_start_date fnd_flex_values_vl.start_date_active%TYPE;
3264: l_co VARCHAR2(240);
3265: l_cc VARCHAR2(240);
3266: l_org_id hr_all_organization_units.organization_id%TYPE := -1;
3267: l_bg_id hr_all_organization_units.business_group_id%TYPE := -1;
3268:
3269: TYPE cur_type IS REF CURSOR;
3270: c_list cur_type;
3271:

Line 3332: ' FROM hr_all_organization_units UNITS'||

3328: -- Check if Organization already exists
3329: IF l_retcode = 0 THEN
3330: hr_utility.set_location(l_proc, 70);
3331: OPEN c_list FOR 'SELECT UNITS.organization_id'||
3332: ' FROM hr_all_organization_units UNITS'||
3333: ', hr_organization_information CLASS'||
3334: ', hr_organization_information CC'||
3335: ' WHERE UNITS.organization_id = CLASS.organization_id'||
3336: ' AND CLASS.org_information_context = ''CLASS'''||

Line 3520: l_org_id hr_all_organization_units.organization_id%TYPE := -1;

3516: l_updated_by NUMBER := 0;
3517: l_ccid NUMBER;
3518: l_co VARCHAR2(240);
3519: l_cc VARCHAR2(240);
3520: l_org_id hr_all_organization_units.organization_id%TYPE := -1;
3521: l_duplicate_orgs_found BOOLEAN;
3522:
3523: -- Local exceptions
3524: e_no_records_to_process EXCEPTION;

Line 3551: ' FROM hr_all_organization_units UNITS'||

3547:
3548: EXECUTE IMMEDIATE 'UPDATE '||g_temp_table_name||' TEMP'||
3549: ' SET TEMP.org_id ='||
3550: ' (SELECT UNITS.organization_id'||
3551: ' FROM hr_all_organization_units UNITS'||
3552: ', hr_organization_information CLASS'||
3553: ', hr_organization_information CC'||
3554: ' WHERE UNITS.organization_id = CLASS.organization_id'||
3555: ' AND CLASS.org_information_context = ''CLASS'''||

Line 3681: l_org_id hr_all_organization_units.organization_id%TYPE;

3677: l_co VARCHAR2(240); -- Company value
3678: l_cc VARCHAR2(240); -- Cost Center value
3679: l_co_vs_id NUMBER(15); -- Id of company value set
3680: l_cc_vs_id NUMBER(15); -- Id of cost center value set
3681: l_org_id hr_all_organization_units.organization_id%TYPE;
3682:
3683: -- Local exceptions
3684: e_no_records_to_process EXCEPTION;
3685:

Line 3873: WHERE trigger_name = 'HR_ALL_ORGANIZATION_UNITS_UTF8';

3869: -- Cursor to test the existence of the UTF8 trigger
3870: CURSOR c_utf8_trigger IS
3871: SELECT 1
3872: FROM user_triggers
3873: WHERE trigger_name = 'HR_ALL_ORGANIZATION_UNITS_UTF8';
3874:
3875: -- Cursor to get the debug level for the instance.
3876: CURSOR c_debug_level IS
3877: SELECT parameter_value

Line 4177: l_bg_name hr_all_organization_units.name%TYPE;

4173: ) IS
4174:
4175: -- Local variables
4176: l_proc VARCHAR2(50) := g_package||'.sync_orgs';
4177: l_bg_name hr_all_organization_units.name%TYPE;
4178:
4179: -- Cursor to fetch business group name
4180: CURSOR c_bg_name IS
4181: SELECT name

Line 4182: FROM hr_all_organization_units

4178:
4179: -- Cursor to fetch business group name
4180: CURSOR c_bg_name IS
4181: SELECT name
4182: FROM hr_all_organization_units
4183: WHERE organization_id = p_business_group_id;
4184:
4185: BEGIN
4186: