[Home] [Help]
PACKAGE: APPS.GMI_ITEM_PUB
Source
1 PACKAGE GMI_ITEM_PUB AUTHID CURRENT_USER AS
2 -- $Header: GMIPITMS.pls 115.4 2002/10/28 15:08:31 jdiiorio gmigapib.pls $
3 --+=========================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| TVP, Reading, England |
6 --| All rights reserved |
7 --+=========================================================================+
8 --| FILENAME |
9 --| GMIPITMS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package contains public procedures relating to Inventory |
13 --| Item creation. |
14 --| |
15 --| HISTORY |
16 --| 01-OCT-1998 M.Godfrey Created |
17 --| 15-FEB-1999 M.Godfrey Upgraded to R11 |
18 --| 28-OCT-2002 J.DiIorio Bug#2643440 - added nocopy. |
19 --+=========================================================================+
20 -- API Name : GMI_ITEM_PUB
21 -- Type : Public
22 -- Function : This package contains public procedures used to create an
23 -- inventory item.
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 item_rec_typ IS RECORD
36 ( item_no ic_item_mst.item_no%TYPE
37 , item_desc1 ic_item_mst.item_desc1%TYPE
38 , item_desc2 ic_item_mst.item_desc2%TYPE DEFAULT NULL
39 , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL
40 , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL
41 , item_um ic_item_mst.item_um%TYPE
42 , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0
43 , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
44 , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0
45 , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0
46 , level_code ic_item_mst.level_code%TYPE DEFAULT NULL
47 , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0
48 , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0
49 , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0
50 , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0
51 , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0
52 , match_type ic_item_mst.match_type%TYPE DEFAULT 3
53 , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0
54 , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL
55 , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0
56 , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0
57 , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL
58 , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL
59 , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL
60 , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL
61 , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL
62 , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL
63 , price_class ic_item_mst.price_class%TYPE DEFAULT NULL
64 , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL
65 , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL
66 , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL
67 , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL
68 , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL
69 , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL
70 , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL
71 , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL
72 , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL
73 , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0
74 , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0
75 , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL
76 , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL
77 , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL
78 , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL
79 , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL
80 , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL
81 , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL
82 , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0
83 , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL
84 , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0
85 , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0
86 , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL
87 , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0
88 , exported_date ic_item_mst.exported_date%TYPE
89 DEFAULT TO_DATE('02011970','DDMMYYYY')
90 , seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE DEFAULT NULL
91 , commodity_code ic_item_mst.commodity_code%TYPE DEFAULT NULL
92 , ic_matr_days ic_item_cpg.ic_matr_days%TYPE DEFAULT 0
93 , ic_hold_days ic_item_cpg.ic_hold_days%TYPE DEFAULT 0
94 , attribute1 ic_item_mst.attribute1%TYPE DEFAULT NULL
95 , attribute2 ic_item_mst.attribute2%TYPE DEFAULT NULL
96 , attribute3 ic_item_mst.attribute3%TYPE DEFAULT NULL
97 , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL
98 , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL
99 , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL
100 , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL
101 , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL
102 , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL
103 , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL
104 , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL
105 , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL
106 , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL
107 , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL
108 , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL
109 , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL
110 , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL
111 , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL
112 , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL
113 , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL
114 , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL
115 , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL
116 , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL
117 , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL
118 , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL
119 , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL
120 , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL
121 , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL
122 , attribute29 ic_item_mst.attribute29%TYPE DEFAULT NULL
123 , attribute30 ic_item_mst.attribute30%TYPE DEFAULT NULL
124 , attribute_category ic_item_mst.attribute_category%TYPE DEFAULT NULL
125 , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
126 );
127 --
128 PROCEDURE Create_Item
129 ( p_api_version IN NUMBER
130 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
131 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
132 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
133 , p_item_rec IN item_rec_typ
134 , x_return_status OUT NOCOPY VARCHAR2
135 , x_msg_count OUT NOCOPY NUMBER
136 , x_msg_data OUT NOCOPY VARCHAR2
137 );
138 --
139 PROCEDURE Validate_Item
140 ( p_api_version IN NUMBER
141 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
142 , p_validation_level IN VARCHAR2 DEFAULT FND_API.G_VALID_LEVEL_FULL
143 , p_item_rec IN item_rec_typ
144 , x_return_status OUT NOCOPY VARCHAR2
145 , x_msg_count OUT NOCOPY NUMBER
146 , x_msg_data OUT NOCOPY VARCHAR2
147 );
148
149 END GMI_ITEM_PUB;