PACKAGE: APPS.BOM_BOM_HEADER_UTIL

Source

1 PACKAGE Bom_Bom_Header_Util AS
2 /* $Header: BOMUBOMS.pls 120.0 2005/05/25 05:02:34 appldev noship $ */
3 /*#
4 * This API contains entity utility methods for the Bill of Materials header.
5 * @rep:scope private
6 * @rep:product BOM
7 * @rep:displayname BOM Header Util package
8 * @rep:lifecycle active
9 * @rep:category BUSINESS_ENTITY BOM_BILL_OF_MATERIAL
10 */
11 /****************************************************************************
12 --
13 --  Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
14 --  All rights reserved.
15 --
16 --  FILENAME
17 --
18 --      ENGUBOMS.pls
19 --
20 --  DESCRIPTION
21 --
22 --      Spec of package Bom_Bom_Header_Util
23 --
24 --  NOTES
25 --
26 --  HISTORY
27 --  02-JUL-1999	Rahul Chitko	Initial Creation
28 --
29 ****************************************************************************/
30 /*#
31 * This method will query the database record, seperate the  values into exposed columns
32 * and unexposed columns and return with those records
33 * @param p_assembly_item_id Assembly item id
34 * @param p_organization_id  Organization Id
35 * @param p_alternate_bom_code Alternate_Bom_Code
36 * @param x_bom_header_rec Bom header exposed column record
37 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_head_Rec_Type }
38 * @param x_bom_head_unexp_rec Bom Header unexposed column record
39 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_head_unexposed_Rec_Type }
40 * @param x_Return_status Return Status
41 * @rep:scope private
42 * @rep:lifecycle active
43 * @rep:displayname Query Row
44 */
45 
46 PROCEDURE Query_Row
47 ( p_assembly_item_id	IN  NUMBER
48 , p_organization_id     IN  NUMBER
49 , p_alternate_bom_code	IN VARCHAR2 := NULL
50 , x_bom_header_rec	IN OUT NOCOPY Bom_Bo_Pub.Bom_head_Rec_Type
51 , x_bom_head_unexp_rec  IN OUT NOCOPY Bom_Bo_Pub.Bom_head_unexposed_Rec_Type
52 , x_Return_status       IN OUT NOCOPY VARCHAR2
53 );
54 
55 PROCEDURE Query_Table_Row
56 ( p_assembly_item_id	IN  NUMBER
57 , p_organization_id     IN  NUMBER
58 , p_alternate_bom_code	IN VARCHAR2 := NULL
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_Return_status       IN OUT NOCOPY VARCHAR2
62 );
63 
64 /*#
65 * This is the only method that the user will have access to when he/she needs to perform any kind
66 * of writes to the bom_bill_of_materials table
67 * @param p_bom_header_rec BOM Header Exposed Column Record
68 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Head_Rec_Type }
69 * @param p_bom_head_unexp_rec BOM Header Unexposed column record
70 * @rep:paraminfo { @rep:innertype Bom_Bo_Pub.Bom_Head_Unexposed_Rec_Type }
71 * @param x_mesg_token_tbl Messgae Token Table
72 * @rep:paraminfo { @rep:innertype Error_Handler.Mesg_Token_Tbl_Type }
73 * @param x_Return_status Return Status
74 * @rep:scope private
75 * @rep:lifecycle active
76 * @rep:displayname Perform Writes
77 */
78 
79 PROCEDURE Perform_Writes
80 ( p_bom_header_rec     IN  Bom_Bo_Pub.Bom_Head_Rec_Type
81 , p_bom_head_unexp_rec IN  Bom_Bo_Pub.Bom_Head_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 END Bom_Bom_Header_Util;