[Home] [Help]
63: p_pass IN NUMBER := 1
64: ) is
65: cursor l_check_fnd_category_name_csr (p_category_id in number) is
66: select name
67: from fnd_document_categories
68: where category_id = p_category_id;
69: cursor l_check_fnd_category_id_csr (p_category_name in varchar2) is
70: select category_id
71: from fnd_document_categories
67: from fnd_document_categories
68: where category_id = p_category_id;
69: cursor l_check_fnd_category_id_csr (p_category_name in varchar2) is
70: select category_id
71: from fnd_document_categories
72: where name =p_category_name;
73: cursor l_get_region_item_csr (region_appl_id_param number,
74: region_code_param varchar2) is
75: select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
1268: --
1269: elsif (l_state = 200) then
1270: if (l_token is not null) then
1271: l_category_usage_rec.category_id := to_number(l_token);
1272: -- select name into l_category_usage_rec.category_name from fnd_document_categories where category_id = l_category_usage_rec.category_id;
1273: l_value_count := null;
1274: l_state := 230;
1275: else
1276: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5705: and attribute_code = param_attr_code;
5706:
5707: cursor l_check_category_csr (param_category_name in varchar2) is
5708: select 1
5709: from fnd_document_categories_vl
5710: where name = param_category_name;
5711:
5712: l_api_version_number CONSTANT number := 1.0;
5713: l_api_name CONSTANT varchar2(30) := 'validate_category_usage';