DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REVISED_ITEM dependencies on ENG_ECO_PUB

Line 1098: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

1094: * not be rescheduled.
1095: ******************************************************************************/
1096:
1097: FUNCTION Check_Rtg_Reschedule
1098: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
1099: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_item_unexposed_rec_type
1100: )RETURN BOOLEAN
1101: IS
1102:

Line 1099: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_item_unexposed_rec_type

1095: ******************************************************************************/
1096:
1097: FUNCTION Check_Rtg_Reschedule
1098: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
1099: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_item_unexposed_rec_type
1100: )RETURN BOOLEAN
1101: IS
1102:
1103: l_ret_status BOOLEAN := TRUE ;

Line 1158: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

1154: * the function return True and the revised item can be re-
1155: * scheduled.
1156: ******************************************************************************/
1157: FUNCTION Check_Reschedule
1158: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
1159: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_item_unexposed_rec_type
1160: )RETURN NUMBER
1161: IS
1162: l_count1 NUMBER := 0;

Line 1159: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_item_unexposed_rec_type

1155: * scheduled.
1156: ******************************************************************************/
1157: FUNCTION Check_Reschedule
1158: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
1159: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_item_unexposed_rec_type
1160: )RETURN NUMBER
1161: IS
1162: l_count1 NUMBER := 0;
1163: l_count2 NUMBER := NULL;

Line 1985: , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type

1981: *****************************************************************************/
1982: PROCEDURE Check_Required
1983: ( x_return_status OUT NOCOPY VARCHAR2
1984: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1985: , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
1986: )
1987: IS
1988: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1989: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 2056: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

2052: * necessary cross entity validations and will also make sure
2053: * the user is not entering conflicting values for columns.
2054: ******************************************************************************/
2055: PROCEDURE Check_Entity
2056: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
2057: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2058: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
2059: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2060: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type

Line 2057: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

2053: * the user is not entering conflicting values for columns.
2054: ******************************************************************************/
2055: PROCEDURE Check_Entity
2056: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
2057: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2058: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
2059: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2060: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
2061: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC

Line 2058: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

2054: ******************************************************************************/
2055: PROCEDURE Check_Entity
2056: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
2057: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2058: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
2059: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2060: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
2061: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
2062: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2059: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

2055: PROCEDURE Check_Entity
2056: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
2057: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2058: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
2059: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
2060: , p_control_rec IN BOM_BO_Pub.Control_Rec_Type
2061: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
2062: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2063: , x_Return_Status OUT NOCOPY VARCHAR2

Line 5341: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

5337: *****************************************************************************/
5338: PROCEDURE Check_Attributes
5339: ( x_return_status OUT NOCOPY VARCHAR2
5340: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5341: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5342: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5343: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5344: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5345: )

Line 5342: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

5338: PROCEDURE Check_Attributes
5339: ( x_return_status OUT NOCOPY VARCHAR2
5340: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5341: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5342: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5343: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5344: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5345: )
5346: IS

Line 5343: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

5339: ( x_return_status OUT NOCOPY VARCHAR2
5340: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5341: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5342: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5343: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5344: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5345: )
5346: IS
5347: l_err_text VARCHAR2(2000) := NULL;

Line 5344: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

5340: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5341: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5342: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5343: , p_old_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5344: , p_old_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5345: )
5346: IS
5347: l_err_text VARCHAR2(2000) := NULL;
5348: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 5872: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

5868: ******************************************************************************/
5869: PROCEDURE Check_Entity_Delete
5870: ( x_return_status OUT NOCOPY VARCHAR2
5871: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5872: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5873: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5874: )
5875: IS
5876: l_err_text VARCHAR2(2000) := NULL;

Line 5873: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

5869: PROCEDURE Check_Entity_Delete
5870: ( x_return_status OUT NOCOPY VARCHAR2
5871: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
5872: , p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
5873: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
5874: )
5875: IS
5876: l_err_text VARCHAR2(2000) := NULL;
5877: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 6117: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type

6113: * with a success status.
6114: ****************************************************************************/
6115:
6116: PROCEDURE Check_Existence
6117: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
6118: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6119: , x_old_revised_item_rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
6120: , x_old_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6121: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 6118: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

6114: ****************************************************************************/
6115:
6116: PROCEDURE Check_Existence
6117: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
6118: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6119: , x_old_revised_item_rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
6120: , x_old_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6121: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
6122: , x_Return_Status OUT NOCOPY VARCHAR2

Line 6119: , x_old_revised_item_rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type

6115:
6116: PROCEDURE Check_Existence
6117: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
6118: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6119: , x_old_revised_item_rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
6120: , x_old_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6121: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
6122: , x_Return_Status OUT NOCOPY VARCHAR2
6123: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642

Line 6120: , x_old_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

6116: PROCEDURE Check_Existence
6117: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
6118: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6119: , x_old_revised_item_rec IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Rec_Type
6120: , x_old_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6121: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
6122: , x_Return_Status OUT NOCOPY VARCHAR2
6123: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
6124: )

Line 6257: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type

6253: * Added for Enhancement 5470261
6254:
6255: ****************************************************************************/
6256: PROCEDURE Check_Access_Scheduled
6257: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
6258: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6259:
6260: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
6261: , x_Return_Status OUT NOCOPY VARCHAR2

Line 6258: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type

6254:
6255: ****************************************************************************/
6256: PROCEDURE Check_Access_Scheduled
6257: ( p_revised_item_rec IN ENG_Eco_PUB.Revised_Item_Rec_Type
6258: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
6259:
6260: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
6261: , x_Return_Status OUT NOCOPY VARCHAR2
6262: )

Line 7006: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;

7002: l_api_version CONSTANT NUMBER := 1.0;
7003: l_return_status VARCHAR2(1);
7004: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
7005:
7006: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
7007: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
7008: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
7009: l_old_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
7010: l_control_rec BOM_BO_Pub.Control_Rec_Type;

Line 7007: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;

7003: l_return_status VARCHAR2(1);
7004: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
7005:
7006: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
7007: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
7008: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
7009: l_old_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
7010: l_control_rec BOM_BO_Pub.Control_Rec_Type;
7011:

Line 7008: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;

7004: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
7005:
7006: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
7007: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
7008: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
7009: l_old_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
7010: l_control_rec BOM_BO_Pub.Control_Rec_Type;
7011:
7012: EXC_ERR_PVT_API_MAIN EXCEPTION;

Line 7009: l_old_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;

7005:
7006: l_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
7007: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
7008: l_old_revised_item_rec ENG_Eco_PUB.Revised_Item_Rec_Type;
7009: l_old_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
7010: l_control_rec BOM_BO_Pub.Control_Rec_Type;
7011:
7012: EXC_ERR_PVT_API_MAIN EXCEPTION;
7013: