[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,
384: x_language OUT NOCOPY VARCHAR2
385: ) RETURN VARCHAR2 IS
386: l_api_name CONSTANT VARCHAR2(30) := 'set_attributes';
387: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
388: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
389: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
390: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
391: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
392: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
385: ) RETURN VARCHAR2 IS
386: l_api_name CONSTANT VARCHAR2(30) := 'set_attributes';
387: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
388: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
389: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
390: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
391: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
392: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
393: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
386: l_api_name CONSTANT VARCHAR2(30) := 'set_attributes';
387: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
388: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
389: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
390: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
391: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
392: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
393: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
394: BEGIN
387: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
388: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
389: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
390: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
391: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
392: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
393: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
394: BEGIN
395: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
389: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
390: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
391: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
392: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
393: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
394: BEGIN
395: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
396: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Entered Set_Attributes ');
389: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
390: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
391: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
392: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
393: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
394: BEGIN
395: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
396: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Entered Set_Attributes ');
397: END IF;
733:
734: END Set_Attributes ;
735:
736: ----------------------------------------------
737: -- Validate_Attributes for: OKC_TERMS_TEMPLATES_ALL --
738: ----------------------------------------------
739: FUNCTION Validate_Attributes (
740: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
741:
791: l_apps_user VARCHAR2(150);
792: l_layout_start_date DATE;
793: l_layout_end_date DATE;
794: l_eff_date DATE;
795: l_tmpl_status okc_terms_templates_all.status_code%TYPE := 'ZZZ';
796: l_validate_layout VARCHAR2(1) := 'Y';
797:
798: CURSOR l_apps_user_csr IS
799: SELECT oracle_username
807: AND owner = pc_user;
808:
809: CURSOR l_parent_template_id_csr is
810: SELECT '!'
811: FROM okc_terms_templates_all
812: WHERE TEMPLATE_ID = p_parent_template_id;
813:
814: /***************Commented out to remove XDO dependency
815: CURSOR l_print_template_id_csr is
831: WHERE ORGANIZATION_ID = p_org_id;
832:
833: CURSOR l_tmpl_status_csr(pc_template_id NUMBER) IS
834: SELECT status_code
835: FROM OKC_TERMS_TEMPLATES_ALL
836: WHERE template_id = pc_template_id;
837:
838:
839: BEGIN
1097: -- PROCEDURE Validate_Record
1098: -- It calls Item Level Validations and then makes Record Level Validations
1099: ---------------------------------------------------------------------------
1100: ------------------------------------------
1101: -- Validate_Record for:OKC_TERMS_TEMPLATES_ALL --
1102: ------------------------------------------
1103: FUNCTION Validate_Record (
1104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1105:
1147: ) RETURN VARCHAR2 IS
1148: l_api_name CONSTANT VARCHAR2(30) := 'validate_record';
1149: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1150: l_dummy_var VARCHAR2(1) := '?';
1151: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
1152:
1153: CURSOR l_tmpl_name_csr is
1154: SELECT '!'
1155: FROM okc_terms_templates_all
1151: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
1152:
1153: CURSOR l_tmpl_name_csr is
1154: SELECT '!'
1155: FROM okc_terms_templates_all
1156: WHERE template_name = p_template_name
1157: AND nvl(working_copy_flag,'N') = nvl(p_working_copy_flag,'N')
1158: AND ((p_template_id IS NULL) OR (p_template_id <> template_id))
1159: AND ORG_ID = mo_global.get_current_org_id();
1159: AND ORG_ID = mo_global.get_current_org_id();
1160: --MLS for templates
1161: CURSOR l_primary_tmpl_csr IS
1162: SELECT '!'
1163: FROM okc_terms_templates_all
1164: WHERE translated_from_tmpl_id = p_template_id
1165: UNION ALL
1166: SELECT '!'
1167: FROM okc_terms_templates_all
1163: FROM okc_terms_templates_all
1164: WHERE translated_from_tmpl_id = p_template_id
1165: UNION ALL
1166: SELECT '!'
1167: FROM okc_terms_templates_all
1168: WHERE translated_from_tmpl_id = p_parent_template_id ;
1169: --MLS for templates
1170: CURSOR l_tmpl_group1_csr IS
1171: SELECT '!', template_name
1168: WHERE translated_from_tmpl_id = p_parent_template_id ;
1169: --MLS for templates
1170: CURSOR l_tmpl_group1_csr IS
1171: SELECT '!', template_name
1172: FROM okc_terms_templates_all
1173: WHERE translated_from_tmpl_id= p_parent_template_id
1174: AND language = p_language;
1175:
1176: --MLS for templates
1175:
1176: --MLS for templates
1177: CURSOR l_tmpl_group2_csr IS
1178: SELECT '!', template_name
1179: FROM okc_terms_templates_all
1180: WHERE translated_from_tmpl_id= p_template_id
1181: AND language = p_language;
1182:
1183: --MLS for templates
1182:
1183: --MLS for templates
1184: CURSOR l_tmpl_group3_csr IS
1185: SELECT '!', tta.template_name
1186: FROM okc_terms_templates_all tta
1187: WHERE tta.template_id = p_translated_from_tmpl_id
1188: AND language = p_language
1189: UNION ALL
1190: SELECT '!', tta.template_name
1187: WHERE tta.template_id = p_translated_from_tmpl_id
1188: AND language = p_language
1189: UNION ALL
1190: SELECT '!', tta.template_name
1191: FROM okc_terms_templates_all tta
1192: WHERE tta.parent_template_id = p_translated_from_tmpl_id
1193: AND language = p_language
1194: UNION ALL
1195: SELECT '!', tta.template_name
1192: WHERE tta.parent_template_id = p_translated_from_tmpl_id
1193: AND language = p_language
1194: UNION ALL
1195: SELECT '!', tta.template_name
1196: FROM okc_terms_templates_all tta
1197: WHERE tta.translated_from_tmpl_id = p_translated_from_tmpl_id
1198: AND tta.language = p_language
1199: AND tta.template_id <> p_template_id
1200: AND tta.template_id <> nvl(p_parent_template_id,0)
1199: AND tta.template_id <> p_template_id
1200: AND tta.template_id <> nvl(p_parent_template_id,0)
1201: AND not exists
1202: (SELECT 1
1203: FROM okc_terms_templates_all tta3
1204: WHERE tta3.template_id = tta.template_id
1205: AND tta3.parent_template_id = p_template_id) ;
1206:
1207:
1423: ---------------------------------------------------------------------------
1424: -- PROCEDURE validate_row
1425: ---------------------------------------------------------------------------
1426: ---------------------------------------
1427: -- validate_row for:OKC_TERMS_TEMPLATES_ALL --
1428: ---------------------------------------
1429: PROCEDURE validate_row(
1430: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1431:
1476: p_language IN VARCHAR2,
1477: p_object_version_number IN NUMBER
1478: ) IS
1479: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1480: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
1481: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
1482: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
1483: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
1484: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1477: p_object_version_number IN NUMBER
1478: ) IS
1479: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1480: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
1481: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
1482: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
1483: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
1484: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1485: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1478: ) IS
1479: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1480: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
1481: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
1482: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
1483: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
1484: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1485: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1486: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1479: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1480: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
1481: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
1482: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
1483: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
1484: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1485: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1486: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1487: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1480: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
1481: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
1482: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
1483: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
1484: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1485: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1486: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1487: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1488: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
1481: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
1482: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
1483: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
1484: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1485: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1486: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1487: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1488: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
1489: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
1482: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
1483: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
1484: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1485: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1486: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1487: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1488: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
1489: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
1490: l_cls_enabled OKC_TERMS_TEMPLATES_ALL.CLS_ENABLED%TYPE;
1483: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
1484: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1485: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1486: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1487: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1488: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
1489: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
1490: l_cls_enabled OKC_TERMS_TEMPLATES_ALL.CLS_ENABLED%TYPE;
1491: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE;
1484: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
1485: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1486: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1487: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1488: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
1489: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
1490: l_cls_enabled OKC_TERMS_TEMPLATES_ALL.CLS_ENABLED%TYPE;
1491: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE;
1492: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE;
1485: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
1486: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1487: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1488: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
1489: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
1490: l_cls_enabled OKC_TERMS_TEMPLATES_ALL.CLS_ENABLED%TYPE;
1491: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE;
1492: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE;
1493: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
1486: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
1487: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1488: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
1489: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
1490: l_cls_enabled OKC_TERMS_TEMPLATES_ALL.CLS_ENABLED%TYPE;
1491: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE;
1492: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE;
1493: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
1494: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
1487: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
1488: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
1489: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
1490: l_cls_enabled OKC_TERMS_TEMPLATES_ALL.CLS_ENABLED%TYPE;
1491: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE;
1492: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE;
1493: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
1494: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
1495: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
1488: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
1489: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
1490: l_cls_enabled OKC_TERMS_TEMPLATES_ALL.CLS_ENABLED%TYPE;
1491: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE;
1492: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE;
1493: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
1494: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
1495: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
1496: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
1489: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
1490: l_cls_enabled OKC_TERMS_TEMPLATES_ALL.CLS_ENABLED%TYPE;
1491: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE;
1492: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE;
1493: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
1494: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
1495: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
1496: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
1497: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
1490: l_cls_enabled OKC_TERMS_TEMPLATES_ALL.CLS_ENABLED%TYPE;
1491: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE;
1492: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE;
1493: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
1494: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
1495: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
1496: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
1497: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
1498: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
1491: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE;
1492: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE;
1493: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
1494: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
1495: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
1496: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
1497: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
1498: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
1499: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1492: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE;
1493: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
1494: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
1495: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
1496: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
1497: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
1498: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
1499: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1500: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1493: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
1494: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
1495: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
1496: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
1497: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
1498: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
1499: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1500: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1501: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1494: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
1495: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
1496: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
1497: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
1498: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
1499: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1500: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1501: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1502: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
1495: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
1496: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
1497: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
1498: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
1499: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1500: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1501: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1502: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
1503: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1496: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
1497: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
1498: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
1499: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1500: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1501: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1502: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
1503: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1504: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
1497: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
1498: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
1499: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1500: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1501: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1502: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
1503: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1504: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
1505: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
1498: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
1499: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1500: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1501: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1502: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
1503: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1504: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
1505: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
1506: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
1499: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
1500: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1501: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1502: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
1503: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1504: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
1505: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
1506: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
1507: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
1500: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
1501: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1502: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
1503: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1504: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
1505: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
1506: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
1507: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
1508: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
1501: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
1502: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
1503: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1504: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
1505: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
1506: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
1507: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
1508: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
1509: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
1502: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
1503: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1504: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
1505: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
1506: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
1507: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
1508: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
1509: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
1510: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
1503: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
1504: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
1505: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
1506: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
1507: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
1508: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
1509: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
1510: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
1511: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
1504: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
1505: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
1506: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
1507: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
1508: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
1509: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
1510: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
1511: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
1512: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
1505: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
1506: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
1507: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
1508: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
1509: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
1510: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
1511: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
1512: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
1513: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
1506: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
1507: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
1508: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
1509: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
1510: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
1511: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
1512: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
1513: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
1514: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
1507: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
1508: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
1509: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
1510: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
1511: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
1512: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
1513: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
1514: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
1515: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
1508: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
1509: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
1510: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
1511: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
1512: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
1513: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
1514: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
1515: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
1516: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
1509: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
1510: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
1511: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
1512: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
1513: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
1514: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
1515: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
1516: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
1517: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
1510: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
1511: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
1512: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
1513: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
1514: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
1515: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
1516: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
1517: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
1518: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
1511: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
1512: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
1513: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
1514: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
1515: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
1516: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
1517: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
1518: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
1519: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1512: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
1513: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
1514: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
1515: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
1516: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
1517: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
1518: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
1519: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1520: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1513: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
1514: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
1515: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
1516: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
1517: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
1518: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
1519: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1520: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1521: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1514: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
1515: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
1516: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
1517: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
1518: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
1519: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1520: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1521: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1522: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1515: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
1516: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
1517: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
1518: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
1519: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1520: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1521: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1522: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1523: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1516: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
1517: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
1518: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
1519: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1520: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1521: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1522: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1523: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1524: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1517: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
1518: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
1519: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1520: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1521: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1522: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1523: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1524: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1525: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
1518: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
1519: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1520: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1521: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1522: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1523: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1524: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1525: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
1526: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
1519: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1520: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1521: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1522: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1523: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1524: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1525: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
1526: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
1527: BEGIN
1520: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1521: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1522: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1523: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1524: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1525: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
1526: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
1527: BEGIN
1528:
1521: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1522: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1523: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1524: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1525: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
1526: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
1527: BEGIN
1528:
1529: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1522: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1523: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1524: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1525: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
1526: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
1527: BEGIN
1528:
1529: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1530: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3100: Entered validate_row');
1705: ---------------------------------------------------------------------------
1706: -- PROCEDURE Insert_Row
1707: ---------------------------------------------------------------------------
1708: -------------------------------------
1709: -- Insert_Row for:OKC_TERMS_TEMPLATES_ALL --
1710: -------------------------------------
1711: FUNCTION Insert_Row(
1712: p_template_name IN VARCHAR2,
1713: p_template_id IN NUMBER,
1766: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1767: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3600: Entered Insert_Row function');
1768: END IF;
1769:
1770: INSERT INTO OKC_TERMS_TEMPLATES_ALL(
1771: TEMPLATE_NAME,
1772: TEMPLATE_ID,
1773: WORKING_COPY_FLAG,
1774: INTENT,
1893: END Insert_Row;
1894:
1895:
1896: -------------------------------------
1897: -- Insert_Row for:OKC_TERMS_TEMPLATES_ALL --
1898: -------------------------------------
1899: PROCEDURE Insert_Row(
1900: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1901: x_return_status OUT NOCOPY VARCHAR2,
1945: x_template_id OUT NOCOPY NUMBER
1946:
1947: ) IS
1948: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1949: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1950: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1951: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1952: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1953: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1946:
1947: ) IS
1948: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1949: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1950: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1951: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1952: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1953: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1954: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1947: ) IS
1948: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1949: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1950: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1951: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1952: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1953: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1954: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1955: BEGIN
1948: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
1949: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1950: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1951: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1952: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1953: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1954: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1955: BEGIN
1956:
1949: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
1950: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1951: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1952: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1953: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1954: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1955: BEGIN
1956:
1957: x_return_status := G_RET_STS_SUCCESS;
1950: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
1951: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
1952: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
1953: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
1954: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
1955: BEGIN
1956:
1957: x_return_status := G_RET_STS_SUCCESS;
1958:
2136: ---------------------------------------------------------------------------
2137: -- PROCEDURE Lock_Row
2138: ---------------------------------------------------------------------------
2139: -----------------------------------
2140: -- Lock_Row for:OKC_TERMS_TEMPLATES_ALL --
2141: -----------------------------------
2142: FUNCTION Lock_Row(
2143: p_template_id IN NUMBER,
2144: p_object_version_number IN NUMBER
2148: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
2149:
2150: CURSOR lock_csr (cp_template_id NUMBER, cp_object_version_number NUMBER) IS
2151: SELECT object_version_number
2152: FROM OKC_TERMS_TEMPLATES_ALL
2153: WHERE TEMPLATE_ID = cp_template_id
2154: AND ( object_version_number = cp_object_version_number
2155: OR cp_object_version_number IS NULL)
2156: FOR UPDATE OF object_version_number NOWAIT;
2156: FOR UPDATE OF object_version_number NOWAIT;
2157:
2158: CURSOR lchk_csr (cp_template_id NUMBER) IS
2159: SELECT object_version_number
2160: FROM OKC_TERMS_TEMPLATES_ALL
2161: WHERE TEMPLATE_ID = cp_template_id;
2162:
2163: l_return_status VARCHAR2(1);
2164:
2161: WHERE TEMPLATE_ID = cp_template_id;
2162:
2163: l_return_status VARCHAR2(1);
2164:
2165: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2166:
2167: l_row_notfound BOOLEAN := FALSE;
2168: BEGIN
2169:
2244: RETURN( G_RET_STS_UNEXP_ERROR );
2245: END Lock_Row;
2246:
2247: -----------------------------------
2248: -- Lock_Row for:OKC_TERMS_TEMPLATES_ALL --
2249: -----------------------------------
2250: PROCEDURE Lock_Row(
2251: x_return_status OUT NOCOPY VARCHAR2,
2252:
2309: ---------------------------------------------------------------------------
2310: -- PROCEDURE Update_Row
2311: ---------------------------------------------------------------------------
2312: -------------------------------------
2313: -- Update_Row for:OKC_TERMS_TEMPLATES_ALL --
2314: -------------------------------------
2315: FUNCTION Update_Row(
2316: p_template_name IN VARCHAR2,
2317: p_template_id IN NUMBER,
2369: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2370: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6400: Entered Update_Row');
2371: END IF;
2372:
2373: UPDATE OKC_TERMS_TEMPLATES_ALL
2374: SET TEMPLATE_NAME = p_template_name,
2375: WORKING_COPY_FLAG = NVL(p_working_copy_flag,'N'),
2376: INTENT = p_intent,
2377: STATUS_CODE = p_status_code,
2443:
2444: END Update_Row;
2445:
2446: -------------------------------------
2447: -- Update_Row for:OKC_TERMS_TEMPLATES_ALL --
2448: -------------------------------------
2449: PROCEDURE Update_Row(
2450: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2451:
2497: p_object_version_number IN NUMBER
2498:
2499: ) IS
2500: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
2501: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2502: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
2503: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
2504: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
2505: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2498:
2499: ) IS
2500: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
2501: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2502: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
2503: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
2504: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
2505: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2506: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2499: ) IS
2500: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
2501: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2502: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
2503: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
2504: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
2505: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2506: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2507: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2500: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
2501: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2502: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
2503: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
2504: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
2505: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2506: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2507: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2508: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2501: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2502: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
2503: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
2504: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
2505: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2506: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2507: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2508: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2509: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
2502: l_working_copy_flag OKC_TERMS_TEMPLATES_ALL.WORKING_COPY_FLAG%TYPE;
2503: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
2504: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
2505: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2506: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2507: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2508: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2509: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
2510: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
2503: l_intent OKC_TERMS_TEMPLATES_ALL.INTENT%TYPE;
2504: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
2505: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2506: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2507: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2508: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2509: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
2510: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
2511: l_cls_enabled OKC_TERMS_TEMPLATES_ALL.CLS_ENABLED%TYPE;
2504: l_status_code OKC_TERMS_TEMPLATES_ALL.STATUS_CODE%TYPE;
2505: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2506: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2507: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2508: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2509: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
2510: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
2511: l_cls_enabled OKC_TERMS_TEMPLATES_ALL.CLS_ENABLED%TYPE;
2512: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE; -- Added for 11.5.10+:Contract Expert Changes
2505: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
2506: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2507: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2508: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2509: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
2510: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
2511: l_cls_enabled OKC_TERMS_TEMPLATES_ALL.CLS_ENABLED%TYPE;
2512: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE; -- Added for 11.5.10+:Contract Expert Changes
2513: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE; -- Added for 11.5.10+: Contract Expert Changes
2506: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
2507: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2508: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2509: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
2510: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
2511: l_cls_enabled OKC_TERMS_TEMPLATES_ALL.CLS_ENABLED%TYPE;
2512: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE; -- Added for 11.5.10+:Contract Expert Changes
2513: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE; -- Added for 11.5.10+: Contract Expert Changes
2514: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
2507: l_global_flag OKC_TERMS_TEMPLATES_ALL.GLOBAL_FLAG%TYPE;
2508: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2509: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
2510: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
2511: l_cls_enabled OKC_TERMS_TEMPLATES_ALL.CLS_ENABLED%TYPE;
2512: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE; -- Added for 11.5.10+:Contract Expert Changes
2513: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE; -- Added for 11.5.10+: Contract Expert Changes
2514: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
2515: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
2508: l_parent_template_id OKC_TERMS_TEMPLATES_ALL.PARENT_TEMPLATE_ID%TYPE;
2509: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
2510: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
2511: l_cls_enabled OKC_TERMS_TEMPLATES_ALL.CLS_ENABLED%TYPE;
2512: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE; -- Added for 11.5.10+:Contract Expert Changes
2513: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE; -- Added for 11.5.10+: Contract Expert Changes
2514: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
2515: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
2516: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
2509: l_print_template_id OKC_TERMS_TEMPLATES_ALL.PRINT_TEMPLATE_ID%TYPE;
2510: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
2511: l_cls_enabled OKC_TERMS_TEMPLATES_ALL.CLS_ENABLED%TYPE;
2512: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE; -- Added for 11.5.10+:Contract Expert Changes
2513: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE; -- Added for 11.5.10+: Contract Expert Changes
2514: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
2515: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
2516: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
2517: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
2510: l_contract_expert_enabled OKC_TERMS_TEMPLATES_ALL.CONTRACT_EXPERT_ENABLED%TYPE;
2511: l_cls_enabled OKC_TERMS_TEMPLATES_ALL.CLS_ENABLED%TYPE;
2512: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE; -- Added for 11.5.10+:Contract Expert Changes
2513: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE; -- Added for 11.5.10+: Contract Expert Changes
2514: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
2515: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
2516: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
2517: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
2518: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
2511: l_cls_enabled OKC_TERMS_TEMPLATES_ALL.CLS_ENABLED%TYPE;
2512: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE; -- Added for 11.5.10+:Contract Expert Changes
2513: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE; -- Added for 11.5.10+: Contract Expert Changes
2514: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
2515: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
2516: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
2517: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
2518: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
2519: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
2512: l_xprt_clause_mandatory_flag OKC_TERMS_TEMPLATES_ALL.XPRT_CLAUSE_MANDATORY_FLAG%TYPE; -- Added for 11.5.10+:Contract Expert Changes
2513: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE; -- Added for 11.5.10+: Contract Expert Changes
2514: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
2515: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
2516: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
2517: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
2518: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
2519: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
2520: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2513: l_xprt_scn_code OKC_TERMS_TEMPLATES_ALL.XPRT_SCN_CODE%TYPE; -- Added for 11.5.10+: Contract Expert Changes
2514: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
2515: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
2516: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
2517: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
2518: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
2519: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
2520: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2521: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2514: l_template_model_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_MODEL_ID%TYPE;
2515: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
2516: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
2517: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
2518: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
2519: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
2520: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2521: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2522: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2515: l_instruction_text OKC_TERMS_TEMPLATES_ALL.INSTRUCTION_TEXT%TYPE;
2516: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
2517: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
2518: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
2519: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
2520: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2521: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2522: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2523: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
2516: l_tmpl_numbering_scheme OKC_TERMS_TEMPLATES_ALL.TMPL_NUMBERING_SCHEME%TYPE;
2517: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
2518: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
2519: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
2520: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2521: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2522: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2523: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
2524: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2517: l_description OKC_TERMS_TEMPLATES_ALL.DESCRIPTION%TYPE;
2518: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
2519: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
2520: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2521: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2522: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2523: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
2524: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2525: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
2518: l_approval_wf_key OKC_TERMS_TEMPLATES_ALL.APPROVAL_WF_KEY%TYPE;
2519: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
2520: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2521: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2522: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2523: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
2524: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2525: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
2526: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
2519: l_cz_export_wf_key OKC_TERMS_TEMPLATES_ALL.CZ_EXPORT_WF_KEY%TYPE;
2520: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2521: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2522: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2523: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
2524: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2525: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
2526: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
2527: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
2520: l_orig_system_reference_code OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_CODE%TYPE;
2521: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2522: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2523: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
2524: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2525: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
2526: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
2527: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
2528: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
2521: l_orig_system_reference_id1 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID1%TYPE;
2522: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2523: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
2524: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2525: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
2526: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
2527: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
2528: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
2529: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
2522: l_orig_system_reference_id2 OKC_TERMS_TEMPLATES_ALL.ORIG_SYSTEM_REFERENCE_ID2%TYPE;
2523: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
2524: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2525: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
2526: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
2527: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
2528: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
2529: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
2530: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
2523: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
2524: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2525: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
2526: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
2527: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
2528: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
2529: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
2530: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
2531: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
2524: l_attribute_category OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE_CATEGORY%TYPE;
2525: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
2526: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
2527: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
2528: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
2529: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
2530: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
2531: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
2532: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
2525: l_attribute1 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE1%TYPE;
2526: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
2527: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
2528: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
2529: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
2530: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
2531: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
2532: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
2533: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
2526: l_attribute2 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE2%TYPE;
2527: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
2528: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
2529: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
2530: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
2531: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
2532: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
2533: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
2534: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
2527: l_attribute3 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE3%TYPE;
2528: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
2529: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
2530: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
2531: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
2532: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
2533: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
2534: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
2535: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
2528: l_attribute4 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE4%TYPE;
2529: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
2530: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
2531: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
2532: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
2533: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
2534: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
2535: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
2536: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
2529: l_attribute5 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE5%TYPE;
2530: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
2531: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
2532: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
2533: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
2534: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
2535: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
2536: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
2537: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
2530: l_attribute6 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE6%TYPE;
2531: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
2532: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
2533: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
2534: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
2535: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
2536: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
2537: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
2538: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
2531: l_attribute7 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE7%TYPE;
2532: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
2533: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
2534: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
2535: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
2536: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
2537: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
2538: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
2539: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
2532: l_attribute8 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE8%TYPE;
2533: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
2534: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
2535: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
2536: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
2537: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
2538: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
2539: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
2540: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2533: l_attribute9 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE9%TYPE;
2534: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
2535: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
2536: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
2537: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
2538: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
2539: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
2540: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2541: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
2534: l_attribute10 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE10%TYPE;
2535: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
2536: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
2537: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
2538: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
2539: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
2540: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2541: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
2542: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
2535: l_attribute11 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE11%TYPE;
2536: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
2537: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
2538: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
2539: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
2540: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2541: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
2542: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
2543: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
2536: l_attribute12 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE12%TYPE;
2537: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
2538: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
2539: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
2540: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2541: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
2542: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
2543: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
2544: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
2537: l_attribute13 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE13%TYPE;
2538: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
2539: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
2540: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2541: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
2542: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
2543: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
2544: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
2545: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
2538: l_attribute14 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE14%TYPE;
2539: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
2540: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2541: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
2542: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
2543: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
2544: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
2545: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
2546: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
2539: l_attribute15 OKC_TERMS_TEMPLATES_ALL.ATTRIBUTE15%TYPE;
2540: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2541: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
2542: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
2543: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
2544: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
2545: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
2546: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
2547: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
2540: l_object_version_number OKC_TERMS_TEMPLATES_ALL.OBJECT_VERSION_NUMBER%TYPE;
2541: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
2542: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
2543: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
2544: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
2545: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
2546: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
2547: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
2548:
2541: l_created_by OKC_TERMS_TEMPLATES_ALL.CREATED_BY%TYPE;
2542: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
2543: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
2544: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
2545: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
2546: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
2547: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
2548:
2549: l_xprt_enabled_flag OKC_TERMS_TEMPLATES_ALL.contract_expert_enabled%TYPE;
2542: l_creation_date OKC_TERMS_TEMPLATES_ALL.CREATION_DATE%TYPE;
2543: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
2544: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
2545: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
2546: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
2547: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
2548:
2549: l_xprt_enabled_flag OKC_TERMS_TEMPLATES_ALL.contract_expert_enabled%TYPE;
2550: CURSOR c_template_xprt_enabled_csr IS
2543: l_last_updated_by OKC_TERMS_TEMPLATES_ALL.LAST_UPDATED_BY%TYPE;
2544: l_last_update_login OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_LOGIN%TYPE;
2545: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
2546: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
2547: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
2548:
2549: l_xprt_enabled_flag OKC_TERMS_TEMPLATES_ALL.contract_expert_enabled%TYPE;
2550: CURSOR c_template_xprt_enabled_csr IS
2551: SELECT contract_expert_enabled
2545: l_last_update_date OKC_TERMS_TEMPLATES_ALL.LAST_UPDATE_DATE%TYPE;
2546: l_translated_from_tmpl_id OKC_TERMS_TEMPLATES_ALL.TRANSLATED_FROM_TMPL_ID%TYPE;
2547: l_language OKC_TERMS_TEMPLATES_ALL.LANGUAGE%TYPE;
2548:
2549: l_xprt_enabled_flag OKC_TERMS_TEMPLATES_ALL.contract_expert_enabled%TYPE;
2550: CURSOR c_template_xprt_enabled_csr IS
2551: SELECT contract_expert_enabled
2552: FROM OKC_TERMS_TEMPLATES_ALL
2553: WHERE template_id = p_template_id;
2548:
2549: l_xprt_enabled_flag OKC_TERMS_TEMPLATES_ALL.contract_expert_enabled%TYPE;
2550: CURSOR c_template_xprt_enabled_csr IS
2551: SELECT contract_expert_enabled
2552: FROM OKC_TERMS_TEMPLATES_ALL
2553: WHERE template_id = p_template_id;
2554:
2555: l_msg_data VARCHAR2(1000);
2556: l_msg_count NUMBER;
2871: ---------------------------------------------------------------------------
2872: -- PROCEDURE Delete_Row
2873: ---------------------------------------------------------------------------
2874: -------------------------------------
2875: -- Delete_Row for:OKC_TERMS_TEMPLATES_ALL --
2876: -------------------------------------
2877: FUNCTION Delete_Row(
2878: p_template_id IN NUMBER
2879: ) RETURN VARCHAR2 IS
2883: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2884: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8200: Entered Delete_Row');
2885: END IF;
2886:
2887: DELETE FROM OKC_TERMS_TEMPLATES_ALL WHERE TEMPLATE_ID = p_TEMPLATE_ID;
2888:
2889: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2890: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'8300: Leaving Delete_Row');
2891: END IF;
2910:
2911: END Delete_Row;
2912:
2913: -------------------------------------
2914: -- Delete_Row for:OKC_TERMS_TEMPLATES_ALL --
2915: -------------------------------------
2916: PROCEDURE Delete_Row(
2917: x_return_status OUT NOCOPY VARCHAR2,
2918: p_template_id IN NUMBER,
2919: p_object_version_number IN NUMBER,
2920: p_delete_parent_yn IN VARCHAR2 := 'N' --If set to 'Y', delete template without checking for translated templates.
2921: ) IS
2922: l_api_name CONSTANT VARCHAR2(30) := 'B_Delete_Row';
2923: l_template_model_id OKC_TERMS_TEMPLATES_ALL.template_model_id%TYPE;
2924: l_orig_sys_ref okc_exprt_import_refs.orig_sys_ref%TYPE;
2925: l_msg_count NUMBER;
2926: l_msg_data VARCHAR2(4000);
2927: l_status_code VARCHAR2(30);
2925: l_msg_count NUMBER;
2926: l_msg_data VARCHAR2(4000);
2927: l_status_code VARCHAR2(30);
2928: l_dummy_var VARCHAR2(1);
2929: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2930:
2931: CURSOR c_chk_template_csr IS
2932: SELECT template_model_id, status_code
2933: FROM OKC_TERMS_TEMPLATES_ALL
2929: l_template_name OKC_TERMS_TEMPLATES_ALL.TEMPLATE_NAME%TYPE;
2930:
2931: CURSOR c_chk_template_csr IS
2932: SELECT template_model_id, status_code
2933: FROM OKC_TERMS_TEMPLATES_ALL
2934: WHERE template_id = p_template_id;
2935:
2936: CURSOR csr_template_model_details IS
2937: SELECT orig_sys_ref
2939: WHERE product_key='510:'||p_template_id ;
2940:
2941: CURSOR c_chk_template_trans IS
2942: SELECT '!' , parent.template_name
2943: FROM okc_terms_templates_all translated,
2944: okc_terms_templates_all parent
2945: WHERE translated.translated_from_tmpl_id = p_template_id
2946: AND parent.template_id = translated.translated_from_tmpl_id;
2947: BEGIN
2940:
2941: CURSOR c_chk_template_trans IS
2942: SELECT '!' , parent.template_name
2943: FROM okc_terms_templates_all translated,
2944: okc_terms_templates_all parent
2945: WHERE translated.translated_from_tmpl_id = p_template_id
2946: AND parent.template_id = translated.translated_from_tmpl_id;
2947: BEGIN
2948:
3099: --------------------------------------------
3100: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3101: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'9900: Updating Row');
3102: END IF;
3103: UPDATE OKC_TERMS_TEMPLATES_ALL
3104: SET TEMPLATE_ID = p_new_template_id,
3105: WORKING_COPY_FLAG = 'N',
3106: PARENT_TEMPLATE_ID = NULL,
3107: STATUS_CODE = 'APPROVED',