APPS.FUN_SEQ_UTILS dependencies on FUN_SEQ_ENTITIES

Line 223: -- Insert Sequence Entity Information into fun_seq_entities

219: l_debug_loc := l_debug_loc || ' -> '||'is_table_name_valid';
220: RAISE invalid_table;
221: END IF;
222: --
223: -- Insert Sequence Entity Information into fun_seq_entities
224: --
225: l_debug_loc := l_debug_loc || '->' || 'insert into fun_seq_entities';
226: --
227: INSERT INTO fun_seq_entities (

Line 225: l_debug_loc := l_debug_loc || '->' || 'insert into fun_seq_entities';

221: END IF;
222: --
223: -- Insert Sequence Entity Information into fun_seq_entities
224: --
225: l_debug_loc := l_debug_loc || '->' || 'insert into fun_seq_entities';
226: --
227: INSERT INTO fun_seq_entities (
228: application_id,
229: table_name,

Line 227: INSERT INTO fun_seq_entities (

223: -- Insert Sequence Entity Information into fun_seq_entities
224: --
225: l_debug_loc := l_debug_loc || '->' || 'insert into fun_seq_entities';
226: --
227: INSERT INTO fun_seq_entities (
228: application_id,
229: table_name,
230: entity_name,
231: created_by,

Line 374: FROM fun_seq_entities se

370: --
371: -- Delete Sequence Entity
372: --
373: DELETE
374: FROM fun_seq_entities se
375: WHERE se.application_id = p_application_id
376: AND se.table_name = p_table_name;
377:
378: EXCEPTION

Line 476: UPDATE fun_seq_entities se

472: l_debug_loc := l_debug_loc || ' -> '|| 'is_seq_entity_registered';
473: RAISE no_seq_entity_found;
474: END IF;
475:
476: UPDATE fun_seq_entities se
477: SET se.entity_name = p_entity_name,
478: se.last_updated_by = l_user_id,
479: se.last_update_date = sysdate,
480: se.last_update_login = l_user_id

Line 664: FROM fun_seq_entities se

660: l_dummy VARCHAR2(1);
661: BEGIN
662: SELECT 'x'
663: INTO l_dummy
664: FROM fun_seq_entities se
665: WHERE se.application_id = p_application_id
666: AND se.table_name = p_table_name;
667: RETURN (TRUE);
668: EXCEPTION