[Home] [Help]
PACKAGE: APPS.GMI_MOVE_ORDER_HEADER_UTIL
Source
1 PACKAGE GMI_Move_Order_Header_Util AUTHID CURRENT_USER AS
2 /* $Header: GMIUMOHS.pls 120.0 2005/05/26 00:17:29 appldev noship $
3 +=========================================================================+
4 | Copyright (c) 2000 Oracle Corporation |
5 | TVP, Reading, England |
6 | All rights reserved |
7 +=========================================================================+
8 | FILENAME |
9 | GMIUMOHS.pls |
10 | |
11 | DESCRIPTION |
12 | This package contains public procedures relating to GMI |
13 | Move Order Header Utilities |
14 | |
15 | - Process_Move_Order_Header |
16 | |
17 | |
18 | HISTORY |
19 | 27-Apr-2000 odaboval Created |
20 | |
21 +=========================================================================+
22 API Name : GMI_Move_Order_Header_Util
23 Type : Global
24 -
25 Pre-reqs : N/A
26 Parameters: Per function
27
28 Current Vers : 1.0
29
30 */
31 /*
32 Attributes global constants
33 */
34 G_ATTRIBUTE1 CONSTANT NUMBER := 1;
35 G_ATTRIBUTE10 CONSTANT NUMBER := 2;
36 G_ATTRIBUTE11 CONSTANT NUMBER := 3;
37 G_ATTRIBUTE12 CONSTANT NUMBER := 4;
38 G_ATTRIBUTE13 CONSTANT NUMBER := 5;
39 G_ATTRIBUTE14 CONSTANT NUMBER := 6;
40 G_ATTRIBUTE15 CONSTANT NUMBER := 7;
41 G_ATTRIBUTE2 CONSTANT NUMBER := 8;
42 G_ATTRIBUTE3 CONSTANT NUMBER := 9;
43 G_ATTRIBUTE4 CONSTANT NUMBER := 10;
44 G_ATTRIBUTE5 CONSTANT NUMBER := 11;
45 G_ATTRIBUTE6 CONSTANT NUMBER := 12;
46 G_ATTRIBUTE7 CONSTANT NUMBER := 13;
47 G_ATTRIBUTE8 CONSTANT NUMBER := 14;
48 G_ATTRIBUTE9 CONSTANT NUMBER := 15;
49 G_ATTRIBUTE_CATEGORY CONSTANT NUMBER := 16;
50 G_CREATED_BY CONSTANT NUMBER := 17;
51 G_CREATION_DATE CONSTANT NUMBER := 18;
52 G_DATE_REQUIRED CONSTANT NUMBER := 19;
53 G_DESCRIPTION CONSTANT NUMBER := 20;
54 G_FROM_SUBINVENTORY CONSTANT NUMBER := 21;
55 G_HEADER CONSTANT NUMBER := 22;
56 G_HEADER_STATUS CONSTANT NUMBER := 23;
57 G_LAST_UPDATED_BY CONSTANT NUMBER := 24;
58 G_LAST_UPDATE_DATE CONSTANT NUMBER := 25;
59 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 26;
60 G_ORGANIZATION CONSTANT NUMBER := 27;
61 G_PROGRAM_APPLICATION CONSTANT NUMBER := 28;
62 G_PROGRAM CONSTANT NUMBER := 29;
63 G_PROGRAM_UPDATE_DATE CONSTANT NUMBER := 30;
64 G_REQUEST CONSTANT NUMBER := 31;
65 G_REQUEST_NUMBER CONSTANT NUMBER := 32;
66 G_STATUS_DATE CONSTANT NUMBER := 33;
67 G_TO_ACCOUNT CONSTANT NUMBER := 34;
68 G_TO_SUBINVENTORY CONSTANT NUMBER := 35;
69 G_MOVE_ORDER_TYPE CONSTANT NUMBER := 36;
70 G_TRANSACTION_TYPE CONSTANT NUMBER := 37;
71 G_MAX_ATTR_ID CONSTANT NUMBER := 38;
72 G_SHIP_TO_LOCATION_ID CONSTANT NUMBER := 39;
73
74 /* Procedure Clear_Dependent_Attr
75 Procedure Apply_Attribute_Changes
76 Function Get_Values
77 Function Get_Ids
78 */
79
80 FUNCTION Complete_Record
81 ( p_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
82 , p_old_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
83 ) RETURN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC;
84
85
86 FUNCTION Convert_Miss_To_Null
87 ( p_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
88 ) RETURN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC;
89
90
91 PROCEDURE Update_Row
92 ( p_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
93 );
94
95
96 PROCEDURE Update_Row_Status
97 ( p_header_id IN Number,
98 p_status IN Number
99 );
100
101
102 PROCEDURE Insert_Row
103 ( p_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
104 );
105
106
107 PROCEDURE Delete_Row
108 ( p_header_id IN NUMBER
109 );
110
111
112 FUNCTION Query_Row
113 ( p_header_id IN NUMBER
114 ) RETURN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC;
115
116
117 PROCEDURE Lock_Row
118 ( x_return_status OUT NOCOPY VARCHAR2
119 , p_mo_hdr_rec IN GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
120 , x_mo_hdr_rec OUT NOCOPY GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC
121 );
122
123
124 END GMI_Move_Order_Header_Util;