40: X_return_status OUT NOCOPY VARCHAR2,
41: X_msg_count OUT NOCOPY NUMBER,
42: X_G_msg_data OUT NOCOPY LONG) IS
43:
44: l_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE
45: := BOM_BO_PUB.G_MISS_BOM_HEADER_TBL;
46: --Bug 3349138 l_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE
47: -- := BOM_BO_PUB.G_MISS_BOM_REVISION_TBL;
48: l_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE
41: X_msg_count OUT NOCOPY NUMBER,
42: X_G_msg_data OUT NOCOPY LONG) IS
43:
44: l_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE
45: := BOM_BO_PUB.G_MISS_BOM_HEADER_TBL;
46: --Bug 3349138 l_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE
47: -- := BOM_BO_PUB.G_MISS_BOM_REVISION_TBL;
48: l_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE
49: := BOM_BO_PUB.G_MISS_BOM_COMPONENT_TBL;
42: X_G_msg_data OUT NOCOPY LONG) IS
43:
44: l_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE
45: := BOM_BO_PUB.G_MISS_BOM_HEADER_TBL;
46: --Bug 3349138 l_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE
47: -- := BOM_BO_PUB.G_MISS_BOM_REVISION_TBL;
48: l_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE
49: := BOM_BO_PUB.G_MISS_BOM_COMPONENT_TBL;
50: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
43:
44: l_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE
45: := BOM_BO_PUB.G_MISS_BOM_HEADER_TBL;
46: --Bug 3349138 l_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE
47: -- := BOM_BO_PUB.G_MISS_BOM_REVISION_TBL;
48: l_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE
49: := BOM_BO_PUB.G_MISS_BOM_COMPONENT_TBL;
50: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
51: := BOM_BO_PUB.G_MISS_BOM_REF_DESIGNATOR_TBL;
44: l_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE
45: := BOM_BO_PUB.G_MISS_BOM_HEADER_TBL;
46: --Bug 3349138 l_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE
47: -- := BOM_BO_PUB.G_MISS_BOM_REVISION_TBL;
48: l_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE
49: := BOM_BO_PUB.G_MISS_BOM_COMPONENT_TBL;
50: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
51: := BOM_BO_PUB.G_MISS_BOM_REF_DESIGNATOR_TBL;
52: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
45: := BOM_BO_PUB.G_MISS_BOM_HEADER_TBL;
46: --Bug 3349138 l_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE
47: -- := BOM_BO_PUB.G_MISS_BOM_REVISION_TBL;
48: l_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE
49: := BOM_BO_PUB.G_MISS_BOM_COMPONENT_TBL;
50: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
51: := BOM_BO_PUB.G_MISS_BOM_REF_DESIGNATOR_TBL;
52: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
53: := BOM_BO_PUB.G_MISS_BOM_SUB_COMPONENT_TBL;
46: --Bug 3349138 l_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE
47: -- := BOM_BO_PUB.G_MISS_BOM_REVISION_TBL;
48: l_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE
49: := BOM_BO_PUB.G_MISS_BOM_COMPONENT_TBL;
50: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
51: := BOM_BO_PUB.G_MISS_BOM_REF_DESIGNATOR_TBL;
52: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
53: := BOM_BO_PUB.G_MISS_BOM_SUB_COMPONENT_TBL;
54: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
47: -- := BOM_BO_PUB.G_MISS_BOM_REVISION_TBL;
48: l_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE
49: := BOM_BO_PUB.G_MISS_BOM_COMPONENT_TBL;
50: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
51: := BOM_BO_PUB.G_MISS_BOM_REF_DESIGNATOR_TBL;
52: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
53: := BOM_BO_PUB.G_MISS_BOM_SUB_COMPONENT_TBL;
54: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
55: := BOM_BO_PUB.G_MISS_BOM_COMP_OPS_TBL;
48: l_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE
49: := BOM_BO_PUB.G_MISS_BOM_COMPONENT_TBL;
50: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
51: := BOM_BO_PUB.G_MISS_BOM_REF_DESIGNATOR_TBL;
52: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
53: := BOM_BO_PUB.G_MISS_BOM_SUB_COMPONENT_TBL;
54: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
55: := BOM_BO_PUB.G_MISS_BOM_COMP_OPS_TBL;
56: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE
49: := BOM_BO_PUB.G_MISS_BOM_COMPONENT_TBL;
50: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
51: := BOM_BO_PUB.G_MISS_BOM_REF_DESIGNATOR_TBL;
52: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
53: := BOM_BO_PUB.G_MISS_BOM_SUB_COMPONENT_TBL;
54: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
55: := BOM_BO_PUB.G_MISS_BOM_COMP_OPS_TBL;
56: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE
57: := BOM_BO_PUB.G_MISS_BOM_HEADER_TBL;
50: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
51: := BOM_BO_PUB.G_MISS_BOM_REF_DESIGNATOR_TBL;
52: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
53: := BOM_BO_PUB.G_MISS_BOM_SUB_COMPONENT_TBL;
54: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
55: := BOM_BO_PUB.G_MISS_BOM_COMP_OPS_TBL;
56: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE
57: := BOM_BO_PUB.G_MISS_BOM_HEADER_TBL;
58: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE
51: := BOM_BO_PUB.G_MISS_BOM_REF_DESIGNATOR_TBL;
52: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
53: := BOM_BO_PUB.G_MISS_BOM_SUB_COMPONENT_TBL;
54: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
55: := BOM_BO_PUB.G_MISS_BOM_COMP_OPS_TBL;
56: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE
57: := BOM_BO_PUB.G_MISS_BOM_HEADER_TBL;
58: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE
59: := BOM_BO_PUB.G_MISS_BOM_REVISION_TBL;
52: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
53: := BOM_BO_PUB.G_MISS_BOM_SUB_COMPONENT_TBL;
54: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
55: := BOM_BO_PUB.G_MISS_BOM_COMP_OPS_TBL;
56: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE
57: := BOM_BO_PUB.G_MISS_BOM_HEADER_TBL;
58: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE
59: := BOM_BO_PUB.G_MISS_BOM_REVISION_TBL;
60: X_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE
53: := BOM_BO_PUB.G_MISS_BOM_SUB_COMPONENT_TBL;
54: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
55: := BOM_BO_PUB.G_MISS_BOM_COMP_OPS_TBL;
56: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE
57: := BOM_BO_PUB.G_MISS_BOM_HEADER_TBL;
58: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE
59: := BOM_BO_PUB.G_MISS_BOM_REVISION_TBL;
60: X_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE
61: := BOM_BO_PUB.G_MISS_BOM_COMPONENT_TBL;
54: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
55: := BOM_BO_PUB.G_MISS_BOM_COMP_OPS_TBL;
56: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE
57: := BOM_BO_PUB.G_MISS_BOM_HEADER_TBL;
58: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE
59: := BOM_BO_PUB.G_MISS_BOM_REVISION_TBL;
60: X_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE
61: := BOM_BO_PUB.G_MISS_BOM_COMPONENT_TBL;
62: X_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
55: := BOM_BO_PUB.G_MISS_BOM_COMP_OPS_TBL;
56: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE
57: := BOM_BO_PUB.G_MISS_BOM_HEADER_TBL;
58: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE
59: := BOM_BO_PUB.G_MISS_BOM_REVISION_TBL;
60: X_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE
61: := BOM_BO_PUB.G_MISS_BOM_COMPONENT_TBL;
62: X_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
63: := BOM_BO_PUB.G_MISS_BOM_REF_DESIGNATOR_TBL;
56: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE
57: := BOM_BO_PUB.G_MISS_BOM_HEADER_TBL;
58: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE
59: := BOM_BO_PUB.G_MISS_BOM_REVISION_TBL;
60: X_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE
61: := BOM_BO_PUB.G_MISS_BOM_COMPONENT_TBL;
62: X_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
63: := BOM_BO_PUB.G_MISS_BOM_REF_DESIGNATOR_TBL;
64: X_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
57: := BOM_BO_PUB.G_MISS_BOM_HEADER_TBL;
58: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE
59: := BOM_BO_PUB.G_MISS_BOM_REVISION_TBL;
60: X_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE
61: := BOM_BO_PUB.G_MISS_BOM_COMPONENT_TBL;
62: X_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
63: := BOM_BO_PUB.G_MISS_BOM_REF_DESIGNATOR_TBL;
64: X_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
65: := BOM_BO_PUB.G_MISS_BOM_SUB_COMPONENT_TBL;
58: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE
59: := BOM_BO_PUB.G_MISS_BOM_REVISION_TBL;
60: X_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE
61: := BOM_BO_PUB.G_MISS_BOM_COMPONENT_TBL;
62: X_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
63: := BOM_BO_PUB.G_MISS_BOM_REF_DESIGNATOR_TBL;
64: X_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
65: := BOM_BO_PUB.G_MISS_BOM_SUB_COMPONENT_TBL;
66: X_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
59: := BOM_BO_PUB.G_MISS_BOM_REVISION_TBL;
60: X_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE
61: := BOM_BO_PUB.G_MISS_BOM_COMPONENT_TBL;
62: X_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
63: := BOM_BO_PUB.G_MISS_BOM_REF_DESIGNATOR_TBL;
64: X_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
65: := BOM_BO_PUB.G_MISS_BOM_SUB_COMPONENT_TBL;
66: X_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
67: := BOM_BO_PUB.G_MISS_BOM_COMP_OPS_TBL;
60: X_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE
61: := BOM_BO_PUB.G_MISS_BOM_COMPONENT_TBL;
62: X_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
63: := BOM_BO_PUB.G_MISS_BOM_REF_DESIGNATOR_TBL;
64: X_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
65: := BOM_BO_PUB.G_MISS_BOM_SUB_COMPONENT_TBL;
66: X_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
67: := BOM_BO_PUB.G_MISS_BOM_COMP_OPS_TBL;
68: /* 090403
61: := BOM_BO_PUB.G_MISS_BOM_COMPONENT_TBL;
62: X_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
63: := BOM_BO_PUB.G_MISS_BOM_REF_DESIGNATOR_TBL;
64: X_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
65: := BOM_BO_PUB.G_MISS_BOM_SUB_COMPONENT_TBL;
66: X_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
67: := BOM_BO_PUB.G_MISS_BOM_COMP_OPS_TBL;
68: /* 090403
69: CURSOR bom_updates_CUR IS
62: X_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
63: := BOM_BO_PUB.G_MISS_BOM_REF_DESIGNATOR_TBL;
64: X_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
65: := BOM_BO_PUB.G_MISS_BOM_SUB_COMPONENT_TBL;
66: X_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
67: := BOM_BO_PUB.G_MISS_BOM_COMP_OPS_TBL;
68: /* 090403
69: CURSOR bom_updates_CUR IS
70: SELECT AssemblyItemName
63: := BOM_BO_PUB.G_MISS_BOM_REF_DESIGNATOR_TBL;
64: X_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
65: := BOM_BO_PUB.G_MISS_BOM_SUB_COMPONENT_TBL;
66: X_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
67: := BOM_BO_PUB.G_MISS_BOM_COMP_OPS_TBL;
68: /* 090403
69: CURSOR bom_updates_CUR IS
70: SELECT AssemblyItemName
71: , OrganizationCode
1261: i := i + 1;
1262: END LOOP;
1263: END IF;
1264: BOM_GLOBALS.Set_Caller_Type('MIGRATION');
1265: BOM_BO_PUB.Process_Bom(p_bom_header_tbl => l_bom_header_tbl,
1266: --Bug 3349138 p_bom_revision_tbl => l_bom_revisions_tbl,
1267: p_bom_component_tbl => l_bom_comp_tbl,
1268: p_bom_ref_designator_tbl => l_bom_ref_desig_tbl,
1269: p_bom_sub_component_tbl => l_bom_sub_comp_tbl,