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_TEMPLATE_USAGES_GRP dependencies on OKC_TEMPLATE_USAGES

Line 1: PACKAGE BODY OKC_TEMPLATE_USAGES_GRP AS

1: PACKAGE BODY OKC_TEMPLATE_USAGES_GRP AS
2: /* $Header: OKCGTMPLUSGB.pls 120.2 2005/12/23 11:59:20 vnanjang noship $ */
3:
4:
5: ---------------------------------------------------------------------------

Line 12: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TEMPLATE_USAGES_GRP';

8: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
9: ---------------------------------------------------------------------------
10: -- GLOBAL VARIABLES
11: ---------------------------------------------------------------------------
12: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TEMPLATE_USAGES_GRP';
13: G_MODULE CONSTANT VARCHAR2(200) := 'okc.plsq.'||G_PKG_NAME||'.';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15: G_INTERNAL_PARTY_CODE CONSTANT VARCHAR2(30) := 'INTERNAL_ORG';
16:

Line 76: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%type;

72:
73: ) IS
74: l_api_version CONSTANT NUMBER := 1;
75: l_api_name CONSTANT VARCHAR2(30) := 'g_validate_row';
76: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%type;
77:
78: BEGIN
79:
80: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 109: OKC_TEMPLATE_USAGES_PVT.Validate_Row(

105:
106: --------------------------------------------
107: -- Calling Simple API for Validation
108: --------------------------------------------
109: OKC_TEMPLATE_USAGES_PVT.Validate_Row(
110: p_validation_level => p_validation_level,
111: x_return_status => x_return_status,
112: p_document_type => p_document_type,
113: p_document_id => p_document_id,

Line 228: l_object_version_number OKC_TEMPLATE_USAGES.OBJECT_VERSION_NUMBER%TYPE := 1;

224: ) IS
225:
226: l_api_version CONSTANT NUMBER := 1;
227: l_api_name CONSTANT VARCHAR2(30) := 'create_template_usages';
228: l_object_version_number OKC_TEMPLATE_USAGES.OBJECT_VERSION_NUMBER%TYPE := 1;
229: l_created_by OKC_TEMPLATE_USAGES.CREATED_BY%TYPE;
230: l_creation_date OKC_TEMPLATE_USAGES.CREATION_DATE%TYPE;
231: l_last_updated_by OKC_TEMPLATE_USAGES.LAST_UPDATED_BY%TYPE;
232: l_last_update_login OKC_TEMPLATE_USAGES.LAST_UPDATE_LOGIN%TYPE;

Line 229: l_created_by OKC_TEMPLATE_USAGES.CREATED_BY%TYPE;

225:
226: l_api_version CONSTANT NUMBER := 1;
227: l_api_name CONSTANT VARCHAR2(30) := 'create_template_usages';
228: l_object_version_number OKC_TEMPLATE_USAGES.OBJECT_VERSION_NUMBER%TYPE := 1;
229: l_created_by OKC_TEMPLATE_USAGES.CREATED_BY%TYPE;
230: l_creation_date OKC_TEMPLATE_USAGES.CREATION_DATE%TYPE;
231: l_last_updated_by OKC_TEMPLATE_USAGES.LAST_UPDATED_BY%TYPE;
232: l_last_update_login OKC_TEMPLATE_USAGES.LAST_UPDATE_LOGIN%TYPE;
233: l_last_update_date OKC_TEMPLATE_USAGES.LAST_UPDATE_DATE%TYPE;

Line 230: l_creation_date OKC_TEMPLATE_USAGES.CREATION_DATE%TYPE;

226: l_api_version CONSTANT NUMBER := 1;
227: l_api_name CONSTANT VARCHAR2(30) := 'create_template_usages';
228: l_object_version_number OKC_TEMPLATE_USAGES.OBJECT_VERSION_NUMBER%TYPE := 1;
229: l_created_by OKC_TEMPLATE_USAGES.CREATED_BY%TYPE;
230: l_creation_date OKC_TEMPLATE_USAGES.CREATION_DATE%TYPE;
231: l_last_updated_by OKC_TEMPLATE_USAGES.LAST_UPDATED_BY%TYPE;
232: l_last_update_login OKC_TEMPLATE_USAGES.LAST_UPDATE_LOGIN%TYPE;
233: l_last_update_date OKC_TEMPLATE_USAGES.LAST_UPDATE_DATE%TYPE;
234: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%type;

Line 231: l_last_updated_by OKC_TEMPLATE_USAGES.LAST_UPDATED_BY%TYPE;

227: l_api_name CONSTANT VARCHAR2(30) := 'create_template_usages';
228: l_object_version_number OKC_TEMPLATE_USAGES.OBJECT_VERSION_NUMBER%TYPE := 1;
229: l_created_by OKC_TEMPLATE_USAGES.CREATED_BY%TYPE;
230: l_creation_date OKC_TEMPLATE_USAGES.CREATION_DATE%TYPE;
231: l_last_updated_by OKC_TEMPLATE_USAGES.LAST_UPDATED_BY%TYPE;
232: l_last_update_login OKC_TEMPLATE_USAGES.LAST_UPDATE_LOGIN%TYPE;
233: l_last_update_date OKC_TEMPLATE_USAGES.LAST_UPDATE_DATE%TYPE;
234: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%type;
235:

Line 232: l_last_update_login OKC_TEMPLATE_USAGES.LAST_UPDATE_LOGIN%TYPE;

228: l_object_version_number OKC_TEMPLATE_USAGES.OBJECT_VERSION_NUMBER%TYPE := 1;
229: l_created_by OKC_TEMPLATE_USAGES.CREATED_BY%TYPE;
230: l_creation_date OKC_TEMPLATE_USAGES.CREATION_DATE%TYPE;
231: l_last_updated_by OKC_TEMPLATE_USAGES.LAST_UPDATED_BY%TYPE;
232: l_last_update_login OKC_TEMPLATE_USAGES.LAST_UPDATE_LOGIN%TYPE;
233: l_last_update_date OKC_TEMPLATE_USAGES.LAST_UPDATE_DATE%TYPE;
234: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%type;
235:
236: BEGIN

Line 233: l_last_update_date OKC_TEMPLATE_USAGES.LAST_UPDATE_DATE%TYPE;

229: l_created_by OKC_TEMPLATE_USAGES.CREATED_BY%TYPE;
230: l_creation_date OKC_TEMPLATE_USAGES.CREATION_DATE%TYPE;
231: l_last_updated_by OKC_TEMPLATE_USAGES.LAST_UPDATED_BY%TYPE;
232: l_last_update_login OKC_TEMPLATE_USAGES.LAST_UPDATE_LOGIN%TYPE;
233: l_last_update_date OKC_TEMPLATE_USAGES.LAST_UPDATE_DATE%TYPE;
234: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%type;
235:
236: BEGIN
237:

Line 234: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%type;

230: l_creation_date OKC_TEMPLATE_USAGES.CREATION_DATE%TYPE;
231: l_last_updated_by OKC_TEMPLATE_USAGES.LAST_UPDATED_BY%TYPE;
232: l_last_update_login OKC_TEMPLATE_USAGES.LAST_UPDATE_LOGIN%TYPE;
233: l_last_update_date OKC_TEMPLATE_USAGES.LAST_UPDATE_DATE%TYPE;
234: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%type;
235:
236: BEGIN
237:
238: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 269: OKC_TEMPLATE_USAGES_PVT.Insert_Row(

265:
266: --------------------------------------------
267: -- Calling Simple API for Creating A Row
268: --------------------------------------------
269: OKC_TEMPLATE_USAGES_PVT.Insert_Row(
270: p_validation_level => p_validation_level,
271: x_return_status => x_return_status,
272: p_document_type => p_document_type,
273: p_document_id => p_document_id,

Line 387: OKC_TEMPLATE_USAGES_PVT.lock_row(

383:
384: --------------------------------------------
385: -- Calling Simple API for Locking A Row
386: --------------------------------------------
387: OKC_TEMPLATE_USAGES_PVT.lock_row(
388: x_return_status => x_return_status,
389: p_document_type => p_document_type,
390: p_document_id => p_document_id,
391: p_object_version_number => p_object_version_number

Line 506: OKC_TEMPLATE_USAGES_PVT.Update_Row(

502:
503: --------------------------------------------
504: -- Calling Simple API for Updating A Row
505: --------------------------------------------
506: OKC_TEMPLATE_USAGES_PVT.Update_Row(
507: p_validation_level => p_validation_level,
508: x_return_status => x_return_status,
509: p_document_type => p_document_type,
510: p_document_id => p_document_id,

Line 623: OKC_TEMPLATE_USAGES_PVT.Delete_Row(

619:
620: --------------------------------------------
621: -- Calling Simple API for Deleting A Row
622: --------------------------------------------
623: OKC_TEMPLATE_USAGES_PVT.Delete_Row(
624: x_return_status => x_return_status,
625: p_document_type => p_document_type,
626: p_document_id => p_document_id,
627: p_object_version_number => p_object_version_number

Line 699: l_document_type OKC_TEMPLATE_USAGES.DOCUMENT_TYPE%TYPE;

695: ) IS
696: l_api_version CONSTANT NUMBER := 1;
697: l_api_name CONSTANT VARCHAR2(30) := 'g_Set_Contract_Source';
698: l_value VARCHAR2(1) := 'N';
699: l_document_type OKC_TEMPLATE_USAGES.DOCUMENT_TYPE%TYPE;
700: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE;
701: l_contract_source_code VARCHAR2(30);
702: l_authoring_party_code VARCHAR2(30);
703:

Line 700: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE;

696: l_api_version CONSTANT NUMBER := 1;
697: l_api_name CONSTANT VARCHAR2(30) := 'g_Set_Contract_Source';
698: l_value VARCHAR2(1) := 'N';
699: l_document_type OKC_TEMPLATE_USAGES.DOCUMENT_TYPE%TYPE;
700: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE;
701: l_contract_source_code VARCHAR2(30);
702: l_authoring_party_code VARCHAR2(30);
703:
704: CURSOR l_template_usages_csr IS

Line 706: FROM OKC_TEMPLATE_USAGES

702: l_authoring_party_code VARCHAR2(30);
703:
704: CURSOR l_template_usages_csr IS
705: SELECT 'Y'
706: FROM OKC_TEMPLATE_USAGES
707: WHERE document_id = p_document_id
708: AND document_type = p_document_type;
709:
710: CURSOR l_template_usages_details_csr IS

Line 713: FROM OKC_TEMPLATE_USAGES

709:
710: CURSOR l_template_usages_details_csr IS
711: SELECT contract_source_code,
712: authoring_party_code
713: FROM OKC_TEMPLATE_USAGES
714: WHERE document_type = p_document_type
715: AND document_id = p_document_id;
716:
717: BEGIN

Line 786: OKC_TEMPLATE_USAGES_PVT.update_row(

782: END IF;
783:
784: IF l_value = 'Y' THEN
785: --update existing template usages record.
786: OKC_TEMPLATE_USAGES_PVT.update_row(
787: x_return_status => x_return_status ,
788:
789: p_document_type => p_document_type ,
790: p_document_id => p_document_id ,

Line 797: OKC_TEMPLATE_USAGES_PVT.insert_row(

793: p_document_number => p_document_number);
794:
795: ELSE
796: --create new template usages record
797: OKC_TEMPLATE_USAGES_PVT.insert_row(
798: x_return_status => x_return_status,
799:
800: p_document_type => p_document_type ,
801: p_document_id => p_document_id ,

Line 891: l_document_type OKC_TEMPLATE_USAGES.DOCUMENT_TYPE%TYPE;

887: ) IS
888: l_api_version CONSTANT NUMBER := 1;
889: l_api_name CONSTANT VARCHAR2(30) := 'g_Set_Contract_Source_details';
890: l_value VARCHAR2(1) := 'N';
891: l_document_type OKC_TEMPLATE_USAGES.DOCUMENT_TYPE%TYPE;
892: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE;
893: l_contract_source_code OKC_TEMPLATE_USAGES.contract_source_code%TYPE;
894: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%TYPE;
895:

Line 892: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE;

888: l_api_version CONSTANT NUMBER := 1;
889: l_api_name CONSTANT VARCHAR2(30) := 'g_Set_Contract_Source_details';
890: l_value VARCHAR2(1) := 'N';
891: l_document_type OKC_TEMPLATE_USAGES.DOCUMENT_TYPE%TYPE;
892: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE;
893: l_contract_source_code OKC_TEMPLATE_USAGES.contract_source_code%TYPE;
894: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%TYPE;
895:
896: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;

Line 893: l_contract_source_code OKC_TEMPLATE_USAGES.contract_source_code%TYPE;

889: l_api_name CONSTANT VARCHAR2(30) := 'g_Set_Contract_Source_details';
890: l_value VARCHAR2(1) := 'N';
891: l_document_type OKC_TEMPLATE_USAGES.DOCUMENT_TYPE%TYPE;
892: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE;
893: l_contract_source_code OKC_TEMPLATE_USAGES.contract_source_code%TYPE;
894: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%TYPE;
895:
896: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;
897: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;

Line 894: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%TYPE;

890: l_value VARCHAR2(1) := 'N';
891: l_document_type OKC_TEMPLATE_USAGES.DOCUMENT_TYPE%TYPE;
892: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE;
893: l_contract_source_code OKC_TEMPLATE_USAGES.contract_source_code%TYPE;
894: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%TYPE;
895:
896: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;
897: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;
898: CURSOR l_template_usages_csr IS

Line 896: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;

892: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE;
893: l_contract_source_code OKC_TEMPLATE_USAGES.contract_source_code%TYPE;
894: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%TYPE;
895:
896: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;
897: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;
898: CURSOR l_template_usages_csr IS
899: SELECT 'Y'
900: FROM OKC_TEMPLATE_USAGES

Line 897: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;

893: l_contract_source_code OKC_TEMPLATE_USAGES.contract_source_code%TYPE;
894: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%TYPE;
895:
896: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;
897: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;
898: CURSOR l_template_usages_csr IS
899: SELECT 'Y'
900: FROM OKC_TEMPLATE_USAGES
901: WHERE document_id = p_document_id

Line 900: FROM OKC_TEMPLATE_USAGES

896: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;
897: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;
898: CURSOR l_template_usages_csr IS
899: SELECT 'Y'
900: FROM OKC_TEMPLATE_USAGES
901: WHERE document_id = p_document_id
902: AND document_type = p_document_type;
903:
904: CURSOR l_template_usages_details_csr IS

Line 907: FROM OKC_TEMPLATE_USAGES

903:
904: CURSOR l_template_usages_details_csr IS
905: SELECT contract_source_code,
906: authoring_party_code
907: FROM OKC_TEMPLATE_USAGES
908: WHERE document_type = p_document_type
909: AND document_id = p_document_id;
910:
911: BEGIN

Line 971: OKC_TEMPLATE_USAGES_PVT.update_row(

967: END IF;
968:
969: IF l_value = 'Y' THEN
970: --update existing template usages record.
971: OKC_TEMPLATE_USAGES_PVT.update_row(
972: x_return_status => x_return_status ,
973:
974: p_document_type => p_document_type ,
975: p_document_id => p_document_id ,

Line 999: OKC_TEMPLATE_USAGES_PVT.insert_row(

995: l_legal_contact_id := null;
996: end if;
997:
998:
999: OKC_TEMPLATE_USAGES_PVT.insert_row(
1000: x_return_status => x_return_status,
1001:
1002: p_document_type => p_document_type ,
1003: p_document_id => p_document_id ,

Line 1072: END OKC_TEMPLATE_USAGES_GRP;

1068: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1069:
1070: END Set_Contract_Source_details;
1071:
1072: END OKC_TEMPLATE_USAGES_GRP;