APPS.ASO_DEPENDENCY_UTIL SQL Statements

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

Line: 145

  	SELECT line, text
  	FROM user_errors
  	WHERE name = upper(p_pkg_name)
  	  AND type = decode(p_pkg_type,'SPEC','PACKAGE',
  					'BODY','PACKAGE BODY');

Line: 409

	  l_src_attr_tbl.DELETE;

Line: 432

    l_dep_attr_tbl.DELETE;

Line: 449

SELECT  min(attribute_id)
FROM    oe_ak_obj_attr_ext
WHERE   database_object_name = p_database_object_name
        AND attribute_application_id = G_APPLICATION_ID;

Line: 475

SELECT  count(distinct dependent_attribute_id)
FROM    aso_dependency_mappings
WHERE   database_object_name = p_database_object_name;

Line: 507

    SELECT  DISTINCT a.trigger_attribute_id,b.attribute_code
    FROM    ASO_DEPENDENCY_MAPPINGS a,oe_ak_obj_attr_ext b
    WHERE   a.trigger_attribute_id = b.attribute_id
            AND a.database_object_name = p_database_object_name;

Line: 513

    SELECT  a.dependent_attribute_id,b.attribute_code
    FROM    ASO_DEPENDENCY_MAPPINGS a,oe_ak_obj_attr_ext b
    WHERE   a.dependent_attribute_id = b.attribute_id
    AND     a.trigger_attribute_id = lc_trigger_attribute_id
    AND     a.enabled_flag = 'Y';

Line: 602

  p_last_update_date_name IN  VARCHAR2)
IS
  l_attribute_code          VARCHAR2(30);

Line: 624

    SELECT  DISTINCT a.attribute_code, a.attribute_id, c.column_name
    FROM    oe_ak_obj_attr_ext a, ASO_DEPENDENCY_MAPPINGS b, ak_object_attributes c
    WHERE   b.TRIGGER_ATTRIBUTE_ID = a.attribute_id
            AND a.attribute_application_id = G_APPLICATION_ID
            AND a.database_object_name = p_database_object_name
            AND b.enabled_flag = 'Y'
            AND a.database_object_name = c.database_object_name
            AND a.attribute_code = c.attribute_code
            AND a.attribute_application_id = c.attribute_application_id;

Line: 635

    SELECT  DISTINCT a.attribute_code, a.attribute_id, c.column_name
    FROM    oe_ak_obj_attr_ext a, ASO_DEPENDENCY_MAPPINGS b, ak_object_attributes c
    WHERE   b.TRIGGER_ATTRIBUTE_ID = a.attribute_id
            AND a.attribute_application_id = G_APPLICATION_ID
            AND a.database_object_name = p_database_object_name
            AND a.database_object_name = c.database_object_name
            AND a.attribute_code = c.attribute_code
            AND a.attribute_application_id = c.attribute_application_id
    ORDER BY  a.attribute_code;

Line: 646

    SELECT  DECODE(data_type, 'NUMBER', 'FND_API.G_MISS_NUM',
              'VARCHAR2', 'FND_API.G_MISS_CHAR',
              'DATE', 'FND_API.G_MISS_DATE',
              'FND_API.G_MISS_CHAR')
    FROM    ak_attributes
    WHERE   attribute_code = lc_attribute_code
            AND attribute_application_id = G_APPLICATION_ID;

Line: 655

    SELECT  attribute_code
    FROM    oe_ak_obj_attr_ext
    WHERE   attribute_id = lc_attribute_id;

Line: 660

    SELECT  column_name
    FROM    ak_object_attributes
    WHERE   database_object_name = p_database_object_name
            AND attribute_code = lc_attribute_code;

Line: 666

    SELECT  a.attribute_code, a.attribute_id, b.column_name,
            DECODE(data_type, 'NUMBER', 'FND_API.G_MISS_NUM',
              'VARCHAR2', 'FND_API.G_MISS_CHAR',
              'DATE', 'FND_API.G_MISS_DATE',
              'FND_API.G_MISS_CHAR') miss_str
    FROM    oe_ak_obj_attr_ext a, ak_object_attributes b, ak_attributes c
    WHERE   a.attribute_application_id = G_APPLICATION_ID
            AND a.database_object_name = p_database_object_name
            AND a.database_object_name = b.database_object_name
            AND a.attribute_application_id = b.attribute_application_id
            AND a.attribute_code = b.attribute_code
            AND b.attribute_code = c.attribute_code
            and b.attribute_application_id = b.attribute_application_id
    ORDER BY ATTRIBUTE_ID;

Line: 682

    SELECT  entity_code
    FROM    oe_ak_objects_ext
    WHERE   database_object_name = p_database_object_name;

Line: 690

  PUT_LINE('p_last_update_date_name: ' || p_last_update_date_name);

Line: 822

  Text('  SELECT   attribute_code', 1);

Line: 830

  Text('  SELECT    ', 1);

Line: 948

  Text('  IF (p_control_record.last_update_date is NULL OR', 1);

Line: 949

  Text('        p_control_record.last_update_date = FND_API.G_MISS_Date ) ', 1);

Line: 953

  Text('	      FND_MESSAGE.Set_Token(''COLUMN'', ''Last_Update_Date'', FALSE);', 1);

Line: 958

  Text('  IF (p_control_record.last_update_date <> '||lv_ak_var_name||'.'||p_last_update_date_name||')', 1);

Line: 1097

    SELECT  attribute_id
      FROM  oe_ak_obj_attr_ext
     WHERE  attribute_code = lc_attribute_code
            AND database_object_name = p_database_object_name
            AND attribute_application_id = G_APPLICATION_ID;