1 PACKAGE BOM_Default_Op_Network AUTHID CURRENT_USER AS
2 /* $Header: BOMDONWS.pls 120.1 2006/02/21 03:30:20 grastogi noship $*/
3 /*#
4 * This API contains methods that will try to copy over values from OLD record for all NULL columns found in
5 * business object Operation Resource record.It will also default in values either by retrieving
6 * them from the database, or by having the program assign values.
7 * @rep:scope private
8 * @rep:product BOM
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:displayname Operation Network Defaulting
12 */
13 /****************************************************************************
14 --
15 -- Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA
16 -- All rights reserved.
17 --
18 -- FILENAME
19 --
20 -- BOMDONWS.pls
21 --
22 -- DESCRIPTION
23 --
24 -- Spec of package Bom_Default_Op_Network
25 --
26 -- NOTES
27 --
28 -- HISTORY
29 -- 07-AUG-2000 Biao Zhang Initial Creation
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
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}
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
51 * @rep:displayname Operation Network-Attribute Defaulting
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
61 , x_return_status IN OUT NOCOPY VARCHAR2
62 );
63 /*#
64 * This method will perform checks against Opearion Resource record in the order
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}
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
80 * @rep:compatibility S
81 * @rep:displayname Opearion Network-Entity Defaulting
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
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.
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}
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
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;