PACKAGE: APPS.WMA_COMMON

Source

1 PACKAGE wma_common AUTHID CURRENT_USER AS
2 /* $Header: wmaccoms.pls 120.0.12000000.2 2007/03/13 21:13:37 kboonyap ship $ */
3 
4   /* Constants */
5 
6   -- length of our error messages
7   ERR_LEN      CONSTANT NUMBER := WIP_CONSTANTS.ERR_LEN;
8   SOURCE_CODE  CONSTANT VARCHAR2(11) := 'WMA MOBILE';
9   SERIALIZATION_SOURCE_CODE CONSTANT VARCHAR2(29) := 'WMA SERIALIZATION MOBILE TXN';
10 
11 
12   -- the number format
13   WMA_NUMBER_FORMAT CONSTANT VARCHAR2(29) := '9999999999999999999.999999';
14 
15 
16   /**
17    * Record Types
18    * Notes:
19    * String lengths corrospond to constants defined in WIP_CONSTANTS
20    */
21 
22   /**
23    * environment information. Includes user info and organization info
24    */
25   TYPE Environment IS RECORD
26   (
27     orgID        NUMBER,
28     orgCode      VARCHAR2(4),
29     userID       NUMBER,
30     userName     VARCHAR2(100)
31   );
32 
33 
34   /**
35    * inventory item structure
36    */
37   /* ER 4378835: Increased length of lot_number from 31 to 80 to support OPM Lot-model changes */
38   TYPE Item IS RECORD
39   (
40     invItemID               NUMBER,
41     itemName                VARCHAR2(241),
42     description             VARCHAR2(241),
43     orgID                   NUMBER,
44     primaryUOMCode          VARCHAR2(4),
45     lotControlCode          NUMBER,
46     autoLotAlphaPrefix      VARCHAR2(80),
47     startAutoLotNumber      VARCHAR2(80),
48     serialNumberControlCode NUMBER,
49     autoSerialAlfaPrefix    VARCHAR2(31),
50     startAutoSerialNumber   VARCHAR2(31),
51     locationControlCode     NUMBER,
52     revQtyControlCode       NUMBER,
53     restrictLocatorsCode    NUMBER,
54     restrictSubinvCode      NUMBER,
55     shelfLifeCode           NUMBER,
56     shelfLifeDays           NUMBER,
57     invAssetFlag            VARCHAR2(2),
58     allowedUnitsLookupCode  NUMBER,
59     mtlTxnsEnabled          VARCHAR2(2),
60     projectID               NUMBER,
61     taskID                  NUMBER
62   );
63 
64 
65   /**
66     * Discrete Job Structure
67     */
68   TYPE Job IS RECORD (
69     wipEntityID               NUMBER,
70     organizationID            NUMBER,
71     jobName                   VARCHAR2(240),
72     jobType                   NUMBER,
73     description               VARCHAR2(240),
74     primaryItemID             NUMBER,
75     statusType                NUMBER,
76     wipSupplyType             NUMBER,
77     lineID                    NUMBER,
78     lineCode                  VARCHAR2(11),
79     scheduledStartDate        DATE,
80     scheduledCompletionDate   DATE,
81     startQuantity             NUMBER,
82     quantityCompleted         NUMBER,
83     quantityScrapped          NUMBER,
84     completionSubinventory    VARCHAR2(10),
85     completionLocatorID       NUMBER,
86     projectID                 NUMBER,
87     taskID                    NUMBER,
88     endItemUnitNumber         VARCHAR2(30)
89   );
90 
91 
92 END wma_common;