APPS.INV_PULLSEQUENCE_PKG dependencies on MTL_KANBAN_PULL_SEQUENCES

Line 18: From MTL_KANBAN_PULL_SEQUENCES

14: l_Dummy Varchar2(1);
15: BEGIN
16: Select 'x'
17: Into l_Dummy
18: From MTL_KANBAN_PULL_SEQUENCES
19: Where organization_id = p_Organization_Id
20: And kanban_plan_id = p_kanban_plan_id
21: And inventory_item_id = p_inventory_item_id
22: And subinventory_name = p_Subinventory_Name

Line 178: FROM MTL_KANBAN_PULL_SEQUENCES

174: , l_pull_sequence_rec.point_of_supply_y
175: , l_pull_sequence_rec.planning_update_status
176: , l_pull_sequence_rec.auto_request
177: , l_pull_sequence_rec.auto_allocate_flag --Added for3905884
178: FROM MTL_KANBAN_PULL_SEQUENCES
179: WHERE PULL_SEQUENCE_ID = p_pull_sequence_id
180: ;
181:
182: RETURN l_pull_sequence_rec;

Line 731: l_pull_sequence_Id MTL_Kanban_Pull_Sequences.Pull_Sequence_Id%Type;

727: p_planning_update_status NUMBER DEFAULT NULL,
728: p_auto_request VARCHAR2 DEFAULT NULL,
729: p_Auto_Allocate_Flag NUMBER ) --Bug3905884
730: is
731: l_pull_sequence_Id MTL_Kanban_Pull_Sequences.Pull_Sequence_Id%Type;
732: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
733: BEGIN
734: FND_MSG_PUB.Initialize;
735: If nvl(p_Pull_sequence_Id,0) <= 0

Line 737: Select MTL_KANBAN_PULL_SEQUENCES_S.NEXTVAL

733: BEGIN
734: FND_MSG_PUB.Initialize;
735: If nvl(p_Pull_sequence_Id,0) <= 0
736: Then
737: Select MTL_KANBAN_PULL_SEQUENCES_S.NEXTVAL
738: into l_pull_sequence_Id
739: from dual;
740: Else
741: l_pull_sequence_Id := p_Pull_sequence_Id;

Line 744: INSERT INTO MTL_KANBAN_PULL_SEQUENCES

740: Else
741: l_pull_sequence_Id := p_Pull_sequence_Id;
742: End If;
743:
744: INSERT INTO MTL_KANBAN_PULL_SEQUENCES
745: (
746: Pull_sequence_id,
747: Inventory_item_id,
748: Organization_id,

Line 1036: FROM MTL_KANBAN_PULL_SEQUENCES

1032: p_Auto_Allocate_Flag NUMBER)--Added for 3905884.
1033: IS
1034: CURSOR Get_Current_Row IS
1035: SELECT *
1036: FROM MTL_KANBAN_PULL_SEQUENCES
1037: WHERE pull_sequence_id = p_pull_sequence_id
1038: FOR UPDATE of Organization_Id NOWAIT;
1039:
1040: Recinfo MTL_KANBAN_PULL_SEQUENCES%ROWTYPE;

Line 1040: Recinfo MTL_KANBAN_PULL_SEQUENCES%ROWTYPE;

1036: FROM MTL_KANBAN_PULL_SEQUENCES
1037: WHERE pull_sequence_id = p_pull_sequence_id
1038: FOR UPDATE of Organization_Id NOWAIT;
1039:
1040: Recinfo MTL_KANBAN_PULL_SEQUENCES%ROWTYPE;
1041: RECORD_CHANGED EXCEPTION;
1042: BEGIN
1043: OPEN Get_Current_Row;
1044: FETCH Get_Current_Row INTO Recinfo;

Line 1243: UPDATE MTL_KANBAN_PULL_SEQUENCES

1239: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1240:
1241: BEGIN
1242: FND_MSG_PUB.Initialize;
1243: UPDATE MTL_KANBAN_PULL_SEQUENCES
1244: SET
1245: Inventory_item_id = p_Inventory_item_id,
1246: Organization_Id = p_Organization_Id,
1247: Subinventory_name = p_Subinventory_name,

Line 1433: DELETE FROM MTL_KANBAN_PULL_SEQUENCES

1429: FND_MSG_PUB.Initialize;
1430: if INV_Kanban_PVT.Ok_To_Delete_Pull_Sequence(p_pull_sequence_Id)
1431: then
1432:
1433: DELETE FROM MTL_KANBAN_PULL_SEQUENCES
1434: WHERE pull_sequence_id = p_pull_sequence_id;
1435:
1436: if (SQL%NOTFOUND) then
1437: Raise FND_API.G_EXC_UNEXPECTED_ERROR;