DBA Data[Home] [Help]

APPS.OKC_ARTWF_PVT dependencies on WF_ITEMS

Line 110: ikey wf_items.item_key%type,

106: article_version_id okc_article_versions.article_version_id%type,
107: article_status okc_article_versions.article_status%type,
108: adoption_type okc_article_versions.adoption_type%type,
109: global_yn okc_article_versions.global_yn%type,
110: ikey wf_items.item_key%type,
111: ukey wf_items.user_key%type,
112: ovn number,
113: article_title okc_articles_all.article_title%type,
114: article_version_number okc_article_versions.article_version_number%type

Line 111: ukey wf_items.user_key%type,

107: article_status okc_article_versions.article_status%type,
108: adoption_type okc_article_versions.adoption_type%type,
109: global_yn okc_article_versions.global_yn%type,
110: ikey wf_items.item_key%type,
111: ukey wf_items.user_key%type,
112: ovn number,
113: article_title okc_articles_all.article_title%type,
114: article_version_number okc_article_versions.article_version_number%type
115: );

Line 447: select 'Y' into result FROM wf_items_v

443: function ikey_exists(p_ikey in varchar2) return boolean
444: as
445: result varchar2(1);
446: begin
447: select 'Y' into result FROM wf_items_v
448: where item_type = 'OKCARTAP'
449: and item_key = p_ikey;
450: return true; -- found
451: exception