APPS.ENG_REVISED_ITEMS_PKG dependencies on BOM_LISTS

Line 29: Function Get_BOM_Lists_Seq_Id RETURN NUMBER IS

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

Line 32: select BOM_LISTS_S.nextval

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;

Line 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,

Line 39: PROCEDURE Insert_BOM_Lists (x_revised_item_id NUMBER,

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,
41: x_bill_sequence_id NUMBER) IS
42: BEGIN
43: insert into BOM_LISTS (sequence_id, assembly_item_id)

Line 43: insert into BOM_LISTS (sequence_id, assembly_item_id)

39: PROCEDURE Insert_BOM_Lists (x_revised_item_id NUMBER,
40: x_sequence_id NUMBER,
41: x_bill_sequence_id NUMBER) IS
42: BEGIN
43: insert into BOM_LISTS (sequence_id, assembly_item_id)
44: values (x_sequence_id, x_revised_item_id);
45:
46: insert into BOM_LISTS (sequence_id, assembly_item_id)
47: select distinct(x_sequence_id), component_item_id

Line 46: insert into BOM_LISTS (sequence_id, assembly_item_id)

42: BEGIN
43: insert into BOM_LISTS (sequence_id, assembly_item_id)
44: values (x_sequence_id, x_revised_item_id);
45:
46: insert into BOM_LISTS (sequence_id, assembly_item_id)
47: select distinct(x_sequence_id), component_item_id
48: from BOM_INVENTORY_COMPONENTS
49: where bill_sequence_id = x_bill_sequence_id;
50: END Insert_BOM_Lists;

Line 50: END Insert_BOM_Lists;

46: insert into BOM_LISTS (sequence_id, assembly_item_id)
47: select distinct(x_sequence_id), component_item_id
48: from BOM_INVENTORY_COMPONENTS
49: where bill_sequence_id = x_bill_sequence_id;
50: END Insert_BOM_Lists;
51:
52:
53: PROCEDURE Delete_BOM_Lists (x_sequence_id NUMBER) IS
54: BEGIN

Line 53: PROCEDURE Delete_BOM_Lists (x_sequence_id NUMBER) IS

49: where bill_sequence_id = x_bill_sequence_id;
50: END Insert_BOM_Lists;
51:
52:
53: PROCEDURE Delete_BOM_Lists (x_sequence_id NUMBER) IS
54: BEGIN
55: delete from BOM_LISTS
56: where sequence_id = x_sequence_id;
57: END Delete_BOM_Lists;

Line 55: delete from BOM_LISTS

51:
52:
53: PROCEDURE Delete_BOM_Lists (x_sequence_id NUMBER) IS
54: BEGIN
55: delete from BOM_LISTS
56: where sequence_id = x_sequence_id;
57: END Delete_BOM_Lists;
58:
59:

Line 57: END Delete_BOM_Lists;

53: PROCEDURE Delete_BOM_Lists (x_sequence_id NUMBER) IS
54: BEGIN
55: delete from BOM_LISTS
56: where sequence_id = x_sequence_id;
57: END Delete_BOM_Lists;
58:
59:
60: PROCEDURE Delete_Details (x_organization_id NUMBER,
61: x_revised_item_id NUMBER,