DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REVISED_ITEM dependencies on ENG_ECO_PUB

Line 1154: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

1150: * not be rescheduled.
1151: ******************************************************************************/
1152:
1153: FUNCTION Check_Rtg_Reschedule
1154: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
1155: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_item_unexposed_rec_type
1156: )RETURN BOOLEAN
1157: IS
1158:

Line 1155: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_item_unexposed_rec_type

1151: ******************************************************************************/
1152:
1153: FUNCTION Check_Rtg_Reschedule
1154: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
1155: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_item_unexposed_rec_type
1156: )RETURN BOOLEAN
1157: IS
1158:
1159: l_ret_status BOOLEAN := TRUE ;

Line 1214: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

1210: * the function return True and the revised item can be re-
1211: * scheduled.
1212: ******************************************************************************/
1213: FUNCTION Check_Reschedule
1214: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
1215: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_item_unexposed_rec_type
1216: )RETURN NUMBER
1217: IS
1218: l_count1 NUMBER := 0;

Line 1215: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_item_unexposed_rec_type

1211: * scheduled.
1212: ******************************************************************************/
1213: FUNCTION Check_Reschedule
1214: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
1215: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_item_unexposed_rec_type
1216: )RETURN NUMBER
1217: IS
1218: l_count1 NUMBER := 0;
1219: l_count2 NUMBER := NULL;

Line 2057: , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type

2053: *****************************************************************************/
2054: PROCEDURE Check_Required
2055: ( x_return_status OUT NOCOPY VARCHAR2
2056: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2057: , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
2058: )
2059: IS
2060: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2061: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 2128: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

2124: * necessary cross entity validations and will also make sure
2125: * the user is not entering conflicting values for columns.
2126: ******************************************************************************/
2127: PROCEDURE Check_Entity
2128: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
2129: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2130: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
2131: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2132: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type

Line 2129: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

2125: * the user is not entering conflicting values for columns.
2126: ******************************************************************************/
2127: PROCEDURE Check_Entity
2128: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
2129: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2130: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
2131: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2132: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
2133: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC

Line 2130: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

2126: ******************************************************************************/
2127: PROCEDURE Check_Entity
2128: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
2129: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2130: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
2131: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2132: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
2133: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
2134: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2131: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

2127: PROCEDURE Check_Entity
2128: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
2129: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2130: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
2131: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2132: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
2133: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
2134: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2135: , x_Return_Status OUT NOCOPY VARCHAR2

Line 5422: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

5418: *****************************************************************************/
5419: PROCEDURE Check_Attributes
5420: ( x_return_status OUT NOCOPY VARCHAR2
5421: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5422: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5423: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5424: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5425: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5426: )

Line 5423: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

5419: PROCEDURE Check_Attributes
5420: ( x_return_status OUT NOCOPY VARCHAR2
5421: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5422: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5423: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5424: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5425: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5426: )
5427: IS

Line 5424: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

5420: ( x_return_status OUT NOCOPY VARCHAR2
5421: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5422: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5423: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5424: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5425: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5426: )
5427: IS
5428: l_err_text VARCHAR2(2000) := NULL;

Line 5425: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

5421: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5422: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5423: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5424: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5425: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5426: )
5427: IS
5428: l_err_text VARCHAR2(2000) := NULL;
5429: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 5953: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

5949: ******************************************************************************/
5950: PROCEDURE Check_Entity_Delete
5951: ( x_return_status OUT NOCOPY VARCHAR2
5952: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5953: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5954: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5955: )
5956: IS
5957: l_err_text VARCHAR2(2000) := NULL;

Line 5954: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

5950: PROCEDURE Check_Entity_Delete
5951: ( x_return_status OUT NOCOPY VARCHAR2
5952: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5953: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5954: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5955: )
5956: IS
5957: l_err_text VARCHAR2(2000) := NULL;
5958: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 6203: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type

6199: * with a success status.
6200: ****************************************************************************/
6201:
6202: PROCEDURE Check_Existence
6203: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
6204: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6205: , x_old_revised_item_rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
6206: , x_old_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6207: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 6204: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

6200: ****************************************************************************/
6201:
6202: PROCEDURE Check_Existence
6203: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
6204: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6205: , x_old_revised_item_rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
6206: , x_old_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6207: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
6208: , x_Return_Status OUT NOCOPY VARCHAR2

Line 6205: , x_old_revised_item_rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type

6201:
6202: PROCEDURE Check_Existence
6203: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
6204: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6205: , x_old_revised_item_rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
6206: , x_old_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6207: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
6208: , x_Return_Status OUT NOCOPY VARCHAR2
6209: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642

Line 6206: , x_old_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

6202: PROCEDURE Check_Existence
6203: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
6204: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6205: , x_old_revised_item_rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
6206: , x_old_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6207: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
6208: , x_Return_Status OUT NOCOPY VARCHAR2
6209: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
6210: )

Line 6343: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

6339: * Added for Enhancement 5470261
6340:
6341: ****************************************************************************/
6342: PROCEDURE Check_Access_Scheduled
6343: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
6344: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6345:
6346: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
6347: , x_Return_Status OUT NOCOPY VARCHAR2

Line 6344: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

6340:
6341: ****************************************************************************/
6342: PROCEDURE Check_Access_Scheduled
6343: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
6344: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6345:
6346: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
6347: , x_Return_Status OUT NOCOPY VARCHAR2
6348: )

Line 7096: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;

7092: l_api_version CONSTANT NUMBER := 1.0;
7093: l_return_status VARCHAR2(1);
7094: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
7095:
7096: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
7097: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
7098: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
7099: l_old_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
7100: l_control_rec BOM_BO_Pub.Control_Rec_Type;

Line 7097: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;

7093: l_return_status VARCHAR2(1);
7094: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
7095:
7096: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
7097: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
7098: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
7099: l_old_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
7100: l_control_rec BOM_BO_Pub.Control_Rec_Type;
7101:

Line 7098: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;

7094: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
7095:
7096: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
7097: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
7098: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
7099: l_old_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
7100: l_control_rec BOM_BO_Pub.Control_Rec_Type;
7101:
7102: EXC_ERR_PVT_API_MAIN EXCEPTION;

Line 7099: l_old_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;

7095:
7096: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
7097: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
7098: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
7099: l_old_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
7100: l_control_rec BOM_BO_Pub.Control_Rec_Type;
7101:
7102: EXC_ERR_PVT_API_MAIN EXCEPTION;
7103: