APPS.OKC_ARTWF_PVT dependencies on OKC_ARTICLE_ADOPTIONS

Line 61: okc_article_adoptions arta

57: artv.article_version_number
58: from
59: okc_articles_all art,
60: okc_article_versions artv,
61: okc_article_adoptions arta
62: where art.article_id = artv.article_id
63: and art.standard_yn = 'Y'
64: and artv.global_yn = 'Y'
65: and arta.adoption_type = 'AVAILABLE'

Line 75: from okc_article_adoptions

71: and sysdate <= nvl(artv.end_date,sysdate+1)
72: and not exists
73: (
74: select 1
75: from okc_article_adoptions
76: where global_article_version_id in
77: (select article_version_id
78: from okc_article_versions
79: where article_id = art.article_id)

Line 84: from okc_article_adoptions

80: and local_org_id = arta.local_org_id
81: and adoption_type = 'LOCALIZED'
82: union
83: select 1
84: from okc_article_adoptions
85: where global_article_version_id in
86: (select article_version_id
87: from okc_article_versions
88: where article_id = art.article_id)

Line 545: update okc_article_adoptions

541: if ca%notfound then raise e_check_2;
542: else write_ptr := write_ptr+1;
543: end if;
544: /*
545: update okc_article_adoptions
546: set
547: adoption_type = 'ADOPTED',
548: adoption_status = 'PENDING_APPROVAL',
549: object_version_number = c_tab(write_ptr).ovn,

Line 716: okc_article_adoptions arta,

712: hr.organization_id,
713: decode(p_art_intent, 'S', org_information3, 'B', org_information7,
714: 'SYSADMIN') notified
715: from
716: okc_article_adoptions arta,
717: hr_organization_information hri,
718: hr_organization_units hr
719: where
720: global_article_version_id = p_artv_id

Line 803: operation okc_article_adoptions.adoption_type%type;

799: actid in number,
800: funcmode in varchar2,
801: resultout out nocopy varchar2)
802: is
803: operation okc_article_adoptions.adoption_type%type;
804: organization hr_organization_units_v.organization_id%type;
805: notified hr_organization_information.org_information3%type;
806: counter number;
807:

Line 963: okc_article_adoptions arta,

959: artv.end_date
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

Line 1162: adoption_type okc_article_adoptions.adoption_type%type;

1158: actid in number,
1159: command in varchar2,
1160: resultout in out nocopy varchar2)
1161: is
1162: adoption_type okc_article_adoptions.adoption_type%type;
1163: global_yn okc_article_versions.global_yn%type;
1164: user_id number;
1165: resp_id number;
1166: resp_appl_id number;

Line 1396: okc_article_adoptions arta

1392: select 'Y'
1393: from
1394: okc_articles_all art,
1395: okc_article_versions artv,
1396: okc_article_adoptions arta
1397: where art.standard_yn = 'Y'
1398: and artv.global_yn = 'Y'
1399: and art.article_id = artv.article_id
1400: and artv.article_version_id = arta.global_article_version_id

Line 1440: okc_article_adoptions arta

1436: 'PENDING_APPROVAL', 'PENDING_APPROVAL' ) ) article_status
1437: from
1438: okc_articles_all art,
1439: okc_article_versions artv,
1440: okc_article_adoptions arta
1441: where art.standard_yn = 'Y'
1442: and artv.global_yn = 'Y'
1443: and art.article_id = artv.article_id
1444: and artv.article_version_id = arta.global_article_version_id

Line 1484: okc_article_adoptions arta

1480: 'EXPIRED', 'ON_HOLD', 'ON_HOLD', 'PENDING_APPROVAL', 'PENDING_APPROVAL' ) ) article_status
1481: from
1482: okc_articles_all art,
1483: okc_article_versions artv,
1484: okc_article_adoptions arta
1485: where art.standard_yn = 'Y'
1486: and artv.global_yn = 'Y'
1487: and art.article_id = artv.article_id
1488: and artv.article_version_id = arta.global_article_version_id

Line 2055: from okc_article_adoptions

2051: select article_text into text
2052: from okc_article_versions
2053: where article_version_id = (
2054: select global_article_version_id
2055: from okc_article_adoptions
2056: where local_org_id = p_org_id
2057: and local_article_version_id = p_article_version_id
2058: );
2059: return text;

Line 2087: from okc_article_adoptions

2083: yn varchar2(1);
2084: begin
2085: yn := 'N';
2086: select 'Y' into yn
2087: from okc_article_adoptions
2088: where local_org_id = p_org_id
2089: and local_article_version_id = p_article_version_id;
2090: return yn;
2091: exception when others then

Line 2102: from okc_article_adoptions

2098: id okc_article_versions.article_version_id%type;
2099: begin
2100: id := null;
2101: select global_article_version_id into id
2102: from okc_article_adoptions
2103: where local_org_id = p_org_id
2104: and local_article_version_id = p_article_version_id;
2105: return id;
2106: exception when others then