eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_ARTWF_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 24: okc_article_versions artv

20: art.article_title,
21: artv.article_version_number
22: from
23: okc_articles_all art,
24: okc_article_versions artv
25: where art.article_id = artv.article_id
26: and art.standard_yn = 'Y'
27: and artv.article_status in ('DRAFT','REJECTED')
28: and art.org_id = cp_org_id

Line 60: okc_article_versions artv,

56: art.article_title,
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'

Line 78: from okc_article_versions

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)
80: and local_org_id = arta.local_org_id
81: and adoption_type = 'LOCALIZED'
82: union

Line 87: from okc_article_versions

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)
89: and local_org_id = arta.local_org_id
90: and adoption_type = 'ADOPTED'
91: and article_version_number > artv.article_version_number

Line 106: article_version_id okc_article_versions.article_version_id%type,

102:
103: type c_rec_type is record (
104: org_id okc_articles_all.org_id%type,
105: article_id okc_articles_all.article_id%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,

Line 107: article_status okc_article_versions.article_status%type,

103: type c_rec_type is record (
104: org_id okc_articles_all.org_id%type,
105: article_id okc_articles_all.article_id%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,

Line 108: adoption_type okc_article_versions.adoption_type%type,

104: org_id okc_articles_all.org_id%type,
105: article_id okc_articles_all.article_id%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,

Line 109: global_yn okc_article_versions.global_yn%type,

105: article_id okc_articles_all.article_id%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,

Line 114: article_version_number okc_article_versions.article_version_number%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: );
116:
117: type c_tab_type is table of c_rec_type index by binary_integer;
118: c_tab c_tab_type;

Line 261: okc_article_versions artv,

257: substr(nvl(art.article_number,art.article_title),0,240) ukey,
258: artv.object_version_number
259: from
260: okc_articles_all art,
261: okc_article_versions artv,
262: okc_art_interface_all int
263: where art.article_id = artv.article_id
264: and art.standard_yn = 'Y'
265: and artv.article_status in ('PENDING_APPROVAL','APPROVED')

Line 395: from okc_articles_all a, okc_article_versions v

391: is
392: art_intent okc_articles_all.article_intent%type;
393: begin
394: select article_intent into art_intent
395: from okc_articles_all a, okc_article_versions v
396: where a.article_id = v.article_id
397: and v.article_version_id = art_ver_id;
398: return art_intent;
399: exception

Line 463: update okc_article_versions

459: if cv%notfound then raise e_check_1;
460: else write_ptr := write_ptr+1;
461: end if;
462: /*
463: update okc_article_versions
464: set
465: article_status = 'PENDING_APPROVAL',
466: object_version_number = c_tab(write_ptr).ovn,
467: last_update_date = sysdate,

Line 641: x_article_version_id out nocopy okc_article_versions.article_version_id%type,

637:
638: -- get record (p_ptr) from success table
639: procedure get_tab( p_ptr in binary_integer,
640: x_article_id out nocopy okc_articles_all.article_id%type,
641: x_article_version_id out nocopy okc_article_versions.article_version_id%type,
642: x_article_status out nocopy okc_article_versions.article_status%type,
643: x_adoption_type out nocopy okc_article_versions.adoption_type%type,
644: x_global_yn out nocopy okc_article_versions.global_yn%type,
645: x_key out nocopy varchar2)

Line 642: x_article_status out nocopy okc_article_versions.article_status%type,

638: -- get record (p_ptr) from success table
639: procedure get_tab( p_ptr in binary_integer,
640: x_article_id out nocopy okc_articles_all.article_id%type,
641: x_article_version_id out nocopy okc_article_versions.article_version_id%type,
642: x_article_status out nocopy okc_article_versions.article_status%type,
643: x_adoption_type out nocopy okc_article_versions.adoption_type%type,
644: x_global_yn out nocopy okc_article_versions.global_yn%type,
645: x_key out nocopy varchar2)
646: is

Line 643: x_adoption_type out nocopy okc_article_versions.adoption_type%type,

639: procedure get_tab( p_ptr in binary_integer,
640: x_article_id out nocopy okc_articles_all.article_id%type,
641: x_article_version_id out nocopy okc_article_versions.article_version_id%type,
642: x_article_status out nocopy okc_article_versions.article_status%type,
643: x_adoption_type out nocopy okc_article_versions.adoption_type%type,
644: x_global_yn out nocopy okc_article_versions.global_yn%type,
645: x_key out nocopy varchar2)
646: is
647: begin

Line 644: x_global_yn out nocopy okc_article_versions.global_yn%type,

640: x_article_id out nocopy okc_articles_all.article_id%type,
641: x_article_version_id out nocopy okc_article_versions.article_version_id%type,
642: x_article_status out nocopy okc_article_versions.article_status%type,
643: x_adoption_type out nocopy okc_article_versions.adoption_type%type,
644: x_global_yn out nocopy okc_article_versions.global_yn%type,
645: x_key out nocopy varchar2)
646: is
647: begin
648: if write_ptr > 0 then

Line 666: x_article_version_id out nocopy okc_article_versions.article_version_id%type,

662:
663: -- get record (p_ptr) from errors table
664: procedure get_err( p_ptr in binary_integer,
665: x_article_id out nocopy okc_articles_all.article_id%type,
666: x_article_version_id out nocopy okc_article_versions.article_version_id%type,
667: x_article_status out nocopy okc_article_versions.article_status%type,
668: x_adoption_type out nocopy okc_article_versions.adoption_type%type,
669: x_global_yn out nocopy okc_article_versions.global_yn%type,
670: x_key out nocopy varchar2)

Line 667: x_article_status out nocopy okc_article_versions.article_status%type,

663: -- get record (p_ptr) from errors table
664: procedure get_err( p_ptr in binary_integer,
665: x_article_id out nocopy okc_articles_all.article_id%type,
666: x_article_version_id out nocopy okc_article_versions.article_version_id%type,
667: x_article_status out nocopy okc_article_versions.article_status%type,
668: x_adoption_type out nocopy okc_article_versions.adoption_type%type,
669: x_global_yn out nocopy okc_article_versions.global_yn%type,
670: x_key out nocopy varchar2)
671: is

Line 668: x_adoption_type out nocopy okc_article_versions.adoption_type%type,

664: procedure get_err( p_ptr in binary_integer,
665: x_article_id out nocopy okc_articles_all.article_id%type,
666: x_article_version_id out nocopy okc_article_versions.article_version_id%type,
667: x_article_status out nocopy okc_article_versions.article_status%type,
668: x_adoption_type out nocopy okc_article_versions.adoption_type%type,
669: x_global_yn out nocopy okc_article_versions.global_yn%type,
670: x_key out nocopy varchar2)
671: is
672: begin

Line 669: x_global_yn out nocopy okc_article_versions.global_yn%type,

665: x_article_id out nocopy okc_articles_all.article_id%type,
666: x_article_version_id out nocopy okc_article_versions.article_version_id%type,
667: x_article_status out nocopy okc_article_versions.article_status%type,
668: x_adoption_type out nocopy okc_article_versions.adoption_type%type,
669: x_global_yn out nocopy okc_article_versions.global_yn%type,
670: x_key out nocopy varchar2)
671: is
672: begin
673: if error_ptr < 0 then

Line 914: article_version_id okc_article_versions.article_version_id%type;

910: is
911: message_code fnd_new_messages.message_name%type;
912: org_id okc_articles_all.org_id%type;
913: article_id okc_articles_all.article_id%type;
914: article_version_id okc_article_versions.article_version_id%type;
915:
916: cursor c_approve(cp_org_id in number, cp_art_ver_id in number) is
917: select
918: art.article_title,

Line 930: okc_article_versions artv,

926: artv.start_date,
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

Line 962: okc_article_versions artv,

958: artv.start_date,
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,

Line 1163: global_yn okc_article_versions.global_yn%type;

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;
1167: begin

Line 1202: article_version_id okc_article_versions.article_version_id%type;

1198: funcmode in varchar2,
1199: resultout out nocopy varchar2)
1200: is
1201: --pragma autonomous_transaction;
1202: article_version_id okc_article_versions.article_version_id%type;
1203: adoption_flag varchar2(1);
1204: l_return_status varchar2(1);
1205: msg_count number;
1206: msg_data varchar2(250);

Line 1247: article_version_id okc_article_versions.article_version_id%type;

1243: funcmode in varchar2,
1244: resultout out nocopy varchar2)
1245: is
1246: --pragma autonomous_transaction;
1247: article_version_id okc_article_versions.article_version_id%type;
1248: adoption_flag varchar2(1);
1249: l_return_status varchar2(1);
1250: msg_count number;
1251: msg_data varchar2(250);

Line 1386: okc_article_versions artv

1382: from (
1383: select 'Y'
1384: from
1385: okc_articles_all art,
1386: okc_article_versions artv
1387: where art.standard_yn = 'Y'
1388: and art.article_id = artv.article_id
1389: and artv.article_version_id = p_article_version_id
1390: and art.org_id = p_org_id

Line 1395: okc_article_versions artv,

1391: union all
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

Line 1423: okc_article_versions artv

1419: trunc(sysdate))+1, trunc(sysdate)), trunc(sysdate), 'EXPIRED', artv.article_status),
1420: artv.article_status) article_status
1421: from
1422: okc_articles_all art,
1423: okc_article_versions artv
1424: where art.standard_yn = 'Y'
1425: and art.article_id = artv.article_id
1426: and artv.article_version_id = p_article_version_id
1427: and art.org_id = p_org_id

Line 1439: okc_article_versions artv,

1435: artv.article_status) ), 'APPROVED', arta.adoption_status, 'EXPIRED', 'EXPIRED', 'ON_HOLD', 'ON_HOLD',
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

Line 1467: okc_article_versions artv

1463: trunc(sysdate))+1, trunc(sysdate)), trunc(sysdate), 'EXPIRED', artv.article_status),
1464: artv.article_status) article_status
1465: from
1466: okc_articles_all art,
1467: okc_article_versions artv
1468: where art.standard_yn = 'Y'
1469: and art.article_id = artv.article_id
1470: and artv.article_version_id = p_article_version_id
1471: and art.org_id = p_org_id

Line 1483: okc_article_versions artv,

1479: trunc(sysdate), 'EXPIRED', artv.article_status) ), 'APPROVED', arta.adoption_status, 'EXPIRED',
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

Line 1510: okc_article_versions artv

1506: from (
1507: select 'Y'
1508: from
1509: okc_articles_all art,
1510: okc_article_versions artv
1511: where
1512: art.standard_yn = 'Y'
1513: and art.article_id = artv.article_id
1514: and org_id = p_org_id

Line 1535: okc_article_versions artv

1531: trunc(sysdate))+1, trunc(sysdate)), trunc(sysdate), 'EXPIRED', artv.article_status),
1532: artv.article_status) article_status
1533: from
1534: okc_articles_all art,
1535: okc_article_versions artv
1536: where
1537: art.standard_yn = 'Y'
1538: and art.article_id = artv.article_id
1539: and org_id = p_org_id

Line 1560: okc_article_versions artv

1556: trunc(sysdate))+1, trunc(sysdate)), trunc(sysdate), 'EXPIRED', artv.article_status),
1557: artv.article_status) article_status
1558: from
1559: okc_articles_all art,
1560: okc_article_versions artv
1561: where
1562: art.standard_yn = 'Y'
1563: and art.article_id = artv.article_id
1564: and org_id = p_org_id

Line 1923: article_version_id okc_article_versions.article_version_id%type;

1919: is
1920: message_code fnd_new_messages.message_name%type;
1921: org_id okc_articles_all.org_id%type;
1922: article_id okc_articles_all.article_id%type;
1923: article_version_id okc_article_versions.article_version_id%type;
1924:
1925: requestor_name wf_users.display_name%type;
1926: itemtype wf_engine.setctx_itemtype%type;
1927: itemkey wf_engine.setctx_itemkey%type;

Line 2046: return okc_article_versions.article_text%type

2042:
2043: -- bug 5261848 - cr3 start
2044:
2045: function get_g_article_text(p_org_id number, p_article_version_id number)
2046: return okc_article_versions.article_text%type
2047: is
2048: text okc_article_versions.article_text%type;
2049: begin
2050: text := empty_clob();

Line 2048: text okc_article_versions.article_text%type;

2044:
2045: function get_g_article_text(p_org_id number, p_article_version_id number)
2046: return okc_article_versions.article_text%type
2047: is
2048: text okc_article_versions.article_text%type;
2049: begin
2050: text := empty_clob();
2051: select article_text into text
2052: from okc_article_versions

Line 2052: from okc_article_versions

2048: text okc_article_versions.article_text%type;
2049: begin
2050: text := empty_clob();
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

Line 2066: return okc_article_versions.translated_yn%type

2062: return text;
2063: end;
2064:
2065: function get_g_translated_yn(p_article_version_id number)
2066: return okc_article_versions.translated_yn%type
2067: is
2068: yn okc_article_versions.translated_yn%type;
2069: begin
2070: yn := 'N';

Line 2068: yn okc_article_versions.translated_yn%type;

2064:
2065: function get_g_translated_yn(p_article_version_id number)
2066: return okc_article_versions.translated_yn%type
2067: is
2068: yn okc_article_versions.translated_yn%type;
2069: begin
2070: yn := 'N';
2071: select nvl(translated_yn, 'N') into yn
2072: from okc_article_versions

Line 2072: from okc_article_versions

2068: yn okc_article_versions.translated_yn%type;
2069: begin
2070: yn := 'N';
2071: select nvl(translated_yn, 'N') into yn
2072: from okc_article_versions
2073: where article_version_id = p_article_version_id;
2074: return yn;
2075: exception when others then
2076: return 'N';

Line 2095: return okc_article_versions.article_version_id%type

2091: return 'N';
2092: end;
2093:
2094: function get_g_article_version_id(p_org_id number, p_article_version_id number)
2095: return okc_article_versions.article_version_id%type
2096: is
2097: id okc_article_versions.article_version_id%type;
2098: begin
2099: id := null;

Line 2097: id okc_article_versions.article_version_id%type;

2093:
2094: function get_g_article_version_id(p_org_id number, p_article_version_id number)
2095: return okc_article_versions.article_version_id%type
2096: is
2097: id okc_article_versions.article_version_id%type;
2098: begin
2099: id := null;
2100: select global_article_version_id into id
2101: from okc_article_adoptions