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_ART_BLK_PVT dependencies on OKC_ART_BLK_TEMP

Line 98: SELECT OKC_ART_BLK_TEMP_S1.NEXTVAL FROM DUAL;

94: l_api_name CONSTANT VARCHAR2(30) := 'get_version_details';
95: l_num NUMBER;
96:
97: CURSOR c1 IS
98: SELECT OKC_ART_BLK_TEMP_S1.NEXTVAL FROM DUAL;
99: BEGIN
100:
101: OPEN c1;
102: FETCH c1 INTO l_num;

Line 146: FROM OKC_ART_BLK_TEMP

142: SELECT sum(to_number(decode(adopt_asis_yn, 'Y', '1', '0'))) adopt_is_count,
143: sum(to_number(decode(global_yn, 'Y', '1', '0'))) global_count,
144: sum(to_number(decode(localized_yn, 'Y', '1', '0'))) localized_count,
145: count(*) total_count
146: FROM OKC_ART_BLK_TEMP
147: WHERE id = cp_id;
148:
149: BEGIN
150:

Line 185: INSERT INTO OKC_ART_BLK_TEMP

181: IF ( p_org_id = G_GLOBAL_ORG_ID) THEN
182: -- if we are in global org, store the list of articles with global_yn = Y
183:
184: FORALL i in p_art_ver_tbl.FIRST..p_art_ver_tbl.LAST
185: INSERT INTO OKC_ART_BLK_TEMP
186: (
187: ID,
188: ARTICLE_ID,
189: ARTICLE_VERSION_ID,

Line 214: INSERT INTO OKC_ART_BLK_TEMP

210: ELSE
211: -- we are not in the global org,
212: -- get the local/localized articles
213: FORALL i in p_art_ver_tbl.FIRST..p_art_ver_tbl.LAST
214: INSERT INTO OKC_ART_BLK_TEMP
215: (
216: ID,
217: ARTICLE_ID,
218: ARTICLE_VERSION_ID,

Line 241: INSERT INTO OKC_ART_BLK_TEMP

237: AND ART.ORG_ID = p_org_id;
238:
239: -- get the adopt as is articles
240: FORALL i in p_art_ver_tbl.FIRST..p_art_ver_tbl.LAST
241: INSERT INTO OKC_ART_BLK_TEMP
242: (
243: ID,
244: ARTICLE_ID,
245: ARTICLE_VERSION_ID,

Line 336: FROM OKC_ART_BLK_TEMP

332:
333: CURSOR l_pend_app_csr IS
334: SELECT article_id, article_version_id, nvl(display_name, article_title),
335: nvl(status, 'DRAFT')
336: FROM OKC_ART_BLK_TEMP
337: WHERE id = p_id AND
338: status NOT IN ('DRAFT', 'REJECTED');
339:
340: CURSOR l_app_rej_csr IS

Line 343: FROM OKC_ART_BLK_TEMP

339:
340: CURSOR l_app_rej_csr IS
341: SELECT article_id, article_version_id, nvl(display_name, article_title),
342: nvl(status, 'DRAFT')
343: FROM OKC_ART_BLK_TEMP
344: WHERE id = p_id AND
345: status <> 'PENDING_APPROVAL';
346:
347: CURSOR l_status_csr is

Line 533: OKC_ART_BLK_TEMP TMP

529: BVT.variable_name
530: FROM OKC_BUS_VARIABLES_TL BVT,
531: OKC_BUS_VARIABLES_B BVB,
532: OKC_ARTICLE_VARIABLES AAV,
533: OKC_ART_BLK_TEMP TMP
534: WHERE TMP.id = cp_id
535: AND TMP.adopt_asis_yn = 'N' --check not done for adopt as is clauses
536: AND AAV.article_version_id = TMP.article_version_id
537: AND BVB.variable_code = AAV.variable_code

Line 551: OKC_ART_BLK_TEMP TMP

547: FROM OKC_BUS_VARIABLES_TL BVT,
548: FND_FLEX_VALUE_SETS FVS,
549: OKC_BUS_VARIABLES_B BVB,
550: OKC_ARTICLE_VARIABLES AAV,
551: OKC_ART_BLK_TEMP TMP
552: WHERE TMP.id = cp_id
553: AND TMP.adopt_asis_yn = 'N' --check not done for adopt as is clauses
554: AND AAV.article_version_id = TMP.article_version_id
555: AND BVB.variable_code = AAV.variable_code

Line 679: FROM OKC_ART_BLK_TEMP TMP

675: -- check for article_type
676: CURSOR l_art_typ_csr (cp_id IN NUMBER, cp_date IN DATE) IS
677: SELECT TMP.article_id, TMP.article_version_id, nvl(TMP.display_name, TMP.article_title),
678: TMP.article_type
679: FROM OKC_ART_BLK_TEMP TMP
680: WHERE TMP.id = cp_id
681: AND TMP.adopt_asis_yn = 'N' --check not done for adopt as is clauses
682: AND NOT EXISTS (
683: SELECT '1' from FND_LOOKUPS F

Line 693: FROM OKC_ART_BLK_TEMP TMP

689: -- check for default_section
690: CURSOR l_def_sec_csr (cp_id IN NUMBER, cp_date IN DATE) IS
691: SELECT TMP.article_id, TMP.article_version_id, nvl(TMP.display_name, TMP.article_title),
692: TMP.default_section
693: FROM OKC_ART_BLK_TEMP TMP
694: WHERE TMP.id = cp_id
695: AND TMP.adopt_asis_yn = 'N' --check not done for adopt as is clauses
696: AND TMP.default_section <> 'UNASSIGNED'
697: AND NOT EXISTS (

Line 838: (SELECT article_version_id FROM OKC_ART_BLK_TEMP

834: LAST_UPDATE_LOGIN = G_LOGIN_ID,
835: LAST_UPDATE_DATE = l_date
836: WHERE
837: ARTICLE_VERSION_ID IN
838: (SELECT article_version_id FROM OKC_ART_BLK_TEMP
839: WHERE id = p_id AND adopt_asis_yn = 'N');
840: ELSE
841:
842: UPDATE OKC_ARTICLE_VERSIONS

Line 851: (SELECT article_version_id FROM OKC_ART_BLK_TEMP

847: LAST_UPDATE_LOGIN = G_LOGIN_ID,
848: LAST_UPDATE_DATE = l_date
849: WHERE
850: ARTICLE_VERSION_ID IN
851: (SELECT article_version_id FROM OKC_ART_BLK_TEMP
852: WHERE id = p_id AND adopt_asis_yn = 'N');
853:
854: END IF;
855:

Line 908: (SELECT article_version_id FROM OKC_ART_BLK_TEMP

904: LAST_UPDATE_LOGIN = G_LOGIN_ID,
905: LAST_UPDATE_DATE = l_date
906: WHERE
907: GLOBAL_ARTICLE_VERSION_ID IN
908: (SELECT article_version_id FROM OKC_ART_BLK_TEMP
909: WHERE id = p_id AND adopt_asis_yn = 'Y')
910: AND LOCAL_ORG_ID = p_local_org_id;
911:
912: ELSIF (p_type = 'LOCALIZED') THEN

Line 924: (SELECT article_version_id FROM OKC_ART_BLK_TEMP

920: LAST_UPDATE_LOGIN = G_LOGIN_ID,
921: LAST_UPDATE_DATE = l_date
922: WHERE
923: LOCAL_ARTICLE_VERSION_ID IN
924: (SELECT article_version_id FROM OKC_ART_BLK_TEMP
925: WHERE id = p_id AND adopt_asis_yn = 'N' AND localized_yn = 'Y')
926: AND LOCAL_ORG_ID = p_local_org_id;
927:
928: ELSE

Line 975: FROM OKC_ART_BLK_TEMP TMP,

971:
972: --determine all previous versions that have a null end date
973: CURSOR l_prev_ver_csr(cp_id IN NUMBER) IS
974: SELECT PREV.article_version_id, TMP.start_date
975: FROM OKC_ART_BLK_TEMP TMP,
976: OKC_ARTICLE_VERSIONS PREV
977: WHERE TMP.id = cp_id AND
978: TMP.adopt_asis_yn = 'N' AND
979: PREV.article_id = TMP.article_id AND

Line 1049: -- p_id OKC_ART_BLK_TEMP table is populated with a number of rows containing

1045:
1046: ----------------------------------------------------------------------------
1047:
1048: --
1049: -- p_id OKC_ART_BLK_TEMP table is populated with a number of rows containing
1050: -- global article version ids, global article ids and the corresponding
1051: -- local org ids for which the relationships need to be adopted.
1052: -- p_id identifies these rows.
1053: --

Line 1098: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLE_RELATNS_ALL REL

1094: l_date,
1095: G_USER_ID,
1096: G_LOGIN_ID,
1097: l_date
1098: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLE_RELATNS_ALL REL
1099: WHERE TMP.id = p_id AND
1100: REL.org_id = G_GLOBAL_ORG_ID AND
1101: REL.source_article_id = TMP.article_id AND
1102: EXISTS

Line 1138: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLE_RELATNS_ALL REL

1134: l_date,
1135: G_USER_ID,
1136: G_LOGIN_ID,
1137: l_date
1138: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLE_RELATNS_ALL REL
1139: WHERE TMP.id = p_id AND
1140: REL.org_id = G_GLOBAL_ORG_ID AND
1141: REL.target_article_id = TMP.article_id AND
1142: EXISTS

Line 1192: FROM OKC_ART_BLK_TEMP TMP

1188:
1189: -- select only those article versions that are being adopted as is
1190: CURSOR l_art_id_csr(cp_id IN NUMBER) IS
1191: SELECT article_id, article_version_id
1192: FROM OKC_ART_BLK_TEMP TMP
1193: WHERE TMP.id = cp_id AND TMP.adopt_asis_yn = 'Y';
1194:
1195: BEGIN
1196:

Line 1318: FROM OKC_ART_BLK_TEMP TMP

1314:
1315: -- get some details about adopt as is articles for filling the x_validation_results table
1316: CURSOR l_adopt_as_is_csr(cp_id IN NUMBER) IS
1317: SELECT TMP.article_id, TMP.article_version_id, nvl(TMP.display_name, TMP.article_title)
1318: FROM OKC_ART_BLK_TEMP TMP
1319: WHERE TMP.id = cp_id AND
1320: TMP.adopt_asis_yn = 'Y';
1321:
1322:

Line 1590: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLES_ALL ART

1586: CURSOR l_non_uniq_title_csr(cp_id IN NUMBER, cp_global_org_id IN NUMBER) IS
1587: -- check if article title is unique for the local org also
1588: -- if title is not unique in the local org, set to 'AVAILABLE' and NULL
1589: SELECT TMP.article_version_id , ART.org_id
1590: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLES_ALL ART
1591: WHERE TMP.id = cp_id AND
1592: TMP.global_yn = 'Y' AND
1593: ART.article_title = TMP.article_title AND
1594: ART.org_id <> cp_global_org_id ;

Line 1658: FROM OKC_ART_BLK_TEMP TMP

1654: SELECT TMP.article_version_id, l_adp_typ_tbl(i), l_org_id_tbl(i),
1655: decode(l_adp_typ_tbl(i), 'ADOPTED', 'APPROVED', NULL),
1656: NULL, 1, G_USER_ID, l_date,
1657: G_USER_ID, G_LOGIN_ID, l_date
1658: FROM OKC_ART_BLK_TEMP TMP
1659: WHERE TMP.id = p_id AND
1660: TMP.global_yn = 'Y';
1661:
1662: -- now for local orgs, check if any clauses

Line 1691: INSERT INTO OKC_ART_BLK_TEMP

1687:
1688: -- now adopt relationship for those article versions/local orgs
1689: -- where adoption_type = 'ADOPTED'
1690: l_id := get_uniq_id;
1691: INSERT INTO OKC_ART_BLK_TEMP
1692: (
1693: ID,
1694: ARTICLE_ID,
1695: ARTICLE_VERSION_ID,

Line 1699: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLE_ADOPTIONS ADP

1695: ARTICLE_VERSION_ID,
1696: ORG_ID
1697: )
1698: SELECT l_id, TMP.article_id, TMP.article_version_id, ADP.local_org_id
1699: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLE_ADOPTIONS ADP
1700: WHERE TMP.id = p_id AND
1701: TMP.global_yn = 'Y' AND
1702: ADP.global_article_version_id = TMP.article_version_id AND
1703: ADP.adoption_type = 'ADOPTED';

Line 1983: INSERT INTO OKC_ART_BLK_TEMP

1979:
1980: -- now adopt relationship for these articles
1981: -- first populate the temp table with whatever adopt_relationships_blk requires
1982: l_rel_id := get_uniq_id;
1983: INSERT INTO OKC_ART_BLK_TEMP
1984: (
1985: ID,
1986: ARTICLE_ID,
1987: ARTICLE_VERSION_ID,

Line 1991: FROM OKC_ART_BLK_TEMP TMP

1987: ARTICLE_VERSION_ID,
1988: ORG_ID
1989: )
1990: SELECT l_rel_id, TMP.article_id, TMP.article_version_id, p_org_id
1991: FROM OKC_ART_BLK_TEMP TMP
1992: WHERE TMP.id = l_id AND
1993: TMP.adopt_asis_yn = 'Y';
1994:
1995: adopt_relationships_blk(

Line 2010: DELETE FROM OKC_ART_BLK_TEMP

2006:
2007: END IF; -- of IF (p_org_id <> G_GLOBAL_ORG_ID)
2008:
2009: -- delete rows created in the temp table
2010: DELETE FROM OKC_ART_BLK_TEMP
2011: WHERE id IN (l_id, l_rel_id);
2012:
2013: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2014: IF(FND_API.to_boolean(p_commit)) THEN

Line 2247: DELETE FROM OKC_ART_BLK_TEMP

2243: END IF; -- of IF (p_org_id = G_GLOBAL_ORG_ID) THEN
2244:
2245:
2246: -- delete rows created in the temp table
2247: DELETE FROM OKC_ART_BLK_TEMP
2248: WHERE id = l_id;
2249:
2250: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2251: IF(FND_API.to_boolean(p_commit)) THEN

Line 2462: DELETE FROM OKC_ART_BLK_TEMP

2458: END IF; -- of IF (p_org_id <> G_GLOBAL_ORG_ID) THEN
2459:
2460:
2461: -- delete rows created in the temp table
2462: DELETE FROM OKC_ART_BLK_TEMP
2463: WHERE id = l_id;
2464:
2465: fnd_msg_pub.count_and_get( p_count => x_msg_count , p_data => x_msg_data);
2466: IF(FND_API.to_boolean(p_commit)) THEN