1 PACKAGE BOM_Default_Rtg_Revision AUTHID CURRENT_USER AS
2 /* $Header: BOMDRRVS.pls 120.1 2006/01/03 22:21:24 bbpatel noship $ */
3 /*#
4 * This API contains procedures that will copy values from Routing Revision 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 Revision record attributes
12 * @rep:compatibility S
13 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
14 */
15 /****************************************************************************
16 --
17 -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
18 -- All rights reserved.
19 --
20 -- FILENAME
21 --
22 -- BOMDRRVS.pls
23 --
24 -- DESCRIPTION
25 --
26 -- Spec of package BOM_Default_Rtg_Revision
27 --
28 -- NOTE
29 --
30 -- HISTORY
31 -- 07-AUG-2000 Biao Zhang Initial Creation
32 --
33 ****************************************************************************/
34
35 /*#
36 * Procedure to default values for exposed Routing Revision 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_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}
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 *
55 * @rep:scope private
56 * @rep:lifecycle active
57 * @rep:displayname Default Routing Revision record attributes
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
67 , x_return_status IN OUT NOCOPY VARCHAR2
68 );
69
70 /*#
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 }
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 *
86 * @rep:scope private
87 * @rep:lifecycle active
88 * @rep:displayname Default Routing Revision entity attributes
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
98 , x_return_status IN OUT NOCOPY VARCHAR2
99 );
100
101 /*#
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 }
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
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
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;
135