32: * success if the operation is CREATE and the record EXISTS or will return an error if the operation
33: * is UPDATE and the record DOES NOT EXIST.In case of UPDATE if the record exists then the procedure
34: * will return the old record in the old entity parameters with a success status.
35: * @param p_op_network_rec Operation Network Record as given by the User
36: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type }
37: * @param p_op_network_Unexp_Rec Operation Network Unexposed Record
38: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
39: * @param x_old_op_network_rec Old Operation Network exposed column record
40: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type }
34: * will return the old record in the old entity parameters with a success status.
35: * @param p_op_network_rec Operation Network Record as given by the User
36: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type }
37: * @param p_op_network_Unexp_Rec Operation Network Unexposed Record
38: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
39: * @param x_old_op_network_rec Old Operation Network exposed column record
40: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type }
41: * @param x_old_op_network_unexp_rec Old Operation Network unexposed column record
42: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
36: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type }
37: * @param p_op_network_Unexp_Rec Operation Network Unexposed Record
38: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
39: * @param x_old_op_network_rec Old Operation Network exposed column record
40: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type }
41: * @param x_old_op_network_unexp_rec Old Operation Network unexposed column record
42: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
43: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
44: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
38: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
39: * @param x_old_op_network_rec Old Operation Network exposed column record
40: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type }
41: * @param x_old_op_network_unexp_rec Old Operation Network unexposed column record
42: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
43: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
44: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
45: * @param x_return_status Indicating success or faliure
46: * @rep:scope private
47: * @rep:lifecycle active
48: * @rep:displayname Check Existence
49: */
50: PROCEDURE Check_Existence
51: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
52: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
53: , x_old_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
54: , x_old_Op_Network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
55: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
48: * @rep:displayname Check Existence
49: */
50: PROCEDURE Check_Existence
51: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
52: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
53: , x_old_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
54: , x_old_Op_Network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
55: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
56: , x_return_status IN OUT NOCOPY VARCHAR2
49: */
50: PROCEDURE Check_Existence
51: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
52: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
53: , x_old_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
54: , x_old_Op_Network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
55: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
56: , x_return_status IN OUT NOCOPY VARCHAR2
57: );
50: PROCEDURE Check_Existence
51: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
52: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
53: , x_old_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
54: , x_old_Op_Network_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
55: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
56: , x_return_status IN OUT NOCOPY VARCHAR2
57: );
58: /*#
61: * @param x_return_status Indicating success or faliure
62: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
63: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
64: * @param p_op_Network_rec Bom Operation Network Record as given by the User
65: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
66: * @param p_op_network_unexp_rec Bom Operation Network Record as given by the User
67: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
68: * @param p_old_op_network_rec Bom Old Operation Network Record as given by the User
69: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
63: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
64: * @param p_op_Network_rec Bom Operation Network Record as given by the User
65: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
66: * @param p_op_network_unexp_rec Bom Operation Network Record as given by the User
67: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
68: * @param p_old_op_network_rec Bom Old Operation Network Record as given by the User
69: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
70: * @param p_old_op_network_unexp_rec Bom Old Operation Network Record as given by the User
71: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
65: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
66: * @param p_op_network_unexp_rec Bom Operation Network Record as given by the User
67: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
68: * @param p_old_op_network_rec Bom Old Operation Network Record as given by the User
69: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
70: * @param p_old_op_network_unexp_rec Bom Old Operation Network Record as given by the User
71: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
72: * @rep:scope private
73: * @rep:lifecycle active
67: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
68: * @param p_old_op_network_rec Bom Old Operation Network Record as given by the User
69: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
70: * @param p_old_op_network_unexp_rec Bom Old Operation Network Record as given by the User
71: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
72: * @rep:scope private
73: * @rep:lifecycle active
74: * @rep:displayname Check Attributes
75: */
75: */
76: PROCEDURE Check_Attributes
77: ( x_return_status IN OUT NOCOPY VARCHAR2
78: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
79: , p_Op_Network_Rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
80: , p_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
81: , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
82: , p_old_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
83: );
76: PROCEDURE Check_Attributes
77: ( x_return_status IN OUT NOCOPY VARCHAR2
78: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
79: , p_Op_Network_Rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
80: , p_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
81: , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
82: , p_old_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
83: );
84: /*#
77: ( x_return_status IN OUT NOCOPY VARCHAR2
78: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
79: , p_Op_Network_Rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
80: , p_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
81: , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
82: , p_old_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
83: );
84: /*#
85: * This procedure will check if the user has access to
78: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
79: , p_Op_Network_Rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
80: , p_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
81: , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
82: , p_old_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
83: );
84: /*#
85: * This procedure will check if the user has access to
86: * the operations for Op Network.
87: * @param x_return_status Indicating success or faliure
88: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
89: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
90: * @param p_op_Network_rec Bom Operation Network Record as given by the User
91: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
92: * @param p_op_network_unexp_rec Bom Operation Network Record as given by the User
93: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
94: * @rep:scope private
95: * @rep:lifecycle active
89: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
90: * @param p_op_Network_rec Bom Operation Network Record as given by the User
91: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
92: * @param p_op_network_unexp_rec Bom Operation Network Record as given by the User
93: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
94: * @rep:scope private
95: * @rep:lifecycle active
96: * @rep:displayname Check Access
97: */
95: * @rep:lifecycle active
96: * @rep:displayname Check Access
97: */
98: PROCEDURE Check_Access
99: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
100: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
101: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
102: , x_return_status IN OUT NOCOPY VARCHAR2
103: ) ;
96: * @rep:displayname Check Access
97: */
98: PROCEDURE Check_Access
99: ( p_op_network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
100: , p_op_network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
101: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
102: , x_return_status IN OUT NOCOPY VARCHAR2
103: ) ;
104: /*#
108: * @param x_return_status Indicating success or faliure
109: * @param x_Mesg_Token_Tbl Filled with any errors or warnings
110: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
111: * @param p_op_network_rec Operation Network Record
112: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
113: * @param p_op_network_unexp_rec Operation Network Unexposed Record
114: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
115: * @param p_old_op_network_rec Old Operation Network Record
116: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type }
110: * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
111: * @param p_op_network_rec Operation Network Record
112: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
113: * @param p_op_network_unexp_rec Operation Network Unexposed Record
114: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
115: * @param p_old_op_network_rec Old Operation Network Record
116: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type }
117: * @param p_old_op_network_unexp_rec Operation Resource Unexposed Record
118: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
112: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Resource_Rec_Type }
113: * @param p_op_network_unexp_rec Operation Network Unexposed Record
114: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
115: * @param p_old_op_network_rec Old Operation Network Record
116: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type }
117: * @param p_old_op_network_unexp_rec Operation Resource Unexposed Record
118: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
119: * @rep:scope private
120: * @rep:lifecycle active
114: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
115: * @param p_old_op_network_rec Old Operation Network Record
116: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type }
117: * @param p_old_op_network_unexp_rec Operation Resource Unexposed Record
118: * @rep:paraminfo { @rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type }
119: * @rep:scope private
120: * @rep:lifecycle active
121: * @rep:displayname Check Entity1
122: */
121: * @rep:displayname Check Entity1
122: */
123:
124: PROCEDURE Check_Entity1
125: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
126: , p_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
127: , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
128: , p_old_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
129: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
122: */
123:
124: PROCEDURE Check_Entity1
125: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
126: , p_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
127: , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
128: , p_old_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
129: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
130: , x_return_status IN OUT NOCOPY VARCHAR2
123:
124: PROCEDURE Check_Entity1
125: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
126: , p_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
127: , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
128: , p_old_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
129: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
130: , x_return_status IN OUT NOCOPY VARCHAR2
131: );
124: PROCEDURE Check_Entity1
125: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
126: , p_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
127: , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
128: , p_old_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
129: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
130: , x_return_status IN OUT NOCOPY VARCHAR2
131: );
132:
130: , x_return_status IN OUT NOCOPY VARCHAR2
131: );
132:
133: PROCEDURE Check_Entity2
134: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
135: , p_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
136: , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
137: , p_old_Op_Network_unexp_rec IN
138: Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
131: );
132:
133: PROCEDURE Check_Entity2
134: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
135: , p_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
136: , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
137: , p_old_Op_Network_unexp_rec IN
138: Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
139: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
132:
133: PROCEDURE Check_Entity2
134: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
135: , p_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
136: , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
137: , p_old_Op_Network_unexp_rec IN
138: Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
139: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
140: , x_return_status IN OUT NOCOPY VARCHAR2
134: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
135: , p_Op_Network_unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
136: , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
137: , p_old_Op_Network_unexp_rec IN
138: Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
139: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
140: , x_return_status IN OUT NOCOPY VARCHAR2
141: );
142: