APPS.HR_GL_SYNC_ORGS dependencies on FND_FLEX_VALUE_SETS

Line 419: FROM fnd_flex_value_sets

415: -- Local cursor to fetch flex value set name
416: CURSOR c_vs_dets( cp_vs_id IN NUMBER
417: ) IS
418: SELECT flex_value_set_name
419: FROM fnd_flex_value_sets
420: WHERE flex_value_set_id = cp_vs_id;
421:
422: BEGIN
423:

Line 465: l_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;

461:
462: -- Local variables
463: l_proc VARCHAR2(50) := g_package||'.get_vs_for_seg';
464: l_retcode NUMBER := 0;
465: l_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;
466:
467: TYPE cur_type IS REF CURSOR;
468: c_list cur_type;
469:

Line 478: ' fnd_flex_value_sets VS'||

474:
475: OPEN c_list FOR ' SELECT VS.flex_value_set_id,'||
476: ' VS.flex_value_set_name'||
477: ' FROM fnd_id_flex_segments_vl SEG,'||
478: ' fnd_flex_value_sets VS'||
479: ' WHERE UPPER(SEG.id_flex_code) = ''GL#'''||
480: ' AND SEG.application_id = 101'||
481: ' AND SEG.flex_value_set_id = VS.flex_value_set_id'||
482: ' AND SEG.enabled_flag = ''Y'''||

Line 1726: l_co_vs_name fnd_flex_value_sets.flex_value_set_name%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;
1730: c_list cur_type;

Line 1727: l_cc_vs_name fnd_flex_value_sets.flex_value_set_name%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;
1730: c_list cur_type;
1731:

Line 2407: l_co_vs_name fnd_flex_value_sets.flex_value_set_name%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;
2411: l_delete_synced_orgs_flag BOOLEAN := FALSE;

Line 2408: l_cc_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;

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;
2411: l_delete_synced_orgs_flag BOOLEAN := FALSE;
2412:

Line 3073: l_co_vs_name fnd_flex_value_sets.flex_value_set_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:
3077: TYPE cur_type IS REF CURSOR;

Line 3074: l_cc_vs_name fnd_flex_value_sets.flex_value_set_name%TYPE;

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:
3077: TYPE cur_type IS REF CURSOR;
3078: c_list cur_type;