1 PACKAGE BOM_Default_Ref_Designator AUTHID CURRENT_USER AS
2 /* $Header: BOMDRFDS.pls 120.0 2005/05/25 07:04:44 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 Reference Designator record and to default in values either by retrieving them from the database,
6 * 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 Reference Designator Defaulting
12 */
13
14 -- Procedure Attributes
15 /*#
16 * This method will try to default in values,for all NULL columns found in business object Reference
17 * Designator record either by retrieving them from the database, or by having the program
18 * assign values.For CREATEs, there is no OLD record. So the program must default
19 * in individual attribute values,independently of each other. This
20 * feature enables the user to enter minimal information for the
21 * operation to go through.
22 * @param p_ref_designator_rec IN Reference Designator Exposed Column Record
23 * @paraminfo {@rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type}
24 * @param p_ref_desg_unexp_rec IN Reference Designator Unexposed Column Record
25 * @paraminfo {@rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type}
26 * @param x_ref_designator_rec IN OUT NOCOPY processed Reference Designator Exposed Column Record
27 * @paraminfo {@rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type}
28 * @param x_Ref_Desg_Unexp_Rec IN OUT NOCOPY processed Reference Designator Unexposed Column Record
29 * @paraminfo {@rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type}
30 * @param x_Mesg_Token_Tbl IN OUT NOCOPY Message Token Table
31 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
32 * @param x_Return_Status IN OUT NOCOPY Return Status of the business object.
33 * @rep:scope public
34 * @rep:lifecycle active
35 * @rep:compatibility S
36 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
37 * @rep:displayname Refernce Designator-Attribute Defaulting
38 */
39 PROCEDURE Attribute_Defaulting
40 ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type :=
41 Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
42 , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
43 , x_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
44 , x_Ref_Desg_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
45 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
46 , x_Return_Status IN OUT NOCOPY VARCHAR2
47 );
48
49
50 /*#
51 * This method will copy over values from OLD record for all NULL columns found in
52 * business object Reference Designator record of type Bom_Bo_Pub.Ref_Designator_Rec_Type
53 * The user may send in a record with
54 * certain values set to NULL. Values for all such columns are copied over
55 * from the OLD record. This feature enables the user to enter minimal
56 * information for the operation.
57 * @param p_ref_designator_rec IN Reference Designator Exposed Column Record
58 * @paraminfo {@rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type}
59 * @param p_ref_desg_unexp_rec IN Reference Designator Unexposed Column Record
60 * @paraminfo {@rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type}
61 * @param p_old_Ref_Designator_Rec IN Reference Designator Old Record Exposed Column
62 * @paraminfo {@rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type}
63 * @param p_old_ref_desg_unexp_rec IN Reference Designator Old Record Unexposed Column Record.
64 * @paraminfo {@rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type}
65 * @param x_Ref_Designator_Rec IN OUT NOCOPY processed Reference Designator Exposed Column Record
66 * @paraminfo {@rep:innertype Bom_Bo_Pub.Ref_Designator_Rec_Type}
67 * @param x_ref_desg_unexp_rec IN OUT NOCOPY processed Reference Designator Unexposed Column Record
68 * @paraminfo {@rep:innertype Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type}
69 * @rep:scope public
70 * @rep:lifecycle active
71 * @rep:compatibility S
72 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
73 * @rep:displayname Refernce Designator-Populate NULL Columns
74 */
75 PROCEDURE Populate_Null_Columns
76 ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
77 , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
78 , p_old_Ref_Designator_Rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
79 , p_old_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
80 , x_Ref_Designator_Rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
81 , x_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
82 );
83
84
85 /*
86 ** BOM Business Object Definitions
87 */
88 /*#
89 * This method will try to default in values,for all NULL columns found in business object Reference
90 * record either by retrieving them from the database, or by having the program
91 * assign values.For CREATEs, there is no OLD record. So the program must default
92 * in individual attribute values,independently of each other. This
93 * feature enables the user to enter minimal information for the
94 * operation to go through.
95 * @param p_bom_ref_designator_rec IN BOM Reference Designator Exposed Column Record
96 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type}
97 * @param p_bom_ref_desg_unexp_rec IN BOM Reference Designator Unexposed Column Record
98 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type}
99 * @param x_bom_ref_designator_rec IN OUT NOCOPY processed BOM Reference Designator Exposed Column Record
100 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type}
101 * @param x_bom_Ref_Desg_Unexp_Rec IN OUT NOCOPY processed BOM Reference Designator Unexposed Column Record
102 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type}
103 * @param x_Mesg_Token_Tbl IN OUT NOCOPY Message Token Table
104 * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
105 * @param x_Return_Status IN OUT NOCOPY Return Status
106 * @rep:scope private
107 * @rep:displayname Ref Desg-Attribute Defaulting
108 * @rep:compatibility S
109 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
110 * @rep:lifecycle active
111 */
112 PROCEDURE Attribute_Defaulting
113 ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type :=
114 Bom_Bo_Pub.G_MISS_Bom_REF_DESIGNATOR_REC
115 , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
116 , x_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
117 , x_bom_Ref_Desg_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
118 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
119 , x_Return_Status IN OUT NOCOPY VARCHAR2
120 );
121
122
123 /*#
124 * This method will copy over values from OLD record for all NULL columns found in
125 * business object Reference Designator record of type Bom_Bo_Pub.Ref_Designator_Rec_Type
126 * The user may send in a record with
127 * certain values set to NULL. Values for all such columns are copied over
128 * from the OLD record. This feature enables the user to enter minimal
129 * information for the operation.
130 * @param p_bom_ref_designator_rec IN BOM Refence Designator Exposed Column Record
131 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type}
132 * @param p_bom_ref_desg_unexp_rec IN BOM Reference Designator Unexposed Cloumn Record
133 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type}
134 * @param p_old_bom_Ref_Designator_Rec IN BOM Refence Designator Old Record Exposed Column Record
135 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type}
136 * @param p_old_bom_ref_desg_unexp_rec IN BOM Reference Designator Old Record Unexposed Cloumn Record
137 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type}
138 * @param x_bom_Ref_Designator_Rec IN OUT NOCOPY processed BOM Refence Designator Exposed Column Record
139 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type}
140 * @param x_bom_ref_desg_unexp_rec IN OUT NOCOPY processed BOM Reference Designator Unexposed Cloumn Record
141 * @paraminfo {@rep:innertype Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type}
142 * @rep:scope private
143 * @rep:displayname Ref Desg-Populate NULL Column
144 * @rep:compatibility S
145 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
146 * @rep:lifecycle active
147 */
148 PROCEDURE Populate_Null_Columns
149 ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
150 , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
151 , p_old_bom_Ref_Designator_Rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
152 , p_old_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
153 , x_bom_Ref_Designator_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
154 , x_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
155 );
156
157 END BOM_Default_Ref_Designator;