APPS.OE_DEFAULTING_FWK_PUB SQL Statements

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

Line: 163

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

Line: 389

	SELECT substr(rtrim(APPLICATION_SHORT_NAME),1,3)
	FROM fnd_application
	WHERE application_id = p_application_id;

Line: 395

	SELECT ENTITY_CODE
	FROM OE_DEF_AK_OBJ_EXT_V
	WHERE database_object_name = p_database_object_name
	AND application_id = p_application_id;

Line: 406

	SELECT distinct fk.unique_key_name
               ,uk.database_object_name uk_database_object_name
               ,fk.foreign_key_name
	       ,obj.entity_code uk_entity_code
               , obj.defaulting_enabled_flag uk_obj_defaulting_enabled
	FROM AK_FOREIGN_KEYS fk, AK_UNIQUE_KEYS uk, OE_AK_OBJECTS_EXT obj
	WHERE fk.database_object_name= p_database_object_name
	  AND fk.application_id= p_application_id
          AND fk.unique_key_name = uk.unique_key_name
          AND fk.application_id = uk.application_id
	  AND uk.database_object_name = obj.database_object_name
          AND obj.application_id = p_application_id;

Line: 426

	SELECT ak.column_name,
		oe.attribute_code,
		ak.data_type,
		ak.defaulting_api_pkg,
		ak.defaulting_api_proc,
		ak.validation_api_pkg,
		ak.validation_api_proc,
		oe.dependent_api_pkg,
		oe.dependent_api_proc,
		oe.security_api_pkg,
		oe.security_api_proc,
	        oe.defaulting_condn_ref_flag,
		oe.defaulting_enabled_flag
	FROM OE_AK_OBJ_ATTR_EXT OE
		, AK_OBJECT_ATTRIBUTES_VL ak
	WHERE oe.database_object_name  = p_database_object_name
	AND oe.attribute_application_id = p_application_id
        AND ak.database_object_name = oe.database_object_name
	AND ak.attribute_code = oe.attribute_code
	AND ak.attribute_application_id = oe.attribute_application_id
	ORDER BY oe.defaulting_sequence, ak.attribute_label_long;

Line: 455

	SELECT NVL(status,'INVALID')
	--FROM dba_objects
	FROM user_objects
	WHERE object_name = UPPER(cp_pkg_name);

Line: 539

       select entity_id into l_entity_id
       from oe_ak_objects_ext
       where DATABASE_OBJECT_NAME =l_related_database_object_name;

Line: 609

        select entity_id into l_entity_id
        from oe_ak_objects_ext
        where DATABASE_OBJECT_NAME =l_related_database_object_name;

Line: 661

        select entity_id into l_entity_id
        from oe_ak_objects_ext
        where DATABASE_OBJECT_NAME =p_database_object_name;

Line: 772

        select entity_id into l_entity_id
        from oe_ak_objects_ext
        where DATABASE_OBJECT_NAME =p_database_object_name;

Line: 976

        '-- For UPDATE operations, check security if new defaulted value is not equal to old value',1);

Line: 977

        Text ('IF g_record.operation = OE_GLOBALS.G_OPR_UPDATE THEN',1);

Line: 988

        Text('OE_GLOBALS.G_ATTR_UPDATED_BY_DEF := ''Y'';',3);

Line: 1206

	SELECT DEFAULTING_API_PKG,
	DEFAULTING_API_PROC,NVL(DATA_TYPE,'CHAR'),
	COLUMN_NAME
	FROM OE_DEF_AK_ATTR_EXT_V
	WHERE DATABASE_OBJECT_NAME = p_database_object_name
	AND attribute_application_id = p_application_id
	AND attribute_code = p_attribute_code;

Line: 1214

	SELECT substr(rtrim(APPLICATION_SHORT_NAME),1,3)
	FROM fnd_application
	WHERE application_id = p_application_id;

Line: 1219

	SELECT entity_id FROM OE_DEF_AK_OBJ_EXT_V
	WHERE entity_code = p_entity_code;

Line: 1247

        SELECT condition_id, attr_def_condition_id
        FROM OE_DEF_ATTR_CONDNS
        WHERE DATABASE_OBJECT_NAME = p_database_object_name
          AND ATTRIBUTE_CODE = p_attribute_code
          AND ENABLED_FLAG = 'Y'
        ORDER BY PRECEDENCE;

Line: 1255

     SELECT group_number, attribute_code, value_op, value_string
        FROM OE_DEF_CONDN_ELEMS
        WHERE CONDITION_ID = l_condition_id
        ORDER BY GROUP_NUMBER;

Line: 1261

     SELECT attr_def_rule_id
                  ,src_type
                  ,src_api_pkg
                  ,src_api_fn
                  ,src_profile_option
                  ,src_constant_value
                  ,src_system_variable_expr
                  ,src_database_object_name
                  ,src_attribute_code
     FROM OE_DEF_ATTR_DEF_RULES
        WHERE ATTR_DEF_CONDITION_ID = l_attr_def_condn_id
        ORDER BY SEQUENCE_NO;

Line: 1275

        SELECT ua.column_name, fa.column_name
        FROM AK_UNIQUE_KEYS uk, AK_UNIQUE_KEY_COLUMNS uc
            , AK_FOREIGN_KEYS fk,  AK_FOREIGN_KEY_COLUMNS fc
            , AK_OBJECT_ATTRIBUTES ua, AK_OBJECT_ATTRIBUTES fa
     WHERE uk.database_object_name = l_src_database_object_name
          AND uk.unique_key_name = uc.unique_key_name
          AND fk.database_object_name = p_database_object_name
          AND fk.unique_key_name = uk.unique_key_name
          AND fc.foreign_key_name = fk.foreign_key_name
          AND uc.unique_key_sequence = fc.foreign_key_sequence
          AND ua.database_object_name = l_src_database_object_name
          AND ua.attribute_code = uc.attribute_code
          AND fa.database_object_name = p_database_object_name
          AND fa.attribute_code = fc.attribute_code
        ORDER BY uc.unique_key_sequence;

Line: 1292

        SELECT ua.column_name
        FROM AK_UNIQUE_KEYS uk,
             AK_UNIQUE_KEY_COLUMNS uc,
             AK_OBJECT_ATTRIBUTES ua
        WHERE uk.database_object_name = p_database_object_name
          AND ua.database_object_name = p_database_object_name
          AND uk.unique_key_name = uc.unique_key_name
          AND uc.attribute_code = ua.attribute_code
          AND uc.attribute_application_id = ua.attribute_application_id
          AND ua.database_object_name = p_database_object_name
        ORDER BY uc.unique_key_sequence;

Line: 1416

   select ada.data_type
     into l_src_data_type
     from OE_DEF_AK_ATTR_EXT_V ada
    where ada.DATABASE_OBJECT_NAME = p_database_object_name
      and ada.ATTRIBUTE_APPLICATION_ID = p_application_id
      and ada.ATTRIBUTE_CODE = l_elem_attribute_code;

Line: 1480

      SELECT upper(entity_code)
      INTO l_related_entity_code
      FROM OE_AK_OBJECTS_EXT
      WHERE DATABASE_OBJECT_NAME = l_src_database_object_name;

Line: 1485

      SELECT column_name
      INTO l_src_column_name
      FROM AK_OBJECT_ATTRIBUTES
      WHERE DATABASE_OBJECT_NAME = l_src_database_object_name
        AND ATTRIBUTE_CODE = l_src_attribute_code;

Line: 1529

      SELECT column_name
      INTO l_src_column_name
      FROM AK_OBJECT_ATTRIBUTES
      WHERE DATABASE_OBJECT_NAME = p_database_object_name
        AND ATTRIBUTE_CODE = l_src_attribute_code;

Line: 1706

	SELECT DEFAULTING_API_PKG,
	DEFAULTING_API_PROC,NVL(DATA_TYPE,'CHAR'),
	COLUMN_NAME
	FROM OE_DEF_AK_ATTR_EXT_V
	WHERE DATABASE_OBJECT_NAME = p_database_object_name
	AND attribute_application_id = p_application_id
	AND attribute_code = p_attribute_code;

Line: 1714

	SELECT substr(rtrim(APPLICATION_SHORT_NAME),1,3)
	FROM fnd_application
	WHERE application_id = p_application_id;

Line: 1719

	SELECT entity_id FROM OE_DEF_AK_OBJ_EXT_V
	WHERE entity_code = p_entity_code;

Line: 2076

UPDATE AK_OBJECT_ATTRIBUTES
SET defaulting_api_pkg= l_package,
defaulting_api_proc = 'Get_Default_Value'
WHERE attribute_code = p_attribute_code
AND database_object_name=p_database_object_name
AND attribute_application_id= p_application_id;

Line: 2171

	SELECT aoj.attribute_code,NVL(aoj.data_type,'VARCHAR2')data_type,
	aoj.column_name
	FROM AK_OBJECT_ATTRIBUTES_VL aoj
	WHERE aoj.database_object_name  = p_database_object_name
	AND aoj.attribute_application_id = p_application_id
        AND aoj.column_name is not null;

Line: 2180

	SELECT unique_key_name
	FROM AK_UNIQUE_KEYS
	WHERE database_object_name=l_database_object_name
	AND application_id=p_application_id
	AND rownum = 1;

Line: 2189

	SELECT attribute_code,column_name,
	unique_key_sequence,data_type
	FROM OE_DEF_AK_UKEY_COLS_V
	WHERE unique_key_name= l_uk_name
	AND database_object_name = l_uk_database_object_name
	ORDER BY unique_key_sequence;

Line: 2199

	SELECT b.attribute_code, b.column_name,
	foreign_key_sequence, b.data_type
	FROM ak_object_attributes_vl b,ak_foreign_key_columns a
	WHERE a.foreign_key_name= l_fk_name
	AND b.database_object_name = l_database_object_name
	AND b.attribute_application_id = a.attribute_application_id
	AND b.attribute_code = a.attribute_code
	ORDER BY foreign_key_sequence;

Line: 2210

	SELECT unique_key_name,uk_database_object_name,foreign_key_name,
	fk_entity_code
	FROM OE_DEF_AK_FKEYS_V
	WHERE fk_database_object_name=l_database_object_name
	AND application_id=p_application_id;

Line: 2218

	SELECT unique_key_name,uk_database_object_name
	       , foreign_key_name, fk_entity_code
	FROM OE_DEF_AK_FKEYS_V fk
	WHERE fk_database_object_name=l_database_object_name
	AND application_id=p_application_id
	AND exists (SELECT 'Y'
			  FROM ak_object_attributes_vl oa
			  WHERE oa.database_object_name = fk.uk_database_object_name
			  AND oa.data_type = 'DATE'
			  );

Line: 2289

	l_ukey_attr_tbl.DELETE;

Line: 2425

  l_ak_obj_attr_tbl.DELETE;

Line: 2567

    l_ukey_attr_tbl.DELETE;

Line: 2634

  Text ('SELECT * FROM   '||p_database_object_name,1);

Line: 2743

  l_fkey_tbl.DELETE;

Line: 2775

      l_ukey_attr_tbl.DELETE;

Line: 2793

      l_fkey_attr_tbl.DELETE;

Line: 2950

      l_ukey_attr_tbl.DELETE;

Line: 2968

      l_fkey_attr_tbl.DELETE;

Line: 3119

Text ('SELECT condition_id,group_number,attribute_code,',1);

Line: 3208

PUT_LINE( '       Create PROCEDURE Update_Attr_Rules_Cache');

Line: 3210

Text('PROCEDURE Update_Attr_Rules_Cache',0);

Line: 3218

Text('    CURSOR DEFSRC IS SELECT',0);

Line: 3283

Text('		''Update_Attr_Rules_Cache: ''||l_attribute_code',0);

Line: 3287

Text('END Update_Attr_Rules_Cache;',0);

Line: 3314

Text('    SELECT condition_id  ',0);

Line: 3374

Text('    -- insert a new record in the cache with conditions_defined = ''N''',0);

Line: 3390

Text('     Update_Attr_Rules_Cache(l_valid_condn_index_tbl(I));',0);

Line: 3445

	SELECT substr(rtrim(APPLICATION_SHORT_NAME),1,3)
	FROM fnd_application
	WHERE application_id = p_application_id;

Line: 3451

	SELECT oeatt.attribute_code, akatt.column_name
	FROM OE_AK_OBJ_ATTR_EXT oeatt
		, AK_OBJECT_ATTRIBUTES akatt
	WHERE oeatt.database_object_name  = p_database_object_name
	AND oeatt.attribute_application_id=p_application_id
	AND oeatt.attribute_code = akatt.attribute_code
	AND oeatt.database_object_name = akatt.database_object_name
        AND oeatt.attribute_application_id= akatt.attribute_application_id
	ORDER BY akatt.column_name;