PACKAGE: APPS.GMI_ERES_UTILS

Source

1 PACKAGE gmi_eres_utils AUTHID CURRENT_USER AS
2 /* $Header: GMIERESS.pls 115.5 2003/10/22 13:30:06 jdiiorio noship $ */
3 
4 PROCEDURE GET_ITEM_NO (
5  pitem_id          IN VARCHAR2,
6  pitem_no          OUT NOCOPY VARCHAR2);
7 
8 PROCEDURE GET_ITEM_UM(
9  pitem_id          IN VARCHAR2,
10  pitem_um          OUT NOCOPY VARCHAR2);
11 
12 PROCEDURE GET_ITEM_DESC(
13  pitem_id          IN VARCHAR2,
14  pitem_desc        OUT NOCOPY VARCHAR2);
15 
16 PROCEDURE GET_UM_TYPE(
17  pum               IN VARCHAR2,
18  pum_type          OUT NOCOPY VARCHAR2);
19 
20 PROCEDURE GET_BASE_UOM (
21  pum_type          IN VARCHAR2,
22  puom              OUT NOCOPY VARCHAR2);
23 
24 PROCEDURE GET_ITEM_UOM_AND_TYPE (
25  pitem_id          IN VARCHAR2,
26  puom              OUT NOCOPY VARCHAR2,
27  pum_type          OUT NOCOPY VARCHAR2);
28 
29 PROCEDURE GET_LOT_NO (
30  pitem_id          IN VARCHAR2,
31  plot_id           IN VARCHAR2,
32  plot_no           OUT NOCOPY VARCHAR2);
33 
34 PROCEDURE GET_SUBLOT_NO (
35  pitem_id          IN VARCHAR2,
36  plot_id           IN VARCHAR2,
37  psublot_no        OUT NOCOPY VARCHAR2);
38 
39 PROCEDURE GET_LOT_DESC (
40  pitem_id          IN VARCHAR2,
41  plot_id           IN VARCHAR2,
42  plot_desc         OUT NOCOPY VARCHAR2);
43 
44 PROCEDURE GET_LOOKUP_VALUE (
45  plookup_type       IN VARCHAR2,
46  plookup_code       IN VARCHAR2,
47  pmeaning           OUT NOCOPY VARCHAR2);
48 
49 PROCEDURE GET_VENDOR_NO (
50  pvendor_id         IN VARCHAR2,
51  pvendor_no         OUT NOCOPY VARCHAR2);
52 
53 PROCEDURE GET_VENDOR_DESC (
54  pvendor_id         IN VARCHAR2,
55  pvendor_desc       OUT NOCOPY VARCHAR2);
56 
57 PROCEDURE PAD_LANGUAGE (
58  planguage_in       IN VARCHAR2,
59  planguage_out      OUT NOCOPY VARCHAR2);
60 
61 PROCEDURE ACTIVATE_ITEM (
62  pitem_id           IN NUMBER);
63 
64 /*===============================================
65    BUG#3031296 - Added for Mass Transactions form.
66   ===============================================*/
67 
68 PROCEDURE GET_JOURNAL_NO (
69  pjournal_id        IN NUMBER,
70  pjournal_no        OUT NOCOPY VARCHAR2);
71 
72 PROCEDURE GET_GRADE_DESC (
73  pgrade             IN VARCHAR2,
74  pgrade_desc        OUT NOCOPY VARCHAR2);
75 
76 PROCEDURE GET_STATUS_DESC (
77  pstatus            IN VARCHAR2,
78  pstatus_desc       OUT NOCOPY VARCHAR2);
79 
80 PROCEDURE GET_REASON_DESC (
81  preason_code       IN VARCHAR2,
82  preason_desc       OUT NOCOPY VARCHAR2);
83 
84 PROCEDURE GET_WHSE_DESC (
85  pwhse_code         IN VARCHAR2,
86  pwhse_desc         OUT NOCOPY VARCHAR2);
87 
88 PROCEDURE GET_JRNL_COMMENT (
89  pjournal_id        IN NUMBER,
90  pjrnl_comment      OUT NOCOPY VARCHAR2);
91 
92 /*===============================================
93    Added for Item Master Classes/Flexfields.
94   ===============================================*/
95 
96 PROCEDURE GET_SEG_VALUE (pcategory_id        IN NUMBER,
97                      pstructure_id           IN NUMBER,
98                      pcolname                IN VARCHAR2,
99                      pvalue                  OUT NOCOPY VARCHAR2);
100 
101 PROCEDURE GET_ATTRIBUTE_VALUE (pitem_id      IN NUMBER,
102                          pcolname            IN VARCHAR2,
103                          pvalue              OUT NOCOPY VARCHAR2);
104 
105 /*===============================================
106    Added for Lot Conversion for Batches
107   ===============================================*/
108 
109 PROCEDURE GET_BATCH_NO (pbatch_id        IN NUMBER,
110                         pbatch_no        OUT NOCOPY VARCHAR2);
111 
112 
113 /*===============================================
114    Added for PPT Project.
115   ===============================================*/
116 
117 PROCEDURE GET_HOLD_RELEASE_DATE (pitem_id         IN NUMBER,
118                                  plot_id          IN NUMBER,
119                                  phold_date       OUT NOCOPY DATE);
120 
121 
122 END gmi_eres_utils;