35: -- conc.log and to debug file.
36: --
37: -- 22-NOV-2002 Phani Pilli Enhancement to support BOM Open Interface
38: *************************************************************************/
39: -- g_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
40: -- g_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
41: -- g_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
42: -- g_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
43: -- g_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
36: --
37: -- 22-NOV-2002 Phani Pilli Enhancement to support BOM Open Interface
38: *************************************************************************/
39: -- g_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
40: -- g_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
41: -- g_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
42: -- g_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
43: -- g_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
44: g_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
37: -- 22-NOV-2002 Phani Pilli Enhancement to support BOM Open Interface
38: *************************************************************************/
39: -- g_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
40: -- g_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
41: -- g_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
42: -- g_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
43: -- g_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
44: g_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
45:
38: *************************************************************************/
39: -- g_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
40: -- g_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
41: -- g_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
42: -- g_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
43: -- g_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
44: g_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
45:
46: G_ERROR_TABLE Error_Handler.Error_Tbl_Type;
39: -- g_bom_header_rec Bom_Bo_Pub.Bom_Head_Rec_Type;
40: -- g_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
41: -- g_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
42: -- g_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
43: -- g_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
44: g_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
45:
46: G_ERROR_TABLE Error_Handler.Error_Tbl_Type;
47: G_Msg_Index NUMBER := 0;
40: -- g_bom_revision_tbl Bom_Bo_Pub.Bom_Revision_Tbl_Type;
41: -- g_bom_component_tbl Bom_Bo_Pub.Bom_Comps_Tbl_Type;
42: -- g_bom_ref_designator_tbl Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type;
43: -- g_bom_sub_component_tbl Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type;
44: g_bom_comp_ops_tbl Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type;
45:
46: G_ERROR_TABLE Error_Handler.Error_Tbl_Type;
47: G_Msg_Index NUMBER := 0;
48: G_Msg_Count NUMBER := 0;
86: , p_row_identifier
87: , p_table_name
88: , p_entity_code
89: , p_mesg_name
90: , Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
91: , Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
92: , Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
93: , Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
94: , Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
87: , p_table_name
88: , p_entity_code
89: , p_mesg_name
90: , Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
91: , Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
92: , Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
93: , Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
94: , Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
95: , Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
88: , p_entity_code
89: , p_mesg_name
90: , Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
91: , Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
92: , Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
93: , Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
94: , Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
95: , Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
96: );
89: , p_mesg_name
90: , Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
91: , Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
92: , Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
93: , Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
94: , Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
95: , Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
96: );
97:
90: , Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
91: , Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
92: , Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
93: , Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
94: , Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
95: , Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
96: );
97:
98: END;
91: , Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
92: , Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
93: , Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
94: , Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
95: , Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
96: );
97:
98: END;
99:
107: , p_row_identifier IN NUMBER := NULL
108: , p_table_name IN VARCHAR2 := NULL
109: , p_entity_code IN VARCHAR2 := NULL
110: , p_mesg_name IN VARCHAR2 := NULL
111: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
112: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
113: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
114: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
115: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
108: , p_table_name IN VARCHAR2 := NULL
109: , p_entity_code IN VARCHAR2 := NULL
110: , p_mesg_name IN VARCHAR2 := NULL
111: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
112: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
113: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
114: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
115: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
116: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
109: , p_entity_code IN VARCHAR2 := NULL
110: , p_mesg_name IN VARCHAR2 := NULL
111: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
112: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
113: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
114: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
115: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
116: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
117: )
110: , p_mesg_name IN VARCHAR2 := NULL
111: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
112: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
113: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
114: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
115: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
116: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
117: )
118: IS
111: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
112: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
113: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
114: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
115: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
116: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
117: )
118: IS
119: l_Idx BINARY_INTEGER;
112: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
113: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
114: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
115: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
116: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
117: )
118: IS
119: l_Idx BINARY_INTEGER;
120: l_entity_id_char VARCHAR2(30) := null;
335: , p_other_status IN VARCHAR2
336: , p_rc_idx IN NUMBER := 0
337: , p_entity_index IN NUMBER := 0
338: , p_other_mesg_name IN VARCHAR2 := NULL
339: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
340: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
341: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
342: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
343: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
336: , p_rc_idx IN NUMBER := 0
337: , p_entity_index IN NUMBER := 0
338: , p_other_mesg_name IN VARCHAR2 := NULL
339: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
340: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
341: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
342: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
343: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
344: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
337: , p_entity_index IN NUMBER := 0
338: , p_other_mesg_name IN VARCHAR2 := NULL
339: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
340: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
341: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
342: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
343: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
344: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
345: )
338: , p_other_mesg_name IN VARCHAR2 := NULL
339: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
340: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
341: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
342: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
343: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
344: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
345: )
346: IS
339: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
340: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
341: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
342: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
343: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
344: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
345: )
346: IS
347: BEGIN
340: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
341: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
342: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
343: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
344: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
345: )
346: IS
347: BEGIN
348:
487: , p_rc_idx IN NUMBER := 0
488: , p_rd_idx IN NUMBER := 0
489: , p_entity_index IN NUMBER := 0
490: , p_other_mesg_name IN VARCHAR2 := NULL
491: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
492: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
493: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
494: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
495: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
488: , p_rd_idx IN NUMBER := 0
489: , p_entity_index IN NUMBER := 0
490: , p_other_mesg_name IN VARCHAR2 := NULL
491: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
492: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
493: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
494: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
495: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
496: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
489: , p_entity_index IN NUMBER := 0
490: , p_other_mesg_name IN VARCHAR2 := NULL
491: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
492: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
493: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
494: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
495: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
496: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
497: )
490: , p_other_mesg_name IN VARCHAR2 := NULL
491: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
492: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
493: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
494: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
495: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
496: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
497: )
498: IS
491: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
492: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
493: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
494: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
495: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
496: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
497: )
498: IS
499: l_idx NUMBER;
492: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
493: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
494: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
495: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
496: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
497: )
498: IS
499: l_idx NUMBER;
500: BEGIN
689: , p_other_status IN VARCHAR2
690: , p_rc_idx IN NUMBER DEFAULT 0
691: , p_entity_index IN NUMBER DEFAULT 0
692: , p_other_mesg_name IN VARCHAR2 := NULL
693: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
694: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
695: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
696: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
697: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
690: , p_rc_idx IN NUMBER DEFAULT 0
691: , p_entity_index IN NUMBER DEFAULT 0
692: , p_other_mesg_name IN VARCHAR2 := NULL
693: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
694: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
695: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
696: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
697: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
698: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
691: , p_entity_index IN NUMBER DEFAULT 0
692: , p_other_mesg_name IN VARCHAR2 := NULL
693: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
694: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
695: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
696: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
697: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
698: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
699: )
692: , p_other_mesg_name IN VARCHAR2 := NULL
693: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
694: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
695: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
696: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
697: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
698: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
699: )
700: IS
693: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
694: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
695: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
696: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
697: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
698: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
699: )
700: IS
701: l_idx NUMBER;
694: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
695: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
696: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
697: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
698: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
699: )
700: IS
701: l_idx NUMBER;
702: BEGIN
877: , p_other_mesg_text IN VARCHAR2
878: , p_other_status IN VARCHAR2
879: , p_entity_index IN NUMBER := 0
880: , p_other_mesg_name IN VARCHAR2 := NULL
881: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
882: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
883: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
884: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
885: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
878: , p_other_status IN VARCHAR2
879: , p_entity_index IN NUMBER := 0
880: , p_other_mesg_name IN VARCHAR2 := NULL
881: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
882: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
883: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
884: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
885: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
886: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
879: , p_entity_index IN NUMBER := 0
880: , p_other_mesg_name IN VARCHAR2 := NULL
881: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
882: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
883: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
884: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
885: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
886: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
887: )
880: , p_other_mesg_name IN VARCHAR2 := NULL
881: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
882: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
883: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
884: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
885: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
886: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
887: )
888: IS
881: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
882: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
883: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
884: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
885: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
886: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
887: )
888: IS
889: l_Idx NUMBER;
882: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
883: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
884: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
885: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
886: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
887: )
888: IS
889: l_Idx NUMBER;
890: BEGIN
978: PROCEDURE setRevisions
979: ( p_other_mesg_text IN VARCHAR2
980: , p_other_status IN VARCHAR2
981: , p_other_mesg_name IN VARCHAR2 := NULL
982: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
983: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
984: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
985: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
986: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
979: ( p_other_mesg_text IN VARCHAR2
980: , p_other_status IN VARCHAR2
981: , p_other_mesg_name IN VARCHAR2 := NULL
982: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
983: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
984: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
985: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
986: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
987: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
980: , p_other_status IN VARCHAR2
981: , p_other_mesg_name IN VARCHAR2 := NULL
982: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
983: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
984: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
985: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
986: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
987: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
988: )
981: , p_other_mesg_name IN VARCHAR2 := NULL
982: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
983: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
984: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
985: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
986: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
987: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
988: )
989: IS
982: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
983: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
984: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
985: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
986: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
987: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
988: )
989: IS
990: l_CurrentIndex NUMBER;
983: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
984: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
985: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
986: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
987: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
988: )
989: IS
990: l_CurrentIndex NUMBER;
991: BEGIN
1185: , p_entity_index
1186: , p_table_name
1187: , p_entity_code
1188: , p_addto_fnd_stack
1189: , Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1190: , Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1191: , Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1192: , Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1193: , Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1186: , p_table_name
1187: , p_entity_code
1188: , p_addto_fnd_stack
1189: , Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1190: , Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1191: , Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1192: , Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1193: , Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1194: , Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1187: , p_entity_code
1188: , p_addto_fnd_stack
1189: , Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1190: , Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1191: , Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1192: , Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1193: , Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1194: , Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1195: );
1188: , p_addto_fnd_stack
1189: , Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1190: , Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1191: , Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1192: , Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1193: , Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1194: , Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1195: );
1196:
1189: , Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1190: , Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1191: , Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1192: , Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1193: , Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1194: , Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1195: );
1196:
1197: END;
1190: , Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1191: , Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1192: , Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1193: , Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1194: , Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1195: );
1196:
1197: END;
1198:
1210: , p_entity_index IN NUMBER := NULL
1211: , p_table_name IN VARCHAR2 := NULL
1212: , p_entity_code IN VARCHAR2 := NULL
1213: , p_addto_fnd_stack IN VARCHAR2 := 'N'
1214: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
1215: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1216: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
1217: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1218: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1211: , p_table_name IN VARCHAR2 := NULL
1212: , p_entity_code IN VARCHAR2 := NULL
1213: , p_addto_fnd_stack IN VARCHAR2 := 'N'
1214: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
1215: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1216: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
1217: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1218: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1219: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
1212: , p_entity_code IN VARCHAR2 := NULL
1213: , p_addto_fnd_stack IN VARCHAR2 := 'N'
1214: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
1215: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1216: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
1217: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1218: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1219: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
1220: )
1213: , p_addto_fnd_stack IN VARCHAR2 := 'N'
1214: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
1215: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1216: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
1217: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1218: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1219: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
1220: )
1221: IS
1214: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
1215: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1216: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
1217: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1218: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1219: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
1220: )
1221: IS
1222:
1215: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1216: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
1217: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1218: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1219: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
1220: )
1221: IS
1222:
1223: l_message_text VARCHAR2(2000);
1316: , p_application_id
1317: , p_row_identifier
1318: , p_table_name
1319: , p_entity_code
1320: , Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1321: , Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1322: , Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1323: , Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1324: , Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1317: , p_row_identifier
1318: , p_table_name
1319: , p_entity_code
1320: , Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1321: , Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1322: , Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1323: , Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1324: , Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1325: , Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1318: , p_table_name
1319: , p_entity_code
1320: , Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1321: , Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1322: , Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1323: , Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1324: , Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1325: , Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1326: );
1319: , p_entity_code
1320: , Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1321: , Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1322: , Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1323: , Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1324: , Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1325: , Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1326: );
1327: END;
1320: , Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1321: , Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1322: , Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1323: , Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1324: , Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1325: , Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1326: );
1327: END;
1328:
1321: , Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1322: , Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1323: , Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1324: , Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1325: , Bom_Bo_Pub.G_MISS_BOM_COMP_OPS_TBL
1326: );
1327: END;
1328:
1329:
1335: , p_application_id IN VARCHAR2 := 'ENG'
1336: , p_row_identifier IN NUMBER := NULL
1337: , p_table_name IN VARCHAR2 := NULL
1338: , p_entity_code IN VARCHAR2 := NULL
1339: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
1340: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1341: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
1342: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1343: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1336: , p_row_identifier IN NUMBER := NULL
1337: , p_table_name IN VARCHAR2 := NULL
1338: , p_entity_code IN VARCHAR2 := NULL
1339: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
1340: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1341: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
1342: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1343: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1344: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
1337: , p_table_name IN VARCHAR2 := NULL
1338: , p_entity_code IN VARCHAR2 := NULL
1339: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
1340: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1341: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
1342: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1343: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1344: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
1345: )
1338: , p_entity_code IN VARCHAR2 := NULL
1339: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
1340: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1341: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
1342: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1343: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1344: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
1345: )
1346: IS
1339: , p_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
1340: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1341: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
1342: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1343: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1344: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
1345: )
1346: IS
1347: l_message_text VARCHAR2(2000);
1340: , p_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1341: , p_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
1342: , p_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1343: , p_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1344: , p_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type
1345: )
1346: IS
1347: l_message_text VARCHAR2(2000);
1348: l_message_name VARCHAR2(30);
1394: * status and message.
1395: ******************************************************************/
1396:
1397: PROCEDURE Log_Error
1398: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
1399: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1400: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1401: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1402: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1395: ******************************************************************/
1396:
1397: PROCEDURE Log_Error
1398: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
1399: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1400: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1401: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1402: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1403: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1396:
1397: PROCEDURE Log_Error
1398: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
1399: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1400: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1401: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1402: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1403: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1404: , p_bom_ref_Designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1397: PROCEDURE Log_Error
1398: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
1399: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1400: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1401: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1402: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1403: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1404: , p_bom_ref_Designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1405: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1398: ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
1399: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1400: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1401: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1402: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1403: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1404: , p_bom_ref_Designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1405: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1406: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1399: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
1400: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1401: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1402: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1403: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1404: , p_bom_ref_Designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1405: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1406: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1407: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1400: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
1401: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1402: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1403: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1404: , p_bom_ref_Designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1405: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1406: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1407: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1408: , p_Mesg_Token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
1401: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
1402: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1403: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1404: , p_bom_ref_Designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1405: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1406: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1407: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1408: , p_Mesg_Token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
1409: := Error_Handler.G_MISS_MESG_TOKEN_TBL
1402: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
1403: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1404: , p_bom_ref_Designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1405: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1406: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1407: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1408: , p_Mesg_Token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
1409: := Error_Handler.G_MISS_MESG_TOKEN_TBL
1410: , p_error_status IN VARCHAR2
1403: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
1404: , p_bom_ref_Designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1405: := Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
1406: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1407: := Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
1408: , p_Mesg_Token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
1409: := Error_Handler.G_MISS_MESG_TOKEN_TBL
1410: , p_error_status IN VARCHAR2
1411: , p_error_scope IN VARCHAR2 := NULL
1415: , p_other_token_tbl IN Error_Handler.Token_Tbl_Type
1416: := Error_Handler.G_MISS_TOKEN_TBL
1417: , p_error_level IN NUMBER
1418: , p_entity_index IN NUMBER := 1 -- := NULL
1419: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
1420: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1421: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
1422: , x_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1423: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1416: := Error_Handler.G_MISS_TOKEN_TBL
1417: , p_error_level IN NUMBER
1418: , p_entity_index IN NUMBER := 1 -- := NULL
1419: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
1420: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1421: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
1422: , x_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1423: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1424: , p_row_identifier IN NUMBER := NULL
1417: , p_error_level IN NUMBER
1418: , p_entity_index IN NUMBER := 1 -- := NULL
1419: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
1420: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1421: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
1422: , x_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1423: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1424: , p_row_identifier IN NUMBER := NULL
1425: )
1418: , p_entity_index IN NUMBER := 1 -- := NULL
1419: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
1420: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1421: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
1422: , x_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1423: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1424: , p_row_identifier IN NUMBER := NULL
1425: )
1426: IS
1419: , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
1420: , x_bom_revision_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
1421: , x_bom_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comps_Tbl_Type
1422: , x_bom_ref_Designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
1423: , x_bom_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
1424: , p_row_identifier IN NUMBER := NULL
1425: )
1426: IS
1427: l_message_name VARCHAR2(30);
2353: END Get_Bo_Identifier;
2354:
2355: /* One to many support */
2356:
2357: PROCEDURE Set_Bom_Specific (p_bom_comp_ops_tbl IN Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type)
2358: IS
2359: BEGIN
2360: g_bom_comp_ops_tbl := p_bom_comp_ops_tbl;
2361: END;
2359: BEGIN
2360: g_bom_comp_ops_tbl := p_bom_comp_ops_tbl;
2361: END;
2362:
2363: PROCEDURE Get_Bom_Specific (x_bom_comp_ops_tbl IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Tbl_Type)
2364: IS
2365: BEGIN
2366: x_bom_comp_ops_tbl := g_bom_comp_ops_tbl;
2367: END;