234:
235: --Procedure Check_Delete
236:
237: PROCEDURE Check_Delete
238: ( p_eco_rec IN ENG_ECO_PUB.Eco_Rec_Type
239: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
240: , x_return_status OUT NOCOPY VARCHAR2
241: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
242: )
235: --Procedure Check_Delete
236:
237: PROCEDURE Check_Delete
238: ( p_eco_rec IN ENG_ECO_PUB.Eco_Rec_Type
239: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
240: , x_return_status OUT NOCOPY VARCHAR2
241: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
242: )
243: IS
455: PROCEDURE Check_Entity
456: ( x_return_status OUT NOCOPY VARCHAR2
457: , x_err_text OUT NOCOPY VARCHAR2
458: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
459: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
460: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
461: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
462: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
463: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type :=
456: ( x_return_status OUT NOCOPY VARCHAR2
457: , x_err_text OUT NOCOPY VARCHAR2
458: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
459: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
460: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
461: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
462: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
463: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type :=
464: BOM_BO_PUB.G_DEFAULT_CONTROL_REC
457: , x_err_text OUT NOCOPY VARCHAR2
458: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
459: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
460: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
461: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
462: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
463: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type :=
464: BOM_BO_PUB.G_DEFAULT_CONTROL_REC
465:
458: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
459: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
460: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
461: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
462: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
463: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type :=
464: BOM_BO_PUB.G_DEFAULT_CONTROL_REC
465:
466: )
1151: PROCEDURE Check_Attributes
1152: ( x_return_status OUT NOCOPY VARCHAR2
1153: , x_err_text OUT NOCOPY VARCHAR2
1154: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1155: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
1156: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
1157: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
1158: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
1159: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type ----Bug 2908248
1152: ( x_return_status OUT NOCOPY VARCHAR2
1153: , x_err_text OUT NOCOPY VARCHAR2
1154: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1155: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
1156: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
1157: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
1158: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
1159: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type ----Bug 2908248
1160: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type --Bug 2908248
1153: , x_err_text OUT NOCOPY VARCHAR2
1154: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1155: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
1156: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
1157: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
1158: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
1159: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type ----Bug 2908248
1160: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type --Bug 2908248
1161: )
1154: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1155: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
1156: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
1157: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
1158: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
1159: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type ----Bug 2908248
1160: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type --Bug 2908248
1161: )
1162: IS
1155: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
1156: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
1157: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
1158: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
1159: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type ----Bug 2908248
1160: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type --Bug 2908248
1161: )
1162: IS
1163: l_err_text VARCHAR2(2000) := '';
1156: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
1157: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
1158: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
1159: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type ----Bug 2908248
1160: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type --Bug 2908248
1161: )
1162: IS
1163: l_err_text VARCHAR2(2000) := '';
1164: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1164: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1165: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1166: l_disable_date DATE;
1167: ----Bug 2908248
1168: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
1169: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type ;
1170: l_change_id NUMBER :=0;
1171:
1172: l_cl_cico_count NUMBER :=0; --count of cancelled/implemented/completed chnage lines
1165: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1166: l_disable_date DATE;
1167: ----Bug 2908248
1168: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_Type ;
1169: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type ;
1170: l_change_id NUMBER :=0;
1171:
1172: l_cl_cico_count NUMBER :=0; --count of cancelled/implemented/completed chnage lines
1173: l_cl_count NUMBER :=0;
2033:
2034: PROCEDURE Conditionally_Required
2035: ( x_return_status OUT NOCOPY VARCHAR2
2036: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2037: , p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type
2038: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
2039: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
2040: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
2041: )
2034: PROCEDURE Conditionally_Required
2035: ( x_return_status OUT NOCOPY VARCHAR2
2036: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2037: , p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type
2038: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
2039: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
2040: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
2041: )
2042: IS
2035: ( x_return_status OUT NOCOPY VARCHAR2
2036: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2037: , p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type
2038: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
2039: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
2040: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
2041: )
2042: IS
2043: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2036: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2037: , p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type
2038: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
2039: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
2040: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
2041: )
2042: IS
2043: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2044: l_err_text VARCHAR2(2000) := NULL;
2137: , p_organization_id IN NUMBER
2138: , p_organization_code IN VARCHAR2
2139: , p_calling_entity IN VARCHAR2
2140: , p_transaction_type IN VARCHAR2
2141: , x_eco_rec OUT NOCOPY Eng_Eco_Pub.Eco_Rec_Type
2142: , x_eco_unexp_rec OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2143: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2144: , x_Return_Status OUT NOCOPY VARCHAR2
2145: )
2138: , p_organization_code IN VARCHAR2
2139: , p_calling_entity IN VARCHAR2
2140: , p_transaction_type IN VARCHAR2
2141: , x_eco_rec OUT NOCOPY Eng_Eco_Pub.Eco_Rec_Type
2142: , x_eco_unexp_rec OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2143: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2144: , x_Return_Status OUT NOCOPY VARCHAR2
2145: )
2146: IS