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 680: FROM OKC_ART_BLK_TEMP TMP

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

Line 694: FROM OKC_ART_BLK_TEMP TMP

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

Line 839: (SELECT article_version_id FROM OKC_ART_BLK_TEMP

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

Line 852: (SELECT article_version_id FROM OKC_ART_BLK_TEMP

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

Line 909: (SELECT article_version_id FROM OKC_ART_BLK_TEMP

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

Line 925: (SELECT article_version_id FROM OKC_ART_BLK_TEMP

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

Line 976: FROM OKC_ART_BLK_TEMP TMP,

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

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

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

Line 1099: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLE_RELATNS_ALL REL

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

Line 1139: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLE_RELATNS_ALL REL

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

Line 1193: FROM OKC_ART_BLK_TEMP TMP

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

Line 1319: FROM OKC_ART_BLK_TEMP TMP

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

Line 1591: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLES_ALL ART

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

Line 1659: FROM OKC_ART_BLK_TEMP TMP

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

Line 1692: INSERT INTO OKC_ART_BLK_TEMP

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

Line 1700: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLE_ADOPTIONS ADP

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

Line 1984: INSERT INTO OKC_ART_BLK_TEMP

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

Line 1992: FROM OKC_ART_BLK_TEMP TMP

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

Line 2011: DELETE FROM OKC_ART_BLK_TEMP

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

Line 2248: DELETE FROM OKC_ART_BLK_TEMP

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

Line 2463: DELETE FROM OKC_ART_BLK_TEMP

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