[Home] [Help]
PACKAGE: APPS.GMI_LOTS_PUB
Source
1 PACKAGE GMI_LOTS_PUB AUTHID CURRENT_USER AS
2 -- $Header: GMIPLOTS.pls 115.5 2002/10/30 20:24:20 jdiiorio gmigapib.pls $
3 --+=========================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| TVP, Reading, England |
6 --| All rights reserved |
7 --+=========================================================================+
8 --| FILENAME |
9 --| GMIPLOTS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package contains public procedures relating to Lot creation. |
13 --| |
14 --| HISTORY |
15 --| 01-OCT-1998 M.Godfrey Created |
16 --| 17-FEB-1999 M.Godfrey Upgrade to R11 |
17 --| 29-OCT-2002 J.DiIorio Bug#2643440 11.5.1J - added nocopy |
18 --| Removed fnd_miss default for dates. |
19 --+=========================================================================+
20 -- API Name : GMI_LOTS_PUB
21 -- Type : Public
22 -- Function : This package contains public procedures used to create an
23 -- item lot/sublot.
24 -- Pre-reqs : N/A
25 -- Parameters: Per function
26 --
27 -- Current Vers : 2.0
28 --
29 -- Previous Vers : 1.0
30 --
31 -- Initial Vers : 1.0
32 -- Notes
33 --
34 -- API specific parameters to be presented in SQL RECORD format
35 TYPE lot_rec_typ IS RECORD
36 ( item_no ic_item_mst.item_no%TYPE
37 , lot_no ic_lots_mst.lot_no%TYPE
38 , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
39 , lot_desc ic_lots_mst.lot_desc%TYPE DEFAULT NULL
40 , qc_grade ic_lots_mst.qc_grade%TYPE DEFAULT NULL
41 , expaction_code ic_lots_mst.expaction_code%TYPE DEFAULT NULL
42 , expaction_date ic_lots_mst.expaction_date%TYPE DEFAULT NULL
43 , lot_created ic_lots_mst.lot_created%TYPE DEFAULT SYSDATE
44 , expire_date ic_lots_mst.expire_date%TYPE DEFAULT NULL
45 , retest_date ic_lots_mst.retest_date%TYPE DEFAULT NULL
46 , strength ic_lots_mst.strength%TYPE DEFAULT 100
47 , inactive_ind ic_lots_mst.inactive_ind%TYPE DEFAULT 0
48 , origination_type ic_lots_mst.origination_type%TYPE DEFAULT 0
49 , shipvendor_no po_vend_mst.vendor_no%TYPE DEFAULT NULL
50 , vendor_lot_no ic_lots_mst.vendor_lot_no%TYPE DEFAULT NULL
51 , ic_matr_date ic_lots_cpg.ic_matr_date%TYPE DEFAULT NULL
52 , ic_hold_date ic_lots_cpg.ic_hold_date%TYPE DEFAULT NULL
53 , attribute1 ic_lots_mst.attribute1%TYPE DEFAULT NULL
54 , attribute2 ic_lots_mst.attribute2%TYPE DEFAULT NULL
55 , attribute3 ic_lots_mst.attribute3%TYPE DEFAULT NULL
56 , attribute4 ic_lots_mst.attribute4%TYPE DEFAULT NULL
57 , attribute5 ic_lots_mst.attribute5%TYPE DEFAULT NULL
58 , attribute6 ic_lots_mst.attribute6%TYPE DEFAULT NULL
59 , attribute7 ic_lots_mst.attribute7%TYPE DEFAULT NULL
60 , attribute8 ic_lots_mst.attribute8%TYPE DEFAULT NULL
61 , attribute9 ic_lots_mst.attribute9%TYPE DEFAULT NULL
62 , attribute10 ic_lots_mst.attribute10%TYPE DEFAULT NULL
63 , attribute11 ic_lots_mst.attribute11%TYPE DEFAULT NULL
64 , attribute12 ic_lots_mst.attribute12%TYPE DEFAULT NULL
65 , attribute13 ic_lots_mst.attribute13%TYPE DEFAULT NULL
66 , attribute14 ic_lots_mst.attribute14%TYPE DEFAULT NULL
67 , attribute15 ic_lots_mst.attribute15%TYPE DEFAULT NULL
68 , attribute16 ic_lots_mst.attribute16%TYPE DEFAULT NULL
69 , attribute17 ic_lots_mst.attribute17%TYPE DEFAULT NULL
70 , attribute18 ic_lots_mst.attribute18%TYPE DEFAULT NULL
71 , attribute19 ic_lots_mst.attribute19%TYPE DEFAULT NULL
72 , attribute20 ic_lots_mst.attribute20%TYPE DEFAULT NULL
73 , attribute21 ic_lots_mst.attribute21%TYPE DEFAULT NULL
74 , attribute22 ic_lots_mst.attribute22%TYPE DEFAULT NULL
75 , attribute23 ic_lots_mst.attribute23%TYPE DEFAULT NULL
76 , attribute24 ic_lots_mst.attribute24%TYPE DEFAULT NULL
77 , attribute25 ic_lots_mst.attribute25%TYPE DEFAULT NULL
78 , attribute26 ic_lots_mst.attribute26%TYPE DEFAULT NULL
79 , attribute27 ic_lots_mst.attribute27%TYPE DEFAULT NULL
80 , attribute28 ic_lots_mst.attribute28%TYPE DEFAULT NULL
81 , attribute29 ic_lots_mst.attribute29%TYPE DEFAULT NULL
82 , attribute30 ic_lots_mst.attribute30%TYPE DEFAULT NULL
83 , attribute_category ic_lots_mst.attribute_category%TYPE DEFAULT NULL
84 , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
85 );
86 --
87 PROCEDURE Create_Lot
88 ( p_api_version IN NUMBER
89 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
90 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
91 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
92 , p_lot_rec IN lot_rec_typ
93 , x_return_status OUT NOCOPY VARCHAR2
94 , x_msg_count OUT NOCOPY NUMBER
95 , x_msg_data OUT NOCOPY VARCHAR2
96 );
97 --
98 PROCEDURE Validate_Lot
99 ( p_api_version IN NUMBER
100 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
101 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
102 , p_lot_rec IN lot_rec_typ
103 , p_item_rec IN ic_item_mst%ROWTYPE
104 , x_return_status OUT NOCOPY VARCHAR2
105 , x_msg_count OUT NOCOPY NUMBER
106 , x_msg_data OUT NOCOPY VARCHAR2
107 );
108 --
109
110 END GMI_LOTS_PUB;