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 1934: non_standard_flag,

1930: object_version_number,
1931: label,
1932: display_seq,
1933: action,
1934: non_standard_flag,
1935: mandatory_flag,
1936: lock_text,
1937: new_parent_id,
1938: object_title,

Line 1963: non_standard_flag,

1959: object_version_number,
1960: label,
1961: display_seq,
1962: action,
1963: non_standard_flag,
1964: mandatory_flag,
1965: lock_text,
1966: new_parent_id,
1967: object_title,

Line 2043: -- Standard Start of API savepoint

2039: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2040: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'10000: Entering Accept_Changes');
2041: END IF;
2042:
2043: -- Standard Start of API savepoint
2044: SAVEPOINT g_accept_changes;
2045:
2046: -- Standard call to check for call compatibility.
2047: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

2042:
2043: -- Standard Start of API savepoint
2044: SAVEPOINT g_accept_changes;
2045:
2046: -- Standard call to check for call compatibility.
2047: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2049: END IF;
2050:

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

2444: IF((l_user_access = 'SUPER_USER' and is_lock_text = 'Y') OR
2445: is_lock_text <> 'Y') THEN
2446:
2447: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2448: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12900: This is the case of Make Non-Standard');
2449: 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');
2450: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13100: Clause Title=' || obj_titles(i));
2451: END IF;
2452:

Line 2690: -- Standard check of p_commit

2686:
2687: -- Added for Performance after accepting the changes no longer required to retain data in this table.
2688: DELETE FROM okc_word_sync_t WHERE doc_id=p_document_id AND doc_type=p_document_type;
2689:
2690: -- Standard check of p_commit
2691: IF FND_API.To_Boolean( p_commit ) THEN
2692: COMMIT WORK;
2693: END IF;
2694:

Line 2746: -- Standard Start of API savepoint

2742: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2743: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entering Reject_Changes');
2744: END IF;
2745:
2746: -- Standard Start of API savepoint
2747: SAVEPOINT g_reject_changes;
2748: -- Standard call to check for call compatibility.
2749: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2744: END IF;
2745:
2746: -- Standard Start of API savepoint
2747: SAVEPOINT g_reject_changes;
2748: -- Standard call to check for call compatibility.
2749: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2751: END IF;
2752: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2778: -- Standard check of p_commit

2774:
2775: -- Added for Performance after accepting the changes no longer required to retain data in this table.
2776: DELETE FROM okc_word_sync_t WHERE doc_id=p_document_id AND doc_type=p_document_type;
2777:
2778: -- Standard check of p_commit
2779: IF FND_API.To_Boolean( p_commit ) THEN
2780: COMMIT WORK;
2781: END IF;
2782:

Line 2836: -- Standard Start of API savepoint

2832: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2833: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entering Delete_Uploaded_Terms');
2834: END IF;
2835:
2836: -- Standard Start of API savepoint
2837: SAVEPOINT g_delete_uploaded_terms;
2838: -- Standard call to check for call compatibility.
2839: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2834: END IF;
2835:
2836: -- Standard Start of API savepoint
2837: SAVEPOINT g_delete_uploaded_terms;
2838: -- Standard call to check for call compatibility.
2839: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2841: END IF;
2842: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2887: -- Standard check of p_commit

2883: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2884: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete review terms');
2885: END IF;
2886:
2887: -- Standard check of p_commit
2888: IF FND_API.To_Boolean( p_commit ) THEN
2889: COMMIT WORK;
2890: END IF;
2891:

Line 3296: -- Standard Start of API savepoint

3292:
3293: l_prof_value VARCHAR2(1);
3294: BEGIN
3295:
3296: -- Standard Start of API savepoint
3297: SAVEPOINT g_reject_changes;
3298: -- Standard call to check for call compatibility.
3299: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3294: BEGIN
3295:
3296: -- Standard Start of API savepoint
3297: SAVEPOINT g_reject_changes;
3298: -- Standard call to check for call compatibility.
3299: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3301: END IF;
3302: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3747: SET NON_STANDARD_FLAG = 'Y'

3743:
3744: AND to_char(UT.OBJECT_TITLE) <> SCN.HEADING);
3745:
3746: UPDATE OKC_REVIEW_UPLD_TERMS UT
3747: SET NON_STANDARD_FLAG = 'Y'
3748: WHERE DOCUMENT_ID = P_DOCUMENT_ID
3749: AND DOCUMENT_TYPE = P_DOCUMENT_TYPE
3750: AND OBJECT_TYPE = 'ARTICLE'
3751: AND EXISTS (SELECT 1

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

3755: AND KART.ID = UT.OBJECT_ID
3756: AND KART.DOCUMENT_TYPE = UT.DOCUMENT_TYPE
3757: AND KART.DOCUMENT_ID = UT.DOCUMENT_ID
3758:
3759: AND ART.STANDARD_YN = 'N');
3760:
3761: open clauses_without_parent_exist;
3762: fetch clauses_without_parent_exist into l_clauses_no_parent_exist;
3763: if (clauses_without_parent_exist%FOUND) THEN

Line 4223: -- Standard check of p_commit

4219: p_doc_type => p_document_type,
4220: p_doc_id => p_document_id,
4221: p_num_scheme_id => l_doc_num_scheme);
4222: end if;
4223: -- Standard check of p_commit
4224: IF FND_API.To_Boolean( p_commit ) THEN
4225: COMMIT WORK;
4226: END IF;
4227:

Line 4294: -- Standard Start of API savepoint

4290: BEGIN
4291: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4292: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered Create_Unassigned_Section');
4293: END IF;
4294: -- Standard Start of API savepoint
4295: SAVEPOINT g_Create_Unassigned_Section;
4296: -- Standard call to check for call compatibility.
4297: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4292: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Entered Create_Unassigned_Section');
4293: END IF;
4294: -- Standard Start of API savepoint
4295: SAVEPOINT g_Create_Unassigned_Section;
4296: -- Standard call to check for call compatibility.
4297: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4299: END IF;
4300: -- Initialize message list if p_init_msg_list is set to TRUE.

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

4393:
4394: IF FND_API.To_Boolean( p_commit ) THEN
4395: COMMIT WORK;
4396: END IF;
4397: -- Standard call to get message count and if count is 1, get message info.
4398: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4399: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4400: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving Create_Unassigned_Section');
4401: END IF;