PACKAGE: APPS.BOM_RTG_HEADER_UTIL

Source

1 PACKAGE Bom_Rtg_Header_Util AS
2 /* $Header: BOMURTGS.pls 120.1 2006/01/03 21:56:52 bbpatel noship $*/
3 /*#
4  * This API contains Routing Header entity utility procedure. Utility procedures
5  * include query, update 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 Header 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 --      BOMURTGS.pls
23 --
24 --  DESCRIPTION
25 --
26 --      Spec of package Bom_Rtg_Header_Util
27 --
28 --  NOTES
29 --
30 --  HISTORY
31 --  02-AUG-2000 Biao Zhang      Initial Creation
32 --
33 ****************************************************************************/
34 
35 /*#
36  * Procedure to query a database record and return the populated Exposed and Unexposed
37  * Routing Header record.
38  *
39  * @param p_assembly_item_id IN Assembly Item Id
40  * @param p_organization_id IN Organization Id in which item is defined
41  * @param p_alternate_routing_code IN Alternate Routing Code
42  * @param x_rtg_header_rec IN OUT NOCOPY Populated Routing Header Exposed Record from queried row
43  * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Rec_Type }
44  * @param x_rtg_header_unexp_rec  IN  OUT NOCOPY Populated Routing Header Unexposed Record from queried row
45  * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type}
46  * @param x_return_status IN OUT NOCOPY Return Status, Record Found or not Found
47  *
48  * @rep:scope private
49  * @rep:lifecycle active
50  * @rep:displayname Query a row for Routing Header record
51  * @rep:compatibility S
52  * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
53  */
54 PROCEDURE Query_Row
55 ( p_assembly_item_id    IN  NUMBER
56 , p_organization_id     IN  NUMBER
57 , p_alternate_routing_code      IN VARCHAR2
58 , x_rtg_header_rec      IN OUT NOCOPY Bom_Rtg_Pub.Rtg_header_Rec_Type
59 , x_rtg_header_unexp_rec  IN OUT NOCOPY Bom_Rtg_Pub.Rtg_header_unexposed_Rec_Type
60 , x_Return_status       IN OUT NOCOPY VARCHAR2
61 );
62 
63 /*#
64  * Procedure to update a database record using Exposed and Unexposed
65  * Routing Header record.
66  *
67  * @param p_rtg_header_rec IN Routing Header Exposed Record
68  * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Rec_Type}
69  * @param p_rtg_header_unexp_rec  IN  Routing Header Unexposed Record
70  * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type}
71  * @param x_mesg_token_Tbl IN OUT NOCOPY Message Token Table
72  * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
73  * @param x_return_status IN OUT NOCOPY Return Status
74  *
75  * @rep:scope private
76  * @rep:lifecycle active
77  * @rep:displayname Update a row for Routing Header record
78  * @rep:compatibility S
79  * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
80  */
81 PROCEDURE Update_Row
82         (  p_RTG_header_rec     IN  Bom_Rtg_Pub.RTG_Header_Rec_Type
83          , p_RTG_header_unexp_rec IN  Bom_Rtg_Pub.RTG_Header_Unexposed_Rec_Type
84          , x_mesg_token_Tbl     IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
85          , x_return_Status      IN OUT NOCOPY VARCHAR2
86          );
87 
88 /*#
89  * Procedure to insert/update/delete a database record using Exposed and Unexposed
90  * Routing Header record depending on Transaction Type.
91  *
92  * @param p_rtg_header_rec IN Routing Header Exposed Record
93  * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Rec_Type}
94  * @param p_rtg_header_unexp_rec  IN  Routing Header Unexposed Record
95  * @paraminfo {@rep:innertype Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type}
96  * @param x_mesg_token_Tbl IN OUT NOCOPY Message Token Table
97  * @paraminfo {@rep:innertype Error_Handler.Mesg_Token_Tbl_Type}
98  * @param x_return_status IN OUT NOCOPY Return Status
99  *
100  * @rep:scope private
101  * @rep:lifecycle active
102  * @rep:displayname Insert/Update/Delete a row for Routing Header record
103  * @rep:compatibility S
104  * @rep:category BUSINESS_ENTITY BOM_MFG_ROUTING
105  */
106 PROCEDURE Perform_Writes
107 ( p_rtg_header_rec     IN  Bom_Rtg_Pub.Rtg_Header_Rec_Type
108 , p_rtg_header_unexp_rec IN  Bom_Rtg_Pub.Rtg_Header_Unexposed_Rec_Type
109 , x_mesg_token_tbl     IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
110 , x_return_status      IN OUT NOCOPY VARCHAR2
111 );
112 
113 END Bom_Rtg_Header_Util;