DBA Data[Home] [Help]

PACKAGE: APPS.BOM_DEFAULT_OP_NETWORK

Source


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;