[Home] [Help]
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;