30: --
31: ****************************************************************************/
32: /*#
33: * This method will try to default in values,for all NULL columns found in business object Operation Network
34: * record of type Bom_Rtg_Pub.Op_Network_Rec_Type either by retrieving them from the database, or by having the program
35: * assign values.For CREATEs, there is no OLD record. So the program must default
36: * in individual attribute values,independently of each other. This
37: * feature enables the user to enter minimal information for the
38: * operation to go through
36: * in individual attribute values,independently of each other. This
37: * feature enables the user to enter minimal information for the
38: * operation to go through
39: * @param p_op_network_rec IN Operation Network Exposed Column Record
40: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
41: * @param p_op_network_unexp_rec IN Operation Network Unexposed Column Record
42: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type}
43: * @param x_op_Network_rec IN OUT NOCOPY processed Operation Network Exposed Column Record
44: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
38: * operation to go through
39: * @param p_op_network_rec IN Operation Network Exposed Column Record
40: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
41: * @param p_op_network_unexp_rec IN Operation Network Unexposed Column Record
42: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type}
43: * @param x_op_Network_rec IN OUT NOCOPY processed Operation Network Exposed Column Record
44: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
45: * @param x_op_Network_unexp_rec IN OUT NOCOPY processed Operation Network Unexposed Column Record
46: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type}
40: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
41: * @param p_op_network_unexp_rec IN Operation Network Unexposed Column Record
42: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type}
43: * @param x_op_Network_rec IN OUT NOCOPY processed Operation Network Exposed Column Record
44: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
45: * @param x_op_Network_unexp_rec IN OUT NOCOPY processed Operation Network Unexposed Column Record
46: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type}
47: * @param x_Mesg_Token_Tbl IN OUT NOCOPY Message Token Table
48: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
42: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type}
43: * @param x_op_Network_rec IN OUT NOCOPY processed Operation Network Exposed Column Record
44: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
45: * @param x_op_Network_unexp_rec IN OUT NOCOPY processed Operation Network Unexposed Column Record
46: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type}
47: * @param x_Mesg_Token_Tbl IN OUT NOCOPY Message Token Table
48: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
49: * @param x_return_status IN OUT NOCOPY Return Status
50: * @rep:scope private
52: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
53: * @rep:lifecycle active
54: */
55: PROCEDURE Attribute_Defaulting
56: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
57: , p_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
58: , x_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
59: , x_Op_Network_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
60: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
53: * @rep:lifecycle active
54: */
55: PROCEDURE Attribute_Defaulting
56: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
57: , p_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
58: , x_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
59: , x_Op_Network_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
60: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
61: , x_return_status IN OUT NOCOPY VARCHAR2
54: */
55: PROCEDURE Attribute_Defaulting
56: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
57: , p_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
58: , x_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
59: , x_Op_Network_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
60: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
61: , x_return_status IN OUT NOCOPY VARCHAR2
62: );
55: PROCEDURE Attribute_Defaulting
56: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
57: , p_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
58: , x_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
59: , x_Op_Network_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
60: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
61: , x_return_status IN OUT NOCOPY VARCHAR2
62: );
63: /*#
65: * Non-updateable columns (UPDATEs) Certain columns must not be changed by the user when updating the record.
66: * Cross-attribute checking: The validity of attributes may be checked, based on factors external to it.
67: * Business logic: The record must comply with business logic rules.
68: * @param p_op_Network_rec IN Opearion Network Exposed Column Record
69: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
70: * @param p_op_Network_unexp_rec IN Opearion Network Unexposed Column Record
71: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type}
72: * @param x_op_Network_rec IN OUT NOCOPY processed Opearion Network Exposed Column Record
73: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
67: * Business logic: The record must comply with business logic rules.
68: * @param p_op_Network_rec IN Opearion Network Exposed Column Record
69: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
70: * @param p_op_Network_unexp_rec IN Opearion Network Unexposed Column Record
71: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type}
72: * @param x_op_Network_rec IN OUT NOCOPY processed Opearion Network Exposed Column Record
73: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
74: * @param x_op_Network_unexp_rec IN OUT NOCOPY processed Opearion Network Unexposed Column Record
75: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type}
69: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
70: * @param p_op_Network_unexp_rec IN Opearion Network Unexposed Column Record
71: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type}
72: * @param x_op_Network_rec IN OUT NOCOPY processed Opearion Network Exposed Column Record
73: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
74: * @param x_op_Network_unexp_rec IN OUT NOCOPY processed Opearion Network Unexposed Column Record
75: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type}
76: * @param x_Mesg_Token_Tbl IN OUT NOCOPY Message Token Table
77: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
71: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type}
72: * @param x_op_Network_rec IN OUT NOCOPY processed Opearion Network Exposed Column Record
73: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
74: * @param x_op_Network_unexp_rec IN OUT NOCOPY processed Opearion Network Unexposed Column Record
75: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type}
76: * @param x_Mesg_Token_Tbl IN OUT NOCOPY Message Token Table
77: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
78: * @param x_return_status IN OUT NOCOPY Return Status
79: * @rep:scope private
82: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
83: * @rep:lifecycle active
84: */
85: PROCEDURE Entity_Attribute_Defaulting
86: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
87: , p_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
88: , x_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
89: , x_Op_Network_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
90: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
83: * @rep:lifecycle active
84: */
85: PROCEDURE Entity_Attribute_Defaulting
86: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
87: , p_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
88: , x_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
89: , x_Op_Network_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
90: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
91: , x_return_status IN OUT NOCOPY VARCHAR2
84: */
85: PROCEDURE Entity_Attribute_Defaulting
86: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
87: , p_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
88: , x_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
89: , x_Op_Network_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
90: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
91: , x_return_status IN OUT NOCOPY VARCHAR2
92: );
85: PROCEDURE Entity_Attribute_Defaulting
86: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
87: , p_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
88: , x_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
89: , x_Op_Network_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
90: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
91: , x_return_status IN OUT NOCOPY VARCHAR2
92: );
93: /*#
91: , x_return_status IN OUT NOCOPY VARCHAR2
92: );
93: /*#
94: * This will copy over values from OLD record for all NULL columns found in
95: * business object Operation Resource record of type Bom_Rtg_Pub.Op_Network_Rec_Type.
96: * The user may send in a record with
97: * certain values set to NULL. Values for all such columns are copied over
98: * from the OLD record. This feature enables the user to enter minimal
99: * information for the operation.
97: * certain values set to NULL. Values for all such columns are copied over
98: * from the OLD record. This feature enables the user to enter minimal
99: * information for the operation.
100: * @param p_op_Network_rec IN Operation Network Exposed Column Record
101: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
102: * @param p_old_op_Network_rec IN Operation Network Old Record Exposed Column Record
103: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
104: * @param p_op_Network_unexp_rec IN Operation Network Unexposed Column Record
105: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Typee}
99: * information for the operation.
100: * @param p_op_Network_rec IN Operation Network Exposed Column Record
101: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
102: * @param p_old_op_Network_rec IN Operation Network Old Record Exposed Column Record
103: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
104: * @param p_op_Network_unexp_rec IN Operation Network Unexposed Column Record
105: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Typee}
106: * @param p_old_op_Network_unexp_rec IN Operation Network Old Record Unexposed Column Record
107: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Typee}
101: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
102: * @param p_old_op_Network_rec IN Operation Network Old Record Exposed Column Record
103: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
104: * @param p_op_Network_unexp_rec IN Operation Network Unexposed Column Record
105: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Typee}
106: * @param p_old_op_Network_unexp_rec IN Operation Network Old Record Unexposed Column Record
107: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Typee}
108: * @param x_op_Network_rec IN OUT NOCOPY processed Operation Network Exposed Column Record
109: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
103: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
104: * @param p_op_Network_unexp_rec IN Operation Network Unexposed Column Record
105: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Typee}
106: * @param p_old_op_Network_unexp_rec IN Operation Network Old Record Unexposed Column Record
107: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Typee}
108: * @param x_op_Network_rec IN OUT NOCOPY processed Operation Network Exposed Column Record
109: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
110: * @param x_op_Network_unexp_rec IN OUT NOCOPY processed Operation Network Column Record
111: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type}
105: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Typee}
106: * @param p_old_op_Network_unexp_rec IN Operation Network Old Record Unexposed Column Record
107: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Typee}
108: * @param x_op_Network_rec IN OUT NOCOPY processed Operation Network Exposed Column Record
109: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
110: * @param x_op_Network_unexp_rec IN OUT NOCOPY processed Operation Network Column Record
111: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type}
112: * @rep:scope private
113: * @rep:compatibility S
107: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Typee}
108: * @param x_op_Network_rec IN OUT NOCOPY processed Operation Network Exposed Column Record
109: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Rec_Type}
110: * @param x_op_Network_unexp_rec IN OUT NOCOPY processed Operation Network Column Record
111: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type}
112: * @rep:scope private
113: * @rep:compatibility S
114: * @rep:displayname Opeartion Network-Populate NULL Columns
115: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
116: * @rep:lifecycle active
117: */
118:
119: PROCEDURE Populate_Null_Columns
120: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
121: , p_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
122: , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
123: , p_old_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
124: , x_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
117: */
118:
119: PROCEDURE Populate_Null_Columns
120: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
121: , p_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
122: , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
123: , p_old_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
124: , x_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
125: , x_Op_Network_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
118:
119: PROCEDURE Populate_Null_Columns
120: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
121: , p_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
122: , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
123: , p_old_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
124: , x_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
125: , x_Op_Network_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
126: );
119: PROCEDURE Populate_Null_Columns
120: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
121: , p_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
122: , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
123: , p_old_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
124: , x_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
125: , x_Op_Network_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
126: );
127:
120: ( p_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
121: , p_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
122: , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
123: , p_old_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
124: , x_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
125: , x_Op_Network_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
126: );
127:
128: END BOM_Default_Op_Network;
121: , p_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
122: , p_old_Op_Network_rec IN Bom_Rtg_Pub.Op_Network_Rec_Type
123: , p_old_Op_Network_Unexp_rec IN Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
124: , x_Op_Network_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Rec_Type
125: , x_Op_Network_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Network_Unexposed_Rec_Type
126: );
127:
128: END BOM_Default_Op_Network;