20: -- 02-OCT-2008 Kashif Suleman Initial Creation
21: --
22: ****************************************************************************/
23:
24: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_HEAD_REC_TYPE
25: FUNCTION PL_TO_SQL_HEAD_REC
26: (
27: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE)
28: RETURN BOM_BO_PUB_BOM_HEAD_REC_TYPE;
23:
24: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_HEAD_REC_TYPE
25: FUNCTION PL_TO_SQL_HEAD_REC
26: (
27: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE)
28: RETURN BOM_BO_PUB_BOM_HEAD_REC_TYPE;
29: FUNCTION SQL_TO_PL_HEAD_REC
30: (
31: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE)
24: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_HEAD_REC_TYPE
25: FUNCTION PL_TO_SQL_HEAD_REC
26: (
27: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE)
28: RETURN BOM_BO_PUB_BOM_HEAD_REC_TYPE;
29: FUNCTION SQL_TO_PL_HEAD_REC
30: (
31: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE)
32: RETURN BOM_BO_PUB.BOM_HEAD_REC_TYPE;
27: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE)
28: RETURN BOM_BO_PUB_BOM_HEAD_REC_TYPE;
29: FUNCTION SQL_TO_PL_HEAD_REC
30: (
31: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE)
32: RETURN BOM_BO_PUB.BOM_HEAD_REC_TYPE;
33: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_REC_TYPE
34: FUNCTION PL_TO_SQL_REV_REC
35: (
28: RETURN BOM_BO_PUB_BOM_HEAD_REC_TYPE;
29: FUNCTION SQL_TO_PL_HEAD_REC
30: (
31: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE)
32: RETURN BOM_BO_PUB.BOM_HEAD_REC_TYPE;
33: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_REC_TYPE
34: FUNCTION PL_TO_SQL_REV_REC
35: (
36: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE)
29: FUNCTION SQL_TO_PL_HEAD_REC
30: (
31: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE)
32: RETURN BOM_BO_PUB.BOM_HEAD_REC_TYPE;
33: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_REC_TYPE
34: FUNCTION PL_TO_SQL_REV_REC
35: (
36: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE)
37: RETURN BOM_BO_PUB_BOM_REV_REC_TYPE;
32: RETURN BOM_BO_PUB.BOM_HEAD_REC_TYPE;
33: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_REC_TYPE
34: FUNCTION PL_TO_SQL_REV_REC
35: (
36: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE)
37: RETURN BOM_BO_PUB_BOM_REV_REC_TYPE;
38: FUNCTION SQL_TO_PL_REV_REC
39: (
40: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE)
33: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_REC_TYPE
34: FUNCTION PL_TO_SQL_REV_REC
35: (
36: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE)
37: RETURN BOM_BO_PUB_BOM_REV_REC_TYPE;
38: FUNCTION SQL_TO_PL_REV_REC
39: (
40: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE)
41: RETURN BOM_BO_PUB.BOM_REVISION_REC_TYPE;
36: aPlsqlItem BOM_BO_PUB.BOM_REVISION_REC_TYPE)
37: RETURN BOM_BO_PUB_BOM_REV_REC_TYPE;
38: FUNCTION SQL_TO_PL_REV_REC
39: (
40: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE)
41: RETURN BOM_BO_PUB.BOM_REVISION_REC_TYPE;
42: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_TBL_TYPE
43: FUNCTION PL_TO_SQL_REV_TBL
44: (
37: RETURN BOM_BO_PUB_BOM_REV_REC_TYPE;
38: FUNCTION SQL_TO_PL_REV_REC
39: (
40: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE)
41: RETURN BOM_BO_PUB.BOM_REVISION_REC_TYPE;
42: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_TBL_TYPE
43: FUNCTION PL_TO_SQL_REV_TBL
44: (
45: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE)
38: FUNCTION SQL_TO_PL_REV_REC
39: (
40: aSqlItem BOM_BO_PUB_BOM_REV_REC_TYPE)
41: RETURN BOM_BO_PUB.BOM_REVISION_REC_TYPE;
42: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_TBL_TYPE
43: FUNCTION PL_TO_SQL_REV_TBL
44: (
45: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE)
46: RETURN BOM_BO_PUB_BOM_REV_TBL_TYPE;
41: RETURN BOM_BO_PUB.BOM_REVISION_REC_TYPE;
42: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_TBL_TYPE
43: FUNCTION PL_TO_SQL_REV_TBL
44: (
45: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE)
46: RETURN BOM_BO_PUB_BOM_REV_TBL_TYPE;
47: FUNCTION SQL_TO_PL_REV_TBL
48: (
49: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE)
42: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REVISION_TBL_TYPE
43: FUNCTION PL_TO_SQL_REV_TBL
44: (
45: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE)
46: RETURN BOM_BO_PUB_BOM_REV_TBL_TYPE;
47: FUNCTION SQL_TO_PL_REV_TBL
48: (
49: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE)
50: RETURN BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
45: aPlsqlItem BOM_BO_PUB.BOM_REVISION_TBL_TYPE)
46: RETURN BOM_BO_PUB_BOM_REV_TBL_TYPE;
47: FUNCTION SQL_TO_PL_REV_TBL
48: (
49: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE)
50: RETURN BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
51: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_REC_TYPE
52: FUNCTION PL_TO_SQL_COMPS_REC
53: (
46: RETURN BOM_BO_PUB_BOM_REV_TBL_TYPE;
47: FUNCTION SQL_TO_PL_REV_TBL
48: (
49: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE)
50: RETURN BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
51: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_REC_TYPE
52: FUNCTION PL_TO_SQL_COMPS_REC
53: (
54: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE)
47: FUNCTION SQL_TO_PL_REV_TBL
48: (
49: aSqlItem BOM_BO_PUB_BOM_REV_TBL_TYPE)
50: RETURN BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
51: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_REC_TYPE
52: FUNCTION PL_TO_SQL_COMPS_REC
53: (
54: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE)
55: RETURN BOM_BO_PUB_BOM_COMPS_REC_TYPE;
50: RETURN BOM_BO_PUB.BOM_REVISION_TBL_TYPE;
51: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_REC_TYPE
52: FUNCTION PL_TO_SQL_COMPS_REC
53: (
54: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE)
55: RETURN BOM_BO_PUB_BOM_COMPS_REC_TYPE;
56: FUNCTION SQL_TO_PL_COMPS_REC
57: (
58: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE)
51: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_REC_TYPE
52: FUNCTION PL_TO_SQL_COMPS_REC
53: (
54: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE)
55: RETURN BOM_BO_PUB_BOM_COMPS_REC_TYPE;
56: FUNCTION SQL_TO_PL_COMPS_REC
57: (
58: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE)
59: RETURN BOM_BO_PUB.BOM_COMPS_REC_TYPE;
54: aPlsqlItem BOM_BO_PUB.BOM_COMPS_REC_TYPE)
55: RETURN BOM_BO_PUB_BOM_COMPS_REC_TYPE;
56: FUNCTION SQL_TO_PL_COMPS_REC
57: (
58: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE)
59: RETURN BOM_BO_PUB.BOM_COMPS_REC_TYPE;
60: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_TBL_TYPE
61: FUNCTION PL_TO_SQL_COMPS_TBL
62: (
55: RETURN BOM_BO_PUB_BOM_COMPS_REC_TYPE;
56: FUNCTION SQL_TO_PL_COMPS_REC
57: (
58: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE)
59: RETURN BOM_BO_PUB.BOM_COMPS_REC_TYPE;
60: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_TBL_TYPE
61: FUNCTION PL_TO_SQL_COMPS_TBL
62: (
63: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE)
56: FUNCTION SQL_TO_PL_COMPS_REC
57: (
58: aSqlItem BOM_BO_PUB_BOM_COMPS_REC_TYPE)
59: RETURN BOM_BO_PUB.BOM_COMPS_REC_TYPE;
60: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_TBL_TYPE
61: FUNCTION PL_TO_SQL_COMPS_TBL
62: (
63: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE)
64: RETURN BOM_BO_PUB_BOM_COMPS_TBL_TYPE;
59: RETURN BOM_BO_PUB.BOM_COMPS_REC_TYPE;
60: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_TBL_TYPE
61: FUNCTION PL_TO_SQL_COMPS_TBL
62: (
63: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE)
64: RETURN BOM_BO_PUB_BOM_COMPS_TBL_TYPE;
65: FUNCTION SQL_TO_PL_COMPS_TBL
66: (
67: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE)
60: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMPS_TBL_TYPE
61: FUNCTION PL_TO_SQL_COMPS_TBL
62: (
63: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE)
64: RETURN BOM_BO_PUB_BOM_COMPS_TBL_TYPE;
65: FUNCTION SQL_TO_PL_COMPS_TBL
66: (
67: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE)
68: RETURN BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
63: aPlsqlItem BOM_BO_PUB.BOM_COMPS_TBL_TYPE)
64: RETURN BOM_BO_PUB_BOM_COMPS_TBL_TYPE;
65: FUNCTION SQL_TO_PL_COMPS_TBL
66: (
67: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE)
68: RETURN BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
69: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE
70: FUNCTION PL_TO_SQL_RF_DES_REC
71: (
64: RETURN BOM_BO_PUB_BOM_COMPS_TBL_TYPE;
65: FUNCTION SQL_TO_PL_COMPS_TBL
66: (
67: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE)
68: RETURN BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
69: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE
70: FUNCTION PL_TO_SQL_RF_DES_REC
71: (
72: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE)
65: FUNCTION SQL_TO_PL_COMPS_TBL
66: (
67: aSqlItem BOM_BO_PUB_BOM_COMPS_TBL_TYPE)
68: RETURN BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
69: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE
70: FUNCTION PL_TO_SQL_RF_DES_REC
71: (
72: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE)
73: RETURN BOM_BO_PUB_BOM_RF_DES_REC_TYPE;
68: RETURN BOM_BO_PUB.BOM_COMPS_TBL_TYPE;
69: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE
70: FUNCTION PL_TO_SQL_RF_DES_REC
71: (
72: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE)
73: RETURN BOM_BO_PUB_BOM_RF_DES_REC_TYPE;
74: FUNCTION SQL_TO_PL_RF_DES_REC
75: (
76: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE)
69: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE
70: FUNCTION PL_TO_SQL_RF_DES_REC
71: (
72: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE)
73: RETURN BOM_BO_PUB_BOM_RF_DES_REC_TYPE;
74: FUNCTION SQL_TO_PL_RF_DES_REC
75: (
76: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE)
77: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE;
72: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE)
73: RETURN BOM_BO_PUB_BOM_RF_DES_REC_TYPE;
74: FUNCTION SQL_TO_PL_RF_DES_REC
75: (
76: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE)
77: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE;
78: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
79: FUNCTION PL_TO_SQL_RF_DES_TBL
80: (
73: RETURN BOM_BO_PUB_BOM_RF_DES_REC_TYPE;
74: FUNCTION SQL_TO_PL_RF_DES_REC
75: (
76: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE)
77: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE;
78: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
79: FUNCTION PL_TO_SQL_RF_DES_TBL
80: (
81: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE)
74: FUNCTION SQL_TO_PL_RF_DES_REC
75: (
76: aSqlItem BOM_BO_PUB_BOM_RF_DES_REC_TYPE)
77: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE;
78: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
79: FUNCTION PL_TO_SQL_RF_DES_TBL
80: (
81: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE)
82: RETURN BOM_BO_PUB_BOM_RF_DES_TBL_TYPE;
77: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_REC_TYPE;
78: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
79: FUNCTION PL_TO_SQL_RF_DES_TBL
80: (
81: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE)
82: RETURN BOM_BO_PUB_BOM_RF_DES_TBL_TYPE;
83: FUNCTION SQL_TO_PL_RF_DES_TBL
84: (
85: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE)
78: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE
79: FUNCTION PL_TO_SQL_RF_DES_TBL
80: (
81: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE)
82: RETURN BOM_BO_PUB_BOM_RF_DES_TBL_TYPE;
83: FUNCTION SQL_TO_PL_RF_DES_TBL
84: (
85: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE)
86: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
81: aPlsqlItem BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE)
82: RETURN BOM_BO_PUB_BOM_RF_DES_TBL_TYPE;
83: FUNCTION SQL_TO_PL_RF_DES_TBL
84: (
85: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE)
86: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
87: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE
88: FUNCTION PL_TO_SQL_SUB_COMP_REC
89: (
82: RETURN BOM_BO_PUB_BOM_RF_DES_TBL_TYPE;
83: FUNCTION SQL_TO_PL_RF_DES_TBL
84: (
85: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE)
86: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
87: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE
88: FUNCTION PL_TO_SQL_SUB_COMP_REC
89: (
90: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE)
83: FUNCTION SQL_TO_PL_RF_DES_TBL
84: (
85: aSqlItem BOM_BO_PUB_BOM_RF_DES_TBL_TYPE)
86: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
87: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE
88: FUNCTION PL_TO_SQL_SUB_COMP_REC
89: (
90: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE)
91: RETURN BOM_BO_PUB_BOM_SUBCMP_REC_TYPE;
86: RETURN BOM_BO_PUB.BOM_REF_DESIGNATOR_TBL_TYPE;
87: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE
88: FUNCTION PL_TO_SQL_SUB_COMP_REC
89: (
90: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE)
91: RETURN BOM_BO_PUB_BOM_SUBCMP_REC_TYPE;
92: FUNCTION SQL_TO_PL_SUB_COMP_REC
93: (
94: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE)
87: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE
88: FUNCTION PL_TO_SQL_SUB_COMP_REC
89: (
90: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE)
91: RETURN BOM_BO_PUB_BOM_SUBCMP_REC_TYPE;
92: FUNCTION SQL_TO_PL_SUB_COMP_REC
93: (
94: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE)
95: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE;
90: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE)
91: RETURN BOM_BO_PUB_BOM_SUBCMP_REC_TYPE;
92: FUNCTION SQL_TO_PL_SUB_COMP_REC
93: (
94: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE)
95: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE;
96: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
97: FUNCTION PL_TO_SQL_SUB_COMP_TBL
98: (
91: RETURN BOM_BO_PUB_BOM_SUBCMP_REC_TYPE;
92: FUNCTION SQL_TO_PL_SUB_COMP_REC
93: (
94: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE)
95: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE;
96: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
97: FUNCTION PL_TO_SQL_SUB_COMP_TBL
98: (
99: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE)
92: FUNCTION SQL_TO_PL_SUB_COMP_REC
93: (
94: aSqlItem BOM_BO_PUB_BOM_SUBCMP_REC_TYPE)
95: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE;
96: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
97: FUNCTION PL_TO_SQL_SUB_COMP_TBL
98: (
99: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE)
100: RETURN BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE;
95: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_REC_TYPE;
96: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
97: FUNCTION PL_TO_SQL_SUB_COMP_TBL
98: (
99: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE)
100: RETURN BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE;
101: FUNCTION SQL_TO_PL_SUB_COMP_TBL
102: (
103: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE)
96: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE
97: FUNCTION PL_TO_SQL_SUB_COMP_TBL
98: (
99: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE)
100: RETURN BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE;
101: FUNCTION SQL_TO_PL_SUB_COMP_TBL
102: (
103: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE)
104: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
99: aPlsqlItem BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE)
100: RETURN BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE;
101: FUNCTION SQL_TO_PL_SUB_COMP_TBL
102: (
103: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE)
104: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
105: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE
106: FUNCTION PL_TO_SQL_COMP_OPS_REC
107: (
100: RETURN BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE;
101: FUNCTION SQL_TO_PL_SUB_COMP_TBL
102: (
103: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE)
104: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
105: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE
106: FUNCTION PL_TO_SQL_COMP_OPS_REC
107: (
108: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE)
101: FUNCTION SQL_TO_PL_SUB_COMP_TBL
102: (
103: aSqlItem BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE)
104: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
105: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE
106: FUNCTION PL_TO_SQL_COMP_OPS_REC
107: (
108: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE)
109: RETURN BOM_BO_PUB_BOM_COMPOP_REC_TYPE;
104: RETURN BOM_BO_PUB.BOM_SUB_COMPONENT_TBL_TYPE;
105: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE
106: FUNCTION PL_TO_SQL_COMP_OPS_REC
107: (
108: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE)
109: RETURN BOM_BO_PUB_BOM_COMPOP_REC_TYPE;
110: FUNCTION SQL_TO_PL_COMP_OPS_REC
111: (
112: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE)
105: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE
106: FUNCTION PL_TO_SQL_COMP_OPS_REC
107: (
108: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE)
109: RETURN BOM_BO_PUB_BOM_COMPOP_REC_TYPE;
110: FUNCTION SQL_TO_PL_COMP_OPS_REC
111: (
112: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE)
113: RETURN BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE;
108: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE)
109: RETURN BOM_BO_PUB_BOM_COMPOP_REC_TYPE;
110: FUNCTION SQL_TO_PL_COMP_OPS_REC
111: (
112: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE)
113: RETURN BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE;
114: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
115: FUNCTION PL_TO_SQL_COMP_OPS_TBL
116: (
109: RETURN BOM_BO_PUB_BOM_COMPOP_REC_TYPE;
110: FUNCTION SQL_TO_PL_COMP_OPS_REC
111: (
112: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE)
113: RETURN BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE;
114: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
115: FUNCTION PL_TO_SQL_COMP_OPS_TBL
116: (
117: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE)
110: FUNCTION SQL_TO_PL_COMP_OPS_REC
111: (
112: aSqlItem BOM_BO_PUB_BOM_COMPOP_REC_TYPE)
113: RETURN BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE;
114: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
115: FUNCTION PL_TO_SQL_COMP_OPS_TBL
116: (
117: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE)
118: RETURN BOM_BO_PUB_BOM_COMPOP_TBL_TYPE;
113: RETURN BOM_BO_PUB.BOM_COMP_OPS_REC_TYPE;
114: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
115: FUNCTION PL_TO_SQL_COMP_OPS_TBL
116: (
117: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE)
118: RETURN BOM_BO_PUB_BOM_COMPOP_TBL_TYPE;
119: FUNCTION SQL_TO_PL_COMP_OPS_TBL
120: (
121: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE)
114: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE
115: FUNCTION PL_TO_SQL_COMP_OPS_TBL
116: (
117: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE)
118: RETURN BOM_BO_PUB_BOM_COMPOP_TBL_TYPE;
119: FUNCTION SQL_TO_PL_COMP_OPS_TBL
120: (
121: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE)
122: RETURN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
117: aPlsqlItem BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE)
118: RETURN BOM_BO_PUB_BOM_COMPOP_TBL_TYPE;
119: FUNCTION SQL_TO_PL_COMP_OPS_TBL
120: (
121: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE)
122: RETURN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
123: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_REC_TYPE
124: FUNCTION PL_TO_SQL_PROD_REC
125: (
118: RETURN BOM_BO_PUB_BOM_COMPOP_TBL_TYPE;
119: FUNCTION SQL_TO_PL_COMP_OPS_TBL
120: (
121: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE)
122: RETURN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
123: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_REC_TYPE
124: FUNCTION PL_TO_SQL_PROD_REC
125: (
126: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE)
119: FUNCTION SQL_TO_PL_COMP_OPS_TBL
120: (
121: aSqlItem BOM_BO_PUB_BOM_COMPOP_TBL_TYPE)
122: RETURN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
123: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_REC_TYPE
124: FUNCTION PL_TO_SQL_PROD_REC
125: (
126: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE)
127: RETURN BOM_BO_PUB_BOM_PROD_REC_TYPE;
122: RETURN BOM_BO_PUB.BOM_COMP_OPS_TBL_TYPE;
123: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_REC_TYPE
124: FUNCTION PL_TO_SQL_PROD_REC
125: (
126: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE)
127: RETURN BOM_BO_PUB_BOM_PROD_REC_TYPE;
128: FUNCTION SQL_TO_PL_PROD_REC
129: (
130: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE)
123: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_REC_TYPE
124: FUNCTION PL_TO_SQL_PROD_REC
125: (
126: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE)
127: RETURN BOM_BO_PUB_BOM_PROD_REC_TYPE;
128: FUNCTION SQL_TO_PL_PROD_REC
129: (
130: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE)
131: RETURN BOM_BO_PUB.BOM_PRODUCT_REC_TYPE;
126: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_REC_TYPE)
127: RETURN BOM_BO_PUB_BOM_PROD_REC_TYPE;
128: FUNCTION SQL_TO_PL_PROD_REC
129: (
130: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE)
131: RETURN BOM_BO_PUB.BOM_PRODUCT_REC_TYPE;
132: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE
133: FUNCTION PL_TO_SQL_PROD_MEM_REC
134: (
127: RETURN BOM_BO_PUB_BOM_PROD_REC_TYPE;
128: FUNCTION SQL_TO_PL_PROD_REC
129: (
130: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE)
131: RETURN BOM_BO_PUB.BOM_PRODUCT_REC_TYPE;
132: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE
133: FUNCTION PL_TO_SQL_PROD_MEM_REC
134: (
135: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE)
128: FUNCTION SQL_TO_PL_PROD_REC
129: (
130: aSqlItem BOM_BO_PUB_BOM_PROD_REC_TYPE)
131: RETURN BOM_BO_PUB.BOM_PRODUCT_REC_TYPE;
132: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE
133: FUNCTION PL_TO_SQL_PROD_MEM_REC
134: (
135: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE)
136: RETURN BOM_BO_PUB_BOM_PRDMEM_REC_TYPE;
131: RETURN BOM_BO_PUB.BOM_PRODUCT_REC_TYPE;
132: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE
133: FUNCTION PL_TO_SQL_PROD_MEM_REC
134: (
135: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE)
136: RETURN BOM_BO_PUB_BOM_PRDMEM_REC_TYPE;
137: FUNCTION SQL_TO_PL_PROD_MEM_REC
138: (
139: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE)
132: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE
133: FUNCTION PL_TO_SQL_PROD_MEM_REC
134: (
135: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE)
136: RETURN BOM_BO_PUB_BOM_PRDMEM_REC_TYPE;
137: FUNCTION SQL_TO_PL_PROD_MEM_REC
138: (
139: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE)
140: RETURN BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE;
135: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE)
136: RETURN BOM_BO_PUB_BOM_PRDMEM_REC_TYPE;
137: FUNCTION SQL_TO_PL_PROD_MEM_REC
138: (
139: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE)
140: RETURN BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE;
141: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE
142: FUNCTION PL_TO_SQL_PROD_MEM_TBL
143: (
136: RETURN BOM_BO_PUB_BOM_PRDMEM_REC_TYPE;
137: FUNCTION SQL_TO_PL_PROD_MEM_REC
138: (
139: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE)
140: RETURN BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE;
141: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE
142: FUNCTION PL_TO_SQL_PROD_MEM_TBL
143: (
144: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE)
137: FUNCTION SQL_TO_PL_PROD_MEM_REC
138: (
139: aSqlItem BOM_BO_PUB_BOM_PRDMEM_REC_TYPE)
140: RETURN BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE;
141: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE
142: FUNCTION PL_TO_SQL_PROD_MEM_TBL
143: (
144: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE)
145: RETURN BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE;
140: RETURN BOM_BO_PUB.BOM_PRODUCT_MEMBER_REC_TYPE;
141: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE
142: FUNCTION PL_TO_SQL_PROD_MEM_TBL
143: (
144: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE)
145: RETURN BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE;
146: FUNCTION SQL_TO_PL_PROD_MEM_TBL
147: (
148: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE)
141: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE
142: FUNCTION PL_TO_SQL_PROD_MEM_TBL
143: (
144: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE)
145: RETURN BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE;
146: FUNCTION SQL_TO_PL_PROD_MEM_TBL
147: (
148: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE)
149: RETURN BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE;
144: aPlsqlItem BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE)
145: RETURN BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE;
146: FUNCTION SQL_TO_PL_PROD_MEM_TBL
147: (
148: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE)
149: RETURN BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE;
150: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_HEADER_TBL_TYPE
151: FUNCTION PL_TO_SQL_HEADER_TBL
152: (
145: RETURN BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE;
146: FUNCTION SQL_TO_PL_PROD_MEM_TBL
147: (
148: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE)
149: RETURN BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE;
150: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_HEADER_TBL_TYPE
151: FUNCTION PL_TO_SQL_HEADER_TBL
152: (
153: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE)
146: FUNCTION SQL_TO_PL_PROD_MEM_TBL
147: (
148: aSqlItem BOM_BO_PUB_BOM_PRDMEM_TBL_TYPE)
149: RETURN BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE;
150: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_HEADER_TBL_TYPE
151: FUNCTION PL_TO_SQL_HEADER_TBL
152: (
153: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE)
154: RETURN BOM_BO_PUB_BOM_HEADER_TBL_TYPE;
149: RETURN BOM_BO_PUB.BOM_PRODUCT_MEM_TAB_TYPE;
150: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_HEADER_TBL_TYPE
151: FUNCTION PL_TO_SQL_HEADER_TBL
152: (
153: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE)
154: RETURN BOM_BO_PUB_BOM_HEADER_TBL_TYPE;
155: FUNCTION SQL_TO_PL_HEADER_TBL
156: (
157: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE)
150: -- Declare the conversion functions the PL/SQL type BOM_BO_PUB.BOM_HEADER_TBL_TYPE
151: FUNCTION PL_TO_SQL_HEADER_TBL
152: (
153: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE)
154: RETURN BOM_BO_PUB_BOM_HEADER_TBL_TYPE;
155: FUNCTION SQL_TO_PL_HEADER_TBL
156: (
157: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE)
158: RETURN BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
153: aPlsqlItem BOM_BO_PUB.BOM_HEADER_TBL_TYPE)
154: RETURN BOM_BO_PUB_BOM_HEADER_TBL_TYPE;
155: FUNCTION SQL_TO_PL_HEADER_TBL
156: (
157: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE)
158: RETURN BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
159: PROCEDURE BOM_BO_PUB$PROCESS_BOM
160: (
161: P_BO_IDENTIFIER VARCHAR2,
154: RETURN BOM_BO_PUB_BOM_HEADER_TBL_TYPE;
155: FUNCTION SQL_TO_PL_HEADER_TBL
156: (
157: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE)
158: RETURN BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
159: PROCEDURE BOM_BO_PUB$PROCESS_BOM
160: (
161: P_BO_IDENTIFIER VARCHAR2,
162: P_API_VERSION_NUMBER NUMBER,
155: FUNCTION SQL_TO_PL_HEADER_TBL
156: (
157: aSqlItem BOM_BO_PUB_BOM_HEADER_TBL_TYPE)
158: RETURN BOM_BO_PUB.BOM_HEADER_TBL_TYPE;
159: PROCEDURE BOM_BO_PUB$PROCESS_BOM
160: (
161: P_BO_IDENTIFIER VARCHAR2,
162: P_API_VERSION_NUMBER NUMBER,
163: P_INIT_MSG_LIST INTEGER,
160: (
161: P_BO_IDENTIFIER VARCHAR2,
162: P_API_VERSION_NUMBER NUMBER,
163: P_INIT_MSG_LIST INTEGER,
164: P_BOM_HEADER_TBL BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
165: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,
166: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
167: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
161: P_BO_IDENTIFIER VARCHAR2,
162: P_API_VERSION_NUMBER NUMBER,
163: P_INIT_MSG_LIST INTEGER,
164: P_BOM_HEADER_TBL BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
165: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,
166: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
167: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
162: P_API_VERSION_NUMBER NUMBER,
163: P_INIT_MSG_LIST INTEGER,
164: P_BOM_HEADER_TBL BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
165: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,
166: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
167: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
163: P_INIT_MSG_LIST INTEGER,
164: P_BOM_HEADER_TBL BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
165: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,
166: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
167: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
164: P_BOM_HEADER_TBL BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
165: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,
166: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
167: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
172: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
165: P_BOM_REVISION_TBL BOM_BO_PUB_BOM_REV_TBL_TYPE,
166: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
167: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
172: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
173: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
166: P_BOM_COMPONENT_TBL BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
167: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
172: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
173: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
174: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
167: P_BOM_REF_DESIGNATOR_TBL BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
172: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
173: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
174: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
175: X_BOM_COMP_OPS_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
168: P_BOM_SUB_COMPONENT_TBL BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
172: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
173: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
174: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
175: X_BOM_COMP_OPS_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
176: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,
169: P_BOM_COMP_OPS_TBL BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
172: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
173: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
174: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
175: X_BOM_COMP_OPS_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
176: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,
177: X_MSG_COUNT IN OUT NOCOPY NUMBER,
170: X_BOM_HEADER_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_HEADER_TBL_TYPE,
171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
172: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
173: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
174: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
175: X_BOM_COMP_OPS_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
176: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,
177: X_MSG_COUNT IN OUT NOCOPY NUMBER,
178: X_ERROR_MESSAGE IN OUT NOCOPY VARCHAR2,
171: X_BOM_REVISION_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_REV_TBL_TYPE,
172: X_BOM_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPS_TBL_TYPE,
173: X_BOM_REF_DESIGNATOR_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_RF_DES_TBL_TYPE,
174: X_BOM_SUB_COMPONENT_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_SUBCMP_TBL_TYPE,
175: X_BOM_COMP_OPS_TBL IN OUT NOCOPY BOM_BO_PUB_BOM_COMPOP_TBL_TYPE,
176: X_RETURN_STATUS IN OUT NOCOPY VARCHAR2,
177: X_MSG_COUNT IN OUT NOCOPY NUMBER,
178: X_ERROR_MESSAGE IN OUT NOCOPY VARCHAR2,
179: P_DEBUG VARCHAR2,