APPS.OKC_CDRL_DT_PKG SQL Statements

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

Line: 59

    SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
          AG.ATTR_GROUP_ID ATTR_GROUP_ID,
          AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
          AG.MULTI_ROW MULTI_ROW
    FROM EGO_FND_DSC_FLX_CTX_EXT AG,
         okc_uda_deliverable_usages usg
    WHERE usg.uda_template_id = p_uda_template_id
    and usg.attr_group_id = ag.attr_group_id;

Line: 69

    SELECT   EFDFCE.ATTR_ID                ,
    EFDFCE.APPLICATION_COLUMN_NAME      ,
    FCU.END_USER_COLUMN_NAME,
    fcu.flex_value_set_id,
    EFDFCE.data_type,
    EFDFCE.descriptive_flexfield_name attr_group_type
    FROM
      EGO_FND_DF_COL_USGS_EXT EFDFCE,
      FND_DESCR_FLEX_COLUMN_USAGES FCU
    WHERE EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEXFLD_NAME
    AND EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE  = P_ATTR_GROUP
    AND FCU.DESCRIPTIVE_FLEX_CONTEXT_CODE = EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE
    AND FCU.DESCRIPTIVE_FLEXFIELD_NAME = EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME
    AND FCU.APPLICATION_COLUMN_NAME = EFDFCE.APPLICATION_COLUMN_NAME
    AND FCU.DISPLAY_FLAG <> 'H';

Line: 97

        L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
                 || '", XMLAgg(XMLForest(' ;

Line: 100

        L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '", XMLAgg(XMLForest(';

Line: 104

        L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
                  || '", XMLForest(' ;

Line: 107

        L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '", XMLForest(';

Line: 142

  l_op := ' select XMLConcat(' || l_sql || ') from dual';

Line: 151

	select attr_name, database_column
	from ego_attrs_v
	where attr_group_name = 'CDRL_DIST_ADDR';

Line: 156

	select extension_id , rownum num
	from okc_deliverables_ext_b where attr_group_id in (
	select  attr_group_id from EGO_FND_DSC_FLX_CTX_EXT
	where descriptive_flexfield_name = 'OKC_DELIVERABLES_EXT_ATTRS'
	and descriptive_flex_context_code = 'CDRL_DIST_ADDR')
	and deliverable_id = p_delId
	and rownum < 39;

Line: 178

  	   l_sql := 'select XMLconcat( ' ;

Line: 183

	    		l_sql := l_sql || '(select XMLConcat(';

Line: 185

	    		l_sql := l_sql || ', (select XMLConcat(';

Line: 223

	SELECT attr.database_column , grp.attr_group_id, attr.data_type_code, attr.attr_id
	INTO l_db_col, l_attr_group_id, l_data_type, l_attr_id
	FROM ego_attrs_v attr, ego_attr_groups_v grp
	WHERE attr.attr_group_name = p_attr_group
	AND attr.attr_group_type     = 'OKC_DELIVERABLES_EXT_ATTRS'
	AND attr.attr_name           = p_attr_name
	AND attr.attr_group_type     = grp.attr_group_type
	AND attr.attr_group_name     = grp.attr_group_name;

Line: 232

	l_sql := 'select ' || l_db_col
		|| ' from okc_deliverables_ext_b where deliverable_id = :1 and attr_group_id = :2';