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.3.12020000.2 2012/07/18 10:17:25 harchand ship $ */
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 229: l_object_version_number OKC_TEMPLATE_USAGES.OBJECT_VERSION_NUMBER%TYPE := 1;

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

Line 230: l_created_by OKC_TEMPLATE_USAGES.CREATED_BY%TYPE;

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

Line 231: l_creation_date OKC_TEMPLATE_USAGES.CREATION_DATE%TYPE;

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

Line 232: l_last_updated_by OKC_TEMPLATE_USAGES.LAST_UPDATED_BY%TYPE;

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

Line 233: l_last_update_login OKC_TEMPLATE_USAGES.LAST_UPDATE_LOGIN%TYPE;

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

Line 234: l_last_update_date OKC_TEMPLATE_USAGES.LAST_UPDATE_DATE%TYPE;

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

Line 235: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%type;

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

Line 270: OKC_TEMPLATE_USAGES_PVT.Insert_Row(

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

Line 389: OKC_TEMPLATE_USAGES_PVT.lock_row(

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

Line 508: OKC_TEMPLATE_USAGES_PVT.Update_Row(

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

Line 625: OKC_TEMPLATE_USAGES_PVT.Delete_Row(

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

Line 701: l_document_type OKC_TEMPLATE_USAGES.DOCUMENT_TYPE%TYPE;

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

Line 702: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE;

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

Line 708: FROM OKC_TEMPLATE_USAGES

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

Line 715: FROM OKC_TEMPLATE_USAGES

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

Line 788: OKC_TEMPLATE_USAGES_PVT.update_row(

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

Line 799: OKC_TEMPLATE_USAGES_PVT.insert_row(

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

Line 893: l_document_type OKC_TEMPLATE_USAGES.DOCUMENT_TYPE%TYPE;

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

Line 894: l_document_id OKC_TEMPLATE_USAGES.DOCUMENT_ID%TYPE;

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

Line 895: l_contract_source_code OKC_TEMPLATE_USAGES.contract_source_code%TYPE;

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

Line 896: l_authoring_party_code OKC_TEMPLATE_USAGES.authoring_party_code%TYPE;

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

Line 898: l_contract_admin_id OKC_TEMPLATE_USAGES.CONTRACT_ADMIN_ID%TYPE;

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

Line 899: l_legal_contact_id OKC_TEMPLATE_USAGES.LEGAL_CONTACT_ID%TYPE;

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

Line 902: FROM OKC_TEMPLATE_USAGES

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

Line 909: FROM OKC_TEMPLATE_USAGES

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

Line 973: OKC_TEMPLATE_USAGES_PVT.update_row(

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

Line 1001: OKC_TEMPLATE_USAGES_PVT.insert_row(

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

Line 1074: END OKC_TEMPLATE_USAGES_GRP;

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