eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_BOM_COPYORG_IMP dependencies on BOM_BO_PUB

Line 31: -- records after the call to BOM_BO_PUB.Process_Bom to reduce

27: -- 03-JUL-06 Mohan Yerramsetty Added ImplementationDate to bom_bill_of_materials_temp table
28: -- Added BasisType to bom_inventory_components_temp table
29: -- Bug: 5174575
30: -- 11-NOV-06 Mohan Yerramsetty Modified the code to delete the successfully processed
31: -- records after the call to BOM_BO_PUB.Process_Bom to reduce
32: -- the memory consumed by the process. Bug: 5654718
33: -- 21-FEB-07 Mohan Yerramsetty Bug# 5592181, Modified the code to delete
34: -- unnecessary Log messages and to modify the logic of
35: -- returning the value of ReturnStatus.

Line 49: p_bom_header_tbl IN BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,

45:
46: PROCEDURE CALL_PROCESS_BOM(P_debug IN VARCHAR2,
47: P_output_dir IN VARCHAR2,
48: P_debug_filename IN VARCHAR2,
49: p_bom_header_tbl IN BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
50: p_bom_component_tbl IN BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
51: p_bom_ref_designator_tbl IN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
52: p_bom_sub_component_tbl IN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
53: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,

Line 50: p_bom_component_tbl IN BOM_BO_PUB.BOM_COMPS_TBL_TYPE,

46: PROCEDURE CALL_PROCESS_BOM(P_debug IN VARCHAR2,
47: P_output_dir IN VARCHAR2,
48: P_debug_filename IN VARCHAR2,
49: p_bom_header_tbl IN BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
50: p_bom_component_tbl IN BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
51: p_bom_ref_designator_tbl IN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
52: p_bom_sub_component_tbl IN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
53: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
54: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,

Line 51: p_bom_ref_designator_tbl IN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,

47: P_output_dir IN VARCHAR2,
48: P_debug_filename IN VARCHAR2,
49: p_bom_header_tbl IN BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
50: p_bom_component_tbl IN BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
51: p_bom_ref_designator_tbl IN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
52: p_bom_sub_component_tbl IN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
53: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
54: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
55: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,

Line 52: p_bom_sub_component_tbl IN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,

48: P_debug_filename IN VARCHAR2,
49: p_bom_header_tbl IN BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
50: p_bom_component_tbl IN BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
51: p_bom_ref_designator_tbl IN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
52: p_bom_sub_component_tbl IN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
53: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
54: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
55: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,
56: X_bom_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,

Line 53: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,

49: p_bom_header_tbl IN BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
50: p_bom_component_tbl IN BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
51: p_bom_ref_designator_tbl IN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
52: p_bom_sub_component_tbl IN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
53: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
54: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
55: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,
56: X_bom_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
57: X_bom_ref_desig_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,

Line 54: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,

50: p_bom_component_tbl IN BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
51: p_bom_ref_designator_tbl IN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
52: p_bom_sub_component_tbl IN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
53: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
54: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
55: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,
56: X_bom_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
57: X_bom_ref_desig_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
58: X_bom_sub_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,

Line 55: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,

51: p_bom_ref_designator_tbl IN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
52: p_bom_sub_component_tbl IN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
53: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
54: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
55: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,
56: X_bom_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
57: X_bom_ref_desig_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
58: X_bom_sub_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
59: X_bom_comp_oper_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,

Line 56: X_bom_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,

52: p_bom_sub_component_tbl IN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
53: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
54: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
55: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,
56: X_bom_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
57: X_bom_ref_desig_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
58: X_bom_sub_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
59: X_bom_comp_oper_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
60: X_return_status IN OUT NOCOPY VARCHAR2, --myerrams, Bug: 5592181

Line 57: X_bom_ref_desig_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,

53: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
54: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
55: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,
56: X_bom_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
57: X_bom_ref_desig_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
58: X_bom_sub_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
59: X_bom_comp_oper_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
60: X_return_status IN OUT NOCOPY VARCHAR2, --myerrams, Bug: 5592181
61: X_G_msg_data OUT NOCOPY LONG,

Line 58: X_bom_sub_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,

54: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
55: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,
56: X_bom_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
57: X_bom_ref_desig_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
58: X_bom_sub_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
59: X_bom_comp_oper_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
60: X_return_status IN OUT NOCOPY VARCHAR2, --myerrams, Bug: 5592181
61: X_G_msg_data OUT NOCOPY LONG,
62: X_msg_count OUT NOCOPY NUMBER

Line 59: X_bom_comp_oper_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,

55: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,
56: X_bom_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
57: X_bom_ref_desig_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
58: X_bom_sub_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
59: X_bom_comp_oper_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
60: X_return_status IN OUT NOCOPY VARCHAR2, --myerrams, Bug: 5592181
61: X_G_msg_data OUT NOCOPY LONG,
62: X_msg_count OUT NOCOPY NUMBER
63: );

Line 75: l_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE ;

71: X_msg_count OUT NOCOPY NUMBER,
72: X_G_msg_data OUT NOCOPY LONG,
73: p_bomthreshold IN VARCHAR2 ) IS
74:
75: l_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE ;
76: l_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
77: l_bom_header_tbl_rec BOM_BO_PUB.Bom_Head_Rec_Type ;
78: l_bom_comp_tbl_rec BOM_BO_PUB.Bom_Comps_Rec_Type ;
79: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;

Line 76: l_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;

72: X_G_msg_data OUT NOCOPY LONG,
73: p_bomthreshold IN VARCHAR2 ) IS
74:
75: l_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE ;
76: l_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
77: l_bom_header_tbl_rec BOM_BO_PUB.Bom_Head_Rec_Type ;
78: l_bom_comp_tbl_rec BOM_BO_PUB.Bom_Comps_Rec_Type ;
79: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
80: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;

Line 77: l_bom_header_tbl_rec BOM_BO_PUB.Bom_Head_Rec_Type ;

73: p_bomthreshold IN VARCHAR2 ) IS
74:
75: l_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE ;
76: l_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
77: l_bom_header_tbl_rec BOM_BO_PUB.Bom_Head_Rec_Type ;
78: l_bom_comp_tbl_rec BOM_BO_PUB.Bom_Comps_Rec_Type ;
79: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
80: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
81: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;

Line 78: l_bom_comp_tbl_rec BOM_BO_PUB.Bom_Comps_Rec_Type ;

74:
75: l_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE ;
76: l_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
77: l_bom_header_tbl_rec BOM_BO_PUB.Bom_Head_Rec_Type ;
78: l_bom_comp_tbl_rec BOM_BO_PUB.Bom_Comps_Rec_Type ;
79: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
80: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
81: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
82: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE ;

Line 79: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;

75: l_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE ;
76: l_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
77: l_bom_header_tbl_rec BOM_BO_PUB.Bom_Head_Rec_Type ;
78: l_bom_comp_tbl_rec BOM_BO_PUB.Bom_Comps_Rec_Type ;
79: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
80: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
81: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
82: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE ;
83: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE;

Line 80: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;

76: l_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
77: l_bom_header_tbl_rec BOM_BO_PUB.Bom_Head_Rec_Type ;
78: l_bom_comp_tbl_rec BOM_BO_PUB.Bom_Comps_Rec_Type ;
79: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
80: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
81: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
82: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE ;
83: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
84: X_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;

Line 81: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;

77: l_bom_header_tbl_rec BOM_BO_PUB.Bom_Head_Rec_Type ;
78: l_bom_comp_tbl_rec BOM_BO_PUB.Bom_Comps_Rec_Type ;
79: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
80: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
81: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
82: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE ;
83: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
84: X_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
85: X_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;

Line 82: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE ;

78: l_bom_comp_tbl_rec BOM_BO_PUB.Bom_Comps_Rec_Type ;
79: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
80: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
81: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
82: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE ;
83: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
84: X_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
85: X_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
86: X_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;

Line 83: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE;

79: l_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
80: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
81: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
82: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE ;
83: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
84: X_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
85: X_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
86: X_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
87: X_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;

Line 84: X_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;

80: l_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
81: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
82: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE ;
83: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
84: X_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
85: X_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
86: X_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
87: X_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
88: /* myerrams, Bug: 5142847; End; */

Line 85: X_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;

81: l_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
82: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE ;
83: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
84: X_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
85: X_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
86: X_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
87: X_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
88: /* myerrams, Bug: 5142847; End; */
89:

Line 86: X_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;

82: X_bom_header_tbl BOM_BO_PUB.BOM_HEADER_TBL_TYPE ;
83: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
84: X_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
85: X_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
86: X_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
87: X_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
88: /* myerrams, Bug: 5142847; End; */
89:
90: CURSOR bom_header_temp_CUR IS

Line 87: X_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;

83: X_bom_revisions_tbl BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
84: X_bom_comp_tbl BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
85: X_bom_ref_desig_tbl BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
86: X_bom_sub_comp_tbl BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
87: X_bom_comp_oper_tbl BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
88: /* myerrams, Bug: 5142847; End; */
89:
90: CURSOR bom_header_temp_CUR IS
91: SELECT bom.BILL_SEQUENCE_ID BILL_SEQUENCE_ID, --myerrams, Bug: 5142847

Line 883: p_bom_header_tbl IN BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,

879:
880: PROCEDURE CALL_PROCESS_BOM(P_debug IN VARCHAR2,
881: P_output_dir IN VARCHAR2,
882: P_debug_filename IN VARCHAR2,
883: p_bom_header_tbl IN BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
884: p_bom_component_tbl IN BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
885: p_bom_ref_designator_tbl IN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
886: p_bom_sub_component_tbl IN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
887: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,

Line 884: p_bom_component_tbl IN BOM_BO_PUB.BOM_COMPS_TBL_TYPE,

880: PROCEDURE CALL_PROCESS_BOM(P_debug IN VARCHAR2,
881: P_output_dir IN VARCHAR2,
882: P_debug_filename IN VARCHAR2,
883: p_bom_header_tbl IN BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
884: p_bom_component_tbl IN BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
885: p_bom_ref_designator_tbl IN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
886: p_bom_sub_component_tbl IN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
887: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
888: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,

Line 885: p_bom_ref_designator_tbl IN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,

881: P_output_dir IN VARCHAR2,
882: P_debug_filename IN VARCHAR2,
883: p_bom_header_tbl IN BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
884: p_bom_component_tbl IN BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
885: p_bom_ref_designator_tbl IN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
886: p_bom_sub_component_tbl IN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
887: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
888: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
889: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,

Line 886: p_bom_sub_component_tbl IN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,

882: P_debug_filename IN VARCHAR2,
883: p_bom_header_tbl IN BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
884: p_bom_component_tbl IN BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
885: p_bom_ref_designator_tbl IN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
886: p_bom_sub_component_tbl IN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
887: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
888: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
889: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,
890: X_bom_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,

Line 887: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,

883: p_bom_header_tbl IN BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
884: p_bom_component_tbl IN BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
885: p_bom_ref_designator_tbl IN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
886: p_bom_sub_component_tbl IN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
887: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
888: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
889: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,
890: X_bom_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
891: X_bom_ref_desig_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,

Line 888: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,

884: p_bom_component_tbl IN BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
885: p_bom_ref_designator_tbl IN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
886: p_bom_sub_component_tbl IN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
887: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
888: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
889: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,
890: X_bom_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
891: X_bom_ref_desig_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
892: X_bom_sub_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,

Line 889: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,

885: p_bom_ref_designator_tbl IN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
886: p_bom_sub_component_tbl IN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
887: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
888: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
889: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,
890: X_bom_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
891: X_bom_ref_desig_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
892: X_bom_sub_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
893: X_bom_comp_oper_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,

Line 890: X_bom_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,

886: p_bom_sub_component_tbl IN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
887: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
888: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
889: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,
890: X_bom_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
891: X_bom_ref_desig_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
892: X_bom_sub_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
893: X_bom_comp_oper_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
894: X_return_status IN OUT NOCOPY VARCHAR2, --myerrams, Bug: 5592181

Line 891: X_bom_ref_desig_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,

887: p_bom_comp_ops_tbl IN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
888: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
889: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,
890: X_bom_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
891: X_bom_ref_desig_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
892: X_bom_sub_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
893: X_bom_comp_oper_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
894: X_return_status IN OUT NOCOPY VARCHAR2, --myerrams, Bug: 5592181
895: X_G_msg_data OUT NOCOPY LONG,

Line 892: X_bom_sub_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,

888: X_bom_header_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_HEADER_TBL_TYPE ,
889: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,
890: X_bom_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
891: X_bom_ref_desig_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
892: X_bom_sub_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
893: X_bom_comp_oper_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
894: X_return_status IN OUT NOCOPY VARCHAR2, --myerrams, Bug: 5592181
895: X_G_msg_data OUT NOCOPY LONG,
896: X_msg_count OUT NOCOPY NUMBER

Line 893: X_bom_comp_oper_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,

889: X_bom_revisions_tbl IN OUT NOCOPY BOM_BO_PUB.Bom_Revision_Tbl_Type,
890: X_bom_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMPS_TBL_TYPE,
891: X_bom_ref_desig_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE,
892: X_bom_sub_comp_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE,
893: X_bom_comp_oper_tbl IN OUT NOCOPY BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE,
894: X_return_status IN OUT NOCOPY VARCHAR2, --myerrams, Bug: 5592181
895: X_G_msg_data OUT NOCOPY LONG,
896: X_msg_count OUT NOCOPY NUMBER
897: ) IS

Line 911: , 'Before Calling BOM_BO_PUB.Process_Bom()');

907: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
908: THEN
909: FND_LOG.string( FND_LOG.LEVEL_STATEMENT
910: , G_MODULE_PREFIX || g_api_name
911: , 'Before Calling BOM_BO_PUB.Process_Bom()');
912: END IF;
913:
914: BOM_GLOBALS.Set_Caller_Type('MIGRATION');
915: BOM_BO_PUB.Process_Bom(p_bom_header_tbl => p_bom_header_tbl,

Line 915: BOM_BO_PUB.Process_Bom(p_bom_header_tbl => p_bom_header_tbl,

911: , 'Before Calling BOM_BO_PUB.Process_Bom()');
912: END IF;
913:
914: BOM_GLOBALS.Set_Caller_Type('MIGRATION');
915: BOM_BO_PUB.Process_Bom(p_bom_header_tbl => p_bom_header_tbl,
916: p_bom_component_tbl => p_bom_component_tbl,
917: p_bom_ref_designator_tbl => p_bom_ref_designator_tbl ,
918: p_bom_sub_component_tbl => p_bom_sub_component_tbl ,
919: p_bom_comp_ops_tbl => p_bom_comp_ops_tbl,

Line 946: , 'Current Call Return Status of BOM_BO_PUB.Process_Bom: g_X_return_status:'|| g_X_return_status);

942: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
943: THEN
944: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
945: , G_MODULE_PREFIX || g_api_name
946: , 'Current Call Return Status of BOM_BO_PUB.Process_Bom: g_X_return_status:'|| g_X_return_status);
947: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
948: , G_MODULE_PREFIX || g_api_name
949: , 'Previous Call Return Status of BOM_BO_PUB.Process_Bom: X_return_status:'|| X_return_status);
950: END IF;

Line 949: , 'Previous Call Return Status of BOM_BO_PUB.Process_Bom: X_return_status:'|| X_return_status);

945: , G_MODULE_PREFIX || g_api_name
946: , 'Current Call Return Status of BOM_BO_PUB.Process_Bom: g_X_return_status:'|| g_X_return_status);
947: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
948: , G_MODULE_PREFIX || g_api_name
949: , 'Previous Call Return Status of BOM_BO_PUB.Process_Bom: X_return_status:'|| X_return_status);
950: END IF;
951:
952: IF (g_X_return_status <> 'S' and g_status_set = FALSE) THEN
953: X_return_status := g_X_return_status;

Line 975: , 'Error messages from BOM_BO_PUB.Process_Bom:'|| X_G_msg_data);

971: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
972: THEN
973: FND_LOG.string( FND_LOG.LEVEL_EXCEPTION
974: , G_MODULE_PREFIX || g_api_name
975: , 'Error messages from BOM_BO_PUB.Process_Bom:'|| X_G_msg_data);
976: END IF;
977:
978: END;
979: END LOOP;

Line 986: , 'After Calling BOM_BO_PUB.Process_Bom()');

982: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
983: THEN
984: FND_LOG.string( FND_LOG.LEVEL_STATEMENT
985: , G_MODULE_PREFIX || g_api_name
986: , 'After Calling BOM_BO_PUB.Process_Bom()');
987: END IF;
988: /* Reset all the PL/SQL tables and counters*/
989:
990: END CALL_PROCESS_BOM;