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

Line 1885: TYPE non_std_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NON_STANDARD_FLAG%TYPE INDEX BY BINARY_INTEGER;

1881: TYPE ovn_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_VERSION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1882: TYPE label_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LABEL%TYPE INDEX BY BINARY_INTEGER;
1883: TYPE disp_seq_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.DISPLAY_SEQ%TYPE INDEX BY BINARY_INTEGER;
1884: TYPE action_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.ACTION%TYPE INDEX BY BINARY_INTEGER;
1885: TYPE non_std_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NON_STANDARD_FLAG%TYPE INDEX BY BINARY_INTEGER;
1886: TYPE mandatory_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.MANDATORY_FLAG%TYPE INDEX BY BINARY_INTEGER;
1887: TYPE lock_text_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.LOCK_TEXT%TYPE INDEX BY BINARY_INTEGER;
1888: TYPE new_parent_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE INDEX BY BINARY_INTEGER;
1889: TYPE obj_title_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OBJECT_TITLE%TYPE INDEX BY BINARY_INTEGER;

Line 1930: non_standard_flag,

1926: object_version_number,
1927: label,
1928: display_seq,
1929: action,
1930: non_standard_flag,
1931: mandatory_flag,
1932: lock_text,
1933: new_parent_id,
1934: object_title,

Line 2005: -- Standard Start of API savepoint

2001: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2002: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10000: Entering Accept_Changes');
2003: END IF;
2004:
2005: -- Standard Start of API savepoint
2006: SAVEPOINT g_accept_changes;
2007:
2008: -- Standard call to check for call compatibility.
2009: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

2004:
2005: -- Standard Start of API savepoint
2006: SAVEPOINT g_accept_changes;
2007:
2008: -- Standard call to check for call compatibility.
2009: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2011: END IF;
2012:

Line 2351: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12900: This is the case of Make Non-Standard');

2347: IF((l_user_access = 'SUPER_USER' and is_lock_text = 'Y') OR
2348: is_lock_text <> 'Y') THEN
2349:
2350: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2351: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12900: This is the case of Make Non-Standard');
2352: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13000: Before invoking OKC_K_NON_STD_ART_GRP.create_non_std_article');
2353: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13100: Clause Title=' || obj_titles(i));
2354: END IF;
2355:

Line 2585: -- Standard check of p_commit

2581: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2582: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'15100: After Accept Changes');
2583: END IF;
2584:
2585: -- Standard check of p_commit
2586: IF FND_API.To_Boolean( p_commit ) THEN
2587: COMMIT WORK;
2588: END IF;
2589:

Line 2641: -- Standard Start of API savepoint

2637: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2638: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entering Reject_Changes');
2639: END IF;
2640:
2641: -- Standard Start of API savepoint
2642: SAVEPOINT g_reject_changes;
2643: -- Standard call to check for call compatibility.
2644: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2639: END IF;
2640:
2641: -- Standard Start of API savepoint
2642: SAVEPOINT g_reject_changes;
2643: -- Standard call to check for call compatibility.
2644: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2646: END IF;
2647: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2669: -- Standard check of p_commit

2665:
2666: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2667: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete_uploaded_terms');
2668: END IF;
2669: -- Standard check of p_commit
2670: IF FND_API.To_Boolean( p_commit ) THEN
2671: COMMIT WORK;
2672: END IF;
2673:

Line 2727: -- Standard Start of API savepoint

2723: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2724: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entering Delete_Uploaded_Terms');
2725: END IF;
2726:
2727: -- Standard Start of API savepoint
2728: SAVEPOINT g_delete_uploaded_terms;
2729: -- Standard call to check for call compatibility.
2730: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2725: END IF;
2726:
2727: -- Standard Start of API savepoint
2728: SAVEPOINT g_delete_uploaded_terms;
2729: -- Standard call to check for call compatibility.
2730: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2732: END IF;
2733: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2778: -- Standard check of p_commit

2774: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2775: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete review terms');
2776: END IF;
2777:
2778: -- Standard check of p_commit
2779: IF FND_API.To_Boolean( p_commit ) THEN
2780: COMMIT WORK;
2781: END IF;
2782:

Line 3185: -- Standard Start of API savepoint

3181: select intent from okc_bus_doc_types_b
3182: where document_type = p_document_type;
3183: BEGIN
3184:
3185: -- Standard Start of API savepoint
3186: SAVEPOINT g_reject_changes;
3187: -- Standard call to check for call compatibility.
3188: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3183: BEGIN
3184:
3185: -- Standard Start of API savepoint
3186: SAVEPOINT g_reject_changes;
3187: -- Standard call to check for call compatibility.
3188: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3190: END IF;
3191: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3594: SET NON_STANDARD_FLAG = 'Y'

3590:
3591: AND to_char(UT.OBJECT_TITLE) <> SCN.HEADING);
3592:
3593: UPDATE OKC_REVIEW_UPLD_TERMS UT
3594: SET NON_STANDARD_FLAG = 'Y'
3595: WHERE DOCUMENT_ID = P_DOCUMENT_ID
3596: AND DOCUMENT_TYPE = P_DOCUMENT_TYPE
3597: AND OBJECT_TYPE = 'ARTICLE'
3598: AND EXISTS (SELECT 1

Line 3606: AND ART.STANDARD_YN = 'N');

3602: AND KART.ID = UT.OBJECT_ID
3603: AND KART.DOCUMENT_TYPE = UT.DOCUMENT_TYPE
3604: AND KART.DOCUMENT_ID = UT.DOCUMENT_ID
3605:
3606: AND ART.STANDARD_YN = 'N');
3607:
3608: open clauses_without_parent_exist;
3609: fetch clauses_without_parent_exist into l_clauses_no_parent_exist;
3610: if (clauses_without_parent_exist%FOUND) THEN

Line 4062: -- Standard check of p_commit

4058: p_doc_type => p_document_type,
4059: p_doc_id => p_document_id,
4060: p_num_scheme_id => l_doc_num_scheme);
4061: end if;
4062: -- Standard check of p_commit
4063: IF FND_API.To_Boolean( p_commit ) THEN
4064: COMMIT WORK;
4065: END IF;
4066:

Line 4133: -- Standard Start of API savepoint

4129: BEGIN
4130: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4131: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered Create_Unassigned_Section');
4132: END IF;
4133: -- Standard Start of API savepoint
4134: SAVEPOINT g_Create_Unassigned_Section;
4135: -- Standard call to check for call compatibility.
4136: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4131: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered Create_Unassigned_Section');
4132: END IF;
4133: -- Standard Start of API savepoint
4134: SAVEPOINT g_Create_Unassigned_Section;
4135: -- Standard call to check for call compatibility.
4136: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4138: END IF;
4139: -- Initialize message list if p_init_msg_list is set to TRUE.

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

4232:
4233: IF FND_API.To_Boolean( p_commit ) THEN
4234: COMMIT WORK;
4235: END IF;
4236: -- Standard call to get message count and if count is 1, get message info.
4237: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4238: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4239: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving Create_Unassigned_Section');
4240: END IF;