PACKAGE: APPS.ENG_REF_DESIGNATOR_UTIL

Source

1 PACKAGE ENG_Ref_Designator_Util AUTHID CURRENT_USER AS
2 /* $Header: ENGURFDS.pls 115.7 2002/12/12 18:20:20 akumar ship $ */
3 
4 --  Attributes global constants
5 
6 G_REF_DESIGNATOR              CONSTANT NUMBER := 1;
7 G_LAST_UPDATE_DATE            CONSTANT NUMBER := 2;
8 G_LAST_UPDATED_BY             CONSTANT NUMBER := 3;
9 G_CREATION_DATE               CONSTANT NUMBER := 4;
10 G_CREATED_BY                  CONSTANT NUMBER := 5;
11 G_LAST_UPDATE_LOGIN           CONSTANT NUMBER := 6;
12 G_REF_DESIGNATOR_COMMENT      CONSTANT NUMBER := 7;
13 G_CHANGE_NOTICE               CONSTANT NUMBER := 8;
14 G_COMPONENT_SEQUENCE          CONSTANT NUMBER := 9;
15 G_ACD_TYPE                    CONSTANT NUMBER := 10;
16 G_REQUEST                     CONSTANT NUMBER := 11;
17 G_PROGRAM_APPLICATION         CONSTANT NUMBER := 12;
18 G_PROGRAM                     CONSTANT NUMBER := 13;
19 G_PROGRAM_UPDATE_DATE         CONSTANT NUMBER := 14;
20 G_ATTRIBUTE_CATEGORY          CONSTANT NUMBER := 15;
21 G_ATTRIBUTE1                  CONSTANT NUMBER := 16;
22 G_ATTRIBUTE2                  CONSTANT NUMBER := 17;
23 G_ATTRIBUTE3                  CONSTANT NUMBER := 18;
24 G_ATTRIBUTE4                  CONSTANT NUMBER := 19;
25 G_ATTRIBUTE5                  CONSTANT NUMBER := 20;
26 G_ATTRIBUTE6                  CONSTANT NUMBER := 21;
27 G_ATTRIBUTE7                  CONSTANT NUMBER := 22;
28 G_ATTRIBUTE8                  CONSTANT NUMBER := 23;
29 G_ATTRIBUTE9                  CONSTANT NUMBER := 24;
30 G_ATTRIBUTE10                 CONSTANT NUMBER := 25;
31 G_ATTRIBUTE11                 CONSTANT NUMBER := 26;
32 G_ATTRIBUTE12                 CONSTANT NUMBER := 27;
33 G_ATTRIBUTE13                 CONSTANT NUMBER := 28;
34 G_ATTRIBUTE14                 CONSTANT NUMBER := 29;
35 G_ATTRIBUTE15                 CONSTANT NUMBER := 30;
36 G_MAX_ATTR_ID                 CONSTANT NUMBER := 31;
37 
38 --  Procedure Clear_Dependent_Attr
39 
40 PROCEDURE Clear_Dependent_Attr
41 (   p_attr_id                       IN  NUMBER :=NULL -- FND_API.G_MISS_NUM
42 ,   p_ref_designator_rec            IN  Bom_Bo_Pub.Ref_Designator_Rec_Type
43 ,   p_old_ref_designator_rec        IN  Bom_Bo_Pub.Ref_Designator_Rec_Type :=
44                                         Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
45 ,   x_ref_designator_rec            IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
46 );
47 
48 --  Procedure Apply_Attribute_Changes
49 
50 PROCEDURE Apply_Attribute_Changes
51 (   p_ref_designator_rec            IN  Bom_Bo_Pub.Ref_Designator_Rec_Type
52 ,   p_old_ref_designator_rec        IN  Bom_Bo_Pub.Ref_Designator_Rec_Type :=
53                                         Bom_Bo_Pub.G_MISS_REF_DESIGNATOR_REC
54 ,   x_ref_designator_rec            IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
55 );
56 
57 --  Function Convert_Miss_To_Null
58 
59 FUNCTION Convert_Miss_To_Null
60 (   p_ref_designator_rec            IN  Bom_Bo_Pub.Ref_Designator_Rec_Type
61 ) RETURN Bom_Bo_Pub.Ref_Designator_Rec_Type;
62 
63 --  Function Query_Row
64 
65 PROCEDURE Query_Row
66 (   p_ref_designator            IN  VARCHAR2
67 ,   p_component_sequence_id     IN  NUMBER
68 ,   p_acd_type                  IN  NUMBER
69 ,   x_Ref_Designator_Rec	OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
70 ,   x_Ref_Desg_Unexp_Rec	OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
71 ,   x_Return_Status		OUT NOCOPY VARCHAR2
72 );
73 
74 PROCEDURE Perform_Writes
75 (  p_ref_designator_rec         IN  Bom_Bo_Pub.Ref_Designator_rec_Type
76  , p_ref_desg_unexp_rec         IN  Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
77  , x_mesg_token_tbl             OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
78  , x_return_status              OUT NOCOPY VARCHAR2
79 );
80 
81 END ENG_Ref_Designator_Util;