DBA Data[Home] [Help]

APPS.BOM_INVOKE_BO dependencies on BOM_BO_PUB

Line 29: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=

25: PROCEDURE Process_Bom
26: ( p_bo_identifier IN VARCHAR2 := 'BOM'
27: , p_api_version_number IN NUMBER := 1.0
28: , p_init_msg_list IN BOOLEAN := FALSE
29: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
30: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
31: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
32: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
33: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=

Line 30: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC

26: ( p_bo_identifier IN VARCHAR2 := 'BOM'
27: , p_api_version_number IN NUMBER := 1.0
28: , p_init_msg_list IN BOOLEAN := FALSE
29: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
30: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
31: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
32: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
33: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
34: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL

Line 31: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=

27: , p_api_version_number IN NUMBER := 1.0
28: , p_init_msg_list IN BOOLEAN := FALSE
29: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
30: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
31: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
32: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
33: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
34: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
35: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type :=

Line 32: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL

28: , p_init_msg_list IN BOOLEAN := FALSE
29: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
30: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
31: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
32: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
33: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
34: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
35: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type :=
36: Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL

Line 33: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=

29: , p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type :=
30: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
31: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
32: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
33: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
34: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
35: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type :=
36: Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
37: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=

Line 34: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL

30: Bom_Bo_Pub.G_MISS_BOM_HEADER_REC
31: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
32: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
33: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
34: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
35: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type :=
36: Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
37: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
38: Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL

Line 35: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type :=

31: , p_bom_revision_tbl IN Bom_Bo_Pub.Bom_Revision_Tbl_Type :=
32: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
33: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
34: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
35: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type :=
36: Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
37: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
38: Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
39: , x_bom_header_rec OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type

Line 36: Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL

32: Bom_Bo_Pub.G_MISS_BOM_REVISION_TBL
33: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
34: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
35: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type :=
36: Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
37: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
38: Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
39: , x_bom_header_rec OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
40: , x_bom_revision_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type

Line 37: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=

33: , p_bom_component_tbl IN Bom_Bo_Pub.Bom_Comps_Tbl_Type :=
34: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
35: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type :=
36: Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
37: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
38: Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
39: , x_bom_header_rec OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
40: , x_bom_revision_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
41: , x_bom_component_tbl OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type

Line 38: Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL

34: Bom_Bo_Pub.G_MISS_BOM_COMPONENT_TBL
35: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type :=
36: Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
37: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
38: Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
39: , x_bom_header_rec OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
40: , x_bom_revision_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
41: , x_bom_component_tbl OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
42: , x_bom_ref_designator_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

Line 39: , x_bom_header_rec OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type

35: , p_bom_ref_designator_tbl IN Bom_Bo_Pub.Bom_Ref_Designator_Tbl_type :=
36: Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
37: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
38: Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
39: , x_bom_header_rec OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
40: , x_bom_revision_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
41: , x_bom_component_tbl OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
42: , x_bom_ref_designator_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
43: , x_bom_sub_component_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

Line 40: , x_bom_revision_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type

36: Bom_Bo_Pub.G_MISS_BOM_REF_DESIGNATOR_TBL
37: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
38: Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
39: , x_bom_header_rec OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
40: , x_bom_revision_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
41: , x_bom_component_tbl OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
42: , x_bom_ref_designator_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
43: , x_bom_sub_component_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
44: , x_return_status OUT NOCOPY VARCHAR2

Line 41: , x_bom_component_tbl OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type

37: , p_bom_sub_component_tbl IN Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type :=
38: Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
39: , x_bom_header_rec OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
40: , x_bom_revision_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
41: , x_bom_component_tbl OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
42: , x_bom_ref_designator_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
43: , x_bom_sub_component_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
44: , x_return_status OUT NOCOPY VARCHAR2
45: , x_msg_count OUT NOCOPY NUMBER

Line 42: , x_bom_ref_designator_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type

38: Bom_Bo_Pub.G_MISS_BOM_SUB_COMPONENT_TBL
39: , x_bom_header_rec OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
40: , x_bom_revision_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
41: , x_bom_component_tbl OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
42: , x_bom_ref_designator_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
43: , x_bom_sub_component_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
44: , x_return_status OUT NOCOPY VARCHAR2
45: , x_msg_count OUT NOCOPY NUMBER
46: , p_debug IN VARCHAR2 := 'N'

Line 43: , x_bom_sub_component_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type

39: , x_bom_header_rec OUT NOCOPY Bom_Bo_Pub.bom_Head_Rec_Type
40: , x_bom_revision_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Revision_Tbl_Type
41: , x_bom_component_tbl OUT NOCOPY Bom_Bo_pub.Bom_Comps_Tbl_Type
42: , x_bom_ref_designator_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Tbl_Type
43: , x_bom_sub_component_tbl OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Tbl_Type
44: , x_return_status OUT NOCOPY VARCHAR2
45: , x_msg_count OUT NOCOPY NUMBER
46: , p_debug IN VARCHAR2 := 'N'
47: , p_output_dir IN VARCHAR2 := NULL

Line 51: Bom_Bo_Pub.Process_Bom

47: , p_output_dir IN VARCHAR2 := NULL
48: , p_debug_filename IN VARCHAR2 := 'BOM_BO_debug.log'
49: ) IS
50: BEGIN
51: Bom_Bo_Pub.Process_Bom
52: ( p_bo_identifier => p_bo_identifier
53: , p_api_version_number => p_api_version_number
54: , p_init_msg_list => p_init_msg_list
55: , p_bom_header_rec => p_bom_header_rec

Line 208: X_bom_header_tbl OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE,

204: P_organization_code IN VARCHAR2,
205: P_alternate_bm_designator IN VARCHAR2 DEFAULT NULL,
206: P_Costs IN NUMBER DEFAULT 2,
207: P_Cost_type_id IN NUMBER DEFAULT 0,
208: X_bom_header_tbl OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE,
209: X_bom_revisions_tbl OUT NOCOPY BOM_BO_PUB.BOM_REVISION_TBL_TYPE,
210: X_bom_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
211: X_bom_ref_designators_tbl OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
212: X_bom_sub_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,

Line 209: X_bom_revisions_tbl OUT NOCOPY BOM_BO_PUB.BOM_REVISION_TBL_TYPE,

205: P_alternate_bm_designator IN VARCHAR2 DEFAULT NULL,
206: P_Costs IN NUMBER DEFAULT 2,
207: P_Cost_type_id IN NUMBER DEFAULT 0,
208: X_bom_header_tbl OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE,
209: X_bom_revisions_tbl OUT NOCOPY BOM_BO_PUB.BOM_REVISION_TBL_TYPE,
210: X_bom_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
211: X_bom_ref_designators_tbl OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
212: X_bom_sub_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
213: X_bom_comp_ops_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,

Line 210: X_bom_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,

206: P_Costs IN NUMBER DEFAULT 2,
207: P_Cost_type_id IN NUMBER DEFAULT 0,
208: X_bom_header_tbl OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE,
209: X_bom_revisions_tbl OUT NOCOPY BOM_BO_PUB.BOM_REVISION_TBL_TYPE,
210: X_bom_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
211: X_bom_ref_designators_tbl OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
212: X_bom_sub_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
213: X_bom_comp_ops_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
214: X_Err_Msg OUT NOCOPY VARCHAR2,

Line 211: X_bom_ref_designators_tbl OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,

207: P_Cost_type_id IN NUMBER DEFAULT 0,
208: X_bom_header_tbl OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE,
209: X_bom_revisions_tbl OUT NOCOPY BOM_BO_PUB.BOM_REVISION_TBL_TYPE,
210: X_bom_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
211: X_bom_ref_designators_tbl OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
212: X_bom_sub_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
213: X_bom_comp_ops_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
214: X_Err_Msg OUT NOCOPY VARCHAR2,
215: X_Error_Code OUT NOCOPY NUMBER)

Line 212: X_bom_sub_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,

208: X_bom_header_tbl OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE,
209: X_bom_revisions_tbl OUT NOCOPY BOM_BO_PUB.BOM_REVISION_TBL_TYPE,
210: X_bom_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
211: X_bom_ref_designators_tbl OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
212: X_bom_sub_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
213: X_bom_comp_ops_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
214: X_Err_Msg OUT NOCOPY VARCHAR2,
215: X_Error_Code OUT NOCOPY NUMBER)
216: IS

Line 213: X_bom_comp_ops_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,

209: X_bom_revisions_tbl OUT NOCOPY BOM_BO_PUB.BOM_REVISION_TBL_TYPE,
210: X_bom_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
211: X_bom_ref_designators_tbl OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
212: X_bom_sub_components_tbl OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
213: X_bom_comp_ops_tbl OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
214: X_Err_Msg OUT NOCOPY VARCHAR2,
215: X_Error_Code OUT NOCOPY NUMBER)
216: IS
217: Begin