DBA Data[Home] [Help]

PACKAGE: APPS.BOM_VALIDATE

Source


1 PACKAGE BOM_Validate AS
2 /* $Header: BOMSVATS.pls 120.1 2005/12/04 22:32:45 vhymavat noship $ */
3 /****************************************************************************
4 --
5 --  Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
6 --  All rights reserved.
7 --
8 --  FILENAME
9 --
10 --      BOMSVATS.pls
11 --
12 --  DESCRIPTION
13 --
14 --      Spec of package BOM_Validate
15 --
16 --  NOTES
17 --
18 --  HISTORY
19 --
20 --  01-JUL-99   Rahul Chitko    Initial Creation
21 --
22 --  08-MAY-01   Refai Farook    EAM changes
23 
24 --  26-MAY-04   Vani Hymavathi  added new function Is_Preferred_Structure
25 
26 ****************************************************************************/
27 	FUNCTION Alternate_Designator(  p_alternate_bom_code	IN  VARCHAR2
28 			              , p_organization_id	IN  NUMBER
29 				      ) RETURN BOOLEAN;
30 
31 
32         FUNCTION End_Item_Unit_Number
33         ( p_from_end_item_unit_number IN  VARCHAR2
34         , p_revised_item_id           IN  VARCHAR2
35         , x_err_text                  IN OUT NOCOPY VARCHAR2 ) RETURN BOOLEAN;
36 
37         FUNCTION Wip_Supply_Type
38 	(  p_wip_supply_type   IN  NUMBER
39          , x_err_text          IN OUT NOCOPY VARCHAR2 ) RETURN BOOLEAN;
40 
41         FUNCTION Asset_Group_Serial_Number
42         ( p_assembly_item_id  IN NUMBER,
43           p_organization_id   IN NUMBER,
44           p_serial_number     IN  VARCHAR2,
45           x_err_text         IN OUT NOCOPY VARCHAR2 ) RETURN BOOLEAN;
46 
47 
48         FUNCTION  Is_Preferred_Structure
49         ( p_assembly_item_id  IN NUMBER,
50           p_organization_id   IN NUMBER,
51           p_alternate_bom_code IN  VARCHAR2,
52           x_err_text         IN OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 ;
53 
54 	FUNCTION Object_Exists
55 	(p_object_type VARCHAR2,p_object_name VARCHAR2) RETURN  VARCHAR2;
56 END BOM_Validate;