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 FND_FLEX_VALUES_VL

Line 366: FROM fnd_flex_values_vl

362: ) IS
363: SELECT description
364: , start_date_active
365: , end_date_active
366: FROM fnd_flex_values_vl
367: WHERE flex_value_set_id = cp_vs_id
368: AND flex_value = cp_code;
369:
370: BEGIN

Line 1331: l_co_start_date fnd_flex_values_vl.start_date_active%TYPE;

1327:
1328: -- Local variables
1329: l_proc VARCHAR2(50) := g_package||'.derive_org_name';
1330: l_retcode NUMBER := 0;
1331: l_co_start_date fnd_flex_values_vl.start_date_active%TYPE;
1332: l_cc_start_date fnd_flex_values_vl.start_date_active%TYPE;
1333: l_co_end_date fnd_flex_values_vl.end_date_active%TYPE;
1334: l_cc_end_date fnd_flex_values_vl.end_date_active%TYPE;
1335:

Line 1332: l_cc_start_date fnd_flex_values_vl.start_date_active%TYPE;

1328: -- Local variables
1329: l_proc VARCHAR2(50) := g_package||'.derive_org_name';
1330: l_retcode NUMBER := 0;
1331: l_co_start_date fnd_flex_values_vl.start_date_active%TYPE;
1332: l_cc_start_date fnd_flex_values_vl.start_date_active%TYPE;
1333: l_co_end_date fnd_flex_values_vl.end_date_active%TYPE;
1334: l_cc_end_date fnd_flex_values_vl.end_date_active%TYPE;
1335:
1336: BEGIN

Line 1333: l_co_end_date fnd_flex_values_vl.end_date_active%TYPE;

1329: l_proc VARCHAR2(50) := g_package||'.derive_org_name';
1330: l_retcode NUMBER := 0;
1331: l_co_start_date fnd_flex_values_vl.start_date_active%TYPE;
1332: l_cc_start_date fnd_flex_values_vl.start_date_active%TYPE;
1333: l_co_end_date fnd_flex_values_vl.end_date_active%TYPE;
1334: l_cc_end_date fnd_flex_values_vl.end_date_active%TYPE;
1335:
1336: BEGIN
1337:

Line 1334: l_cc_end_date fnd_flex_values_vl.end_date_active%TYPE;

1330: l_retcode NUMBER := 0;
1331: l_co_start_date fnd_flex_values_vl.start_date_active%TYPE;
1332: l_cc_start_date fnd_flex_values_vl.start_date_active%TYPE;
1333: l_co_end_date fnd_flex_values_vl.end_date_active%TYPE;
1334: l_cc_end_date fnd_flex_values_vl.end_date_active%TYPE;
1335:
1336: BEGIN
1337:
1338: hr_utility.set_location('Entering: '|| l_proc, 10);

Line 1481: l_org_start_date fnd_flex_values_vl.start_date_active%TYPE;

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;
1485: l_class_ovn hr_organization_information.object_version_number%TYPE;

Line 1482: l_org_end_date fnd_flex_values_vl.end_date_active%TYPE;

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;
1485: l_class_ovn hr_organization_information.object_version_number%TYPE;
1486: l_co VARCHAR2(240);

Line 1490: l_co_desc fnd_flex_values_vl.description%TYPE;

1486: l_co VARCHAR2(240);
1487: l_cc VARCHAR2(240);
1488: l_co_vs_id NUMBER(15); -- Id of company value set
1489: l_cc_vs_id NUMBER(15); -- Id of cost center value set
1490: l_co_desc fnd_flex_values_vl.description%TYPE;
1491: l_cc_desc fnd_flex_values_vl.description%TYPE;
1492:
1493: BEGIN
1494:

Line 1491: l_cc_desc fnd_flex_values_vl.description%TYPE;

1487: l_cc VARCHAR2(240);
1488: l_co_vs_id NUMBER(15); -- Id of company value set
1489: l_cc_vs_id NUMBER(15); -- Id of cost center value set
1490: l_co_desc fnd_flex_values_vl.description%TYPE;
1491: l_cc_desc fnd_flex_values_vl.description%TYPE;
1492:
1493: BEGIN
1494:
1495: hr_utility.set_location('Entering: '|| l_proc, 10);

Line 1721: l_co_desc fnd_flex_values_vl.description%TYPE;

1717: l_co VARCHAR2(240); -- Company value
1718: l_cc VARCHAR2(240); -- Cost Center value
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;

Line 1722: l_cc_desc fnd_flex_values_vl.description%TYPE;

1718: l_cc VARCHAR2(240); -- Cost Center value
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;

Line 1724: l_org_start_date fnd_flex_values_vl.start_date_active%TYPE;

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;
1728:

Line 1725: l_org_end_date fnd_flex_values_vl.end_date_active%TYPE;

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;
1728:
1729: TYPE cur_type IS REF CURSOR;

Line 1849: l_cc_desc fnd_flex_values_vl.description%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;
1853: l_co varchar2(240); -- company value

Line 1850: l_co_desc fnd_flex_values_vl.description%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;
1853: l_co varchar2(240); -- company value
1854: l_cc varchar2(240); -- cost center value

Line 1851: l_org_start_date fnd_flex_values_vl.start_date_active%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;
1853: l_co varchar2(240); -- company value
1854: l_cc varchar2(240); -- cost center value
1855: l_proc varchar2(72) := g_package||'.update_org_name_date';

Line 1852: l_org_end_date fnd_flex_values_vl.end_date_active%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;
1853: l_co varchar2(240); -- company value
1854: l_cc varchar2(240); -- cost center value
1855: l_proc varchar2(72) := g_package||'.update_org_name_date';
1856: --

Line 2053: from fnd_flex_values_vl

2049: and cc.org_information5 is null
2050: and units.business_group_id = cp_business_group_id
2051: and cc.org_information3 in (
2052: select flex_value
2053: from fnd_flex_values_vl
2054: where flex_value_set_id = cp_co_vs_id);
2055: --
2056: -- Cursor to fetch Cost Center Codes from the specified value set
2057: cursor c_cost_centers(cp_cc_vs_id in number) is

Line 2059: from fnd_flex_values_vl ffv

2055: --
2056: -- Cursor to fetch Cost Center Codes from the specified value set
2057: cursor c_cost_centers(cp_cc_vs_id in number) is
2058: select ffv.flex_value cost_center_code
2059: from fnd_flex_values_vl ffv
2060: where ffv.flex_value_set_id = cp_cc_vs_id
2061: order by ffv.flex_value;
2062: --
2063: -- Local exceptions

Line 2404: l_cc_desc fnd_flex_values_vl.description%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;
2407: l_co_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2408: l_cc_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;

Line 2406: l_co_desc fnd_flex_values_vl.description%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;
2407: l_co_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2408: l_cc_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2409: l_org_start_date fnd_flex_values_vl.start_date_active%TYPE;
2410: l_org_end_date fnd_flex_values_vl.end_date_active%TYPE;

Line 2409: l_org_start_date fnd_flex_values_vl.start_date_active%TYPE;

2405: l_co VARCHAR2(240); -- Company value
2406: l_co_desc fnd_flex_values_vl.description%TYPE;
2407: l_co_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2408: l_cc_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2409: l_org_start_date fnd_flex_values_vl.start_date_active%TYPE;
2410: l_org_end_date fnd_flex_values_vl.end_date_active%TYPE;
2411: l_delete_synced_orgs_flag BOOLEAN := FALSE;
2412:
2413: TYPE cur_type IS REF CURSOR;

Line 2410: l_org_end_date fnd_flex_values_vl.end_date_active%TYPE;

2406: l_co_desc fnd_flex_values_vl.description%TYPE;
2407: l_co_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2408: l_cc_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2409: l_org_start_date fnd_flex_values_vl.start_date_active%TYPE;
2410: l_org_end_date fnd_flex_values_vl.end_date_active%TYPE;
2411: l_delete_synced_orgs_flag BOOLEAN := FALSE;
2412:
2413: TYPE cur_type IS REF CURSOR;
2414: c_ref cur_type;

Line 2439: FROM fnd_flex_values_vl

2435: AND CC.org_information4 IS NULL
2436: AND CC.org_information5 IS NULL
2437: AND UNITS.business_group_id = cp_business_group_id
2438: AND CC.org_information3 IN ( SELECT flex_value
2439: FROM fnd_flex_values_vl
2440: WHERE flex_value_set_id = cp_co_vs_id
2441: );
2442:
2443: -- Cursor to fetch Cost Center Codes from the specified value set

Line 2446: FROM fnd_flex_values_vl FFV

2442:
2443: -- Cursor to fetch Cost Center Codes from the specified value set
2444: CURSOR c_cost_centers(cp_cc_vs_id IN NUMBER) IS
2445: SELECT FFV.flex_value cost_center_code
2446: FROM fnd_flex_values_vl FFV
2447: WHERE FFV.flex_value_set_id = cp_cc_vs_id
2448: ORDER BY FFV.flex_value;
2449:
2450: -- Local exceptions

Line 3070: l_cc_desc fnd_flex_values_vl.description%TYPE;

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;
3073: l_co_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;
3074: l_cc_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;

Line 3072: l_co_desc fnd_flex_values_vl.description%TYPE;

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;
3073: l_co_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;
3074: l_cc_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;
3075: l_org_start_date fnd_flex_values_vl.start_date_active%TYPE;
3076:

Line 3075: l_org_start_date fnd_flex_values_vl.start_date_active%TYPE;

3071: l_co VARCHAR2(240); -- Company value
3072: l_co_desc fnd_flex_values_vl.description%TYPE;
3073: l_co_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;
3074: l_cc_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;
3075: l_org_start_date fnd_flex_values_vl.start_date_active%TYPE;
3076:
3077: TYPE cur_type IS REF CURSOR;
3078: c_list cur_type;
3079:

Line 3260: l_co_desc fnd_flex_values_vl.description%TYPE;

3256: l_co_seg VARCHAR2(240); -- Col name of seg holding company value
3257: l_cc_seg VARCHAR2(240); -- Col name of seg holding cost center value
3258: l_co_vs_id NUMBER(15); -- Id of company value set
3259: l_cc_vs_id NUMBER(15); -- Id of cost center value set
3260: l_co_desc fnd_flex_values_vl.description%TYPE;
3261: l_cc_desc fnd_flex_values_vl.description%TYPE;
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);

Line 3261: l_cc_desc fnd_flex_values_vl.description%TYPE;

3257: l_cc_seg VARCHAR2(240); -- Col name of seg holding cost center value
3258: l_co_vs_id NUMBER(15); -- Id of company value set
3259: l_cc_vs_id NUMBER(15); -- Id of cost center value set
3260: l_co_desc fnd_flex_values_vl.description%TYPE;
3261: l_cc_desc fnd_flex_values_vl.description%TYPE;
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);

Line 3262: l_co_start_date fnd_flex_values_vl.start_date_active%TYPE;

3258: l_co_vs_id NUMBER(15); -- Id of company value set
3259: l_cc_vs_id NUMBER(15); -- Id of cost center value set
3260: l_co_desc fnd_flex_values_vl.description%TYPE;
3261: l_cc_desc fnd_flex_values_vl.description%TYPE;
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;

Line 3263: l_cc_start_date fnd_flex_values_vl.start_date_active%TYPE;

3259: l_cc_vs_id NUMBER(15); -- Id of cost center value set
3260: l_co_desc fnd_flex_values_vl.description%TYPE;
3261: l_cc_desc fnd_flex_values_vl.description%TYPE;
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;