1 PACKAGE BOM_Validate_Rtg_Revision AUTHID CURRENT_USER AS
2 /* $Header: BOMLRRVS.pls 120.1 2006/01/03 22:23:31 bbpatel noship $ */
3 /*#
4 * This API performs Attribute and Entity level validations for Routing Revision.
5 * Entity level validations include existence and accessibility check for Routing
6 * Revision record. Attribute level validations include check for required attributes and
7 * business logic validations.
8 *
9 * @rep:scope private
10 * @rep:product BOM
11 * @rep:lifecycle active
12 * @rep:displayname Validate Routing Revision
13 * @rep:compatibility S
14 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
15 */
16
17 /****************************************************************************
18 --
19 -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
20 -- All rights reserved.
21 --
22 -- FILENAME
23 --
24 -- BOMLRRVS.pls
25 --
26 -- DESCRIPTION
27 --
28 -- Spec of package BOM_Validate_Rtg_Revision
29 --
30 -- NOTES
31 --
32 -- HISTORY
33 -- 07-AUG-2000 Biao Zhang Initial Creation
34 --
35 ****************************************************************************/
36
37
38 /*#
39 * Procedure will query the routing revision record and return it in old record variable.
40 * If the Transaction Type is Create and the record already exists the return status
41 * would be error. If the Transaction Type is Update or Delete and the record does not
42 * exist then the return status would be an error as well. Such an error in a record will
43 * cause all children to error out, since they are referencing an invalid parent.
44 * Mesg_Token_Table will carry the error messsage and the tokens associated with the message.
45 *
46 * @param p_rtg_revision_rec IN Routing Revision Exposed Record
47 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
48 * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
49 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
50 * @param x_old_rtg_revision_rec IN OUT NOCOPY Old Routing Revision Exposed Record if already exists
51 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
52 * @param x_old_rtg_Rev_Unexp_rec IN OUT NOCOPY Old Routing Revision Unexposed Record if already exists
53 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
54 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
55 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
56 * @param x_return_status IN OUT NOCOPY Return Status
57 *
58 * @rep:scope private
59 * @rep:lifecycle active
60 * @rep:displayname Check Existence for Routing Revision record
61 * @rep:compatibility S
62 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
63 */
64 PROCEDURE Check_Existence
65 ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
66 , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
67 , x_old_rtg_revision_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Revision_Rec_Type
68 , x_old_rtg_rev_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
69 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
70 , x_return_status IN OUT NOCOPY VARCHAR2
71 );
72
73 /*#
74 * This procedure checks the attributes validity. Validations include checking
75 * for start effective date in case of update.
76 *
77 * @param x_return_status IN OUT NOCOPY Return Status
78 * @param x_mesg_token_tbl IN OUT NOCOPY Message Token Table
79 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
80 * @param p_rtg_revision_rec IN Routing Revision Exposed Record
81 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
82 * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
83 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
84 * @param p_old_rtg_revision_rec IN Old Routing Revision Exposed Record
85 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
86 * @param p_old_rtg_Rev_Unexp_rec IN Old Routing Revision Unexposed Record
87 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
88 *
89 * @rep:scope private
90 * @rep:lifecycle active
91 * @rep:displayname Check Routing Revision attributes
92 * @rep:compatibility S
93 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
94 */
95 PROCEDURE Check_Attributes
96 ( x_return_status IN OUT NOCOPY VARCHAR2
97 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
98 , p_rtg_revision_Rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
99 , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
100 , p_old_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
101 , p_old_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
102 );
103
104
105 /*#
106 * Procedure to validate the Routing Revision entity record.
107 * The following are checked.
108 * Non-updateable columns (UPDATEs): Certain columns must not be changed by the user when updating the record
109 * Cross-attribute checking: The validity of attributes may be checked, based on factors external to it
110 * Business logic: The record must comply with business logic rules.
111 *
112 * @param p_rtg_revision_rec IN Routing Revision Exposed Record
113 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
114 * @param p_rtg_Rev_Unexp_rec IN Routing Revision Unexposed Record
115 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
116 * @param p_old_rtg_revision_rec IN Old Routing Revision Exposed Record
117 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
118 * @param p_old_rtg_Rev_Unexp_rec IN Old Routing Revision Unexposed Record
119 * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
120 * @param x_mesg_token_tbl IN OUT NOCOPY output Message Token Table with proper error or warning messages
121 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
122 * @param x_return_status IN OUT NOCOPY Return Status
123 *
124 * @rep:scope private
125 * @rep:lifecycle active
126 * @rep:displayname Check Routing Revision entity
127 * @rep:compatibility S
128 * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
129 */
130 PROCEDURE Check_Entity
131 ( p_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
132 , p_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
133 , p_old_rtg_revision_rec IN Bom_Rtg_Pub.Rtg_Revision_Rec_Type
134 , p_old_rtg_rev_unexp_rec IN Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type
135 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
136 , x_return_status IN OUT NOCOPY VARCHAR2
137 );
138
139
140 END BOM_Validate_Rtg_Revision;