DBA Data[Home] [Help]

APPS.OTA_TBD_API dependencies on OTA_CATEGORY_USAGES

Line 872: -- OTA_CATEGORY_USAGES row of TYPE 'P'(ackage).

868: -- -----------------------------< CHECK_CATEGORY >-----------------------------
869: -- ----------------------------------------------------------------------------
870: --
871: -- The category must be in the domain 'CATEGORY' and have an
872: -- OTA_CATEGORY_USAGES row of TYPE 'P'(ackage).
873: --
874: procedure CHECK_CATEGORY (
875: P_BUSINESS_GROUP_ID in number,
876: P_CATEGORY in varchar2

Line 886: from OTA_CATEGORY_USAGES TCU

882: W_VALID boolean;
883: --
884: cursor C1 is
885: select 1
886: from OTA_CATEGORY_USAGES TCU
887: where TCU.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
888: and TCU.CATEGORY_usage_id = P_CATEGORY
889: and TCU.TYPE = 'D';
890: --