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_K_ARTICLES_GRP dependencies on STANDARD

Line 121: -- Standard Start of API savepoint

117: IF (l_debug = 'Y') THEN
118: okc_debug.log('600: Entered create_article', 2);
119: END IF;
120:
121: -- Standard Start of API savepoint
122: SAVEPOINT g_create_article_GRP;
123: -- Standard call to check for call compatibility.
124: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 123: -- Standard call to check for call compatibility.

119: END IF;
120:
121: -- Standard Start of API savepoint
122: SAVEPOINT g_create_article_GRP;
123: -- Standard call to check for call compatibility.
124: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 270: -- Standard check of p_commit

266: END IF;
267: END LOOP;
268: END IF;
269:
270: -- Standard check of p_commit
271: IF FND_API.To_Boolean( p_commit ) THEN
272: COMMIT WORK;
273: END IF;
274: -- Standard call to get message count and if count is 1, get message info.

Line 274: -- Standard call to get message count and if count is 1, get message info.

270: -- Standard check of p_commit
271: IF FND_API.To_Boolean( p_commit ) THEN
272: COMMIT WORK;
273: END IF;
274: -- Standard call to get message count and if count is 1, get message info.
275: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
276:
277: IF (l_debug = 'Y') THEN
278: okc_debug.log('700: Leaving create_article', 2);

Line 384: -- Standard Start of API savepoint

380: IF (l_debug = 'Y') THEN
381: okc_debug.log('100: Entered validate_row', 2);
382: END IF;
383:
384: -- Standard Start of API savepoint
385: SAVEPOINT g_validate_row_GRP;
386: -- Standard call to check for call compatibility.
387: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 386: -- Standard call to check for call compatibility.

382: END IF;
383:
384: -- Standard Start of API savepoint
385: SAVEPOINT g_validate_row_GRP;
386: -- Standard call to check for call compatibility.
387: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
389: END IF;
390: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 450: -- Standard call to get message count and if count is 1, get message info.

446: RAISE FND_API.G_EXC_ERROR ;
447: END IF;
448: --------------------------------------------
449:
450: -- Standard call to get message count and if count is 1, get message info.
451: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
452:
453: IF (l_debug = 'Y') THEN
454: okc_debug.log('200: Leaving validate_row', 2);

Line 508: -- Standard Start of API savepoint

504: IF (l_debug = 'Y') THEN
505: okc_debug.log('1100: Entered lock_row', 2);
506: END IF;
507:
508: -- Standard Start of API savepoint
509: SAVEPOINT g_lock_row_GRP;
510: -- Standard call to check for call compatibility.
511: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 510: -- Standard call to check for call compatibility.

506: END IF;
507:
508: -- Standard Start of API savepoint
509: SAVEPOINT g_lock_row_GRP;
510: -- Standard call to check for call compatibility.
511: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 537: -- Standard call to get message count and if count is 1, get message info.

533: RAISE FND_API.G_EXC_ERROR ;
534: END IF;
535: --------------------------------------------
536:
537: -- Standard call to get message count and if count is 1, get message info.
538: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
539:
540: IF (l_debug = 'Y') THEN
541: okc_debug.log('1200: Leaving lock_row', 2);

Line 634: l_standard_yn VARCHAR2(1);

630: l_document_id NUMBER;
631: l_cle_id NUMBER;
632: l_document_type VARCHAR2(30);
633: l_article_version_id NUMBER;
634: l_standard_yn VARCHAR2(1);
635: l_sync_variable VARCHAR2(1) := FND_API.G_FALSE;
636: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
637: l_summary_amend_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
638: l_existing_summary_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

Line 650: SELECT ARTICLE_VERSION_ID,standard_yn

646: FROM OKC_K_ARTIClES_B
647: WHERE ID=P_ID;
648:
649: CURSOR l_art_version_csr IS
650: SELECT ARTICLE_VERSION_ID,standard_yn
651: FROM OKC_K_ARTIClES_B kart,okc_articles_all art
652: WHERE ID=P_ID
653: AND art.article_id=kart.sav_sae_id;
654:

Line 717: -- Standard Start of API savepoint

713: IF (l_debug = 'Y') THEN
714: okc_debug.log('1600: Entered update_article', 2);
715: END IF;
716:
717: -- Standard Start of API savepoint
718: SAVEPOINT g_update_article_grp;
719: -- Standard call to check for call compatibility.
720: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 719: -- Standard call to check for call compatibility.

715: END IF;
716:
717: -- Standard Start of API savepoint
718: SAVEPOINT g_update_article_grp;
719: -- Standard call to check for call compatibility.
720: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 758: FETCH l_art_version_csr into l_article_version_id,l_standard_yn;

754:
755: -- Check if this update going to update article version also.If yes then article variables will be created.
756:
757: OPEN l_art_version_csr;
758: FETCH l_art_version_csr into l_article_version_id,l_standard_yn;
759: CLOSE l_art_version_csr;
760:
761: IF (p_article_version_id IS NOT NULL AND
762: p_article_version_id <>FND_API.G_MISS_NUM AND

Line 763: l_article_version_id <> p_article_version_id ) OR l_standard_yn='N' THEN

759: CLOSE l_art_version_csr;
760:
761: IF (p_article_version_id IS NOT NULL AND
762: p_article_version_id <>FND_API.G_MISS_NUM AND
763: l_article_version_id <> p_article_version_id ) OR l_standard_yn='N' THEN
764:
765: l_sync_variable := FND_API.G_TRUE;
766:
767: END IF;

Line 921: -- Standard check of p_commit

917: END LOOP;
918:
919: END IF;
920:
921: -- Standard check of p_commit
922: IF FND_API.To_Boolean( p_commit ) THEN
923: COMMIT WORK;
924: END IF;
925: -- Standard call to get message count and if count is 1, get message info.

Line 925: -- Standard call to get message count and if count is 1, get message info.

921: -- Standard check of p_commit
922: IF FND_API.To_Boolean( p_commit ) THEN
923: COMMIT WORK;
924: END IF;
925: -- Standard call to get message count and if count is 1, get message info.
926: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
927:
928: IF (l_debug = 'Y') THEN
929: okc_debug.log('1800: Leaving update_article', 2);

Line 1053: l_standard_yn VARCHAR2(1);

1049: l_document_id NUMBER;
1050: l_cle_id NUMBER;
1051: l_document_type VARCHAR2(30);
1052: l_mandatory_yn VARCHAR2(1);
1053: l_standard_yn VARCHAR2(1);
1054: l_amendment_operation_code OKC_K_ARTICLES_B.AMENDMENT_OPERATION_CODE%TYPE;
1055: l_amendment_description OKC_K_ARTICLES_B.AMENDMENT_DESCRIPTION%TYPE;
1056:
1057: l_summary_amend_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;

Line 1063: SELECT kart.DOCUMENT_ID,kart.DOCUMENT_TYPE,kart.mandatory_yn, art.standard_yn

1059: l_existing_operation_code OKC_SECTIONS_B.SUMMARY_AMEND_OPERATION_CODE%TYPE;
1060: l_delete_rec BOOLEAN := FALSE;
1061:
1062: CURSOR l_document_id_csr IS
1063: SELECT kart.DOCUMENT_ID,kart.DOCUMENT_TYPE,kart.mandatory_yn, art.standard_yn
1064: FROM OKC_K_ARTIClES_B kart, OKC_ARTICLES_ALL art
1065: WHERE kart.sav_sae_id = art.article_id
1066: AND ID=P_ID;
1067:

Line 1080: -- Standard Start of API savepoint

1076: IF (l_debug = 'Y') THEN
1077: okc_debug.log('2200: Entered delete_article', 2);
1078: END IF;
1079:
1080: -- Standard Start of API savepoint
1081: SAVEPOINT g_delete_article_grp;
1082: -- Standard call to check for call compatibility.
1083: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1082: -- Standard call to check for call compatibility.

1078: END IF;
1079:
1080: -- Standard Start of API savepoint
1081: SAVEPOINT g_delete_article_grp;
1082: -- Standard call to check for call compatibility.
1083: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1084: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1085: END IF;
1086: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1096: FETCH l_document_id_csr INTO l_document_id,l_document_type,l_mandatory_yn, l_standard_yn;

1092: x_return_status := FND_API.G_RET_STS_SUCCESS;
1093:
1094:
1095: OPEN l_document_id_csr;
1096: FETCH l_document_id_csr INTO l_document_id,l_document_type,l_mandatory_yn, l_standard_yn;
1097: CLOSE l_document_id_csr;
1098:
1099: IF l_mandatory_yn='Y' and l_document_type<>'TEMPLATE' and p_super_user_yn='N' and p_mandatory_clause_delete='N' THEN
1100:

Line 1110: l_standard_yn ='N' THEN

1106: END IF;
1107:
1108: -- if user does NOT have non-std access, don't allow delete of non-std articles
1109: IF (NOT fnd_function.test('OKC_TERMS_AUTHOR_NON_STD','N')) AND
1110: l_standard_yn ='N' THEN
1111: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1112: p_msg_name => 'OKC_DEL_NON_STD_ARTICLE');
1113:
1114: raise FND_API.G_EXC_ERROR;

Line 1211: -- Standard check of p_commit

1207: RAISE FND_API.G_EXC_ERROR ;
1208: END IF;
1209: --------------------------------------------
1210: END IF;
1211: -- Standard check of p_commit
1212: IF FND_API.To_Boolean( p_commit ) THEN
1213: COMMIT WORK;
1214: END IF;
1215: -- Standard call to get message count and if count is 1, get message info.

Line 1215: -- Standard call to get message count and if count is 1, get message info.

1211: -- Standard check of p_commit
1212: IF FND_API.To_Boolean( p_commit ) THEN
1213: COMMIT WORK;
1214: END IF;
1215: -- Standard call to get message count and if count is 1, get message info.
1216: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1217:
1218: IF (l_debug = 'Y') THEN
1219: okc_debug.log('2300: Leaving delete_article', 2);