1 PACKAGE BOM_Default_Rtg_Header AS
2 /* $Header: BOMDRTGS.pls 120.1 2006/01/03 21:54:25 bbpatel noship $*/
3 /*#
4 * This API contains procedures that will copy values from Routing Header record provided by the user.
5 * In old record, atrributes having null values or not provided by the user, will be defaulted
6 * to appropriate value. In the case of create, attributes will be defaulted to appropriate value.
7 *
8 * @rep:scope private
9 * @rep:product BOM
10 * @rep:lifecycle active
11 * @rep:displayname Default Routing Header record attributes
12 * @rep:compatibility S
13 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
14 */
15 /****************************************************************************
16 --
17 -- Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA
18 -- All rights reserved.
19 --
20 -- FILENAME
21 --
22 -- BOMDRTGS.pls
23 --
24 -- DESCRIPTION
25 --
26 -- Spec of package BOM_Default_Rtg_Header
27 --
28 -- NOTES
29 --
30 -- HISTORY
31 -- 07-AUG-2000 Biao Zhang Initial Creation
32 --
33 ****************************************************************************/
34
35 /*#
36 * Procedure to default values for exposed Routing Header record.
37 * In old record, atrributes, having null values or not provided by the user, will be defaulted
38 * to appropriate value. For CREATEs, there is no OLD record. So procedure will default
39 * individual attribute values, independent of each other. This
40 * feature enables the user to enter minimal information for the
41 * operation to go through.
42 *
43 * @param p_rtg_header_rec IN Routing Header Exposed Record
44 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Rec_Type }
45 * @param p_rtg_header_unexp_rec IN Routing Header Unexposed Record
46 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type}
47 * @param x_rtg_header_rec IN OUT NOCOPY Routing Header Exposed Record after defaulting
48 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Rec_Type }
49 * @param x_rtg_header_unexp_rec IN OUT NOCOPY Routing Header Unexposed Record after defaulting
50 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_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 of the Business Object
54 *
55 * @rep:scope private
56 * @rep:lifecycle active
57 * @rep:displayname Default Routing Header record attributes
58 * @rep:compatibility S
59 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
60 */
61 PROCEDURE Attribute_Defaulting
62 ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
63 , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
64 , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
65 , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_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
70 /*#
71 * Procedure to default values for unexposed Routing Header record.
72 * In old record, atrributes, having null values or not provided by the user, will be defaulted
73 * to appropriate value. For CREATEs, there is no OLD record. So procedure will default
74 * individual attribute values, independent of each other.
75 *
76 * @param p_rtg_header_rec IN Routing Header Exposed Record
77 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Rec_Type }
78 * @param p_rtg_header_unexp_rec IN Routing Header Unexposed Record
79 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type}
80 * @param x_rtg_header_rec IN OUT NOCOPY Routing Header Exposed Record after defaulting
81 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Rec_Type }
82 * @param x_rtg_header_unexp_rec IN OUT NOCOPY Routing Header Unexposed Record after defaulting
83 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type}
84 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
85 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
86 * @param x_return_status IN OUT NOCOPY Return Status of the Business Object
87 *
88 * @rep:scope private
89 * @rep:lifecycle active
90 * @rep:displayname Default Routing Header entity attributes
91 * @rep:compatibility S
92 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
93 */
94 PROCEDURE Entity_Attribute_Defaulting
95 ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
96 , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
97 , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
98 , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
99 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
100 , x_return_status IN OUT NOCOPY VARCHAR2
101 );
102
103 /*#
104 * Procedure to copy the existing values from old Routing Header record, when the user has not
105 * given the attribute values. This procedure will not be called in CREATE case.
106 *
107 * @param p_rtg_header_rec IN Routing Header Exposed Record
108 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Rec_Type }
109 * @param p_rtg_header_unexp_rec IN Routing Header Unexposed Record
110 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type}
111 * @param p_old_rtg_header_rec IN Old Routing Header Exposed Record
112 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Rec_Type }
113 * @param p_old_rtg_header_unexp_rec IN Old Routing Header Unexposed Record
114 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type}
115 * @param x_rtg_header_rec IN OUT NOCOPY Routing Header Exposed Record after processing
116 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Rec_Type }
117 * @param x_rtg_header_unexp_rec IN OUT NOCOPY Routing Header Unexposed Record after processing
118 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type}
119 *
120 * @rep:scope private
121 * @rep:lifecycle active
122 * @rep:displayname Populate Null Routing Header attributes
123 * @rep:compatibility S
124 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
125 */
126 PROCEDURE Populate_Null_Columns
127 ( p_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
128 , p_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
129 , p_old_rtg_header_rec IN Bom_Rtg_Pub.Rtg_Header_Rec_Type
130 , p_old_rtg_header_unexp_rec IN Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
131 , x_rtg_header_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Rec_Type
132 , x_rtg_header_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
133 );
134
135
136 /*#
137 * Function to get new Routing Sequence Id
138 *
139 * @return Routing Sequence Id
140 * @rep:scope private
141 * @rep:lifecycle active
142 * @rep:displayname Get Routing Sequence Id
143 * @rep:compatibility S
144 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
145 */
146 -- Get Routing Sequence Id
147 FUNCTION Get_routing_Sequence
148 RETURN NUMBER ;
149
150 /*#
151 * Function to get the default CFM Routing Flag. Returns 2(Standard Routing).
152 *
153 * @return CFM Routing Flag
154 * @rep:scope private
155 * @rep:lifecycle active
156 * @rep:displayname Get CFM Routing Flag
157 * @rep:compatibility S
158 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
159 */
160 -- Get_Cfm_Routing_Flag
161 FUNCTION Get_Cfm_Routing_Flag
162 RETURN NUMBER ;
163
164 /*#
165 * Function to get the default Mixed Model Map flag. Returns 2(No).
166 *
167 * @return Mixed Model Map flag
168 * @rep:scope private
169 * @rep:lifecycle active
170 * @rep:displayname Get Mixed Model Map flag
171 * @rep:compatibility S
172 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
173 */
174 -- Get_Mixed_Model_Map_Flag
175 FUNCTION Get_Mixed_Model_Map_Flag
176 RETURN NUMBER ;
177
178 /*#
179 * Function to get the default CTP flag. Returns 2(No).
180 *
181 * @return CTP flag
182 * @rep:scope private
183 * @rep:lifecycle active
184 * @rep:displayname Get CTP flag
185 * @rep:compatibility S
186 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
187 */
188 -- Get_Ctp_Flag
189 FUNCTION Get_Ctp_Flag
190 RETURN NUMBER ;
191
192
193
194 END BOM_Default_Rtg_Header;