188: END IF;
189:
190: SELECT fem_object_id_seq.nextval
191: INTO x_object_id
192: FROM dual;
193:
194: BEGIN
195: FEM_OBJECT_CATALOG_PKG.INSERT_ROW (
196: X_ROWID => v_rowid,
505:
506: IF v_date_range_is_valid = 'Y' THEN
507: SELECT fem_object_definition_id_seq.nextval
508: INTO x_object_definition_id
509: FROM dual;
510:
511: SELECT DECODE(t.workflow_enabled_flag,'Y','NEW','NOT_APPLICABLE')
512: INTO v_approval_status_code
513: FROM fem_object_types t, fem_object_catalog_b o