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_ARTICLE_VERSIONS

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 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 69: return okc_article_versions.article_version_number%type

65: exception when others then return null;
66: end;
67:
68: function article_version_number( p_article_version_id in number)
69: return okc_article_versions.article_version_number%type
70: as
71: result okc_article_versions.article_version_number%type;
72: begin
73: select article_version_number into result

Line 71: result okc_article_versions.article_version_number%type;

67:
68: function article_version_number( p_article_version_id in number)
69: return okc_article_versions.article_version_number%type
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

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 82: return okc_article_versions.article_id%type

78: exception when others then return null;
79: end;
80:
81: function article_id( p_article_version_id in number)
82: return okc_article_versions.article_id%type
83: as
84: result okc_article_versions.article_id%type;
85: begin
86: select article_id into result

Line 84: result okc_article_versions.article_id%type;

80:
81: function article_id( p_article_version_id in number)
82: return okc_article_versions.article_id%type
83: as
84: result okc_article_versions.article_id%type;
85: begin
86: select article_id into result
87: from okc_article_versions
88: where article_version_id = p_article_version_id;

Line 87: from okc_article_versions

83: as
84: result okc_article_versions.article_id%type;
85: begin
86: select article_id into result
87: from okc_article_versions
88: where article_version_id = p_article_version_id;
89: return result;
90: exception when others then return null;
91: end;

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 108: return okc_article_versions.article_version_id%type

104: end;
105:
106: function latest_article_version_id( p_article_version_id in number,
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;

Line 110: result okc_article_versions.article_version_id%type;

106: function latest_article_version_id( p_article_version_id in number,
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

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 124: from okc_article_versions

120: end;
121: if p_org_id = l_org_id then
122: begin
123: select article_version_id into result
124: from okc_article_versions
125: where article_id = l_article_id
126: and article_status in ('APPROVED','ON_HOLD')
127: and (start_date, article_version_number) = (
128: select

Line 132: okc_article_versions

128: select
129: max(start_date),
130: max(article_version_number)
131: from
132: okc_article_versions
133: where article_id = l_article_id
134: and article_status in ('APPROVED','ON_HOLD')
135: );
136: exception when others then return null;

Line 141: from okc_article_versions

137: end;
138: else
139: begin
140: select article_version_id into result
141: from okc_article_versions
142: where article_id = l_article_id
143: and global_yn = 'Y'
144: and article_status in ('APPROVED','ON_HOLD')
145: and (start_date, article_version_number) = (

Line 150: okc_article_versions

146: select
147: max(start_date),
148: max(article_version_number)
149: from
150: okc_article_versions
151: where article_id = l_article_id
152: and article_status in ('APPROVED','ON_HOLD')
153: and exists (
154: select 1 from okc_article_adoptions

Line 231: okc_article_versions v,

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
235: from

Line 262: okc_article_versions

258: select
259: max(start_date),
260: max(article_version_number)
261: from
262: okc_article_versions
263: where article_id = art.article_id
264: and article_status in ('APPROVED','ON_HOLD')
265: )
266: and org.org_id = art.org_id

Line 281: okc_article_versions v,

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,
284: orgu.name org_name
285: from

Line 316: okc_article_versions v1,

312: select
313: max(start_date),
314: max(article_version_number)
315: from
316: okc_article_versions v1,
317: okc_article_adoptions a1
318: where global_yn = 'Y'
319: and v1.article_version_id = a1.global_article_version_id
320: and v1.article_status in ('APPROVED','ON_HOLD')

Line 465: okc_article_versions a,

461: a.article_version_number,
462: article_adoption_type,
463: org_name
464: from
465: okc_article_versions a,
466: okc_ca_art_versions_gt t,
467: ( select
468: orgu.organization_id org_id,
469: orgu.name org_name

Line 493: okc_article_versions a,

489: a.article_version_number,
490: 'ADOPTED' adoption_type,
491: org_name
492: from
493: okc_article_versions a,
494: okc_ca_art_versions_gt t,
495: ( select
496: orgu.organization_id org_id,
497: orgu.name org_name

Line 579: okc_article_versions v,

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,
583: orgu.name org_name

Line 667: okc_article_versions v,

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
671: a.article_id = v.article_id

Line 668: okc_article_versions v1,

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
671: a.article_id = v.article_id
672: and v.std_article_version_id = v1.article_version_id

Line 677: okc_article_versions ver

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;
681: return result;