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_ARTICLES_ALL

Line 23: okc_articles_all art,

19: artv.object_version_number+1,
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')

Line 59: okc_articles_all art,

55: arta.object_version_number+1,
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'

Line 104: org_id okc_articles_all.org_id%type,

100: nowait;
101: */
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,

Line 105: article_id okc_articles_all.article_id%type,

101: */
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,

Line 113: article_title okc_articles_all.article_title%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: );
116:
117: type c_tab_type is table of c_rec_type index by binary_integer;

Line 260: okc_articles_all art,

256: to_char(artv.object_version_number) ikey,
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'

Line 348: art_id okc_articles_all.article_id%type;

344: -- returns article_intent
345: -- -----------------------------------------------------------------------------
346: function get_intent(itemtype in varchar2, itemkey in varchar2) return varchar2
347: is
348: art_id okc_articles_all.article_id%type;
349: art_intent okc_articles_all.article_intent%type;
350: begin
351: art_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_ID', false);
352: select article_intent into art_intent

Line 349: art_intent okc_articles_all.article_intent%type;

345: -- -----------------------------------------------------------------------------
346: function get_intent(itemtype in varchar2, itemkey in varchar2) return varchar2
347: is
348: art_id okc_articles_all.article_id%type;
349: art_intent okc_articles_all.article_intent%type;
350: begin
351: art_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_ID', false);
352: select article_intent into art_intent
353: from okc_articles_all

Line 353: from okc_articles_all

349: art_intent okc_articles_all.article_intent%type;
350: begin
351: art_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'ARTICLE_ID', false);
352: select article_intent into art_intent
353: from okc_articles_all
354: where article_id = art_id;
355: return art_intent;
356: exception
357: when others then

Line 371: art_intent okc_articles_all.article_intent%type;

367: -- returns article_intent
368: -- -----------------------------------------------------------------------------
369: function get_intent(art_id in number) return varchar2
370: is
371: art_intent okc_articles_all.article_intent%type;
372: begin
373: select article_intent into art_intent
374: from okc_articles_all
375: where article_id = art_id;

Line 374: from okc_articles_all

370: is
371: art_intent okc_articles_all.article_intent%type;
372: begin
373: select article_intent into art_intent
374: from okc_articles_all
375: where article_id = art_id;
376: return art_intent;
377: exception
378: when others then

Line 392: art_intent okc_articles_all.article_intent%type;

388: -- returns article_intent
389: -- -----------------------------------------------------------------------------
390: function get_intent_pub(art_ver_id in number) return varchar2
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

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 640: x_article_id out nocopy okc_articles_all.article_id%type,

636: end;
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,

Line 665: x_article_id out nocopy okc_articles_all.article_id%type,

661: end;
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,

Line 912: org_id okc_articles_all.org_id%type;

908: funcmode in varchar2,
909: resultout out nocopy varchar2)
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

Line 913: article_id okc_articles_all.article_id%type;

909: resultout out nocopy varchar2)
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

Line 929: okc_articles_all art,

925: pm.meaning provision_meaning,
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,

Line 961: okc_articles_all art,

957: pm.meaning provision_meaning,
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,

Line 1385: okc_articles_all art,

1381: select 'Y' into result
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

Line 1394: okc_articles_all art,

1390: and art.org_id = p_org_id
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'

Line 1422: okc_articles_all art,

1418: decode(artv.article_status, 'APPROVED', decode(greatest(nvl(trunc(end_date),
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

Line 1438: okc_articles_all art,

1434: decode(greatest(nvl(trunc(end_date), trunc(sysdate))+1, trunc(sysdate)), trunc(sysdate), 'EXPIRED',
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'

Line 1466: okc_articles_all art,

1462: decode(artv.article_status, 'APPROVED', decode(greatest(nvl(trunc(end_date),
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

Line 1482: okc_articles_all art,

1478: 'PENDING_APPROVAL', decode(greatest(nvl(trunc(end_date), trunc(sysdate))+1, trunc(sysdate)),
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'

Line 1509: okc_articles_all art,

1505: select 'Y' into result
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

Line 1534: okc_articles_all art,

1530: decode(artv.article_status, 'APPROVED', decode(greatest(nvl(trunc(end_date),
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

Line 1559: okc_articles_all art,

1555: decode(artv.article_status, 'APPROVED', decode(greatest(nvl(trunc(end_date),
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

Line 1921: org_id okc_articles_all.org_id%type;

1917: document in out NOCOPY varchar2,
1918: document_type in out NOCOPY varchar2)
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;

Line 1922: article_id okc_articles_all.article_id%type;

1918: document_type in out NOCOPY varchar2)
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;