194: DELETE FROM POR_TEMPLATE_ATTRIBUTES_TL
195: WHERE ATTRIBUTE_CODE IN
196: (
197: SELECT ATTRIBUTE_CODE
198: FROM POR_TEMPLATE_ATTRIBUTES_B
199: WHERE TEMPLATE_CODE = l_template_code
200: );
201:
202: l_progress := '003';
199: WHERE TEMPLATE_CODE = l_template_code
200: );
201:
202: l_progress := '003';
203: DELETE FROM POR_TEMPLATE_ATTRIBUTES_B
204: WHERE TEMPLATE_CODE = l_template_code;
205:
206: l_progress := '004';
207: DELETE FROM POR_TEMPLATES_ALL_B
238: l_attribute_code VARCHAR2(30) := NULL;
239: BEGIN
240:
241: l_progress := '002';
242: INSERT INTO POR_TEMPLATE_ATTRIBUTES_B (
243: TEMPLATE_CODE,
244: ATTRIBUTE_CODE,
245: SEQUENCE,
246: FLEX_VALUE_SET_ID,
322: p_user_id IN NUMBER,
323: p_login_id IN NUMBER) IS
324: CURSOR c_rec(p_row_id VARCHAR2) IS
325: SELECT *
326: FROM por_template_attributes_b
327: WHERE rowid = p_row_id
328: FOR UPDATE NOWAIT;
329:
330: CURSOR c_tl_rec(p_attribute_code VARCHAR2) IS
446: p_login_id IN NUMBER) IS
447: l_progress VARCHAR2(10) := '000';
448: BEGIN
449: l_progress := '001';
450: UPDATE POR_TEMPLATE_ATTRIBUTES_B
451: SET
452: SEQUENCE = p_display_sequence,
453: FLEX_VALUE_SET_ID = p_flex_value_set_id,
454: REQUIRED_FLAG = p_required_flag,
488: FROM por_template_attributes_v
489: WHERE row_id = p_row_id;
490:
491: l_progress := '002';
492: DELETE FROM por_template_attributes_b
493: WHERE rowid = p_row_id;
494:
495: l_progress := '003';
496: DELETE FROM por_template_attributes_tl