DBA Data[Home] [Help]

APPS.MRP_KANBAN_FUNCTIONS_PK dependencies on INV_PULLSEQUENCE_PKG

Line 142: l_pull_sequence_rec := INV_PullSequence_PKG.Query_Row(p_plan_pull_sequence_id);

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;
144: l_pull_sequence_rec.kanban_plan_id :=-1;
145:
146: INV_Kanban_PVT.Insert_Pull_Sequence(l_return_status,l_pull_sequence_rec);

Line 223: INV_pullsequence_PKG.delete_row(l_return_status,l_prod_pull_sequence_id);

219: FROM MTL_KANBAN_CARDS
220: WHERE pull_sequence_id = l_prod_pull_sequence_id;
221: end if;
222: if( (l_flag=l_delplanprodcards ) or ( l_flag = l_delplanprod) ) then -- Delete Production
223: INV_pullsequence_PKG.delete_row(l_return_status,l_prod_pull_sequence_id);
224: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
225: RAISE FND_API.G_EXC_ERROR;
226: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 233: INV_pullsequence_pkg.delete_row(l_return_status,l_pull_seq_id);

229:
230: end if;
231: -- Delete planning pull sequence
232:
233: INV_pullsequence_pkg.delete_row(l_return_status,l_pull_seq_id);
234: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
235: RAISE FND_API.G_EXC_ERROR;
236: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;