APPS.INV_KANBAN_PVT dependencies on INV_PULLSEQUENCE_PKG

Line 141: INV_PullSequence_Pkg.delete_Row(l_return_status,pull_sequences.pull_sequence_id);

137: For pull_sequences in get_pull_sequences
138: loop
139: If Ok_To_Delete_Pull_Sequence(pull_sequences.pull_sequence_id)
140: then
141: INV_PullSequence_Pkg.delete_Row(l_return_status,pull_sequences.pull_sequence_id);
142: Else
143: Raise FND_API.G_EXC_ERROR;
144: end if;
145: end loop;

Line 280: l_Pull_Sequence_Rec := INV_PullSequence_PKG.Convert_Miss_To_Null

276: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
277: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
278: Begin
279: FND_MSG_PUB.initialize;
280: l_Pull_Sequence_Rec := INV_PullSequence_PKG.Convert_Miss_To_Null
281: (p_Pull_Sequence_Rec);
282:
283: Validate_Pull_sequence(l_pull_sequence_rec);
284:

Line 291: INV_PullSequence_PKG.Insert_Row(l_pull_sequence_rec);

287: l_pull_sequence_rec.last_update_date := SYSDATE;
288: l_pull_sequence_rec.last_updated_by := FND_GLOBAL.USER_ID;
289: l_pull_sequence_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
290:
291: INV_PullSequence_PKG.Insert_Row(l_pull_sequence_rec);
292:
293: x_return_status := l_return_status;
294:
295: EXCEPTION

Line 422: l_old_pull_sequence_rec := INV_PullSequence_PKG.Query_Row (p_pull_sequence_id =>

418:
419: END IF;
420: -- dbms_output.put_line('pull:'||to_char(l_pull_sequence_rec.pull_sequence_id));
421:
422: l_old_pull_sequence_rec := INV_PullSequence_PKG.Query_Row (p_pull_sequence_id =>
423: l_pull_sequence_rec.pull_sequence_id);
424: l_pull_sequence_rec := INV_PullSequence_Pkg.Complete_Record
425: ( p_pull_sequence_rec => l_pull_sequence_rec
426: , p_old_pull_sequence_rec => l_old_pull_sequence_rec

Line 424: l_pull_sequence_rec := INV_PullSequence_Pkg.Complete_Record

420: -- dbms_output.put_line('pull:'||to_char(l_pull_sequence_rec.pull_sequence_id));
421:
422: l_old_pull_sequence_rec := INV_PullSequence_PKG.Query_Row (p_pull_sequence_id =>
423: l_pull_sequence_rec.pull_sequence_id);
424: l_pull_sequence_rec := INV_PullSequence_Pkg.Complete_Record
425: ( p_pull_sequence_rec => l_pull_sequence_rec
426: , p_old_pull_sequence_rec => l_old_pull_sequence_rec
427: );
428: Validate_Pull_sequence(l_Pull_sequence_rec);

Line 434: INV_PullSequence_PKG.Update_Row(l_pull_sequence_Rec);

430: l_pull_sequence_rec.last_update_date := SYSDATE;
431: l_pull_sequence_rec.last_updated_by := FND_GLOBAL.USER_ID;
432: l_pull_sequence_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
433:
434: INV_PullSequence_PKG.Update_Row(l_pull_sequence_Rec);
435:
436: x_return_status := l_return_status;
437:
438: x_pull_sequence_rec := l_Pull_Sequence_Rec;

Line 506: l_pull_sequence_rec := INV_PullSequence_PKG.Query_Row

502: SELECT MTL_KANBAN_CARD_PRINT_TEMP_S.nextval
503: INTO l_report_print_id from DUAL;
504:
505: FOR l_record_count in 1 ..l_PullSeqtable.Count LOOP
506: l_pull_sequence_rec := INV_PullSequence_PKG.Query_Row
507: ( p_pull_sequence_id =>
508: l_PullSeqtable(l_record_count));
509: l_pull_sequence_rec.kanban_plan_id := -1;
510: IF X_UPDATE_FLAG = 'Y' THEN