1 PACKAGE Bom_Default_Bom_Header AS
2 /* $Header: BOMDBOMS.pls 120.0 2005/05/25 04:56:37 appldev 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 Header record and to default in values,either by retrieving them from the database, or by having the program
6 * assign values.
7 * @rep:scope private
8 * @rep:product BOM
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:displayname Header NULL Columns Defaulting
12 */
13 /****************************************************************************
14 --
15 -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
16 -- All rights reserved.
17 --
18 -- FILENAME
19 --
20 -- BOMDBOMS.pls
21 --
22 -- DESCRIPTION
23 --
24 -- Spec of package Bom_Default_Bom_Header
25 --
26 -- NOTES
27 --
28 -- HISTORY
29 -- 07-JUL-1999 Rahul Chitko Initial Creation
30 --
31 ****************************************************************************/
32 /*#
33 * This method will try to default in values,for all NULL columns found in business object Header
34 * record 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_bom_header_rec IN BOM Header Exposed Column Record
40 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type }
41 * @param p_bom_head_unexp_rec IN BOM Header Unexposed Column Record
42 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
43 * @param x_bom_header_rec IN OUT NOCOPY processed Header Exposed Column Record
44 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type }
45 * @param x_bom_head_unexp_rec IN OUT NOCOPY processed BOM Header Unexposed Column Record
46 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_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 of the Business Object
50 * @rep:scope private
51 * @rep:displayname Header-Attribute Defaulting
52 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
53 * @rep:compatibility S
54 * @rep:lifecycle active
55 */
56 PROCEDURE Attribute_Defaulting
57 ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
58 , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
59 , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
60 , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
61 , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
62 , x_return_status IN OUT NOCOPY VARCHAR2
63 );
64 /*#
65 * This method will copy over values from OLD record for all NULL columns found in
66 * business object Header record.The user may send in a record with
67 * certain values set to NULL. Values for all such columns are copied over
68 * from the OLD record. This feature enables the user to enter minimal
69 * information for the operation.
70 * @param p_bom_header_rec IN BOM Header Exposed Column Record
71 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type }
72 * @param p_bom_head_unexp_rec IN BOM Header Unexposed Column Record
73 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
74 * @param p_old_bom_header_rec BOM Old Header Exposed Column Record
75 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type}
76 * @param p_old_bom_head_unexp_rec BOM Old Header Unexposed Column Record
77 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type}
78 * @param x_bom_header_rec IN OUT NOCOPY processed Header Exposed Column Record
79 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type }
80 * @param x_bom_head_unexp_rec IN OUT NOCOPY processed BOM Header Unexposed Column Record
81 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
82 * @rep:scope private
83 * @rep:displayname Header-Populate Null Column
84 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
85 * @rep:compatibility S
86 * @rep:lifecycle active
87 */
88 PROCEDURE Populate_Null_Columns
89 ( p_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
90 , p_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
91 , p_old_bom_header_rec IN Bom_Bo_Pub.Bom_Head_Rec_Type
92 , p_old_bom_head_unexp_rec IN Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
93 , x_bom_header_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Rec_Type
94 , x_bom_head_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type
95 );
96
97 END Bom_Default_Bom_Header;