43: * cause all children to error out, since they are referencing an invalid parent.
44: * Mesg_Token_Table will carry the error messsage and the tokens associated with the message.
45: *
46: * @param p_rtg_revision_rec IN Routing Revision Exposed Record
47: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
48: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
49: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
50: * @param x_old_rtg_revision_rec IN OUT NOCOPY Old Routing Revision Exposed Record if already exists
51: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
45: *
46: * @param p_rtg_revision_rec IN Routing Revision Exposed Record
47: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
48: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
49: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
50: * @param x_old_rtg_revision_rec IN OUT NOCOPY Old Routing Revision Exposed Record if already exists
51: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
52: * @param x_old_rtg_Rev_Unexp_rec IN OUT NOCOPY Old Routing Revision Unexposed Record if already exists
53: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
47: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
48: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
49: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
50: * @param x_old_rtg_revision_rec IN OUT NOCOPY Old Routing Revision Exposed Record if already exists
51: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
52: * @param x_old_rtg_Rev_Unexp_rec IN OUT NOCOPY Old Routing Revision Unexposed Record if already exists
53: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
54: * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
55: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
49: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
50: * @param x_old_rtg_revision_rec IN OUT NOCOPY Old Routing Revision Exposed Record if already exists
51: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
52: * @param x_old_rtg_Rev_Unexp_rec IN OUT NOCOPY Old Routing Revision Unexposed Record if already exists
53: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
54: * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
55: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
56: * @param x_return_status IN OUT NOCOPY Return Status
57: *
61: * @rep:compatibility S
62: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
63: */
64: PROCEDURE Check_Existence
65: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
66: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
67: , x_old_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
68: , x_old_rtg_rev_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
69: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
62: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
63: */
64: PROCEDURE Check_Existence
65: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
66: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
67: , x_old_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
68: , x_old_rtg_rev_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
69: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
70: , x_return_status IN OUT NOCOPY VARCHAR2
63: */
64: PROCEDURE Check_Existence
65: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
66: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
67: , x_old_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
68: , x_old_rtg_rev_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
69: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
70: , x_return_status IN OUT NOCOPY VARCHAR2
71: );
64: PROCEDURE Check_Existence
65: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
66: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
67: , x_old_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
68: , x_old_rtg_rev_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
69: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
70: , x_return_status IN OUT NOCOPY VARCHAR2
71: );
72:
77: * @param x_return_status IN OUT NOCOPY Return Status
78: * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
79: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
80: * @param p_rtg_revision_rec IN Routing Revision Exposed Record
81: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
82: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
83: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
84: * @param p_old_rtg_revision_rec IN Old Routing Revision Exposed Record
85: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
79: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
80: * @param p_rtg_revision_rec IN Routing Revision Exposed Record
81: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
82: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
83: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
84: * @param p_old_rtg_revision_rec IN Old Routing Revision Exposed Record
85: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
86: * @param p_old_rtg_Rev_Unexp_rec IN Old Routing Revision Unexposed Record
87: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
81: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
82: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
83: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
84: * @param p_old_rtg_revision_rec IN Old Routing Revision Exposed Record
85: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
86: * @param p_old_rtg_Rev_Unexp_rec IN Old Routing Revision Unexposed Record
87: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
88: *
89: * @rep:scope private
83: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
84: * @param p_old_rtg_revision_rec IN Old Routing Revision Exposed Record
85: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
86: * @param p_old_rtg_Rev_Unexp_rec IN Old Routing Revision Unexposed Record
87: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
88: *
89: * @rep:scope private
90: * @rep:lifecycle active
91: * @rep:displayname Check Routing Revision attributes
94: */
95: PROCEDURE Check_Attributes
96: ( x_return_status IN OUT NOCOPY VARCHAR2
97: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
98: , p_rtg_revision_Rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
99: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
100: , p_old_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
101: , p_old_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
102: );
95: PROCEDURE Check_Attributes
96: ( x_return_status IN OUT NOCOPY VARCHAR2
97: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
98: , p_rtg_revision_Rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
99: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
100: , p_old_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
101: , p_old_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
102: );
103:
96: ( x_return_status IN OUT NOCOPY VARCHAR2
97: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
98: , p_rtg_revision_Rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
99: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
100: , p_old_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
101: , p_old_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
102: );
103:
104:
97: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
98: , p_rtg_revision_Rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
99: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
100: , p_old_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
101: , p_old_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
102: );
103:
104:
105: /*#
109: * Cross-attribute checking: The validity of attributes may be checked, based on factors external to it
110: * Business logic: The record must comply with business logic rules.
111: *
112: * @param p_rtg_revision_rec IN Routing Revision Exposed Record
113: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
114: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
115: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
116: * @param p_old_rtg_revision_rec IN Old Routing Revision Exposed Record
117: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
111: *
112: * @param p_rtg_revision_rec IN Routing Revision Exposed Record
113: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
114: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
115: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
116: * @param p_old_rtg_revision_rec IN Old Routing Revision Exposed Record
117: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
118: * @param p_old_rtg_Rev_Unexp_rec IN Old Routing Revision Unexposed Record
119: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
113: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
114: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
115: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
116: * @param p_old_rtg_revision_rec IN Old Routing Revision Exposed Record
117: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
118: * @param p_old_rtg_Rev_Unexp_rec IN Old Routing Revision Unexposed Record
119: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
120: * @param x_mesg_token_tbl IN OUT NOCOPY output Message Token Table with proper error or warning messages
121: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
115: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
116: * @param p_old_rtg_revision_rec IN Old Routing Revision Exposed Record
117: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
118: * @param p_old_rtg_Rev_Unexp_rec IN Old Routing Revision Unexposed Record
119: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
120: * @param x_mesg_token_tbl IN OUT NOCOPY output Message Token Table with proper error or warning messages
121: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
122: * @param x_return_status IN OUT NOCOPY Return Status
123: *
127: * @rep:compatibility S
128: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
129: */
130: PROCEDURE Check_Entity
131: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
132: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
133: , p_old_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
134: , p_old_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
135: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
128: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
129: */
130: PROCEDURE Check_Entity
131: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
132: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
133: , p_old_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
134: , p_old_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
135: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
136: , x_return_status IN OUT NOCOPY VARCHAR2
129: */
130: PROCEDURE Check_Entity
131: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
132: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
133: , p_old_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
134: , p_old_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
135: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
136: , x_return_status IN OUT NOCOPY VARCHAR2
137: );
130: PROCEDURE Check_Entity
131: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
132: , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
133: , p_old_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
134: , p_old_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
135: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
136: , x_return_status IN OUT NOCOPY VARCHAR2
137: );
138: