25: end if;
26: END Get_High_Rev_ECO;
27:
28:
29: Function Get_BOM_Lists_Seq_Id RETURN NUMBER IS
30: seq_id NUMBER;
31: BEGIN
32: select BOM_LISTS_S.nextval
33: into seq_id
28:
29: Function Get_BOM_Lists_Seq_Id RETURN NUMBER IS
30: seq_id NUMBER;
31: BEGIN
32: select BOM_LISTS_S.nextval
33: into seq_id
34: from DUAL;
35: return(seq_id);
36: END Get_BOM_Lists_Seq_Id;
32: select BOM_LISTS_S.nextval
33: into seq_id
34: from DUAL;
35: return(seq_id);
36: END Get_BOM_Lists_Seq_Id;
37:
38:
39: PROCEDURE Insert_BOM_Lists (x_revised_item_id NUMBER,
40: x_sequence_id NUMBER,