708:
709: -- Get category Id from fnd_document_categories.
710: select doc_category_usage_id
711: INTO l_doc_category_usage_id
712: from fnd_doc_category_usages
713: WHERE category_id = p_category_id
714: and attachment_function_id=p_attachment_function_id;
715:
716: p_category_usage_exists:=1;
718: EXCEPTION
719: WHEN NO_DATA_FOUND THEN
720:
721: -- Get category id from a sequence.
722: select fnd_doc_category_usages_s.nextval
723: into l_doc_category_usage_id
724: from dual;
725:
726: INSERT INTO FND_DOC_CATEGORY_USAGES
722: select fnd_doc_category_usages_s.nextval
723: into l_doc_category_usage_id
724: from dual;
725:
726: INSERT INTO FND_DOC_CATEGORY_USAGES
727: (DOC_CATEGORY_USAGE_ID,
728: CATEGORY_ID,
729: ATTACHMENT_FUNCTION_ID,
730: ENABLED_FLAG,