APPS.BOM_VALIDATE_SUB_COMPONENT dependencies on BOM_BO_PUB

Line 33: Bom_Bo_Pub.Sub_Component_Rec_Type

29: /*********************** Entity **********************************************/
30:
31: PROCEDURE CHECK_REQUIRED( x_return_status IN OUT NOCOPY VARCHAR2
32: , p_sub_component_rec IN
33: Bom_Bo_Pub.Sub_Component_Rec_Type
34: , x_Mesg_Token_tbl IN OUT NOCOPY
35: Error_Handler.Mesg_Token_Tbl_Type
36: )
37: IS

Line 90: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

86: *********************************************************************/
87: PROCEDURE Check_Entity
88: ( x_return_status IN OUT NOCOPY VARCHAR2
89: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
90: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
91: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
92: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
93: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
94: )

Line 91: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

87: PROCEDURE Check_Entity
88: ( x_return_status IN OUT NOCOPY VARCHAR2
89: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
90: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
91: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
92: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
93: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
94: )
95: IS

Line 92: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

88: ( x_return_status IN OUT NOCOPY VARCHAR2
89: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
90: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
91: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
92: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
93: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
94: )
95: IS
96: l_temp_var NUMBER :=0;

Line 93: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC

89: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
90: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
91: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
92: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
93: := BOM_BO_PUB.G_DEFAULT_CONTROL_REC
94: )
95: IS
96: l_temp_var NUMBER :=0;
97: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 668: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

664:
665: PROCEDURE Check_Attributes
666: ( x_return_status IN OUT NOCOPY VARCHAR2
667: , x_Mesg_Token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
668: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
669: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
670: )
671: IS
672: l_dummy VARCHAR2(1);

Line 669: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

665: PROCEDURE Check_Attributes
666: ( x_return_status IN OUT NOCOPY VARCHAR2
667: , x_Mesg_Token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
668: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
669: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
670: )
671: IS
672: l_dummy VARCHAR2(1);
673: l_return_status VARCHAR2(1);

Line 761: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

757:
758: PROCEDURE Check_Entity_Delete
759: ( x_return_status IN OUT NOCOPY VARCHAR2
760: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
761: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
762: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
763: )
764: IS
765: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 762: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

758: PROCEDURE Check_Entity_Delete
759: ( x_return_status IN OUT NOCOPY VARCHAR2
760: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
761: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
762: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
763: )
764: IS
765: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
766: l_err_text VARCHAR2(255);

Line 791: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

787: * the procedure will query the existing record and return them
788: * as old records.
789: ***************************************************************************/
790: PROCEDURE Check_Existence
791: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
792: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
793: , x_old_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
794: , x_old_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
795: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 792: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

788: * as old records.
789: ***************************************************************************/
790: PROCEDURE Check_Existence
791: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
792: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
793: , x_old_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
794: , x_old_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
795: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
796: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 793: , x_old_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type

789: ***************************************************************************/
790: PROCEDURE Check_Existence
791: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
792: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
793: , x_old_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
794: , x_old_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
795: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
796: , x_Return_Status IN OUT NOCOPY VARCHAR2
797: )

Line 794: , x_old_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

790: PROCEDURE Check_Existence
791: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
792: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
793: , x_old_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
794: , x_old_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
795: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
796: , x_Return_Status IN OUT NOCOPY VARCHAR2
797: )
798: IS

Line 896: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

892: * hold good in the production tables based on the data that
893: * the user has given.
894: *****************************************************************************/
895: PROCEDURE Check_Lineage
896: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
897: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
898: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
899: , x_Return_Status IN OUT NOCOPY VARCHAR2
900: )

Line 897: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

893: * the user has given.
894: *****************************************************************************/
895: PROCEDURE Check_Lineage
896: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
897: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
898: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
899: , x_Return_Status IN OUT NOCOPY VARCHAR2
900: )
901: IS

Line 960: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

956: * Component. It will also verify that the revised item is not
957: * already implemented or canceled.
958: ****************************************************************************/
959: PROCEDURE Check_Access
960: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
961: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
962: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
963: , x_Return_Status IN OUT NOCOPY VARCHAR2
964: )

Line 961: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

957: * already implemented or canceled.
958: ****************************************************************************/
959: PROCEDURE Check_Access
960: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
961: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
962: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
963: , x_Return_Status IN OUT NOCOPY VARCHAR2
964: )
965: IS

Line 1054: , p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

1050: ** Procedures for BOM Business Object
1051: */
1052: PROCEDURE Check_Required
1053: ( x_return_status IN OUT NOCOPY VARCHAR2
1054: , p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1055: , x_Mesg_Token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1056: )
1057: IS
1058: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

Line 1058: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

1054: , p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1055: , x_Mesg_Token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1056: )
1057: IS
1058: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1059: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1060: BEGIN
1061: --
1062: -- Convert the BOM Record

Line 1059: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

1055: , x_Mesg_Token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1056: )
1057: IS
1058: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1059: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1060: BEGIN
1061: --
1062: -- Convert the BOM Record
1063: --

Line 1064: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp

1060: BEGIN
1061: --
1062: -- Convert the BOM Record
1063: --
1064: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp
1065: ( p_bom_sub_component_rec => p_bom_sub_component_rec
1066: , x_sub_component_rec => l_sub_component_rec
1067: , x_sub_comp_unexp_rec => l_sub_comp_unexp_rec
1068: );

Line 1087: , p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

1083:
1084: PROCEDURE Check_Entity
1085: ( x_return_status IN OUT NOCOPY VARCHAR2
1086: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1087: , p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1088: , p_bom_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1089: )
1090: IS
1091: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

Line 1088: , p_bom_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

1084: PROCEDURE Check_Entity
1085: ( x_return_status IN OUT NOCOPY VARCHAR2
1086: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1087: , p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1088: , p_bom_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1089: )
1090: IS
1091: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1092: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

Line 1091: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

1087: , p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1088: , p_bom_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1089: )
1090: IS
1091: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1092: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1093: BEGIN
1094: --
1095: -- Convert the BOM Record

Line 1092: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

1088: , p_bom_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1089: )
1090: IS
1091: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1092: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1093: BEGIN
1094: --
1095: -- Convert the BOM Record
1096: --

Line 1097: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp

1093: BEGIN
1094: --
1095: -- Convert the BOM Record
1096: --
1097: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp
1098: ( p_bom_sub_component_rec => p_bom_sub_component_rec
1099: , p_bom_sub_comp_unexp_rec => p_bom_sub_comp_unexp_rec
1100: , x_sub_component_rec => l_sub_component_rec
1101: , x_sub_comp_unexp_rec => l_sub_comp_unexp_rec

Line 1121: , p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

1117:
1118: PROCEDURE Check_Attributes
1119: ( x_return_status IN OUT NOCOPY VARCHAR2
1120: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1121: , p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1122: , p_bom_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1123: )
1124: IS
1125: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

Line 1122: , p_bom_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

1118: PROCEDURE Check_Attributes
1119: ( x_return_status IN OUT NOCOPY VARCHAR2
1120: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1121: , p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1122: , p_bom_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1123: )
1124: IS
1125: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1126: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

Line 1125: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

1121: , p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1122: , p_bom_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1123: )
1124: IS
1125: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1126: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1127: BEGIN
1128:
1129: --

Line 1126: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

1122: , p_bom_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1123: )
1124: IS
1125: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1126: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1127: BEGIN
1128:
1129: --
1130: -- Convert the BOM Record

Line 1132: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp

1128:
1129: --
1130: -- Convert the BOM Record
1131: --
1132: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp
1133: ( p_bom_sub_component_rec => p_bom_sub_component_rec
1134: , p_bom_sub_comp_unexp_rec => p_bom_sub_comp_unexp_rec
1135: , x_sub_component_rec => l_sub_component_rec
1136: , x_sub_comp_unexp_rec => l_sub_comp_unexp_rec

Line 1155: , p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

1151:
1152: PROCEDURE Check_Entity_Delete
1153: ( x_return_status IN OUT NOCOPY VARCHAR2
1154: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1155: , p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1156: , p_bom_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1157: )
1158: IS
1159: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

Line 1156: , p_bom_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

1152: PROCEDURE Check_Entity_Delete
1153: ( x_return_status IN OUT NOCOPY VARCHAR2
1154: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1155: , p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1156: , p_bom_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1157: )
1158: IS
1159: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1160: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

Line 1159: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

1155: , p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1156: , p_bom_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1157: )
1158: IS
1159: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1160: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1161: BEGIN
1162:
1163: --

Line 1160: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

1156: , p_bom_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1157: )
1158: IS
1159: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1160: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1161: BEGIN
1162:
1163: --
1164: -- Convert the BOM Record

Line 1166: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp

1162:
1163: --
1164: -- Convert the BOM Record
1165: --
1166: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp
1167: ( p_bom_sub_component_rec => p_bom_sub_component_rec
1168: , x_sub_component_rec => l_sub_component_rec
1169: , x_sub_comp_unexp_rec => l_sub_comp_unexp_rec
1170: );

Line 1184: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

1180:
1181: END Check_Entity_Delete;
1182:
1183: PROCEDURE Check_Existence
1184: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1185: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1186: , x_old_bom_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1187: , x_old_bom_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1188: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1185: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

1181: END Check_Entity_Delete;
1182:
1183: PROCEDURE Check_Existence
1184: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1185: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1186: , x_old_bom_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1187: , x_old_bom_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1188: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1189: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 1186: , x_old_bom_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

1182:
1183: PROCEDURE Check_Existence
1184: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1185: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1186: , x_old_bom_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1187: , x_old_bom_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1188: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1189: , x_Return_Status IN OUT NOCOPY VARCHAR2
1190: )

Line 1187: , x_old_bom_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

1183: PROCEDURE Check_Existence
1184: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1185: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1186: , x_old_bom_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1187: , x_old_bom_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1188: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1189: , x_Return_Status IN OUT NOCOPY VARCHAR2
1190: )
1191: IS

Line 1192: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

1188: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1189: , x_Return_Status IN OUT NOCOPY VARCHAR2
1190: )
1191: IS
1192: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1193: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1194: l_old_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1195: l_old_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1196: BEGIN

Line 1193: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

1189: , x_Return_Status IN OUT NOCOPY VARCHAR2
1190: )
1191: IS
1192: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1193: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1194: l_old_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1195: l_old_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1196: BEGIN
1197:

Line 1194: l_old_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

1190: )
1191: IS
1192: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1193: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1194: l_old_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1195: l_old_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1196: BEGIN
1197:
1198: --

Line 1195: l_old_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

1191: IS
1192: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1193: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1194: l_old_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1195: l_old_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1196: BEGIN
1197:
1198: --
1199: -- Convert the BOM Record

Line 1201: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp

1197:
1198: --
1199: -- Convert the BOM Record
1200: --
1201: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp
1202: ( p_bom_sub_component_rec => p_bom_sub_component_rec
1203: , p_bom_sub_comp_unexp_rec => p_bom_sub_comp_unexp_rec
1204: , x_sub_component_rec => l_sub_component_rec
1205: , x_sub_comp_unexp_rec => l_sub_comp_unexp_rec

Line 1221: Bom_Bo_Pub.Convert_EcoSComp_To_BomSComp

1217: --
1218: -- Convert the Old record received from Check Existence
1219: --
1220:
1221: Bom_Bo_Pub.Convert_EcoSComp_To_BomSComp
1222: ( p_sub_component_rec => l_old_sub_component_rec
1223: , p_sub_comp_unexp_rec => l_old_sub_comp_unexp_rec
1224: , x_bom_sub_component_rec => x_old_bom_sub_component_rec
1225: , x_bom_sub_comp_unexp_rec => x_old_bom_sub_comp_unexp_rec

Line 1231: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

1227:
1228: END Check_Existence;
1229:
1230: PROCEDURE Check_Lineage
1231: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1232: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1233: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1234: , x_Return_Status IN OUT NOCOPY VARCHAR2
1235: )

Line 1232: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

1228: END Check_Existence;
1229:
1230: PROCEDURE Check_Lineage
1231: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1232: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1233: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1234: , x_Return_Status IN OUT NOCOPY VARCHAR2
1235: )
1236: IS

Line 1237: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

1233: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1234: , x_Return_Status IN OUT NOCOPY VARCHAR2
1235: )
1236: IS
1237: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1238: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1239: BEGIN
1240:
1241: --

Line 1238: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

1234: , x_Return_Status IN OUT NOCOPY VARCHAR2
1235: )
1236: IS
1237: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1238: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1239: BEGIN
1240:
1241: --
1242: -- Convert the BOM Record

Line 1244: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp

1240:
1241: --
1242: -- Convert the BOM Record
1243: --
1244: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp
1245: ( p_bom_sub_component_rec => p_bom_sub_component_rec
1246: , x_sub_component_rec => l_sub_component_rec
1247: , x_sub_comp_unexp_rec => l_sub_comp_unexp_rec
1248: );

Line 1260: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

1256:
1257: END Check_Lineage;
1258:
1259: PROCEDURE Check_Access
1260: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1261: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1262: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1263: , x_Return_Status IN OUT NOCOPY VARCHAR2
1264: )

Line 1261: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

1257: END Check_Lineage;
1258:
1259: PROCEDURE Check_Access
1260: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
1261: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
1262: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1263: , x_Return_Status IN OUT NOCOPY VARCHAR2
1264: )
1265: IS

Line 1266: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

1262: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1263: , x_Return_Status IN OUT NOCOPY VARCHAR2
1264: )
1265: IS
1266: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1267: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1268: BEGIN
1269:
1270: --

Line 1267: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

1263: , x_Return_Status IN OUT NOCOPY VARCHAR2
1264: )
1265: IS
1266: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
1267: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
1268: BEGIN
1269:
1270: --
1271: -- Convert the BOM Record

Line 1273: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp

1269:
1270: --
1271: -- Convert the BOM Record
1272: --
1273: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp
1274: ( p_bom_sub_component_rec => p_bom_sub_component_rec
1275: , p_bom_sub_comp_unexp_rec => p_bom_sub_comp_unexp_rec
1276: , x_sub_component_rec => l_sub_component_rec
1277: , x_sub_comp_unexp_rec => l_sub_comp_unexp_rec