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_ALLOWED_TMPL_USAGES_GRP dependencies on OKC_ALLOWED_TMPL_USAGES

Line 1: PACKAGE BODY OKC_ALLOWED_TMPL_USAGES_GRP AS

1: PACKAGE BODY OKC_ALLOWED_TMPL_USAGES_GRP AS
2: /* $Header: OKCGALDTMPLUSGB.pls 120.0 2005/05/26 09:52:56 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

Line 13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ALLOWED_TMPL_USAGES_GRP';

9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
10: ---------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ALLOWED_TMPL_USAGES_GRP';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15:
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS

Line 94: OKC_ALLOWED_TMPL_USAGES_PVT.Validate_Row(

90:
91: --------------------------------------------
92: -- Calling Simple API for Validation
93: --------------------------------------------
94: OKC_ALLOWED_TMPL_USAGES_PVT.Validate_Row(
95: p_validation_level => p_validation_level,
96: x_return_status => x_return_status,
97: p_template_id => p_template_id,
98: p_document_type => p_document_type,

Line 206: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE := 1;

202: ) IS
203:
204: l_api_version CONSTANT NUMBER := 1;
205: l_api_name CONSTANT VARCHAR2(30) := 'g_Lock_Allowed_Tmpl_Usages';
206: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE := 1;
207: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
208: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
209: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
210: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;

Line 207: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;

203:
204: l_api_version CONSTANT NUMBER := 1;
205: l_api_name CONSTANT VARCHAR2(30) := 'g_Lock_Allowed_Tmpl_Usages';
206: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE := 1;
207: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
208: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
209: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
210: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
211: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;

Line 208: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;

204: l_api_version CONSTANT NUMBER := 1;
205: l_api_name CONSTANT VARCHAR2(30) := 'g_Lock_Allowed_Tmpl_Usages';
206: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE := 1;
207: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
208: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
209: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
210: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
211: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
212: BEGIN

Line 209: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;

205: l_api_name CONSTANT VARCHAR2(30) := 'g_Lock_Allowed_Tmpl_Usages';
206: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE := 1;
207: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
208: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
209: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
210: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
211: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
212: BEGIN
213:

Line 210: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;

206: l_object_version_number OKC_ALLOWED_TMPL_USAGES.OBJECT_VERSION_NUMBER%TYPE := 1;
207: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
208: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
209: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
210: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
211: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
212: BEGIN
213:
214: IF (l_debug = 'Y') THEN

Line 211: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;

207: l_created_by OKC_ALLOWED_TMPL_USAGES.CREATED_BY%TYPE;
208: l_creation_date OKC_ALLOWED_TMPL_USAGES.CREATION_DATE%TYPE;
209: l_last_updated_by OKC_ALLOWED_TMPL_USAGES.LAST_UPDATED_BY%TYPE;
210: l_last_update_login OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_LOGIN%TYPE;
211: l_last_update_date OKC_ALLOWED_TMPL_USAGES.LAST_UPDATE_DATE%TYPE;
212: BEGIN
213:
214: IF (l_debug = 'Y') THEN
215: okc_debug.log('600: Entered Create_Allowed_Tmpl_Usages', 2);

Line 234: OKC_ALLOWED_TMPL_USAGES_PVT.Insert_Row(

230:
231: --------------------------------------------
232: -- Calling Simple API for Creating A Row
233: --------------------------------------------
234: OKC_ALLOWED_TMPL_USAGES_PVT.Insert_Row(
235: p_validation_level => p_validation_level,
236: x_return_status => x_return_status,
237: p_template_id => p_template_id,
238: p_document_type => p_document_type,

Line 346: OKC_ALLOWED_TMPL_USAGES_PVT.lock_row(

342:
343: --------------------------------------------
344: -- Calling Simple API for Locking A Row
345: --------------------------------------------
346: OKC_ALLOWED_TMPL_USAGES_PVT.lock_row(
347: x_return_status => x_return_status,
348: p_allowed_tmpl_usages_id => p_allowed_tmpl_usages_id,
349: p_object_version_number => p_object_version_number
350: );

Line 461: OKC_ALLOWED_TMPL_USAGES_PVT.Update_Row(

457:
458: --------------------------------------------
459: -- Calling Simple API for Updating A Row
460: --------------------------------------------
461: OKC_ALLOWED_TMPL_USAGES_PVT.Update_Row(
462: p_validation_level => p_validation_level,
463: x_return_status => x_return_status,
464: p_template_id => p_template_id,
465: p_document_type => p_document_type,

Line 575: OKC_ALLOWED_TMPL_USAGES_PVT.Delete_Row(

571:
572: --------------------------------------------
573: -- Calling Simple API for Deleting A Row
574: --------------------------------------------
575: OKC_ALLOWED_TMPL_USAGES_PVT.Delete_Row(
576: x_return_status => x_return_status,
577: p_allowed_tmpl_usages_id => p_allowed_tmpl_usages_id,
578: p_object_version_number => p_object_version_number
579: );

Line 630: END OKC_ALLOWED_TMPL_USAGES_GRP;

626: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
627:
628: END Delete_Allowed_Tmpl_Usages;
629:
630: END OKC_ALLOWED_TMPL_USAGES_GRP;