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
333:
334: -- Procedure Entity_Defaulting
335:
336: PROCEDURE Entity_Defaulting
337: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
338: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
339: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
340: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
341: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type :=
334: -- Procedure Entity_Defaulting
335:
336: PROCEDURE Entity_Defaulting
337: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
338: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
339: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
340: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
341: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type :=
342: BOM_BO_PUB.G_DEFAULT_CONTROL_REC
335:
336: PROCEDURE Entity_Defaulting
337: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
338: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
339: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
340: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
341: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type :=
342: BOM_BO_PUB.G_DEFAULT_CONTROL_REC
343: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
336: PROCEDURE Entity_Defaulting
337: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
338: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
339: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
340: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
341: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type :=
342: BOM_BO_PUB.G_DEFAULT_CONTROL_REC
343: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
344: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
339: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
340: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
341: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type :=
342: BOM_BO_PUB.G_DEFAULT_CONTROL_REC
343: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
344: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
345: , x_return_status OUT NOCOPY VARCHAR2
346: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
347: )
340: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
341: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type :=
342: BOM_BO_PUB.G_DEFAULT_CONTROL_REC
343: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
344: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
345: , x_return_status OUT NOCOPY VARCHAR2
346: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
347: )
348: IS
346: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
347: )
348: IS
349: l_process_name VARCHAR2(30) := NULL;
350: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
351: l_Unexp_ECO_rec ENG_Eco_PUB.Eco_unexposed_Rec_Type := p_Unexp_ECO_rec;
352: l_processed BOOLEAN := FALSE;
353: l_Token_Tbl Error_Handler.Token_Tbl_Type;
354: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
347: )
348: IS
349: l_process_name VARCHAR2(30) := NULL;
350: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
351: l_Unexp_ECO_rec ENG_Eco_PUB.Eco_unexposed_Rec_Type := p_Unexp_ECO_rec;
352: l_processed BOOLEAN := FALSE;
353: l_Token_Tbl Error_Handler.Token_Tbl_Type;
354: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
355: l_err_text VARCHAR2(2000) := NULL;
886:
887: -- Procedure Populate_NULL_Columns
888:
889: PROCEDURE Populate_NULL_Columns
890: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
891: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
892: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
893: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
894: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
887: -- Procedure Populate_NULL_Columns
888:
889: PROCEDURE Populate_NULL_Columns
890: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
891: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
892: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
893: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
894: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
895: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
888:
889: PROCEDURE Populate_NULL_Columns
890: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
891: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
892: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
893: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
894: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
895: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
896: )
889: PROCEDURE Populate_NULL_Columns
890: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
891: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
892: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
893: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
894: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
895: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
896: )
897: IS
890: ( p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
891: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
892: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
893: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
894: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
895: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
896: )
897: IS
898: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
891: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
892: , p_Old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
893: , p_Old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_unexposed_Rec_Type
894: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
895: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
896: )
897: IS
898: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
899: l_Unexp_ECO_rec ENG_Eco_PUB.Eco_unexposed_Rec_Type := p_Unexp_ECO_rec;
894: , x_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
895: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
896: )
897: IS
898: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
899: l_Unexp_ECO_rec ENG_Eco_PUB.Eco_unexposed_Rec_Type := p_Unexp_ECO_rec;
900: BEGIN
901:
902: l_Unexp_ECO_rec.initiation_date := p_old_Unexp_ECO_rec.initiation_date;
895: , x_Unexp_ECO_rec IN OUT NOCOPY ENG_Eco_PUB.Eco_unexposed_Rec_Type
896: )
897: IS
898: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
899: l_Unexp_ECO_rec ENG_Eco_PUB.Eco_unexposed_Rec_Type := p_Unexp_ECO_rec;
900: BEGIN
901:
902: l_Unexp_ECO_rec.initiation_date := p_old_Unexp_ECO_rec.initiation_date;
903: l_Unexp_ECO_rec.implementation_date := p_old_Unexp_ECO_rec.implementation_date;