PACKAGE: APPS.WIP_WIP_ENTITIES_UTIL

Source

1 PACKAGE WIP_Wip_Entities_Util AUTHID CURRENT_USER AS
2 /* $Header: WIPUWENS.pls 115.7 2002/12/01 18:13:12 simishra ship $ */
3 
4 --  Attributes global constants
5 
6 G_CREATED_BY                  CONSTANT NUMBER := 1;
7 G_CREATION_DATE               CONSTANT NUMBER := 2;
8 G_DESCRIPTION                 CONSTANT NUMBER := 3;
9 G_ENTITY_TYPE                 CONSTANT NUMBER := 4;
10 G_LAST_UPDATED_BY             CONSTANT NUMBER := 5;
11 G_LAST_UPDATE_DATE            CONSTANT NUMBER := 6;
12 G_LAST_UPDATE_LOGIN           CONSTANT NUMBER := 7;
13 G_ORGANIZATION                CONSTANT NUMBER := 8;
14 G_PRIMARY_ITEM                CONSTANT NUMBER := 9;
15 G_PROGRAM_APPLICATION         CONSTANT NUMBER := 10;
16 G_PROGRAM                     CONSTANT NUMBER := 11;
17 G_PROGRAM_UPDATE_DATE         CONSTANT NUMBER := 12;
18 G_REQUEST                     CONSTANT NUMBER := 13;
19 G_WIP_ENTITY                  CONSTANT NUMBER := 14;
20 G_WIP_ENTITY_NAME             CONSTANT NUMBER := 15;
21 G_MAX_ATTR_ID                 CONSTANT NUMBER := 16;
22 
23 
24 --  Function Complete_Record
25 
26 FUNCTION Complete_Record
27 (   p_Wip_Entities_rec              IN  WIP_Work_Order_PUB.Wip_Entities_Rec_Type
28 ,   p_old_Wip_Entities_rec          IN  WIP_Work_Order_PUB.Wip_Entities_Rec_Type
29 ) RETURN WIP_Work_Order_PUB.Wip_Entities_Rec_Type;
30 
31 --  Function Convert_Miss_To_Null
32 
33 FUNCTION Convert_Miss_To_Null
34 (   p_Wip_Entities_rec              IN  WIP_Work_Order_PUB.Wip_Entities_Rec_Type
35 ) RETURN WIP_Work_Order_PUB.Wip_Entities_Rec_Type;
36 
37 --  Procedure Update_Row
38 
39 PROCEDURE Update_Row
40 (   p_Wip_Entities_rec              IN  WIP_Work_Order_PUB.Wip_Entities_Rec_Type
41 );
42 
43 --  Procedure Insert_Row
44 
45 PROCEDURE Insert_Row
46 (   p_Wip_Entities_rec              IN  WIP_Work_Order_PUB.Wip_Entities_Rec_Type
47 );
48 
49 --  Procedure Delete_Row
50 
51 PROCEDURE Delete_Row
52 (   p_wip_entity_id                 IN  NUMBER
53 );
54 
55 --  Function Query_Row
56 
57 FUNCTION Query_Row
58 (   p_wip_entity_id                 IN  NUMBER
59 ) RETURN WIP_Work_Order_PUB.Wip_Entities_Rec_Type;
60 
61 --  Procedure       lock_Row
62 --
63 
64 PROCEDURE Lock_Row
65 (   x_return_status                 OUT NOCOPY VARCHAR2
66 ,   p_Wip_Entities_rec              IN  WIP_Work_Order_PUB.Wip_Entities_Rec_Type
67 ,   x_Wip_Entities_rec              OUT NOCOPY WIP_Work_Order_PUB.Wip_Entities_Rec_Type
68 );
69 
70 END WIP_Wip_Entities_Util;