APPS.OKC_ARTWF_PVT dependencies on OKC_LOOKUPS_V

Line 931: okc_lookups_v tm,

927: artv.end_date
928: from
929: okc_articles_all art,
930: okc_article_versions artv,
931: okc_lookups_v tm,
932: okc_lookups_v im,
933: okc_lookups_v gm,
934: okc_lookups_v pm
935: where art.standard_yn = 'Y'

Line 932: okc_lookups_v im,

928: from
929: okc_articles_all art,
930: okc_article_versions artv,
931: okc_lookups_v tm,
932: okc_lookups_v im,
933: okc_lookups_v gm,
934: okc_lookups_v pm
935: where art.standard_yn = 'Y'
936: and art.org_id = cp_org_id

Line 933: okc_lookups_v gm,

929: okc_articles_all art,
930: okc_article_versions artv,
931: okc_lookups_v tm,
932: okc_lookups_v im,
933: okc_lookups_v gm,
934: okc_lookups_v pm
935: where art.standard_yn = 'Y'
936: and art.org_id = cp_org_id
937: and article_version_id = cp_art_ver_id

Line 934: okc_lookups_v pm

930: okc_article_versions artv,
931: okc_lookups_v tm,
932: okc_lookups_v im,
933: okc_lookups_v gm,
934: okc_lookups_v pm
935: where art.standard_yn = 'Y'
936: and art.org_id = cp_org_id
937: and article_version_id = cp_art_ver_id
938: and art.article_id = artv.article_id

Line 964: okc_lookups_v tm,

960: from
961: okc_articles_all art,
962: okc_article_versions artv,
963: okc_article_adoptions arta,
964: okc_lookups_v tm,
965: okc_lookups_v im,
966: okc_lookups_v gm,
967: okc_lookups_v pm
968: where art.standard_yn = 'Y'

Line 965: okc_lookups_v im,

961: okc_articles_all art,
962: okc_article_versions artv,
963: okc_article_adoptions arta,
964: okc_lookups_v tm,
965: okc_lookups_v im,
966: okc_lookups_v gm,
967: okc_lookups_v pm
968: where art.standard_yn = 'Y'
969: and artv.global_yn = 'Y'

Line 966: okc_lookups_v gm,

962: okc_article_versions artv,
963: okc_article_adoptions arta,
964: okc_lookups_v tm,
965: okc_lookups_v im,
966: okc_lookups_v gm,
967: okc_lookups_v pm
968: where art.standard_yn = 'Y'
969: and artv.global_yn = 'Y'
970: and arta.local_org_id = cp_org_id

Line 967: okc_lookups_v pm

963: okc_article_adoptions arta,
964: okc_lookups_v tm,
965: okc_lookups_v im,
966: okc_lookups_v gm,
967: okc_lookups_v pm
968: where art.standard_yn = 'Y'
969: and artv.global_yn = 'Y'
970: and arta.local_org_id = cp_org_id
971: and article_version_id = cp_art_ver_id

Line 1067: select meaning from okc_lookups_v

1063:
1064: function get_pending_meaning return varchar2
1065: is
1066: cursor c_pmeaning is
1067: select meaning from okc_lookups_v
1068: where lookup_type = 'OKC_ARTICLE_STATUS'
1069: and lookup_code = 'PENDING_APPROVAL';
1070: meaning okc_lookups_v.meaning%type;
1071: begin

Line 1070: meaning okc_lookups_v.meaning%type;

1066: cursor c_pmeaning is
1067: select meaning from okc_lookups_v
1068: where lookup_type = 'OKC_ARTICLE_STATUS'
1069: and lookup_code = 'PENDING_APPROVAL';
1070: meaning okc_lookups_v.meaning%type;
1071: begin
1072: open c_pmeaning;
1073: fetch c_pmeaning into meaning;
1074: close c_pmeaning;

Line 1085: select meaning from okc_lookups_v

1081:
1082: function get_adopted_meaning return varchar2
1083: is
1084: cursor c_ameaning is
1085: select meaning from okc_lookups_v
1086: where lookup_type = 'OKC_ARTICLE_ADOPTION_TYPE'
1087: and lookup_code = 'ADOPTED';
1088: meaning okc_lookups_v.meaning%type;
1089: begin

Line 1088: meaning okc_lookups_v.meaning%type;

1084: cursor c_ameaning is
1085: select meaning from okc_lookups_v
1086: where lookup_type = 'OKC_ARTICLE_ADOPTION_TYPE'
1087: and lookup_code = 'ADOPTED';
1088: meaning okc_lookups_v.meaning%type;
1089: begin
1090: open c_ameaning;
1091: fetch c_ameaning into meaning;
1092: close c_ameaning;

Line 1997: intent_meaning okc_lookups_v.meaning%type;

1993: end;
1994:
1995: function get_terms_intent_meaning(p_template_id in number) return varchar2
1996: is
1997: intent_meaning okc_lookups_v.meaning%type;
1998: begin
1999: select meaning into intent_meaning
2000: from okc_lookups_v
2001: where lookup_type = 'OKC_TERMS_INTENT'

Line 2000: from okc_lookups_v

1996: is
1997: intent_meaning okc_lookups_v.meaning%type;
1998: begin
1999: select meaning into intent_meaning
2000: from okc_lookups_v
2001: where lookup_type = 'OKC_TERMS_INTENT'
2002: and lookup_code = (
2003: select intent
2004: from okc_terms_templates_all