6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ENG_Default_Eco';
7:
8: -- Package global used within the package.
9:
10: g_ECO_rec ENG_Eco_PUB.Eco_Rec_Type;
11: g_Unexp_ECO_Rec ENG_Eco_PUB.Eco_unexposed_Rec_Type;
12:
13: -- Get functions.
14:
7:
8: -- Package global used within the package.
9:
10: g_ECO_rec ENG_Eco_PUB.Eco_Rec_Type;
11: g_Unexp_ECO_Rec ENG_Eco_PUB.Eco_unexposed_Rec_Type;
12:
13: -- Get functions.
14:
15: FUNCTION Get_Responsible_Org
47: END Get_Change_Id;
48:
49:
50: PROCEDURE Get_Flex_Eco
51: ( p_ECO_rec IN ENG_ECO_PUB.ECO_Rec_Type
52: , x_ECO_rec OUT NOCOPY ENG_ECO_PUB.ECO_Rec_Type
53: )
54: IS
55: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
48:
49:
50: PROCEDURE Get_Flex_Eco
51: ( p_ECO_rec IN ENG_ECO_PUB.ECO_Rec_Type
52: , x_ECO_rec OUT NOCOPY ENG_ECO_PUB.ECO_Rec_Type
53: )
54: IS
55: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
56: BEGIN
51: ( p_ECO_rec IN ENG_ECO_PUB.ECO_Rec_Type
52: , x_ECO_rec OUT NOCOPY ENG_ECO_PUB.ECO_Rec_Type
53: )
54: IS
55: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
56: BEGIN
57:
58: -- In the future call Flex APIs for defaults
59:
127:
128: -- Procedure Attribute_Defaulting
129:
130: PROCEDURE Attribute_Defaulting
131: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
132: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
133: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
134: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
135: , x_return_status OUT NOCOPY VARCHAR2
128: -- Procedure Attribute_Defaulting
129:
130: PROCEDURE Attribute_Defaulting
131: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
132: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
133: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
134: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
135: , x_return_status OUT NOCOPY VARCHAR2
136: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
129:
130: PROCEDURE Attribute_Defaulting
131: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
132: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
133: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
134: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
135: , x_return_status OUT NOCOPY VARCHAR2
136: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
137: )
130: PROCEDURE Attribute_Defaulting
131: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
132: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
133: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
134: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
135: , x_return_status OUT NOCOPY VARCHAR2
136: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
137: )
138: IS
287:
288: -- Procedure Entity_Defaulting
289:
290: PROCEDURE Entity_Defaulting
291: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
292: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
293: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
294: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
295: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type :=
288: -- Procedure Entity_Defaulting
289:
290: PROCEDURE Entity_Defaulting
291: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
292: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
293: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
294: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
295: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type :=
296: BOM_BO_PUB.G_DEFAULT_CONTROL_REC
289:
290: PROCEDURE Entity_Defaulting
291: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
292: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
293: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
294: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
295: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type :=
296: BOM_BO_PUB.G_DEFAULT_CONTROL_REC
297: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
290: PROCEDURE Entity_Defaulting
291: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
292: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
293: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
294: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
295: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type :=
296: BOM_BO_PUB.G_DEFAULT_CONTROL_REC
297: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
298: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
293: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
294: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
295: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type :=
296: BOM_BO_PUB.G_DEFAULT_CONTROL_REC
297: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
298: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
299: , x_return_status OUT NOCOPY VARCHAR2
300: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
301: )
294: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
295: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type :=
296: BOM_BO_PUB.G_DEFAULT_CONTROL_REC
297: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
298: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
299: , x_return_status OUT NOCOPY VARCHAR2
300: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
301: )
302: IS
300: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
301: )
302: IS
303: l_process_name VARCHAR2(30) := NULL;
304: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
305: l_Unexp_ECO_rec ENG_Eco_PUB.Eco_unexposed_Rec_Type := p_Unexp_ECO_rec;
306: l_processed BOOLEAN := FALSE;
307: l_Token_Tbl Error_Handler.Token_Tbl_Type;
308: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
301: )
302: IS
303: l_process_name VARCHAR2(30) := NULL;
304: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
305: l_Unexp_ECO_rec ENG_Eco_PUB.Eco_unexposed_Rec_Type := p_Unexp_ECO_rec;
306: l_processed BOOLEAN := FALSE;
307: l_Token_Tbl Error_Handler.Token_Tbl_Type;
308: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
309: l_err_text VARCHAR2(2000) := NULL;
840:
841: -- Procedure Populate_NULL_Columns
842:
843: PROCEDURE Populate_NULL_Columns
844: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
845: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
846: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
847: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
848: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
841: -- Procedure Populate_NULL_Columns
842:
843: PROCEDURE Populate_NULL_Columns
844: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
845: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
846: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
847: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
848: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
849: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
842:
843: PROCEDURE Populate_NULL_Columns
844: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
845: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
846: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
847: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
848: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
849: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
850: )
843: PROCEDURE Populate_NULL_Columns
844: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
845: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
846: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
847: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
848: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
849: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
850: )
851: IS
844: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
845: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
846: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
847: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
848: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
849: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
850: )
851: IS
852: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
845: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
846: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
847: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
848: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
849: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
850: )
851: IS
852: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
853: l_Unexp_ECO_rec ENG_Eco_PUB.Eco_unexposed_Rec_Type := p_Unexp_ECO_rec;
848: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
849: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
850: )
851: IS
852: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
853: l_Unexp_ECO_rec ENG_Eco_PUB.Eco_unexposed_Rec_Type := p_Unexp_ECO_rec;
854: BEGIN
855:
856: l_Unexp_ECO_rec.initiation_date := p_old_Unexp_ECO_rec.initiation_date;
849: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
850: )
851: IS
852: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
853: l_Unexp_ECO_rec ENG_Eco_PUB.Eco_unexposed_Rec_Type := p_Unexp_ECO_rec;
854: BEGIN
855:
856: l_Unexp_ECO_rec.initiation_date := p_old_Unexp_ECO_rec.initiation_date;
857: l_Unexp_ECO_rec.implementation_date := p_old_Unexp_ECO_rec.implementation_date;