APPS.GL_JAHE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

	SELECT 	parent_flex_value
	FROM	fnd_flex_value_norm_hierarchy
	WHERE	flex_value_set_id = vsid
	AND	range_attribute = 'P'
	AND	child	BETWEEN	child_flex_value_low
			AND	child_flex_value_high;

Line: 70

    SELECT  COUNT(*)
    INTO    range_size
    FROM    FND_FLEX_VALUES
    WHERE   flex_value_set_id = value_set_id
    AND     summary_flag = sum_flag
    AND     flex_value BETWEEN range_low AND range_high;

Line: 80

        DELETE  FND_FLEX_VALUE_NORM_HIERARCHY
        WHERE   flex_value_set_id = value_set_id
        AND     parent_flex_value = parent
        AND     range_attribute = range_attr
        AND     child_flex_value_low = range_low
        AND     child_flex_value_high = range_high;

Line: 91

        SELECT  MIN(flex_value)
        INTO    new_bound
        FROM    fnd_flex_values
        WHERE   flex_value_set_id = value_set_id
        AND     summary_flag = sum_flag
        AND     flex_value > child
        AND     flex_value <= range_high
        ORDER BY flex_value;

Line: 101

            UPDATE  FND_FLEX_VALUE_NORM_HIERARCHY
            SET     child_flex_value_low = new_bound
            WHERE   flex_value_set_id = value_set_id
            AND     parent_flex_value = parent
            AND     range_attribute = range_attr
            AND     child_flex_value_low = range_low
            AND     child_flex_value_high = range_high;

Line: 113

        SELECT  MAX(flex_value)
        INTO    new_bound
        FROM    fnd_flex_values
        WHERE   flex_value_set_id = value_set_id
        AND     summary_flag = sum_flag
        AND     flex_value >= range_low
        AND     flex_value < child
        ORDER BY flex_value;

Line: 123

            UPDATE  FND_FLEX_VALUE_NORM_HIERARCHY
            SET     child_flex_value_high = new_bound
            WHERE   flex_value_set_id = value_set_id
            AND     parent_flex_value = parent
            AND     range_attribute = range_attr
            AND     child_flex_value_low = range_low
            AND     child_flex_value_high = range_high;

Line: 136

        DELETE  FND_FLEX_VALUE_NORM_HIERARCHY
        WHERE   flex_value_set_id = value_set_id
        AND     parent_flex_value = parent
        AND     range_attribute = range_attr
        AND     child_flex_value_low = range_low
        AND     child_flex_value_high = range_high;

Line: 146

        SELECT  MAX(flex_value)
        INTO    new_bound
        FROM    fnd_flex_values
        WHERE   flex_value_set_id = value_set_id
        AND     summary_flag = sum_flag
        AND     flex_value >= range_low
        AND     flex_value < child
        ORDER BY flex_value;

Line: 158

            INSERT INTO FND_FLEX_VALUE_NORM_HIERARCHY
            (   flex_value_set_id,
                parent_flex_value,
                range_attribute,
                child_flex_value_low,
                child_flex_value_high,
                last_update_date,
                last_updated_by,
                creation_date,
                created_by,
                last_update_login )
            VALUES
            (   value_set_id,
                parent,
                range_attr,
                range_low,
                new_bound,
                SYSDATE,
                0,
                SYSDATE,
                0,
                0 );

Line: 185

        SELECT  MIN(flex_value)
        INTO    new_bound
        FROM    fnd_flex_values
        WHERE   flex_value_set_id = value_set_id
        AND     summary_flag = sum_flag
        AND     flex_value > child
        AND     flex_value <= range_high
        ORDER BY flex_value;

Line: 197

            INSERT INTO FND_FLEX_VALUE_NORM_HIERARCHY
            (   flex_value_set_id,
                parent_flex_value,
                range_attribute,
                child_flex_value_low,
                child_flex_value_high,
                last_update_date,
                last_updated_by,
                creation_date,
                created_by,
                last_update_login )
            VALUES
            (   value_set_id,
                parent,
                range_attr,
                new_bound,
                range_high,
                SYSDATE,
                0,
                SYSDATE,
                0,
                0 );

Line: 234

	SELECT 	flex_value
	FROM	fnd_flex_values
	WHERE	flex_value_set_id = vsid
	AND	summary_flag = 'Y'
	AND	flex_value BETWEEN low AND high
    	ORDER	by flex_value;

Line: 273

	SELECT 	child_flex_value_low, child_flex_value_high
    	from    gl_ahe_detail_ranges_gt
    	where   parent_flex_value = parent
    	and     status = 'C'
	order by child_flex_value_low, child_flex_value_high;

Line: 294

            SELECT  1
            INTO    has_value
            FROM    fnd_flex_values
            WHERE   flex_value_set_id = value_set_id
            AND     summary_flag = 'N'
            AND     flex_value > merged_high
            AND     flex_value < low
            AND     rownum <= 1;

Line: 304

            INSERT INTO gl_ahe_detail_ranges_gt
            (parent_flex_value,
             child_flex_value_low,
             child_flex_value_high,
             status)
            values (parent, merged_low, merged_high, 'M');

Line: 321

    INSERT INTO gl_ahe_detail_ranges_gt
    (parent_flex_value,
     child_flex_value_low,
     child_flex_value_high,
     status)
    values (parent, merged_low, merged_high, 'M');

Line: 340

  SELECT count(*)
  INTO row_count
  FROM fnd_flex_values
  WHERE flex_value_set_id = value_set_id
  AND flex_value = f_value
  AND ((parent_low IS null) OR
       (parent_flex_value_low = parent_low));

Line: 360

  select responsibility_id, responsibility_application_id
  from fnd_user_resp_groups
  where user_id = uid
--  and responsibility_application_id = 101
  and (start_date is null or start_date < sysdate)
  and (end_date is null or end_date > sysdate);

Line: 391

        select chart_of_accounts_id into coaid
        from gl_sets_of_books
        where set_of_books_id = to_number(sobid);

Line: 399

        select chart_of_accounts_id into coaid
        from gl_access_sets
        where access_set_id = to_number(accsetid);

Line: 468

PROCEDURE insert_tl_records (fvsid NUMBER DEFAULT NULL) is

  cursor installed_lang_cursor is
    select LANGUAGE_CODE from FND_LANGUAGES
    where INSTALLED_FLAG in ('B', 'I');

Line: 487

        insert into FND_FLEX_VALUES_TL (
          FLEX_VALUE_ID,
          LAST_UPDATE_DATE,
          LAST_UPDATED_BY,
          CREATION_DATE,
          CREATED_BY,
          LAST_UPDATE_LOGIN,
          DESCRIPTION,
          FLEX_VALUE_MEANING,
          LANGUAGE,
          SOURCE_LANG
       )
          (select
             T1.FLEX_VALUE_ID,
             T1.LAST_UPDATE_DATE,
             T1.LAST_UPDATED_BY,
             T1.CREATION_DATE,
             T1.CREATED_BY,
             T1.LAST_UPDATE_LOGIN,
             T1.DESCRIPTION,
             T1.FLEX_VALUE_MEANING,
             lang_code,
             T1.SOURCE_LANG
           from fnd_flex_values_tl T1
           -- Bug 4775405, add join
               ,fnd_flex_values B
           where language = userenv('LANG')
           and not exists  (select NULL
                           from fnd_flex_values_tl T2
                           where T2.language = lang_code
                           and T2.flex_value_id = T1.flex_value_id)
           -- Bug 4775405, add filter
           and T1.flex_value_id = B.flex_value_id
           and B.flex_value_set_id = fvsid
          );

Line: 523

        insert into FND_FLEX_HIERARCHIES_TL (
          FLEX_VALUE_SET_ID,
          HIERARCHY_ID,
          HIERARCHY_NAME,
          LANGUAGE,
          LAST_UPDATE_DATE,
          LAST_UPDATED_BY,
          CREATION_DATE,
          CREATED_BY,
          LAST_UPDATE_LOGIN,
          DESCRIPTION,
          SOURCE_LANG
        )
          (select
             flex_value_set_id,
             hierarchy_id,
             hierarchy_name,
             lang_code,
             last_update_date,
             last_updated_by,
             creation_date,
             created_by,
             last_update_login,
             description,
             source_lang
           from fnd_flex_hierarchies_tl T1
           where language = userenv('LANG')
           and not exists (select NULL
                          from fnd_flex_hierarchies_tl T2
                          where T2.language = lang_code
                          and T2.hierarchy_id = T1.hierarchy_id
                          -- Bug 4775405, add filter
                          and T2.flex_value_set_id = T1.flex_value_set_id)
           -- Bug 4775405, add filter
           and T1.flex_value_set_id = fvsid
          );

Line: 565

END insert_tl_records;