DBA Data[Home] [Help]

APPS.ENG_ECO_PUB dependencies on BOM_RTG_PUB

Line 170: ( p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type

166: * Parameters OUT: N/A
167: * Purpose : This function is to check all the records have the * same change_notice and same organization.
168: *********************************************************************/
169: FUNCTION Does_Op_Have_Same_ECO
170: ( p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
171: , p_change_notice IN VARCHAR2
172: , p_organization_code IN VARCHAR2
173: ) RETURN BOOLEAN
174: IS

Line 206: ( p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type

202: * Parameters OUT: N/A
203: * Purpose : This function is to check all the records have the * same change_notice and same organization.
204: *********************************************************************/
205: FUNCTION Does_Res_Have_Same_ECO
206: ( p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
207: , p_change_notice IN VARCHAR2
208: , p_organization_code IN VARCHAR2
209: ) RETURN BOOLEAN
210: IS

Line 242: ( p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

238: * Parameters OUT: N/A
239: * Purpose : This function is to check all the records have the * same change_notice and same organization.
240: *********************************************************************/
241: FUNCTION Does_SubRes_Have_Same_ECO
242: ( p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
243: , p_change_notice IN VARCHAR2
244: , p_organization_code IN VARCHAR2
245: ) RETURN BOOLEAN
246: IS

Line 316: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type

312: , p_revised_item_tbl IN ENG_ECO_PUB.Revised_Item_Tbl_Type
313: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
314: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
315: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
316: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
317: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
318: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
319: , p_change_line_tbl IN ENG_ECO_PUB.Change_Line_Tbl_Type -- Eng Change
320: , x_change_notice OUT NOCOPY VARCHAR2

Line 317: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type

313: , p_rev_component_tbl IN BOM_BO_PUB.Rev_Component_Tbl_Type
314: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
315: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
316: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
317: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
318: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
319: , p_change_line_tbl IN ENG_ECO_PUB.Change_Line_Tbl_Type -- Eng Change
320: , x_change_notice OUT NOCOPY VARCHAR2
321: , x_organization_code OUT NOCOPY VARCHAR2

Line 318: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

314: , p_ref_designator_tbl IN BOM_BO_PUB.Ref_Designator_Tbl_Type
315: , p_sub_component_tbl IN BOM_BO_PUB.Sub_Component_Tbl_Type
316: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
317: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
318: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
319: , p_change_line_tbl IN ENG_ECO_PUB.Change_Line_Tbl_Type -- Eng Change
320: , x_change_notice OUT NOCOPY VARCHAR2
321: , x_organization_code OUT NOCOPY VARCHAR2
322: ) RETURN BOOLEAN

Line 1026: , p_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type

1022: , p_revised_item_tbl IN OUT NOCOPY ENG_ECO_PUB.Revised_Item_Tbl_Type
1023: , p_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1024: , p_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1025: , p_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1026: , p_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
1027: , p_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1028: , p_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1029: , p_change_line_tbl IN OUT NOCOPY ENG_ECO_PUB.Change_Line_Tbl_Type )
1030: IS

Line 1027: , p_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type

1023: , p_rev_component_tbl IN OUT NOCOPY BOM_BO_PUB.Rev_Component_Tbl_Type
1024: , p_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1025: , p_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1026: , p_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
1027: , p_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1028: , p_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1029: , p_change_line_tbl IN OUT NOCOPY ENG_ECO_PUB.Change_Line_Tbl_Type )
1030: IS
1031: record_count NUMBER;

Line 1028: , p_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

1024: , p_ref_designator_tbl IN OUT NOCOPY BOM_BO_PUB.Ref_Designator_Tbl_Type
1025: , p_sub_component_tbl IN OUT NOCOPY BOM_BO_PUB.Sub_Component_Tbl_Type
1026: , p_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
1027: , p_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
1028: , p_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
1029: , p_change_line_tbl IN OUT NOCOPY ENG_ECO_PUB.Change_Line_Tbl_Type )
1030: IS
1031: record_count NUMBER;
1032: BEGIN

Line 1144: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1

1140: , p_ref_designator_tbl IN Bom_Bo_Pub.Ref_Designator_Tbl_Type :=
1141: G_MISS_REF_DESIGNATOR_TBL
1142: , p_sub_component_tbl IN Bom_Bo_Pub.Sub_Component_Tbl_Type :=
1143: G_MISS_SUB_COMPONENT_TBL
1144: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1145: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1146: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1147: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1148: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1

Line 1145: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1

1141: G_MISS_REF_DESIGNATOR_TBL
1142: , p_sub_component_tbl IN Bom_Bo_Pub.Sub_Component_Tbl_Type :=
1143: G_MISS_SUB_COMPONENT_TBL
1144: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1145: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1146: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1147: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1148: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1149: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1

Line 1146: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1

1142: , p_sub_component_tbl IN Bom_Bo_Pub.Sub_Component_Tbl_Type :=
1143: G_MISS_SUB_COMPONENT_TBL
1144: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1145: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1146: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1147: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1148: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1149: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
1150: , x_ECO_rec IN OUT NOCOPY Eco_Rec_Type

Line 1147: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1

1143: G_MISS_SUB_COMPONENT_TBL
1144: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1145: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1146: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1147: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1148: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1149: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
1150: , x_ECO_rec IN OUT NOCOPY Eco_Rec_Type
1151: , x_eco_revision_tbl IN OUT NOCOPY Eco_Revision_Tbl_Type

Line 1148: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1

1144: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1145: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1146: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1147: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1148: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1149: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
1150: , x_ECO_rec IN OUT NOCOPY Eco_Rec_Type
1151: , x_eco_revision_tbl IN OUT NOCOPY Eco_Revision_Tbl_Type
1152: , x_revised_item_tbl IN OUT NOCOPY Revised_Item_Tbl_Type

Line 1149: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1

1145: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1146: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1147: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1148: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1149: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
1150: , x_ECO_rec IN OUT NOCOPY Eco_Rec_Type
1151: , x_eco_revision_tbl IN OUT NOCOPY Eco_Revision_Tbl_Type
1152: , x_revised_item_tbl IN OUT NOCOPY Revised_Item_Tbl_Type
1153: , x_rev_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Tbl_Type

Line 1156: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--

1152: , x_revised_item_tbl IN OUT NOCOPY Revised_Item_Tbl_Type
1153: , x_rev_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Tbl_Type
1154: , x_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Tbl_Type
1155: , x_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Tbl_Type
1156: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
1157: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
1158: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
1159: , p_debug IN VARCHAR2 := 'N'
1160: , p_output_dir IN VARCHAR2 := NULL

Line 1157: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--

1153: , x_rev_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Tbl_Type
1154: , x_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Tbl_Type
1155: , x_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Tbl_Type
1156: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
1157: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
1158: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
1159: , p_debug IN VARCHAR2 := 'N'
1160: , p_output_dir IN VARCHAR2 := NULL
1161: , p_debug_filename IN VARCHAR2 := 'ECO_BO_Debug.log'

Line 1158: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--

1154: , x_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Tbl_Type
1155: , x_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Tbl_Type
1156: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
1157: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
1158: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
1159: , p_debug IN VARCHAR2 := 'N'
1160: , p_output_dir IN VARCHAR2 := NULL
1161: , p_debug_filename IN VARCHAR2 := 'ECO_BO_Debug.log'
1162: )

Line 1225: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1

1221: , p_ref_designator_tbl IN Bom_Bo_Pub.Ref_Designator_Tbl_Type :=
1222: G_MISS_REF_DESIGNATOR_TBL
1223: , p_sub_component_tbl IN Bom_Bo_Pub.Sub_Component_Tbl_Type :=
1224: G_MISS_SUB_COMPONENT_TBL
1225: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1226: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1227: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1228: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1229: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1

Line 1226: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1

1222: G_MISS_REF_DESIGNATOR_TBL
1223: , p_sub_component_tbl IN Bom_Bo_Pub.Sub_Component_Tbl_Type :=
1224: G_MISS_SUB_COMPONENT_TBL
1225: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1226: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1227: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1228: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1229: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1230: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1

Line 1227: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1

1223: , p_sub_component_tbl IN Bom_Bo_Pub.Sub_Component_Tbl_Type :=
1224: G_MISS_SUB_COMPONENT_TBL
1225: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1226: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1227: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1228: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1229: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1230: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
1231: , x_ECO_rec IN OUT NOCOPY Eco_Rec_Type

Line 1228: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1

1224: G_MISS_SUB_COMPONENT_TBL
1225: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1226: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1227: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1228: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1229: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1230: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
1231: , x_ECO_rec IN OUT NOCOPY Eco_Rec_Type
1232: , x_eco_revision_tbl IN OUT NOCOPY Eco_Revision_Tbl_Type

Line 1229: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1

1225: , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type:= --L1
1226: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1227: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1228: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1229: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1230: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
1231: , x_ECO_rec IN OUT NOCOPY Eco_Rec_Type
1232: , x_eco_revision_tbl IN OUT NOCOPY Eco_Revision_Tbl_Type
1233: , x_change_line_tbl IN OUT NOCOPY Change_Line_Tbl_Type -- Eng Change

Line 1230: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1

1226: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1
1227: , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type:= --L1
1228: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1
1229: , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type:= --L1
1230: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1
1231: , x_ECO_rec IN OUT NOCOPY Eco_Rec_Type
1232: , x_eco_revision_tbl IN OUT NOCOPY Eco_Revision_Tbl_Type
1233: , x_change_line_tbl IN OUT NOCOPY Change_Line_Tbl_Type -- Eng Change
1234: , x_revised_item_tbl IN OUT NOCOPY Revised_Item_Tbl_Type

Line 1238: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--

1234: , x_revised_item_tbl IN OUT NOCOPY Revised_Item_Tbl_Type
1235: , x_rev_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Tbl_Type
1236: , x_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Tbl_Type
1237: , x_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Tbl_Type
1238: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
1239: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
1240: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
1241: , p_debug IN VARCHAR2 := 'N'
1242: , p_output_dir IN VARCHAR2 := NULL

Line 1239: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--

1235: , x_rev_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Tbl_Type
1236: , x_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Tbl_Type
1237: , x_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Tbl_Type
1238: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
1239: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
1240: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
1241: , p_debug IN VARCHAR2 := 'N'
1242: , p_output_dir IN VARCHAR2 := NULL
1243: , p_debug_filename IN VARCHAR2 := 'ECO_BO_Debug.log'

Line 1240: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--

1236: , x_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Tbl_Type
1237: , x_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Tbl_Type
1238: , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type --L1--
1239: , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type --L1--
1240: , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type --L1--
1241: , p_debug IN VARCHAR2 := 'N'
1242: , p_output_dir IN VARCHAR2 := NULL
1243: , p_debug_filename IN VARCHAR2 := 'ECO_BO_Debug.log'
1244: )

Line 1265: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--

1261: l_revised_item_tbl Revised_Item_Tbl_Type;
1262: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1263: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1264: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1265: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
1266: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
1267: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
1268:
1269: -- Eng Change

Line 1266: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--

1262: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1263: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1264: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1265: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
1266: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
1267: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
1268:
1269: -- Eng Change
1270: l_change_line_tbl Change_Line_Tbl_Type;

Line 1267: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--

1263: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1264: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1265: l_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
1266: l_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
1267: l_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
1268:
1269: -- Eng Change
1270: l_change_line_tbl Change_Line_Tbl_Type;
1271: l_disable_revision NUMBER; --BUG 3034642

Line 1279: l_p_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--

1275: l_p_revised_item_tbl Revised_Item_Tbl_Type;
1276: l_p_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1277: l_p_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1278: l_p_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1279: l_p_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
1280: l_p_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
1281: l_p_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
1282: l_p_change_line_tbl Change_Line_Tbl_Type;
1283:

Line 1280: l_p_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--

1276: l_p_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
1277: l_p_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1278: l_p_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1279: l_p_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
1280: l_p_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
1281: l_p_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
1282: l_p_change_line_tbl Change_Line_Tbl_Type;
1283:
1284: BEGIN

Line 1281: l_p_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--

1277: l_p_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
1278: l_p_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
1279: l_p_rev_operation_tbl Bom_Rtg_Pub.Rev_Operation_Tbl_Type; -- L1--
1280: l_p_rev_op_resource_tbl Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type; -- L1--
1281: l_p_rev_sub_resource_tbl Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type; -- L1--
1282: l_p_change_line_tbl Change_Line_Tbl_Type;
1283:
1284: BEGIN
1285: x_return_status := FND_API.G_RET_STS_SUCCESS;