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_CA_UTIL_PVT dependencies on OKC_ARTICLES_ALL

Line 43: return okc_articles_all.article_title%type

39: exception when others then return null;
40: end;
41:
42: function article_title( p_article_version_id in number)
43: return okc_articles_all.article_title%type
44: as
45: result okc_articles_all.article_title%type;
46: begin
47: select article_title into result

Line 45: result okc_articles_all.article_title%type;

41:
42: function article_title( p_article_version_id in number)
43: return okc_articles_all.article_title%type
44: as
45: result okc_articles_all.article_title%type;
46: begin
47: select article_title into result
48: from okc_articles_all a, okc_article_versions v
49: where a.article_id = v.article_id

Line 48: from okc_articles_all a, okc_article_versions v

44: as
45: result okc_articles_all.article_title%type;
46: begin
47: select article_title into result
48: from okc_articles_all a, okc_article_versions v
49: where a.article_id = v.article_id
50: and article_version_id = p_article_version_id;
51: return result;
52: exception when others then return null;

Line 56: return okc_articles_all.article_title%type

52: exception when others then return null;
53: end;
54:
55: function display_name( p_article_version_id in number)
56: return okc_articles_all.article_title%type
57: as
58: result okc_articles_all.article_title%type;
59: begin
60: select nvl(display_name, article_title) into result

Line 58: result okc_articles_all.article_title%type;

54:
55: function display_name( p_article_version_id in number)
56: return okc_articles_all.article_title%type
57: as
58: result okc_articles_all.article_title%type;
59: begin
60: select nvl(display_name, article_title) into result
61: from okc_articles_all a, okc_article_versions v
62: where a.article_id = v.article_id

Line 61: from okc_articles_all a, okc_article_versions v

57: as
58: result okc_articles_all.article_title%type;
59: begin
60: select nvl(display_name, article_title) into result
61: from okc_articles_all a, okc_article_versions v
62: where a.article_id = v.article_id
63: and article_version_id = p_article_version_id;
64: return result;
65: exception when others then return null;

Line 74: from okc_articles_all a, okc_article_versions v

70: as
71: result okc_article_versions.article_version_number%type;
72: begin
73: select article_version_number into result
74: from okc_articles_all a, okc_article_versions v
75: where a.article_id = v.article_id
76: and article_version_id = p_article_version_id;
77: return result;
78: exception when others then return null;

Line 94: return okc_articles_all.org_id%type

90: exception when others then return null;
91: end;
92:
93: function org_id( p_article_version_id in number)
94: return okc_articles_all.org_id%type
95: as
96: result okc_articles_all.org_id%type;
97: begin
98: select org_id into result

Line 96: result okc_articles_all.org_id%type;

92:
93: function org_id( p_article_version_id in number)
94: return okc_articles_all.org_id%type
95: as
96: result okc_articles_all.org_id%type;
97: begin
98: select org_id into result
99: from okc_articles_all a, okc_article_versions v
100: where a.article_id = v.article_id

Line 99: from okc_articles_all a, okc_article_versions v

95: as
96: result okc_articles_all.org_id%type;
97: begin
98: select org_id into result
99: from okc_articles_all a, okc_article_versions v
100: where a.article_id = v.article_id
101: and article_version_id = p_article_version_id;
102: return result;
103: exception when others then return null;

Line 111: l_article_id okc_articles_all.article_id%type;

107: p_org_id in number)
108: return okc_article_versions.article_version_id%type
109: as
110: result okc_article_versions.article_version_id%type;
111: l_article_id okc_articles_all.article_id%type;
112: l_org_id okc_articles_all.org_id%type;
113: begin
114: begin
115: select a.article_id, org_id into l_article_id, l_org_id

Line 112: l_org_id okc_articles_all.org_id%type;

108: return okc_article_versions.article_version_id%type
109: as
110: result okc_article_versions.article_version_id%type;
111: l_article_id okc_articles_all.article_id%type;
112: l_org_id okc_articles_all.org_id%type;
113: begin
114: begin
115: select a.article_id, org_id into l_article_id, l_org_id
116: from okc_articles_all a, okc_article_versions v

Line 116: from okc_articles_all a, okc_article_versions v

112: l_org_id okc_articles_all.org_id%type;
113: begin
114: begin
115: select a.article_id, org_id into l_article_id, l_org_id
116: from okc_articles_all a, okc_article_versions v
117: where a.article_id = v.article_id
118: and article_version_id = p_article_version_id;
119: exception when others then return null;
120: end;

Line 230: okc_articles_all art,

226: article_version_number,
227: decode(global_yn, 'Y', 'GLOBAL', nvl(v.adoption_type, 'LOCAL')) adoption_type,
228: org_name
229: from
230: okc_articles_all art,
231: okc_article_versions v,
232: ( select
233: orgu.organization_id org_id,
234: orgu.name org_name

Line 279: okc_articles_all art,

275: article_version_number,
276: 'ADOPTED' adoption_type,
277: org_name
278: from
279: okc_articles_all art,
280: okc_article_adoptions a,
281: okc_article_versions v,
282: ( select
283: orgu.organization_id org_id,

Line 578: okc_articles_all a,

574: org_name,
575: t.article_title std_article_title,
576: t.article_version_number std_article_version_number
577: from
578: okc_articles_all a,
579: okc_article_versions v,
580: okc_ca_art_versions_gt t,
581: ( select
582: orgu.organization_id org_id,

Line 658: return okc_articles_all.article_number%type

654: exception when others then null;
655: end;
656:
657: function article_number( p_article_id in number)
658: return okc_articles_all.article_number%type
659: as
660: result okc_articles_all.article_number%type;
661: begin
662: select nvl(art.article_number, decode(std_article_version_id, null, art.article_number,

Line 660: result okc_articles_all.article_number%type;

656:
657: function article_number( p_article_id in number)
658: return okc_articles_all.article_number%type
659: as
660: result okc_articles_all.article_number%type;
661: begin
662: select nvl(art.article_number, decode(std_article_version_id, null, art.article_number,
663: (select
664: a1.article_number

Line 666: okc_articles_all a,

662: select nvl(art.article_number, decode(std_article_version_id, null, art.article_number,
663: (select
664: a1.article_number
665: from
666: okc_articles_all a,
667: okc_article_versions v,
668: okc_article_versions v1,
669: okc_articles_all a1
670: where

Line 669: okc_articles_all a1

665: from
666: okc_articles_all a,
667: okc_article_versions v,
668: okc_article_versions v1,
669: okc_articles_all a1
670: where
671: a.article_id = v.article_id
672: and v.std_article_version_id = v1.article_version_id
673: and v1.article_id = a1.article_id

Line 676: from okc_articles_all art,

672: and v.std_article_version_id = v1.article_version_id
673: and v1.article_id = a1.article_id
674: and a.article_id = art.article_id)
675: )) article_number into result
676: from okc_articles_all art,
677: okc_article_versions ver
678: where art.article_id = ver.article_id
679: and art.article_id = p_article_id
680: and rownum <= 1;