APPS.MRP_KANBAN_FUNCTIONS_PK dependencies on INV_KANBAN_PVT

Line 30: l_pull_sequence_rec INV_Kanban_PVT.pull_sequence_rec_type;

26: p_minimum_order_quantity IN NUMBER := FND_API.G_MISS_NUM,
27: p_fixed_lot_multiplier IN NUMBER := FND_API.G_MISS_NUM,
28: p_safety_stock_days IN NUMBER := FND_API.G_MISS_NUM) IS
29:
30: l_pull_sequence_rec INV_Kanban_PVT.pull_sequence_rec_type;
31: l_return_status VARCHAR2(1);
32: BEGIN
33:
34: l_pull_sequence_rec.pull_sequence_id := p_pull_sequence_id;

Line 78: INV_Kanban_PVT.update_pull_sequence(l_return_status,

74: l_pull_sequence_rec.safety_stock_days := p_safety_stock_days;
75: END IF;
76:
77:
78: INV_Kanban_PVT.update_pull_sequence(l_return_status,
79: l_pull_sequence_rec);
80:
81: x_return_status := l_return_status;
82:

Line 110: INV_Kanban_PVT.delete_pull_sequence(l_return_status,

106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_kanban_plan_id IN NUMBER) IS
108: l_return_status VARCHAR2(1);
109: BEGIN
110: INV_Kanban_PVT.delete_pull_sequence(l_return_status,
111: p_kanban_plan_id);
112: x_return_status := l_return_status;
113:
114: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 139: l_Pull_Sequence_Rec INV_Kanban_PVT.Pull_Sequence_Rec_Type;

135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_plan_pull_sequence_id IN NUMBER ) IS
138: l_return_status VARCHAR2(1);
139: l_Pull_Sequence_Rec INV_Kanban_PVT.Pull_Sequence_Rec_Type;
140:
141: BEGIN
142: l_pull_sequence_rec := INV_PullSequence_PKG.Query_Row(p_plan_pull_sequence_id);
143: l_pull_sequence_rec.pull_sequence_id := NULL;

Line 146: INV_Kanban_PVT.Insert_Pull_Sequence(l_return_status,l_pull_sequence_rec);

142: l_pull_sequence_rec := INV_PullSequence_PKG.Query_Row(p_plan_pull_sequence_id);
143: l_pull_sequence_rec.pull_sequence_id := NULL;
144: l_pull_sequence_rec.kanban_plan_id :=-1;
145:
146: INV_Kanban_PVT.Insert_Pull_Sequence(l_return_status,l_pull_sequence_rec);
147:
148: x_return_status := l_return_status;
149:
150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 179: l_pull_seq_tbl INV_Kanban_PVT.Pull_sequence_Id_Tbl_Type;

175:
176: l_pull_seq_id NUMBER;
177: l_counter NUMBER;
178: l_return_status VARCHAR2(1);
179: l_pull_seq_tbl INV_Kanban_PVT.Pull_sequence_Id_Tbl_Type;
180: l_operation_tbl INV_Kanban_PVT.operation_tbl_type;
181:
182: l_update constant number := 0;
183: l_insert constant number := 1;

Line 180: l_operation_tbl INV_Kanban_PVT.operation_tbl_type;

176: l_pull_seq_id NUMBER;
177: l_counter NUMBER;
178: l_return_status VARCHAR2(1);
179: l_pull_seq_tbl INV_Kanban_PVT.Pull_sequence_Id_Tbl_Type;
180: l_operation_tbl INV_Kanban_PVT.operation_tbl_type;
181:
182: l_update constant number := 0;
183: l_insert constant number := 1;
184: l_delplan constant number :=2;

Line 245: INV_Kanban_PVT.Update_Pull_sequence_Tbl (

241:
242: END LOOP;
243:
244: -- call the INV API that updates/inserts
245: INV_Kanban_PVT.Update_Pull_sequence_Tbl (
246: l_return_status,
247: l_pull_seq_tbl,
248: p_update_flag,
249: l_operation_tbl);