APPS.POR_IFT_ADMIN_PKG dependencies on POR_TEMPLATE_ATTRIBUTES_B

Line 198: FROM POR_TEMPLATE_ATTRIBUTES_B

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';

Line 203: DELETE FROM POR_TEMPLATE_ATTRIBUTES_B

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

Line 242: INSERT INTO POR_TEMPLATE_ATTRIBUTES_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,

Line 326: FROM por_template_attributes_b

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

Line 450: UPDATE POR_TEMPLATE_ATTRIBUTES_B

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,

Line 492: DELETE FROM por_template_attributes_b

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