DBA Data[Home] [Help]

APPS.ENG_VALIDATE_ECO dependencies on ENG_ECO_PUB

Line 238: ( p_eco_rec IN ENG_ECO_PUB.Eco_Rec_Type

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: )

Line 239: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type

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

Line 459: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type

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 :=

Line 460: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_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

Line 461: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type

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:

Line 462: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type

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: )

Line 1155: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type

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

Line 1156: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type

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

Line 1157: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type

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: )

Line 1158: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type

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

Line 1159: , p_change_line_tbl IN ENG_Eco_PUB.Change_Line_Tbl_Type ----Bug 2908248

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) := '';

Line 1160: , p_revised_item_tbl IN ENG_Eco_PUB.Revised_Item_Tbl_Type --Bug 2908248

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;

Line 1168: l_change_line_rec Eng_Eco_Pub.Change_Line_Rec_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

Line 1169: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_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
1173: l_cl_count NUMBER :=0;

Line 2040: , p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type

2036:
2037: PROCEDURE Conditionally_Required
2038: ( x_return_status OUT NOCOPY VARCHAR2
2039: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2040: , p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type
2041: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
2042: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
2043: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
2044: )

Line 2041: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type

2037: PROCEDURE Conditionally_Required
2038: ( x_return_status OUT NOCOPY VARCHAR2
2039: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2040: , p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type
2041: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
2042: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
2043: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
2044: )
2045: IS

Line 2042: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type

2038: ( x_return_status OUT NOCOPY VARCHAR2
2039: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2040: , p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type
2041: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
2042: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
2043: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
2044: )
2045: IS
2046: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2043: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type

2039: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2040: , p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type
2041: , p_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
2042: , p_old_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
2043: , p_old_Unexp_ECO_rec IN ENG_Eco_PUB.Eco_Unexposed_Rec_Type
2044: )
2045: IS
2046: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2047: l_err_text VARCHAR2(2000) := NULL;

Line 2144: , x_eco_rec OUT NOCOPY Eng_Eco_Pub.Eco_Rec_Type

2140: , p_organization_id IN NUMBER
2141: , p_organization_code IN VARCHAR2
2142: , p_calling_entity IN VARCHAR2
2143: , p_transaction_type IN VARCHAR2
2144: , x_eco_rec OUT NOCOPY Eng_Eco_Pub.Eco_Rec_Type
2145: , x_eco_unexp_rec OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2146: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2147: , x_Return_Status OUT NOCOPY VARCHAR2
2148: )

Line 2145: , x_eco_unexp_rec OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type

2141: , p_organization_code IN VARCHAR2
2142: , p_calling_entity IN VARCHAR2
2143: , p_transaction_type IN VARCHAR2
2144: , x_eco_rec OUT NOCOPY Eng_Eco_Pub.Eco_Rec_Type
2145: , x_eco_unexp_rec OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2146: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2147: , x_Return_Status OUT NOCOPY VARCHAR2
2148: )
2149: IS