[Home] [Help]
55: x_template_id OUT NOCOPY NUMBER
56: ) RETURN VARCHAR2 IS
57: l_api_name CONSTANT VARCHAR2(30) := 'Get_Seq_Id';
58: CURSOR l_seq_csr IS
59: SELECT OKC_TERMS_TEMPLATES_ALL_S.NEXTVAL FROM DUAL;
60: BEGIN
61: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
62: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered get_seq_id');
63: END IF;
97:
98: END Get_Seq_Id;
99:
100: ---------------------------------------------------------------------------
101: -- FUNCTION get_rec for: OKC_TERMS_TEMPLATES_ALL
102: ---------------------------------------------------------------------------
103: FUNCTION Get_Rec (
104: p_template_id IN NUMBER,
105:
151: x_language OUT NOCOPY VARCHAR2
152:
153: ) RETURN VARCHAR2 IS
154: l_api_name CONSTANT VARCHAR2(30) := 'get_rec';
155: CURSOR OKC_TERMS_TEMPLATES_ALL_pk_csr (cp_template_id IN NUMBER) IS
156: SELECT
157: TEMPLATE_NAME,
158: WORKING_COPY_FLAG,
159: INTENT,
200: LAST_UPDATE_DATE,
201: --MLS for templates
202: TRANSLATED_FROM_TMPL_ID,
203: LANGUAGE
204: FROM OKC_TERMS_TEMPLATES_ALL t
205: WHERE t.TEMPLATE_ID = cp_template_id;
206: BEGIN
207:
208: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
209: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: Entered get_rec');
210: END IF;
211:
212: -- Get current database values
213: OPEN OKC_TERMS_TEMPLATES_ALL_pk_csr (p_template_id);
214: FETCH OKC_TERMS_TEMPLATES_ALL_pk_csr INTO
215: x_template_name,
216: x_working_copy_flag,
217: x_intent,
210: END IF;
211:
212: -- Get current database values
213: OPEN OKC_TERMS_TEMPLATES_ALL_pk_csr (p_template_id);
214: FETCH OKC_TERMS_TEMPLATES_ALL_pk_csr INTO
215: x_template_name,
216: x_working_copy_flag,
217: x_intent,
218: x_status_code,
258: x_last_update_date,
259: --MLS for templates
260: x_translated_from_tmpl_id,
261: x_language ;
262: IF OKC_TERMS_TEMPLATES_ALL_pk_csr%NOTFOUND THEN
263: RAISE NO_DATA_FOUND;
264: END IF;
265: CLOSE OKC_TERMS_TEMPLATES_ALL_pk_csr;
266:
261: x_language ;
262: IF OKC_TERMS_TEMPLATES_ALL_pk_csr%NOTFOUND THEN
263: RAISE NO_DATA_FOUND;
264: END IF;
265: CLOSE OKC_TERMS_TEMPLATES_ALL_pk_csr;
266:
267: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
268: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'500: Leaving get_rec ');
269: END IF;
283: p_token1_value => sqlcode,
284: p_token2 => G_SQLERRM_TOKEN,
285: p_token2_value => sqlerrm);
286:
287: IF OKC_TERMS_TEMPLATES_ALL_pk_csr%ISOPEN THEN
288: CLOSE OKC_TERMS_TEMPLATES_ALL_pk_csr;
289: END IF;
290:
291: RETURN G_RET_STS_UNEXP_ERROR ;
284: p_token2 => G_SQLERRM_TOKEN,
285: p_token2_value => sqlerrm);
286:
287: IF OKC_TERMS_TEMPLATES_ALL_pk_csr%ISOPEN THEN
288: CLOSE OKC_TERMS_TEMPLATES_ALL_pk_csr;
289: END IF;
290:
291: RETURN G_RET_STS_UNEXP_ERROR ;
292:
292:
293: END Get_Rec;
294:
295: -----------------------------------------
296: -- Set_Attributes for:OKC_TERMS_TEMPLATES_ALL --
297: -----------------------------------------
298: FUNCTION Set_Attributes(
299: p_template_name IN VARCHAR2,
300: p_template_id IN NUMBER,
382: x_language OUT NOCOPY VARCHAR2
383: ) RETURN VARCHAR2 IS
384: l_api_name CONSTANT VARCHAR2(30) := 'set_attributes';
385: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
386: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
387: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
388: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
389: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
390: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
383: ) RETURN VARCHAR2 IS
384: l_api_name CONSTANT VARCHAR2(30) := 'set_attributes';
385: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
386: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
387: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
388: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
389: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
390: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
391: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
384: l_api_name CONSTANT VARCHAR2(30) := 'set_attributes';
385: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
386: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
387: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
388: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
389: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
390: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
391: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
392: BEGIN
385: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
386: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
387: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
388: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
389: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
390: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
391: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
392: BEGIN
393: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
386: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
387: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
388: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
389: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
390: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
391: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
392: BEGIN
393: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
394: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Entered Set_Attributes ');
387: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
388: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
389: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
390: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
391: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
392: BEGIN
393: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
394: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Entered Set_Attributes ');
395: END IF;
725:
726: END Set_Attributes ;
727:
728: ----------------------------------------------
729: -- Validate_Attributes for: OKC_TERMS_TEMPLATES_ALL --
730: ----------------------------------------------
731: FUNCTION Validate_Attributes (
732: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
733:
783: l_apps_user VARCHAR2(150);
784: l_layout_start_date DATE;
785: l_layout_end_date DATE;
786: l_eff_date DATE;
787: l_tmpl_status okc_terms_templates_all.status_code%TYPE := 'ZZZ';
788: l_validate_layout VARCHAR2(1) := 'Y';
789:
790: CURSOR l_apps_user_csr IS
791: SELECT oracle_username
799: AND owner = pc_user;
800:
801: CURSOR l_parent_template_id_csr is
802: SELECT '!'
803: FROM okc_terms_templates_all
804: WHERE TEMPLATE_ID = p_parent_template_id;
805:
806: /***************Commented out to remove XDO dependency
807: CURSOR l_print_template_id_csr is
823: WHERE ORGANIZATION_ID = p_org_id;
824:
825: CURSOR l_tmpl_status_csr(pc_template_id NUMBER) IS
826: SELECT status_code
827: FROM OKC_TERMS_TEMPLATES_ALL
828: WHERE template_id = pc_template_id;
829:
830:
831: BEGIN
1089: -- PROCEDURE Validate_Record
1090: -- It calls Item Level Validations and then makes Record Level Validations
1091: ---------------------------------------------------------------------------
1092: ------------------------------------------
1093: -- Validate_Record for:OKC_TERMS_TEMPLATES_ALL --
1094: ------------------------------------------
1095: FUNCTION Validate_Record (
1096: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1097:
1139: ) RETURN VARCHAR2 IS
1140: l_api_name CONSTANT VARCHAR2(30) := 'validate_record';
1141: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1142: l_dummy_var VARCHAR2(1) := '?';
1143: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
1144:
1145: CURSOR l_tmpl_name_csr is
1146: SELECT '!'
1147: FROM okc_terms_templates_all
1143: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
1144:
1145: CURSOR l_tmpl_name_csr is
1146: SELECT '!'
1147: FROM okc_terms_templates_all
1148: WHERE template_name = p_template_name
1149: AND nvl(working_copy_flag,'N') = nvl(p_working_copy_flag,'N')
1150: AND ((p_template_id IS NULL) OR (p_template_id <> template_id))
1151: AND ORG_ID = mo_global.get_current_org_id();
1151: AND ORG_ID = mo_global.get_current_org_id();
1152: --MLS for templates
1153: CURSOR l_primary_tmpl_csr IS
1154: SELECT '!'
1155: FROM okc_terms_templates_all
1156: WHERE translated_from_tmpl_id = p_template_id
1157: UNION ALL
1158: SELECT '!'
1159: FROM okc_terms_templates_all
1155: FROM okc_terms_templates_all
1156: WHERE translated_from_tmpl_id = p_template_id
1157: UNION ALL
1158: SELECT '!'
1159: FROM okc_terms_templates_all
1160: WHERE translated_from_tmpl_id = p_parent_template_id ;
1161: --MLS for templates
1162: CURSOR l_tmpl_group1_csr IS
1163: SELECT '!', template_name
1160: WHERE translated_from_tmpl_id = p_parent_template_id ;
1161: --MLS for templates
1162: CURSOR l_tmpl_group1_csr IS
1163: SELECT '!', template_name
1164: FROM okc_terms_templates_all
1165: WHERE translated_from_tmpl_id= p_parent_template_id
1166: AND language = p_language;
1167:
1168: --MLS for templates
1167:
1168: --MLS for templates
1169: CURSOR l_tmpl_group2_csr IS
1170: SELECT '!', template_name
1171: FROM okc_terms_templates_all
1172: WHERE translated_from_tmpl_id= p_template_id
1173: AND language = p_language;
1174:
1175: --MLS for templates
1174:
1175: --MLS for templates
1176: CURSOR l_tmpl_group3_csr IS
1177: SELECT '!', tta.template_name
1178: FROM okc_terms_templates_all tta
1179: WHERE tta.template_id = p_translated_from_tmpl_id
1180: AND language = p_language
1181: UNION ALL
1182: SELECT '!', tta.template_name
1179: WHERE tta.template_id = p_translated_from_tmpl_id
1180: AND language = p_language
1181: UNION ALL
1182: SELECT '!', tta.template_name
1183: FROM okc_terms_templates_all tta
1184: WHERE tta.parent_template_id = p_translated_from_tmpl_id
1185: AND language = p_language
1186: UNION ALL
1187: SELECT '!', tta.template_name
1184: WHERE tta.parent_template_id = p_translated_from_tmpl_id
1185: AND language = p_language
1186: UNION ALL
1187: SELECT '!', tta.template_name
1188: FROM okc_terms_templates_all tta
1189: WHERE tta.translated_from_tmpl_id = p_translated_from_tmpl_id
1190: AND tta.language = p_language
1191: AND tta.template_id <> p_template_id
1192: AND tta.template_id <> nvl(p_parent_template_id,0)
1191: AND tta.template_id <> p_template_id
1192: AND tta.template_id <> nvl(p_parent_template_id,0)
1193: AND not exists
1194: (SELECT 1
1195: FROM okc_terms_templates_all tta3
1196: WHERE tta3.template_id = tta.template_id
1197: AND tta3.parent_template_id = p_template_id) ;
1198:
1199:
1415: ---------------------------------------------------------------------------
1416: -- PROCEDURE validate_row
1417: ---------------------------------------------------------------------------
1418: ---------------------------------------
1419: -- validate_row for:OKC_TERMS_TEMPLATES_ALL --
1420: ---------------------------------------
1421: PROCEDURE validate_row(
1422: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1423:
1467: p_language IN VARCHAR2,
1468: p_object_version_number IN NUMBER
1469: ) IS
1470: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1471: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
1472: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
1473: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
1474: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
1475: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1468: p_object_version_number IN NUMBER
1469: ) IS
1470: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1471: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
1472: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
1473: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
1474: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
1475: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1476: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1469: ) IS
1470: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1471: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
1472: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
1473: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
1474: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
1475: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1476: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1477: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1470: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1471: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
1472: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
1473: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
1474: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
1475: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1476: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1477: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1478: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1471: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
1472: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
1473: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
1474: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
1475: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1476: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1477: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1478: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1479: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
1472: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
1473: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
1474: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
1475: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1476: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1477: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1478: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1479: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
1480: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
1473: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
1474: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
1475: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1476: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1477: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1478: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1479: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
1480: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
1481: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE;
1474: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
1475: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1476: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1477: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1478: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1479: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
1480: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
1481: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE;
1482: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE;
1475: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1476: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1477: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1478: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1479: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
1480: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
1481: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE;
1482: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE;
1483: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
1476: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1477: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1478: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1479: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
1480: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
1481: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE;
1482: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE;
1483: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
1484: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
1477: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1478: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1479: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
1480: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
1481: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE;
1482: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE;
1483: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
1484: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
1485: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
1478: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1479: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
1480: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
1481: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE;
1482: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE;
1483: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
1484: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
1485: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
1486: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
1479: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
1480: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
1481: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE;
1482: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE;
1483: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
1484: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
1485: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
1486: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
1487: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
1480: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
1481: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE;
1482: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE;
1483: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
1484: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
1485: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
1486: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
1487: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
1488: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
1481: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE;
1482: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE;
1483: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
1484: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
1485: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
1486: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
1487: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
1488: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
1489: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1482: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE;
1483: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
1484: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
1485: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
1486: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
1487: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
1488: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
1489: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1490: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1483: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
1484: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
1485: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
1486: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
1487: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
1488: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
1489: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1490: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1491: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1484: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
1485: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
1486: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
1487: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
1488: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
1489: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1490: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1491: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1492: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
1485: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
1486: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
1487: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
1488: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
1489: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1490: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1491: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1492: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
1493: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1486: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
1487: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
1488: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
1489: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1490: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1491: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1492: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
1493: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1494: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
1487: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
1488: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
1489: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1490: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1491: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1492: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
1493: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1494: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
1495: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
1488: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
1489: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1490: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1491: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1492: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
1493: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1494: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
1495: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
1496: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
1489: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1490: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1491: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1492: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
1493: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1494: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
1495: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
1496: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
1497: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
1490: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1491: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1492: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
1493: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1494: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
1495: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
1496: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
1497: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
1498: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
1491: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1492: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
1493: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1494: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
1495: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
1496: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
1497: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
1498: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
1499: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
1492: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
1493: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1494: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
1495: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
1496: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
1497: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
1498: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
1499: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
1500: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
1493: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1494: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
1495: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
1496: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
1497: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
1498: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
1499: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
1500: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
1501: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
1494: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
1495: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
1496: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
1497: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
1498: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
1499: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
1500: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
1501: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
1502: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
1495: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
1496: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
1497: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
1498: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
1499: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
1500: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
1501: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
1502: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
1503: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
1496: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
1497: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
1498: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
1499: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
1500: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
1501: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
1502: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
1503: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
1504: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
1497: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
1498: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
1499: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
1500: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
1501: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
1502: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
1503: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
1504: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
1505: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
1498: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
1499: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
1500: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
1501: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
1502: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
1503: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
1504: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
1505: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
1506: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
1499: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
1500: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
1501: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
1502: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
1503: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
1504: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
1505: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
1506: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
1507: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
1500: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
1501: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
1502: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
1503: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
1504: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
1505: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
1506: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
1507: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
1508: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
1501: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
1502: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
1503: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
1504: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
1505: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
1506: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
1507: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
1508: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
1509: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1502: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
1503: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
1504: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
1505: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
1506: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
1507: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
1508: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
1509: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1510: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1503: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
1504: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
1505: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
1506: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
1507: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
1508: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
1509: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1510: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1511: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1504: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
1505: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
1506: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
1507: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
1508: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
1509: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1510: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1511: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1512: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1505: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
1506: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
1507: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
1508: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
1509: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1510: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1511: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1512: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1513: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1506: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
1507: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
1508: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
1509: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1510: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1511: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1512: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1513: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1514: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1507: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
1508: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
1509: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1510: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1511: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1512: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1513: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1514: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1515: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
1508: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
1509: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1510: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1511: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1512: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1513: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1514: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1515: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
1516: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
1509: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1510: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1511: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1512: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1513: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1514: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1515: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
1516: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
1517: BEGIN
1510: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1511: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1512: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1513: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1514: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1515: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
1516: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
1517: BEGIN
1518:
1511: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1512: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1513: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1514: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1515: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
1516: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
1517: BEGIN
1518:
1519: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1512: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1513: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1514: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1515: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
1516: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
1517: BEGIN
1518:
1519: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1520: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3100: Entered validate_row');
1693: ---------------------------------------------------------------------------
1694: -- PROCEDURE Insert_Row
1695: ---------------------------------------------------------------------------
1696: -------------------------------------
1697: -- Insert_Row for:OKC_TERMS_TEMPLATES_ALL --
1698: -------------------------------------
1699: FUNCTION Insert_Row(
1700: p_template_name IN VARCHAR2,
1701: p_template_id IN NUMBER,
1752: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1753: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3600: Entered Insert_Row function');
1754: END IF;
1755:
1756: INSERT INTO OKC_TERMS_TEMPLATES_ALL(
1757: TEMPLATE_NAME,
1758: TEMPLATE_ID,
1759: WORKING_COPY_FLAG,
1760: INTENT,
1877: END Insert_Row;
1878:
1879:
1880: -------------------------------------
1881: -- Insert_Row for:OKC_TERMS_TEMPLATES_ALL --
1882: -------------------------------------
1883: PROCEDURE Insert_Row(
1884: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1885: x_return_status OUT NOCOPY VARCHAR2,
1929: x_template_id OUT NOCOPY NUMBER
1930:
1931: ) IS
1932: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1933: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1934: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1935: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1936: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1937: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1930:
1931: ) IS
1932: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1933: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1934: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1935: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1936: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1937: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1938: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1931: ) IS
1932: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1933: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1934: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1935: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1936: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1937: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1938: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1939: BEGIN
1932: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1933: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1934: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1935: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1936: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1937: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1938: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1939: BEGIN
1940:
1933: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1934: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1935: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1936: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1937: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1938: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1939: BEGIN
1940:
1941: x_return_status := G_RET_STS_SUCCESS;
1934: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1935: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1936: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1937: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1938: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1939: BEGIN
1940:
1941: x_return_status := G_RET_STS_SUCCESS;
1942:
2119: ---------------------------------------------------------------------------
2120: -- PROCEDURE Lock_Row
2121: ---------------------------------------------------------------------------
2122: -----------------------------------
2123: -- Lock_Row for:OKC_TERMS_TEMPLATES_ALL --
2124: -----------------------------------
2125: FUNCTION Lock_Row(
2126: p_template_id IN NUMBER,
2127: p_object_version_number IN NUMBER
2131: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2132:
2133: CURSOR lock_csr (cp_template_id NUMBER, cp_object_version_number NUMBER) IS
2134: SELECT object_version_number
2135: FROM OKC_TERMS_TEMPLATES_ALL
2136: WHERE TEMPLATE_ID = cp_template_id
2137: AND ( object_version_number = cp_object_version_number
2138: OR cp_object_version_number IS NULL)
2139: FOR UPDATE OF object_version_number NOWAIT;
2139: FOR UPDATE OF object_version_number NOWAIT;
2140:
2141: CURSOR lchk_csr (cp_template_id NUMBER) IS
2142: SELECT object_version_number
2143: FROM OKC_TERMS_TEMPLATES_ALL
2144: WHERE TEMPLATE_ID = cp_template_id;
2145:
2146: l_return_status VARCHAR2(1);
2147:
2144: WHERE TEMPLATE_ID = cp_template_id;
2145:
2146: l_return_status VARCHAR2(1);
2147:
2148: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2149:
2150: l_row_notfound BOOLEAN := FALSE;
2151: BEGIN
2152:
2227: RETURN( G_RET_STS_UNEXP_ERROR );
2228: END Lock_Row;
2229:
2230: -----------------------------------
2231: -- Lock_Row for:OKC_TERMS_TEMPLATES_ALL --
2232: -----------------------------------
2233: PROCEDURE Lock_Row(
2234: x_return_status OUT NOCOPY VARCHAR2,
2235:
2292: ---------------------------------------------------------------------------
2293: -- PROCEDURE Update_Row
2294: ---------------------------------------------------------------------------
2295: -------------------------------------
2296: -- Update_Row for:OKC_TERMS_TEMPLATES_ALL --
2297: -------------------------------------
2298: FUNCTION Update_Row(
2299: p_template_name IN VARCHAR2,
2300: p_template_id IN NUMBER,
2351: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2352: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6400: Entered Update_Row');
2353: END IF;
2354:
2355: UPDATE OKC_TERMS_TEMPLATES_ALL
2356: SET TEMPLATE_NAME = p_template_name,
2357: WORKING_COPY_FLAG = NVL(p_working_copy_flag,'N'),
2358: INTENT = p_intent,
2359: STATUS_CODE = p_status_code,
2424:
2425: END Update_Row;
2426:
2427: -------------------------------------
2428: -- Update_Row for:OKC_TERMS_TEMPLATES_ALL --
2429: -------------------------------------
2430: PROCEDURE Update_Row(
2431: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2432:
2478: p_object_version_number IN NUMBER
2479:
2480: ) IS
2481: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
2482: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2483: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
2484: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
2485: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
2486: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2479:
2480: ) IS
2481: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
2482: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2483: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
2484: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
2485: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
2486: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2487: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2480: ) IS
2481: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
2482: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2483: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
2484: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
2485: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
2486: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2487: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2488: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2481: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
2482: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2483: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
2484: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
2485: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
2486: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2487: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2488: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2489: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2482: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2483: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
2484: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
2485: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
2486: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2487: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2488: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2489: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2490: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
2483: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
2484: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
2485: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
2486: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2487: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2488: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2489: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2490: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
2491: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
2484: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
2485: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
2486: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2487: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2488: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2489: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2490: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
2491: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
2492: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE; -- Added for 11.5.10+:Contract Expert Changes
2485: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
2486: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2487: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2488: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2489: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2490: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
2491: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
2492: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE; -- Added for 11.5.10+:Contract Expert Changes
2493: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE; -- Added for 11.5.10+: Contract Expert Changes
2486: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2487: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2488: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2489: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2490: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
2491: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
2492: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE; -- Added for 11.5.10+:Contract Expert Changes
2493: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE; -- Added for 11.5.10+: Contract Expert Changes
2494: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
2487: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2488: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2489: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2490: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
2491: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
2492: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE; -- Added for 11.5.10+:Contract Expert Changes
2493: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE; -- Added for 11.5.10+: Contract Expert Changes
2494: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
2495: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
2488: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2489: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2490: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
2491: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
2492: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE; -- Added for 11.5.10+:Contract Expert Changes
2493: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE; -- Added for 11.5.10+: Contract Expert Changes
2494: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
2495: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
2496: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
2489: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2490: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
2491: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
2492: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE; -- Added for 11.5.10+:Contract Expert Changes
2493: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE; -- Added for 11.5.10+: Contract Expert Changes
2494: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
2495: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
2496: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
2497: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
2490: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
2491: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
2492: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE; -- Added for 11.5.10+:Contract Expert Changes
2493: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE; -- Added for 11.5.10+: Contract Expert Changes
2494: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
2495: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
2496: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
2497: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
2498: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
2491: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
2492: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE; -- Added for 11.5.10+:Contract Expert Changes
2493: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE; -- Added for 11.5.10+: Contract Expert Changes
2494: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
2495: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
2496: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
2497: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
2498: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
2499: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
2492: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE; -- Added for 11.5.10+:Contract Expert Changes
2493: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE; -- Added for 11.5.10+: Contract Expert Changes
2494: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
2495: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
2496: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
2497: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
2498: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
2499: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
2500: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2493: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE; -- Added for 11.5.10+: Contract Expert Changes
2494: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
2495: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
2496: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
2497: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
2498: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
2499: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
2500: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2501: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2494: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
2495: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
2496: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
2497: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
2498: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
2499: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
2500: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2501: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2502: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2495: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
2496: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
2497: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
2498: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
2499: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
2500: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2501: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2502: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2503: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
2496: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
2497: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
2498: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
2499: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
2500: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2501: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2502: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2503: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
2504: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2497: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
2498: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
2499: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
2500: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2501: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2502: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2503: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
2504: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2505: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
2498: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
2499: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
2500: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2501: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2502: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2503: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
2504: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2505: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
2506: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
2499: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
2500: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2501: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2502: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2503: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
2504: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2505: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
2506: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
2507: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
2500: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2501: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2502: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2503: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
2504: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2505: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
2506: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
2507: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
2508: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
2501: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2502: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2503: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
2504: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2505: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
2506: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
2507: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
2508: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
2509: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
2502: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2503: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
2504: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2505: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
2506: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
2507: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
2508: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
2509: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
2510: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
2503: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
2504: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2505: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
2506: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
2507: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
2508: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
2509: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
2510: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
2511: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
2504: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2505: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
2506: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
2507: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
2508: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
2509: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
2510: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
2511: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
2512: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
2505: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
2506: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
2507: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
2508: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
2509: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
2510: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
2511: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
2512: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
2513: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
2506: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
2507: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
2508: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
2509: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
2510: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
2511: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
2512: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
2513: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
2514: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
2507: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
2508: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
2509: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
2510: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
2511: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
2512: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
2513: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
2514: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
2515: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
2508: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
2509: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
2510: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
2511: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
2512: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
2513: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
2514: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
2515: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
2516: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
2509: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
2510: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
2511: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
2512: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
2513: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
2514: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
2515: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
2516: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
2517: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
2510: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
2511: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
2512: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
2513: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
2514: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
2515: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
2516: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
2517: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
2518: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
2511: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
2512: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
2513: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
2514: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
2515: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
2516: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
2517: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
2518: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
2519: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
2512: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
2513: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
2514: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
2515: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
2516: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
2517: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
2518: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
2519: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
2520: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2513: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
2514: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
2515: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
2516: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
2517: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
2518: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
2519: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
2520: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2521: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
2514: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
2515: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
2516: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
2517: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
2518: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
2519: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
2520: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2521: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
2522: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
2515: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
2516: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
2517: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
2518: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
2519: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
2520: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2521: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
2522: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
2523: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
2516: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
2517: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
2518: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
2519: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
2520: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2521: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
2522: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
2523: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
2524: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
2517: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
2518: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
2519: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
2520: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2521: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
2522: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
2523: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
2524: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
2525: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
2518: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
2519: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
2520: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2521: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
2522: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
2523: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
2524: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
2525: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
2526: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
2519: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
2520: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2521: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
2522: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
2523: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
2524: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
2525: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
2526: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
2527: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
2520: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2521: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
2522: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
2523: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
2524: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
2525: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
2526: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
2527: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
2528:
2521: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
2522: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
2523: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
2524: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
2525: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
2526: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
2527: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
2528:
2529: l_xprt_enabled_flag OKC_TERMS_TEMPLATES_ALL.contract_expert_enabled%TYPE;
2522: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
2523: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
2524: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
2525: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
2526: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
2527: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
2528:
2529: l_xprt_enabled_flag OKC_TERMS_TEMPLATES_ALL.contract_expert_enabled%TYPE;
2530: CURSOR c_template_xprt_enabled_csr IS
2523: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
2524: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
2525: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
2526: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
2527: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
2528:
2529: l_xprt_enabled_flag OKC_TERMS_TEMPLATES_ALL.contract_expert_enabled%TYPE;
2530: CURSOR c_template_xprt_enabled_csr IS
2531: SELECT contract_expert_enabled
2525: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
2526: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
2527: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
2528:
2529: l_xprt_enabled_flag OKC_TERMS_TEMPLATES_ALL.contract_expert_enabled%TYPE;
2530: CURSOR c_template_xprt_enabled_csr IS
2531: SELECT contract_expert_enabled
2532: FROM OKC_TERMS_TEMPLATES_ALL
2533: WHERE template_id = p_template_id;
2528:
2529: l_xprt_enabled_flag OKC_TERMS_TEMPLATES_ALL.contract_expert_enabled%TYPE;
2530: CURSOR c_template_xprt_enabled_csr IS
2531: SELECT contract_expert_enabled
2532: FROM OKC_TERMS_TEMPLATES_ALL
2533: WHERE template_id = p_template_id;
2534:
2535: l_msg_data VARCHAR2(1000);
2536: l_msg_count NUMBER;
2848: ---------------------------------------------------------------------------
2849: -- PROCEDURE Delete_Row
2850: ---------------------------------------------------------------------------
2851: -------------------------------------
2852: -- Delete_Row for:OKC_TERMS_TEMPLATES_ALL --
2853: -------------------------------------
2854: FUNCTION Delete_Row(
2855: p_template_id IN NUMBER
2856: ) RETURN VARCHAR2 IS
2860: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2861: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8200: Entered Delete_Row');
2862: END IF;
2863:
2864: DELETE FROM OKC_TERMS_TEMPLATES_ALL WHERE TEMPLATE_ID = p_TEMPLATE_ID;
2865:
2866: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2867: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8300: Leaving Delete_Row');
2868: END IF;
2887:
2888: END Delete_Row;
2889:
2890: -------------------------------------
2891: -- Delete_Row for:OKC_TERMS_TEMPLATES_ALL --
2892: -------------------------------------
2893: PROCEDURE Delete_Row(
2894: x_return_status OUT NOCOPY VARCHAR2,
2895: p_template_id IN NUMBER,
2896: p_object_version_number IN NUMBER,
2897: p_delete_parent_yn IN VARCHAR2 := 'N' --If set to 'Y', delete template without checking for translated templates.
2898: ) IS
2899: l_api_name CONSTANT VARCHAR2(30) := 'B_Delete_Row';
2900: l_template_model_id OKC_TERMS_TEMPLATES_ALL.template_model_id%TYPE;
2901: l_orig_sys_ref okc_exprt_import_refs.orig_sys_ref%TYPE;
2902: l_msg_count NUMBER;
2903: l_msg_data VARCHAR2(4000);
2904: l_status_code VARCHAR2(30);
2902: l_msg_count NUMBER;
2903: l_msg_data VARCHAR2(4000);
2904: l_status_code VARCHAR2(30);
2905: l_dummy_var VARCHAR2(1);
2906: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2907:
2908: CURSOR c_chk_template_csr IS
2909: SELECT template_model_id, status_code
2910: FROM OKC_TERMS_TEMPLATES_ALL
2906: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2907:
2908: CURSOR c_chk_template_csr IS
2909: SELECT template_model_id, status_code
2910: FROM OKC_TERMS_TEMPLATES_ALL
2911: WHERE template_id = p_template_id;
2912:
2913: CURSOR csr_template_model_details IS
2914: SELECT orig_sys_ref
2916: WHERE product_key='510:'||p_template_id ;
2917:
2918: CURSOR c_chk_template_trans IS
2919: SELECT '!' , parent.template_name
2920: FROM okc_terms_templates_all translated,
2921: okc_terms_templates_all parent
2922: WHERE translated.translated_from_tmpl_id = p_template_id
2923: AND parent.template_id = translated.translated_from_tmpl_id;
2924: BEGIN
2917:
2918: CURSOR c_chk_template_trans IS
2919: SELECT '!' , parent.template_name
2920: FROM okc_terms_templates_all translated,
2921: okc_terms_templates_all parent
2922: WHERE translated.translated_from_tmpl_id = p_template_id
2923: AND parent.template_id = translated.translated_from_tmpl_id;
2924: BEGIN
2925:
3076: --------------------------------------------
3077: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3078: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'9900: Updating Row');
3079: END IF;
3080: UPDATE OKC_TERMS_TEMPLATES_ALL
3081: SET TEMPLATE_ID = p_new_template_id,
3082: WORKING_COPY_FLAG = 'N',
3083: PARENT_TEMPLATE_ID = NULL,
3084: STATUS_CODE = 'APPROVED',