DBA Data[Home] [Help]

APPS.GMA_EDITEXT_ATTACH_MIG dependencies on FND_DOC_CATEGORY_USAGES

Line 712: from fnd_doc_category_usages

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;

Line 722: select fnd_doc_category_usages_s.nextval

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

Line 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,