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 1023: , p_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type

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

Line 1024: , p_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type

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

Line 1025: , p_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type

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

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

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

Line 1142: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1

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

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

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

Line 1144: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1

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

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

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

Line 1146: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1

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

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

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

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

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

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

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

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

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

Line 1223: Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL --L1

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

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

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

Line 1225: Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL --L1

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

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

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

Line 1227: Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL --L1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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