APPS.OE_OE_FOLDER_EXT dependencies on OE_FOLDER_EXTENSIONS

Line 303: FROM oe_folder_extensions

299: l_folder_extension_id Number;
300: BEGIN
301: SELECT FOLDER_EXTENSION_ID
302: INTO l_folder_extension_id
303: FROM oe_folder_extensions
304: WHERE folder_id=p_folder_id;
305:
306: UPDATE oe_folder_extensions
307: SET DISPLAY_LINE_OTHERS=p_others_tab,

Line 306: UPDATE oe_folder_extensions

302: INTO l_folder_extension_id
303: FROM oe_folder_extensions
304: WHERE folder_id=p_folder_id;
305:
306: UPDATE oe_folder_extensions
307: SET DISPLAY_LINE_OTHERS=p_others_tab,
308: DISPLAY_LINE_PRICING=p_pricing_tab,
309: DISPLAY_LINE_SERVICES=p_service_tab,
310: DISPLAY_LINE_ADDRESSES=p_addresses_tab,

Line 325: INSERT INTO oe_folder_extensions

321: Commit;
322:
323: EXCEPTION
324: WHEN NO_DATA_FOUND THEN
325: INSERT INTO oe_folder_extensions
326: (FOLDER_EXTENSION_ID,
327: OBJECT,
328: USER_ID,
329: FOLDER_ID,

Line 351: oe_folder_extensions_s.nextval,

347: LAST_UPDATED_BY,
348: LAST_UPDATE_LOGIN
349: ) VALUES
350: (
351: oe_folder_extensions_s.nextval,
352: p_object,
353: p_user_id,
354: p_folder_id,
355: fnd_profile.value('RESP_APPL_ID'),

Line 449: FROM OE_FOLDER_EXTENSIONS

445: SELECT FOLDER_EXTENSION_ID,
446: DISPLAY_ORDER_OTHERS
447: INTO l_folder_extension_id,
448: x_header_others_flag
449: FROM OE_FOLDER_EXTENSIONS
450: WHERE folder_id=l_folder_header_id ;
451:
452: EXCEPTION
453: WHEN NO_DATA_FOUND THEN

Line 492: FROM OE_FOLDER_EXTENSIONS

488: x_adjustment_details,
489: x_related_item_details,
490: x_pricing_ava_details ,
491: x_default_line_region
492: FROM OE_FOLDER_EXTENSIONS
493: WHERE folder_id=l_folder_line_id ;
494:
495:
496: EXCEPTION

Line 531: DELETE FROM oe_folder_extensions

527:
528: DELETE FROM OE_CUSTOM_ACTIONS
529: WHERE folder_id=p_folder_id;
530:
531: DELETE FROM oe_folder_extensions
532: WHERE folder_id=p_folder_id;
533:
534: Commit;
535: