288: BEGIN
289: delete from PAY_ELE_TMPLT_CLASS_USAGES
290: where template_id = l_template_id;
291:
292: pay_element_template_api.delete_user_structure(false,true,
293: l_template_id);
294: l_template_exists := 'N';
295: EXCEPTION
296: WHEN OTHERS THEN
1427: BEGIN
1428: delete from PAY_ELE_TMPLT_CLASS_USAGES
1429: where template_id = l_template_id;
1430:
1431: pay_element_template_api.delete_user_structure(false,true,
1432: l_template_id);
1433: l_template_exists := 'N';
1434: EXCEPTION
1435: WHEN OTHERS THEN
2057: BEGIN
2058: delete from PAY_ELE_TMPLT_CLASS_USAGES
2059: where template_id = l_template_id;
2060:
2061: pay_element_template_api.delete_user_structure(false,true,
2062: l_template_id);
2063: l_template_exists := 'N';
2064: EXCEPTION
2065: WHEN OTHERS THEN
3029: BEGIN
3030: delete from PAY_ELE_TMPLT_CLASS_USAGES
3031: where template_id = l_template_id;
3032:
3033: pay_element_template_api.delete_user_structure(false,true,
3034: l_template_id);
3035: l_template_exists := 'N';
3036: EXCEPTION
3037: WHEN OTHERS THEN
4271: BEGIN
4272: delete from PAY_ELE_TMPLT_CLASS_USAGES
4273: where template_id = l_template_id;
4274:
4275: pay_element_template_api.delete_user_structure(false,true,
4276: l_template_id);
4277: l_template_exists := 'N';
4278: EXCEPTION
4279: WHEN OTHERS THEN