[Home] [Help]
PACKAGE: APPS.INV_KANBANCARD_PKG
Source
1 PACKAGE INV_KanbanCard_PKG AUTHID CURRENT_USER as
2 /* $Header: INVKCRDS.pls 115.6 2003/08/20 18:09:55 cjandhya ship $ */
3
4
5 FUNCTION Check_Unique(p_Kanban_Card_Id IN OUT NOCOPY NUMBER,
6 p_Organization_Id NUMBER,
7 p_Kanban_Card_Number VARCHAR2)
8 RETURN BOOLEAN;
9
10 FUNCTION Supply_Status_Change_OK
11 ( p_from_supply_status number,
12 p_to_supply_status number,
13 p_card_status number)
14 RETURN BOOLEAN;
15
16 FUNCTION Query_Row
17 ( p_kanban_card_id IN NUMBER )
18 RETURN INV_Kanban_PVT.Kanban_Card_Rec_Type;
19
20 Procedure commit_row;
21
22 Procedure rollback_row;
23
24 PROCEDURE Insert_Row( x_return_status OUT NOCOPY VARCHAR2,
25 p_Kanban_Card_Id IN OUT NOCOPY NUMBER,
26 p_Kanban_Card_Number IN OUT NOCOPY VARCHAR2,
27 p_Pull_Sequence_Id NUMBER,
28 p_Inventory_item_id NUMBER,
29 p_Organization_id NUMBER,
30 p_Subinventory_name VARCHAR2,
31 p_Supply_Status IN OUT NOCOPY NUMBER,
32 p_Card_Status IN OUT NOCOPY NUMBER,
33 p_Kanban_Card_Type NUMBER,
34 p_Source_type NUMBER,
35 p_Kanban_size NUMBER,
36 p_Last_Update_Date DATE,
37 p_Last_Updated_By NUMBER,
38 p_Creation_Date DATE,
39 p_Created_By NUMBER,
40 p_Last_Update_Login NUMBER,
41 p_Last_Print_Date DATE,
42 p_Locator_id NUMBER,
43 p_Supplier_id NUMBER,
44 p_Supplier_site_id NUMBER,
45 p_Source_Organization_id NUMBER,
46 p_Source_Subinventory VARCHAR2,
47 p_Source_Locator_id NUMBER,
48 p_wip_line_id NUMBER,
49 p_Current_Replnsh_Cycle_Id IN OUT NOCOPY NUMBER,
50 p_Document_Type NUMBER,
51 p_Document_Header_Id NUMBER,
52 p_Document_Detail_Id NUMBER,
53 p_Error_code NUMBER,
54 p_Attribute_Category VARCHAR2,
55 p_Attribute1 VARCHAR2,
56 p_Attribute2 VARCHAR2,
57 p_Attribute3 VARCHAR2,
58 p_Attribute4 VARCHAR2,
59 p_Attribute5 VARCHAR2,
60 p_Attribute6 VARCHAR2,
61 p_Attribute7 VARCHAR2,
62 p_Attribute8 VARCHAR2,
63 p_Attribute9 VARCHAR2,
64 p_Attribute10 VARCHAR2,
65 p_Attribute11 VARCHAR2,
66 p_Attribute12 VARCHAR2,
67 p_Attribute13 VARCHAR2,
68 p_Attribute14 VARCHAR2,
69 p_Attribute15 VARCHAR2,
70 p_Request_Id NUMBER,
71 p_Program_application_Id NUMBER,
72 p_Program_Id NUMBER,
73 p_Program_Update_date DATE,
74 p_release_kanban_flag NUMBER :=1);
75
76 PROCEDURE Lock_Row (p_Kanban_Card_Id NUMBER,
77 p_Kanban_Card_Number VARCHAR2,
78 p_Pull_Sequence_Id NUMBER,
79 p_Inventory_item_id NUMBER,
80 p_Organization_id NUMBER,
81 p_Subinventory_name VARCHAR2,
82 p_Supply_Status NUMBER,
83 p_Card_Status NUMBER,
84 p_Kanban_Card_Type NUMBER,
85 p_Source_type NUMBER,
86 p_Kanban_size NUMBER,
87 p_Last_Print_date DATE,
88 p_Locator_id NUMBER,
89 p_Supplier_id NUMBER,
90 p_Supplier_site_id NUMBER,
91 p_Source_Organization_id NUMBER,
92 p_Source_Subinventory VARCHAR2,
93 p_Source_Locator_id NUMBER,
94 p_wip_line_id NUMBER,
95 p_Current_Replnsh_Cycle_Id NUMBER,
96 p_Error_code NUMBER,
97 p_Attribute_Category VARCHAR2,
98 p_Attribute1 VARCHAR2,
99 p_Attribute2 VARCHAR2,
100 p_Attribute3 VARCHAR2,
101 p_Attribute4 VARCHAR2,
102 p_Attribute5 VARCHAR2,
103 p_Attribute6 VARCHAR2,
104 p_Attribute7 VARCHAR2,
105 p_Attribute8 VARCHAR2,
106 p_Attribute9 VARCHAR2,
107 p_Attribute10 VARCHAR2,
108 p_Attribute11 VARCHAR2,
109 p_Attribute12 VARCHAR2,
110 p_Attribute13 VARCHAR2,
111 p_Attribute14 VARCHAR2,
112 p_Attribute15 VARCHAR2);
113
114 PROCEDURE Update_Row(x_return_status Out NOCOPY VARCHAR2,
115 p_Kanban_Card_Id NUMBER,
116 p_Kanban_Card_Number VARCHAR2,
117 p_Pull_Sequence_Id NUMBER,
118 p_Inventory_item_id NUMBER,
119 p_Organization_id NUMBER,
120 p_Subinventory_name VARCHAR2,
121 p_Supply_Status In OUT NOCOPY NUMBER,
122 p_Card_Status In Out NOCOPY NUMBER,
123 p_Kanban_Card_Type NUMBER,
124 p_Source_type NUMBER,
125 p_Kanban_size NUMBER,
126 p_Last_Update_Date DATE,
127 p_Last_Updated_By NUMBER,
128 p_Creation_Date DATE,
129 p_Created_By NUMBER,
130 p_Last_Update_Login NUMBER,
131 p_Last_Print_Date Date,
132 p_Locator_id NUMBER,
133 p_Supplier_id NUMBER,
134 p_Supplier_site_id NUMBER,
135 p_Source_Organization_id NUMBER,
136 p_Source_Subinventory VARCHAR2,
137 p_Source_Locator_id NUMBER,
138 p_wip_line_id NUMBER,
139 p_Current_Replnsh_Cycle_Id In Out NOCOPY NUMBER,
140 p_Document_Type NUMBER,
141 p_Document_Header_Id NUMBER,
142 p_Document_Detail_Id NUMBER,
143 p_Error_code NUMBER,
144 p_Attribute_Category VARCHAR2,
145 p_Attribute1 VARCHAR2,
146 p_Attribute2 VARCHAR2,
147 p_Attribute3 VARCHAR2,
148 p_Attribute4 VARCHAR2,
149 p_Attribute5 VARCHAR2,
150 p_Attribute6 VARCHAR2,
151 p_Attribute7 VARCHAR2,
152 p_Attribute8 VARCHAR2,
153 p_Attribute9 VARCHAR2,
154 p_Attribute10 VARCHAR2,
155 p_Attribute11 VARCHAR2,
156 p_Attribute12 VARCHAR2,
157 p_Attribute13 VARCHAR2,
158 p_Attribute14 VARCHAR2,
159 p_Attribute15 VARCHAR2,
160 p_lot_item_id NUMBER DEFAULT NULL,
161 p_lot_number VARCHAR2 DEFAULT NULL,
162 p_lot_item_revision VARCHAR2 DEFAULT NULL,
163 p_lot_subinventory_code VARCHAR2 DEFAULT NULL,
164 p_lot_location_id NUMBER DEFAULT NULL,
165 p_lot_quantity NUMBER DEFAULT NULL,
166 p_replenish_quantity NUMBER DEFAULT NULL,
167 p_need_by_date DATE DEFAULT NULL,
168 p_source_wip_entity_id NUMBER DEFAULT NULL);
169
170 PROCEDURE Update_Row(p_Kanban_Card_Rec
171 INV_Kanban_PVT.Kanban_Card_rec_Type);
172
173 PROCEDURE Update_Card_Status(p_Kanban_Card_Rec
174 IN OUT NOCOPY INV_Kanban_PVT.kanban_card_rec_type,
175 p_card_status IN NUMBER);
176
177 PROCEDURE Delete_Row(x_return_status Out NOCOPY Varchar2,
178 p_Kanban_Card_Id Number);
179
180 PROCEDURE Delete_Cards_For_Pull_Seq(p_Pull_Sequence_Id Number);
181
182 PROCEDURE Insert_Activity_For_Card
183 (p_Kanban_Card_Rec INV_Kanban_PVT.Kanban_Card_Rec_Type);
184
185 PROCEDURE Delete_Activity_For_Card(p_Kanban_Card_Id NUMBER);
186
187 PROCEDURE Delete_Activity_For_Pull_Seq(p_Pull_Sequence_Id NUMBER);
188
189 END INV_KanbanCard_PKG;