PACKAGE: APPS.BOM_RTG_REVISION_UTIL

Source

1 PACKAGE BOM_Rtg_Revision_UTIL AS
2 /* $Header: BOMURRVS.pls 120.1 2006/01/03 22:24:39 bbpatel noship $ */
3 /*#
4  * This API contains Routing Revision entity utility procedure. Utility procedures
5  * include query and perform writes (insert/update/delete) for a row.
6  *
7  * @rep:scope private
8  * @rep:product BOM
9  * @rep:lifecycle active
10  * @rep:displayname Routing Revision Utitlity package
11  * @rep:compatibility S
12  * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
13  */
14 
15 /****************************************************************************
16 --
17 --  Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
18 --  All rights reserved.
19 --
20 --  FILENAME
21 --
22 --      BOMURRVS.pls
23 --
24 --  DESCRIPTION
25 --
26 --      Spec of package BOM_Rtg_Revision_UTIL
27 --
28 --  NOTES
29 --
30 --  HISTORY
31 --  07-AUG-2000 Rahul Chitko    Initial Creation
32 --
33 ****************************************************************************/
34 /*#
35  * Procedure to query a database record and return the populated Exposed and Unexposed
36  * Routing Revision record.
37  *
38  * @param p_assembly_item_id IN Assembly Item Id
39  * @param p_organization_id IN Organization Id in which item is defined
40  * @param p_revision IN Routing Revision
41  * @param x_rtg_revision_rec IN OUT NOCOPY Populated Routing Revision Exposed Record from queried row
42  * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
43  * @param x_rtg_Rev_Unexp_rec IN OUT NOCOPY Populated Routing Revision Unexposed Record from queried row
44  * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
45  * @param x_return_status IN OUT NOCOPY Return Status, Record Found or not Found
46  *
47  * @rep:scope private
48  * @rep:lifecycle active
49  * @rep:displayname Query a row for Routing Revision record
50  * @rep:compatibility S
51  * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
52  */
53 PROCEDURE Query_Row
54 ( p_assembly_item_id    IN  NUMBER
55 , p_organization_id     IN  NUMBER
56 , p_revision            IN  VARCHAR2
57 , x_rtg_revision_rec    IN OUT NOCOPY Bom_Rtg_Pub.Rtg_revision_Rec_Type
58 , x_rtg_rev_unexp_rec   IN OUT NOCOPY Bom_Rtg_Pub.Rtg_rev_unexposed_Rec_Type
59 , x_Return_status       IN OUT NOCOPY VARCHAR2
60 );
61 
62 /*#
63  * Procedure to insert/update/delete a database record using Exposed and Unexposed
64  * Routing Revision record depending on Transaction Type.
65  *
66  * @param p_rtg_revision_rec IN Routing Revision Exposed Record
67  * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Revision_Rec_Type }
68  * @param p_rtg_Rev_Unexp_rec  IN Routing Revision Unexposed Record
69  * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Rev_Unexposed_Rec_Type}
70  * @param x_mesg_token_Tbl IN OUT NOCOPY Message Token Table
71  * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
72  * @param x_return_status IN OUT NOCOPY Return Status
73  *
74  * @rep:scope private
75  * @rep:lifecycle active
76  * @rep:displayname Insert/Update/Delete a row for Routing Revision record
77  * @rep:compatibility S
78  * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
79  */
80 PROCEDURE Perform_Writes ( p_rtg_revision_rec     IN  Bom_Rtg_Pub.Rtg_revision_Rec_Type
81 , p_rtg_rev_unexp_rec IN  Bom_Rtg_Pub.Rtg_rev_Unexposed_Rec_Type
82 , x_mesg_token_tbl     IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
83 , x_return_status      IN OUT NOCOPY VARCHAR2
84 );
85 
86 
87 END BOM_Rtg_Revision_UTIL;