DBA Data[Home] [Help]

APPS.ICX_CAT SQL Statements

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

Line: 46

select category_set_id,
       category_set_name
from   icx_category_set_lov;
Line: 51

select lookup_code,
       meaning
from   fnd_lookups
where  lookup_type = 'ICX_RELATIONS'
and    enabled_flag = 'Y';
Line: 93

		parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
		parent.tail.document.Tail.p_category_id.value = document.Category.ICX_CATEGORY_ID.value
		parent.tail.document.Tail.p_category_name.value = document.Category.ICX_CATEGORY.value
		parent.tail.document.Tail.submit()
	    }');
Line: 104

                parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
                parent.tail.document.Tail.p_category_id.value = ""
                parent.tail.document.Tail.p_category_name.value = ""
                parent.tail.document.Tail.submit()
	    }');
Line: 112

		parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
		parent.tail.document.Tail.p_category_id.value = ""
		parent.tail.document.Tail.p_category_name.value = document.Category.ICX_CATEGORY.value
		parent.tail.document.Tail.submit()
	    }');
Line: 119

		var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
	        LOV(''178'',''ICX_CATEGORY'',''601'',''ICX_RELATED_CATEGORIES_R'',''Category'',''header'','''',l_where)
	    }');
Line: 124

		parent.tail.document.Tail.p_category_set_id.value = document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
		parent.tail.document.Tail.p_category_id.value = cat_id
		parent.tail.document.Tail.p_category_name.value = cat_name
		parent.tail.document.Tail.submit()
	    }');
Line: 133

                  var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value
	          LOV(''178'',''ICX_RELATED_CATEGORY'',''601'',''ICX_RELATED_CATEGORIES_R'',''Category'',''header'','''',l_where)
		}
	    }');
Line: 139

	    -- var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value + "^@~^and^@~^CONCATENATED_SEGMENTS<>''" + document.Category.ICX_CATEGORY.value + "''"


	    FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL');
Line: 145

		  if (document.Category.ICX_RELATION.options[document.Category.ICX_RELATION.selectedIndex].value != "TOP") {');
Line: 164

    htp.formOpen(l_agent||'/icx_cat.cat_insert','POST','','','NAME="Category"');
Line: 177

      htp.p(''||htf.formSelectOpen('ICX_CATEGORY_SET_ID','','','onchange="set_changed()"'));
Line: 183

	        htp.formSelectOption(temp_cat_set,'SELECTED','VALUE="'||temp_cat_set_id||'"');
Line: 185

	        htp.formSelectOption(temp_cat_set,'','VALUE="'||temp_cat_set_id||'"');
Line: 189

      htp.p(htf.formSelectClose||'');
Line: 202

      htp.p(''||htf.formSelectOpen('ICX_RELATION'));
Line: 207

	    htp.formSelectOption(temp_relation,'','VALUE="'||temp_relation_code||'"');
Line: 210

      htp.p(htf.formSelectClose||'');
Line: 252

    select substr(temp_text,12,512) into err_mesg from dual;
Line: 309

	    -- javascript function to confirm delete of relationship
 	    FND_MESSAGE.Set_name('ICX','ICX_DELETE');
Line: 311

            htp.p('function delete_relation(cat, related_cat, cat_set_id, cat_id, related_cat_id) {
              if (confirm("'||icx_util.replace_quotes(FND_MESSAGE.Get)||': " + cat + " - " + related_cat)) {
                  open('''||l_agent||'/ICX_CAT.cat_delete?icx_category_set_id='' + cat_set_id + ''&icx_category_id='' + cat_id + ''&icx_related_category_id='' + related_cat_id,''tail'')
              }
            }');
Line: 334

	select count(*) into l_count
   	from   mtl_categories_kfv mck,
               mtl_category_sets mcs
	where  (mcs.validate_flag = 'Y' and
	        mck.category_id in (
          	    select mcsv.category_id
                    from   mtl_category_set_valid_cats mcsv
            	    where  mcsv.category_set_id = p_category_set_id) and
		mck.concatenated_segments = p_category_name)
	or     (mcs.validate_flag <> 'Y' and
	        mcs.structure_id = mck.structure_id and
	        mck.concatenated_segments = p_category_name);
Line: 370

        select QUERY_SET into l_query_size
        from ICX_PARAMETERS;
Line: 498

            htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_cat)||''','''||icx_util.replace_quotes(temp_related_cat)||''','''||temp_cat_set_id||''','''||temp_cat_id||''','''||temp_related_cat_id||
''')',htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'','BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))||
''';return true"'));
Line: 554

    select substr(temp_text,12,512) into err_mesg from dual;
Line: 562

procedure cat_insert(icx_category_set_id in varchar2 default null,
		     icx_category_id in varchar2 default null,
		     icx_category in varchar2 default null,
		     icx_relation in varchar2 default null,
		     icx_related_category_id in varchar2 default null,
		     icx_related_category in varchar2 default null) is

l_return_status  varchar2(1) := 'S';
Line: 582

        ICX_Related_Categories_PUB.Insert_Relation
        ( p_api_version_number 	=> 1.0				,
          p_init_msg_list	=> FND_API.G_TRUE		,
          p_simulate		=> FND_API.G_FALSE 		,
          p_commit		=> FND_API.G_TRUE		,
          p_validation_level	=> FND_API.G_VALID_LEVEL_FULL	,
          p_return_status	=> l_return_status		,
          p_msg_count		=> l_msg_count			,
          p_msg_data		=> l_msg_data			,
          p_category_set_id	=> icx_category_set_id		,
          p_category_id		=> icx_category_id		,
          p_category		=> icx_category			,
          p_related_category_id	=> icx_category_id		,
          p_related_category	=> icx_category			,
          p_relationship_type	=> 'TOP'			,
          p_created_by		=> l_user_id
        );
Line: 605

        ICX_Related_Categories_PUB.Insert_Relation
        ( p_api_version_number 	=> 1.0				,
          p_init_msg_list	=> FND_API.G_FALSE		,
          p_simulate		=> FND_API.G_FALSE 		,
          p_commit		=> FND_API.G_TRUE		,
          p_validation_level	=> FND_API.G_VALID_LEVEL_FULL	,
          p_return_status	=> l_return_status		,
          p_msg_count		=> l_msg_count			,
          p_msg_data		=> l_msg_data			,
          p_category_set_id	=> icx_category_set_id		,
          p_category_id		=> icx_category_id		,
          p_category		=> icx_category			,
          p_related_category_id	=> icx_related_category_id	,
          p_related_category	=> icx_related_category		,
          p_relationship_type	=> 'CHILD'			,
          p_created_by		=> l_user_id
        );
Line: 641

end cat_insert;
Line: 646

procedure cat_delete(icx_category_set_id in varchar2 default null,
		     icx_category_id in varchar2 default null,
		     icx_related_category_id in varchar2 default null) is

cursor category_name is
    select CONCATENATED_SEGMENTS
    from icx_category_lov
    where category_id = icx_category_id;
Line: 669

        ICX_Related_Categories_PUB.Delete_Relation
        ( p_api_version_number 	=> 1.0				,
          p_init_msg_list	=> FND_API.G_TRUE		,
          p_simulate		=> FND_API.G_FALSE 		,
          p_commit		=> FND_API.G_TRUE		,
          p_validation_level	=> FND_API.G_VALID_LEVEL_FULL	,
          p_return_status	=> l_return_status		,
          p_msg_count		=> l_msg_count			,
          p_msg_data		=> l_msg_data			,
          p_category_set_id	=> icx_category_set_id		,
          p_category_id		=> icx_category_id		,
          p_related_category_id	=> icx_related_category_id
        );
Line: 702

end cat_delete;