40: * feature enables the user to enter minimal information for the
41: * operation to go through.
42: *
43: * @param p_rtg_revision_rec IN Routing Revision Exposed Record
44: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
45: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
46: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
47: * @param x_rtg_revision_rec IN OUT NOCOPY Routing Revision Exposed Record after defaulting
48: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
42: *
43: * @param p_rtg_revision_rec IN Routing Revision Exposed Record
44: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
45: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
46: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
47: * @param x_rtg_revision_rec IN OUT NOCOPY Routing Revision Exposed Record after defaulting
48: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
49: * @param x_rtg_Rev_Unexp_rec IN OUT NOCOPY Routing Revision Unexposed Record after defaulting
50: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
44: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
45: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
46: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
47: * @param x_rtg_revision_rec IN OUT NOCOPY Routing Revision Exposed Record after defaulting
48: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
49: * @param x_rtg_Rev_Unexp_rec IN OUT NOCOPY Routing Revision Unexposed Record after defaulting
50: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
51: * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
52: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
46: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
47: * @param x_rtg_revision_rec IN OUT NOCOPY Routing Revision Exposed Record after defaulting
48: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
49: * @param x_rtg_Rev_Unexp_rec IN OUT NOCOPY Routing Revision Unexposed Record after defaulting
50: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
51: * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
52: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
53: * @param x_return_status IN OUT NOCOPY Return Status
54: *
58: * @rep:compatibility S
59: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
60: */
61: PROCEDURE Attribute_Defaulting
62: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
63: , p_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
64: , x_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
65: , x_rtg_Rev_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
66: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
59: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
60: */
61: PROCEDURE Attribute_Defaulting
62: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
63: , p_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
64: , x_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
65: , x_rtg_Rev_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
66: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
67: , x_return_status IN OUT NOCOPY VARCHAR2
60: */
61: PROCEDURE Attribute_Defaulting
62: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
63: , p_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
64: , x_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
65: , x_rtg_Rev_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
66: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
67: , x_return_status IN OUT NOCOPY VARCHAR2
68: );
61: PROCEDURE Attribute_Defaulting
62: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
63: , p_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
64: , x_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
65: , x_rtg_Rev_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
66: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
67: , x_return_status IN OUT NOCOPY VARCHAR2
68: );
69:
71: * Procedure to default values for start effectivity date and
72: * implementation date.
73: *
74: * @param p_rtg_revision_rec IN Routing Revision Exposed Record
75: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
76: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
77: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
78: * @param x_rtg_revision_rec IN OUT NOCOPY Routing Revision Exposed Record after defaulting
79: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
73: *
74: * @param p_rtg_revision_rec IN Routing Revision Exposed Record
75: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
76: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
77: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
78: * @param x_rtg_revision_rec IN OUT NOCOPY Routing Revision Exposed Record after defaulting
79: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
80: * @param x_rtg_Rev_Unexp_rec IN OUT NOCOPY Routing Revision Unexposed Record after defaulting
81: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
75: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
76: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
77: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
78: * @param x_rtg_revision_rec IN OUT NOCOPY Routing Revision Exposed Record after defaulting
79: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
80: * @param x_rtg_Rev_Unexp_rec IN OUT NOCOPY Routing Revision Unexposed Record after defaulting
81: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
82: * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
83: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
77: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
78: * @param x_rtg_revision_rec IN OUT NOCOPY Routing Revision Exposed Record after defaulting
79: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
80: * @param x_rtg_Rev_Unexp_rec IN OUT NOCOPY Routing Revision Unexposed Record after defaulting
81: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
82: * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
83: * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
84: * @param x_return_status IN OUT NOCOPY Return Status
85: *
89: * @rep:compatibility S
90: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
91: */
92: PROCEDURE Entity_Attribute_Defaulting
93: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
94: , p_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
95: , x_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
96: , x_rtg_Rev_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
97: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
90: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
91: */
92: PROCEDURE Entity_Attribute_Defaulting
93: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
94: , p_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
95: , x_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
96: , x_rtg_Rev_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
97: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
98: , x_return_status IN OUT NOCOPY VARCHAR2
91: */
92: PROCEDURE Entity_Attribute_Defaulting
93: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
94: , p_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
95: , x_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
96: , x_rtg_Rev_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
97: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
98: , x_return_status IN OUT NOCOPY VARCHAR2
99: );
92: PROCEDURE Entity_Attribute_Defaulting
93: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
94: , p_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
95: , x_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
96: , x_rtg_Rev_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
97: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
98: , x_return_status IN OUT NOCOPY VARCHAR2
99: );
100:
102: * Procedure to copy the existing values from old Routing Revision record, when the user has not
103: * given the attribute values. This procedure will not be called in CREATE case.
104: *
105: * @param p_rtg_revision_rec IN Routing Revision Exposed Record
106: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
107: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
108: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
109: * @param p_old_rtg_revision_rec IN Old Routing Revision Exposed Record
110: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
104: *
105: * @param p_rtg_revision_rec IN Routing Revision Exposed Record
106: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
107: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
108: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
109: * @param p_old_rtg_revision_rec IN Old Routing Revision Exposed Record
110: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
111: * @param p_old_rtg_Rev_Unexp_rec IN Old Routing Revision Unexposed Record
112: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
106: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
107: * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
108: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
109: * @param p_old_rtg_revision_rec IN Old Routing Revision Exposed Record
110: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
111: * @param p_old_rtg_Rev_Unexp_rec IN Old Routing Revision Unexposed Record
112: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
113: * @param x_rtg_revision_rec IN OUT NOCOPY Routing Revision Exposed Record after processing
114: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
108: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
109: * @param p_old_rtg_revision_rec IN Old Routing Revision Exposed Record
110: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
111: * @param p_old_rtg_Rev_Unexp_rec IN Old Routing Revision Unexposed Record
112: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
113: * @param x_rtg_revision_rec IN OUT NOCOPY Routing Revision Exposed Record after processing
114: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
115: * @param x_rtg_Rev_Unexp_rec IN OUT NOCOPY Routing Revision Unexposed Record after processing
116: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
110: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
111: * @param p_old_rtg_Rev_Unexp_rec IN Old Routing Revision Unexposed Record
112: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
113: * @param x_rtg_revision_rec IN OUT NOCOPY Routing Revision Exposed Record after processing
114: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
115: * @param x_rtg_Rev_Unexp_rec IN OUT NOCOPY Routing Revision Unexposed Record after processing
116: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
117: *
118: * @rep:scope private
112: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
113: * @param x_rtg_revision_rec IN OUT NOCOPY Routing Revision Exposed Record after processing
114: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
115: * @param x_rtg_Rev_Unexp_rec IN OUT NOCOPY Routing Revision Unexposed Record after processing
116: * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
117: *
118: * @rep:scope private
119: * @rep:lifecycle active
120: * @rep:displayname Populate Null Routing Revision attributes
121: * @rep:compatibility S
122: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
123: */
124: PROCEDURE Populate_Null_Columns
125: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
126: , p_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
127: , p_old_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
128: , p_old_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
129: , x_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
122: * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
123: */
124: PROCEDURE Populate_Null_Columns
125: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
126: , p_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
127: , p_old_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
128: , p_old_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
129: , x_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
130: , x_rtg_Rev_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
123: */
124: PROCEDURE Populate_Null_Columns
125: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
126: , p_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
127: , p_old_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
128: , p_old_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
129: , x_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
130: , x_rtg_Rev_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
131: );
124: PROCEDURE Populate_Null_Columns
125: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
126: , p_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
127: , p_old_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
128: , p_old_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
129: , x_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
130: , x_rtg_Rev_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
131: );
132:
125: ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
126: , p_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
127: , p_old_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
128: , p_old_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
129: , x_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
130: , x_rtg_Rev_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
131: );
132:
133:
126: , p_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
127: , p_old_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
128: , p_old_rtg_Rev_Unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
129: , x_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
130: , x_rtg_Rev_Unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
131: );
132:
133:
134: END BOM_Default_Rtg_Revision;