[Home] [Help]
PACKAGE: APPS.BOM_VALIDATE_COMP_OPERATION
Source
1 PACKAGE BOM_Validate_Comp_Operation AUTHID CURRENT_USER AS
2 /* $Header: BOMLCOPS.pls 115.3 2002/11/13 20:54:40 rfarook ship $ */
3 /*****************************************************************************
4 --
5 -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- BOMLCOPS.pls
11 --
12 -- DESCRIPTION
13 --
14 -- Spec of package BOM_Validate_Comp_Operation
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 29-AUG-2001 Refai Farook Initial Creation
21 --
22 *****************************************************************************/
23
24 FUNCTION Check_Overlap_Dates
25 ( p_Effectivity_Date DATE,
26 p_Disable_Date DATE,
27 p_Component_Item_Id NUMBER,
28 p_Bill_Sequence_Id NUMBER,
29 p_component_sequence_id IN NUMBER := NULL,
30 p_comp_operation_seq_id IN NUMBER := NULL,
31 p_Rowid VARCHAR2 := NULL,
32 p_Operation_Seq_Num NUMBER,
33 p_entity VARCHAR2 := 'COPS')
34 RETURN BOOLEAN;
35
36 FUNCTION Check_Overlap_Numbers
37 ( p_From_End_Item_Number VARCHAR2
38 , p_To_End_Item_Number VARCHAR2
39 , p_Component_Item_Id NUMBER
40 , p_Bill_Sequence_Id NUMBER
41 , p_component_sequence_id IN NUMBER := NULL
42 , p_comp_operation_seq_id IN NUMBER := NULL
43 , p_Rowid VARCHAR2 := NULL
44 , p_Operation_Seq_Num NUMBER
45 , p_entity VARCHAR2 := 'COPS')
46 RETURN BOOLEAN;
47
48 PROCEDURE Check_Entity
49 ( x_return_status IN OUT NOCOPY VARCHAR2
50 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
51 , p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
52 , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
53 );
54
55 PROCEDURE Check_Attributes
56 ( x_return_status IN OUT NOCOPY VARCHAR2
57 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
58 , p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
59 , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
60 );
61
62 PROCEDURE Check_Existence
63 ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
64 , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
65 , x_old_bom_comp_ops_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
66 , x_old_bom_comp_ops_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
67 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
68 , x_Return_Status IN OUT NOCOPY VARCHAR2
69 );
70
71 PROCEDURE Check_Lineage
72 ( p_bom_comp_ops_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Rec_Type
73 , p_bom_comp_ops_unexp_rec IN Bom_Bo_Pub.Bom_Comp_Ops_Unexp_Rec_Type
74 , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
75 , x_Return_Status IN OUT NOCOPY VARCHAR2
76 );
77
78 END BOM_Validate_Comp_Operation;