1 PACKAGE EAM_DIRECT_ITEMS_PKG_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVDIPS.pls 120.1 2005/09/22 23:13:27 grajan noship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- EAMVDIPS.pls
11 --
12 -- DESCRIPTION
13 --
14 -- Spec of package EAM_DIRECT_ITEMS_PKG_PVT
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 01-OCT-2003 Basanth Roy Initial Creation
21 ***************************************************************************/
22
23
24 PROCEDURE Insert_Row
25 ( X_DESCRIPTION IN VARCHAR2 ,
26 X_DIRECT_ITEM_TYPE IN NUMBER ,
27 X_PURCHASING_CATEGORY_ID IN NUMBER ,
28 X_DIRECT_ITEM_SEQUENCE_ID IN OUT NOCOPY NUMBER, -- Fix for Bug 3745360
29 X_INVENTORY_ITEM_ID IN NUMBER ,
30 X_OPERATION_SEQ_NUM IN NUMBER ,
31 X_DEPARTMENT_ID IN NUMBER ,
32 X_WIP_ENTITY_ID IN NUMBER ,
33 X_ORGANIZATION_ID IN NUMBER ,
34 X_SUGGESTED_VENDOR_NAME IN VARCHAR2 ,
35 X_SUGGESTED_VENDOR_ID IN NUMBER ,
36 X_SUGGESTED_VENDOR_SITE IN VARCHAR2 ,
37 X_SUGGESTED_VENDOR_SITE_ID IN NUMBER ,
38 X_SUGGESTED_VENDOR_CONTACT IN VARCHAR2 ,
39 X_SUGGESTED_VENDOR_CONTACT_ID IN NUMBER ,
40 X_SUGGESTED_VENDOR_PHONE IN VARCHAR2 ,
41 X_SUGGESTED_VENDOR_ITEM_NUM IN VARCHAR2 ,
42 X_UNIT_PRICE IN NUMBER ,
43 X_AUTO_REQUEST_MATERIAL IN VARCHAR2 ,
44 X_REQUIRED_QUANTITY IN NUMBER ,
45 X_UOM IN VARCHAR2 ,
46 X_NEED_BY_DATE IN DATE ,
47 X_ATTRIBUTE_CATEGORY IN VARCHAR2 ,
48 X_ATTRIBUTE1 IN VARCHAR2 ,
49 X_ATTRIBUTE2 IN VARCHAR2 ,
50 X_ATTRIBUTE3 IN VARCHAR2 ,
51 X_ATTRIBUTE4 IN VARCHAR2 ,
52 X_ATTRIBUTE5 IN VARCHAR2 ,
53 X_ATTRIBUTE6 IN VARCHAR2 ,
54 X_ATTRIBUTE7 IN VARCHAR2 ,
55 X_ATTRIBUTE8 IN VARCHAR2 ,
56 X_ATTRIBUTE9 IN VARCHAR2 ,
57 X_ATTRIBUTE10 IN VARCHAR2 ,
58 X_ATTRIBUTE11 IN VARCHAR2 ,
59 X_ATTRIBUTE12 IN VARCHAR2 ,
60 X_ATTRIBUTE13 IN VARCHAR2 ,
61 X_ATTRIBUTE14 IN VARCHAR2 ,
62 X_ATTRIBUTE15 IN VARCHAR2 ,
63 X_PROGRAM_APPLICATION_ID IN NUMBER ,
64 X_PROGRAM_ID IN NUMBER ,
65 X_PROGRAM_UPDATE_DATE IN DATE ,
66 X_REQUEST_ID IN NUMBER ,
67 x_return_Status OUT NOCOPY VARCHAR2,
68 x_material_shortage_flag OUT NOCOPY VARCHAR2,
69 x_material_shortage_check_date OUT NOCOPY DATE
70 );
71
72
73 PROCEDURE Delete_Row
74 ( X_DIRECT_ITEM_TYPE IN NUMBER,
75 X_DIRECT_ITEM_SEQUENCE_ID IN NUMBER,
76 X_INVENTORY_ITEM_ID IN NUMBER,
77 X_OPERATION_SEQ_NUM IN NUMBER,
78 X_WIP_ENTITY_ID IN NUMBER,
79 X_ORGANIZATION_ID IN NUMBER,
80 x_return_Status OUT NOCOPY VARCHAR2,
81 x_material_shortage_flag OUT NOCOPY VARCHAR2,
82 x_material_shortage_check_date OUT NOCOPY DATE
83 );
84
85 PROCEDURE Update_Row
86 ( X_DESCRIPTION IN VARCHAR2 ,
87 X_DIRECT_ITEM_TYPE IN NUMBER ,
88 X_PURCHASING_CATEGORY_ID IN NUMBER ,
89 X_DIRECT_ITEM_SEQUENCE_ID IN NUMBER ,
90 X_INVENTORY_ITEM_ID IN NUMBER ,
91 X_OPERATION_SEQ_NUM IN NUMBER ,
92 X_DEPARTMENT_ID IN NUMBER ,
93 X_WIP_ENTITY_ID IN NUMBER ,
94 X_ORGANIZATION_ID IN NUMBER ,
95 X_SUGGESTED_VENDOR_NAME IN VARCHAR2 ,
96 X_SUGGESTED_VENDOR_ID IN NUMBER ,
97 X_SUGGESTED_VENDOR_SITE IN VARCHAR2 ,
98 X_SUGGESTED_VENDOR_SITE_ID IN NUMBER ,
99 X_SUGGESTED_VENDOR_CONTACT IN VARCHAR2 ,
100 X_SUGGESTED_VENDOR_CONTACT_ID IN NUMBER ,
101 X_SUGGESTED_VENDOR_PHONE IN VARCHAR2 ,
102 X_SUGGESTED_VENDOR_ITEM_NUM IN VARCHAR2 ,
103 X_UNIT_PRICE IN NUMBER ,
104 X_AUTO_REQUEST_MATERIAL IN VARCHAR2 ,
105 X_REQUIRED_QUANTITY IN NUMBER ,
106 X_UOM IN VARCHAR2 ,
107 X_NEED_BY_DATE IN DATE ,
108 X_ATTRIBUTE_CATEGORY IN VARCHAR2 ,
109 X_ATTRIBUTE1 IN VARCHAR2 ,
110 X_ATTRIBUTE2 IN VARCHAR2 ,
111 X_ATTRIBUTE3 IN VARCHAR2 ,
112 X_ATTRIBUTE4 IN VARCHAR2 ,
113 X_ATTRIBUTE5 IN VARCHAR2 ,
114 X_ATTRIBUTE6 IN VARCHAR2 ,
115 X_ATTRIBUTE7 IN VARCHAR2 ,
116 X_ATTRIBUTE8 IN VARCHAR2 ,
117 X_ATTRIBUTE9 IN VARCHAR2 ,
118 X_ATTRIBUTE10 IN VARCHAR2 ,
119 X_ATTRIBUTE11 IN VARCHAR2 ,
120 X_ATTRIBUTE12 IN VARCHAR2 ,
121 X_ATTRIBUTE13 IN VARCHAR2 ,
122 X_ATTRIBUTE14 IN VARCHAR2 ,
123 X_ATTRIBUTE15 IN VARCHAR2 ,
124 X_PROGRAM_APPLICATION_ID IN NUMBER ,
125 X_PROGRAM_ID IN NUMBER ,
126 X_PROGRAM_UPDATE_DATE IN DATE ,
127 X_REQUEST_ID IN NUMBER ,
128 x_return_Status OUT NOCOPY VARCHAR2,
129 x_material_shortage_flag OUT NOCOPY VARCHAR2,
130 x_material_shortage_check_date OUT NOCOPY DATE
131 );
132
133 --Fix for 3352406.Added the following procedure to show the messages from the api
134 PROCEDURE show_mesg;
135
136
137
138 END EAM_DIRECT_ITEMS_PKG_PVT;