eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_KANBAN_PVT dependencies on INV_KANBANCARD_PKG

Line 755: l_kanban_card_rec := INV_KanbanCard_PKG.Query_Row

751: FND_MSG_PUB.Add;
752: l_return_status := FND_API.G_RET_STS_ERROR;
753: ELSE
754:
755: l_kanban_card_rec := INV_KanbanCard_PKG.Query_Row
756: ( p_Kanban_Card_id => p_kanban_Card_Id);
757:
758: --Bug 3288422 fix. Preventing replenishment 1) If lock cannot be
759: --acquired on the kanban_card_record 2) if the card is in hold

Line 791: IF INV_KanbanCard_PKG.Supply_Status_Change_OK

787: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_REPL_CANCEL_CARD');
788: FND_MSG_PUB.ADD;
789: --Bug 3288422 fix.
790: ELSE
791: IF INV_KanbanCard_PKG.Supply_Status_Change_OK
792: (trunc(l_kanban_card_rec.supply_status),
793: p_supply_status,
794: l_kanban_card_rec.card_status)
795: THEN

Line 825: mydebug('calling INV_KanbanCard_PKG.Update_Row');

821: l_kanban_card_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
822: l_kanban_card_rec.replenish_quantity := p_replenish_quantity;
823: l_kanban_card_rec.need_by_date := p_need_by_date;
824: l_kanban_card_rec.source_wip_entity_id := p_source_wip_entity_id;
825: mydebug('calling INV_KanbanCard_PKG.Update_Row');
826: INV_KanbanCard_PKG.Update_Row(l_kanban_card_rec);
827: END IF;
828: ELSE
829: mydebug('Supply status change not OK');

Line 826: INV_KanbanCard_PKG.Update_Row(l_kanban_card_rec);

822: l_kanban_card_rec.replenish_quantity := p_replenish_quantity;
823: l_kanban_card_rec.need_by_date := p_need_by_date;
824: l_kanban_card_rec.source_wip_entity_id := p_source_wip_entity_id;
825: mydebug('calling INV_KanbanCard_PKG.Update_Row');
826: INV_KanbanCard_PKG.Update_Row(l_kanban_card_rec);
827: END IF;
828: ELSE
829: mydebug('Supply status change not OK');
830: If l_kanban_card_rec.card_status in

Line 838: END IF;--IF INV_KanbanCard_PKG.Supply_Status_Change_OK

834: FND_MESSAGE.SET_TOKEN('CARD_NUMBER',l_kanban_card_rec.kanban_card_number);
835: End If;
836: l_return_status := FND_API.G_RET_STS_ERROR;
837: FND_MSG_PUB.Add;
838: END IF;--IF INV_KanbanCard_PKG.Supply_Status_Change_OK
839: END IF;--IF l_return_status = FND_API.g_ret_sts_error
840: END IF;--IF p_Kanban_Card_Id is NULL THEN
841:
842: IF l_return_status = FND_API.g_ret_sts_error THEN

Line 1479: INV_KanbanCard_PKG.Delete_Cards_For_Pull_Seq(p_pull_sequence_id);

1475: IS
1476: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1477: BEGIN
1478:
1479: INV_KanbanCard_PKG.Delete_Cards_For_Pull_Seq(p_pull_sequence_id);
1480:
1481: END Delete_Kanban_Cards;
1482: --
1483: --

Line 1636: INV_KanbanCard_PKG.Insert_Row(

1632: else
1633: l_supplier_id:= p_Pull_Sequence_Rec.Supplier_id;
1634: l_supp_site_id:= p_Pull_Sequence_Rec.Supplier_site_id;
1635: end if;
1636: INV_KanbanCard_PKG.Insert_Row(
1637: X_Return_Status => l_Return_Status,
1638: P_Kanban_Card_Id => l_Kanban_Card_Id,
1639: P_Kanban_Card_Number => l_Kanban_Card_Number,
1640: P_Pull_Sequence_Id => p_Pull_Sequence_Rec.Pull_Sequence_Id,

Line 1835: INV_KanbanCard_PKG.Insert_Row(

1831: loop
1832: l_Kanban_Card_Id := p_kanban_card_id;
1833: l_Kanban_Card_Number := p_kanban_card_number;
1834:
1835: INV_KanbanCard_PKG.Insert_Row(
1836: X_Return_Status => l_Return_Status,
1837: P_Kanban_Card_Id => l_Kanban_Card_Id,
1838: P_Kanban_Card_Number => l_Kanban_Card_Number,
1839: P_Pull_Sequence_Id => p_Pull_Sequence_Rec.Pull_Sequence_Id,

Line 3844: l_kanban_card_rec := INV_KanbanCard_PKG.Query_Row( p_Kanban_Card_id => l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id);

3840: Last_Updated_By = FND_GLOBAL.USER_ID
3841: Where Kanban_Card_Id = l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id;
3842:
3843: l_Kanban_Card_Rec.Kanban_card_Id := l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id;
3844: l_kanban_card_rec := INV_KanbanCard_PKG.Query_Row( p_Kanban_Card_id => l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id);
3845: l_kanban_card_rec.document_type := l_Kanban_card_Tbl(l_Card_Count).document_type;
3846: l_kanban_card_rec.document_header_id := l_Kanban_card_Tbl(l_Card_Count).document_header_id;
3847: l_kanban_card_rec.document_detail_id := l_Kanban_card_Tbl(l_Card_Count).document_detail_id;
3848:

Line 3849: INV_KanbanCard_PKG.Insert_Activity_For_Card(l_Kanban_Card_Rec);

3845: l_kanban_card_rec.document_type := l_Kanban_card_Tbl(l_Card_Count).document_type;
3846: l_kanban_card_rec.document_header_id := l_Kanban_card_Tbl(l_Card_Count).document_header_id;
3847: l_kanban_card_rec.document_detail_id := l_Kanban_card_Tbl(l_Card_Count).document_detail_id;
3848:
3849: INV_KanbanCard_PKG.Insert_Activity_For_Card(l_Kanban_Card_Rec);
3850: End Loop;
3851: else
3852: For l_card_Count in 1..l_Wait_Kanban_card_Tbl.Count Loop
3853: l_order_count := l_order_count + 1;

Line 3864: l_kanban_card_rec := INV_KanbanCard_PKG.Query_Row( p_Kanban_Card_id => l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id);

3860: Set Supply_Status = INV_Kanban_PVT.G_Supply_Status_Consolidate,
3861: Last_Update_Date = SYSDATE,
3862: Last_Updated_By = FND_GLOBAL.USER_ID
3863: Where Kanban_Card_Id = l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id;
3864: l_kanban_card_rec := INV_KanbanCard_PKG.Query_Row( p_Kanban_Card_id => l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id);
3865: INV_KanbanCard_PKG.Insert_Activity_For_Card(l_Kanban_Card_Rec);
3866: End Loop;
3867: X_Supply_Status := INV_Kanban_PVT.G_Supply_Status_Consolidate;
3868: X_Current_Replenish_Cycle_Id := Null;

Line 3865: INV_KanbanCard_PKG.Insert_Activity_For_Card(l_Kanban_Card_Rec);

3861: Last_Update_Date = SYSDATE,
3862: Last_Updated_By = FND_GLOBAL.USER_ID
3863: Where Kanban_Card_Id = l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id;
3864: l_kanban_card_rec := INV_KanbanCard_PKG.Query_Row( p_Kanban_Card_id => l_Kanban_card_Tbl(l_Card_Count).Kanban_card_Id);
3865: INV_KanbanCard_PKG.Insert_Activity_For_Card(l_Kanban_Card_Rec);
3866: End Loop;
3867: X_Supply_Status := INV_Kanban_PVT.G_Supply_Status_Consolidate;
3868: X_Current_Replenish_Cycle_Id := Null;
3869: end if;

Line 3965: l_kanban_card_rec := inv_kanbancard_pkg.query_row(kanban_cards_ids.kanban_card_id);

3961: BEGIN
3962:
3963: for kanban_cards_ids in get_kanban_card_ids
3964: LOOP
3965: l_kanban_card_rec := inv_kanbancard_pkg.query_row(kanban_cards_ids.kanban_card_id);
3966: inv_kanbancard_pkg.update_card_status
3967: (p_kanban_card_rec =>l_kanban_card_rec,
3968: p_card_status => p_card_status);
3969: END LOOP;

Line 3966: inv_kanbancard_pkg.update_card_status

3962:
3963: for kanban_cards_ids in get_kanban_card_ids
3964: LOOP
3965: l_kanban_card_rec := inv_kanbancard_pkg.query_row(kanban_cards_ids.kanban_card_id);
3966: inv_kanbancard_pkg.update_card_status
3967: (p_kanban_card_rec =>l_kanban_card_rec,
3968: p_card_status => p_card_status);
3969: END LOOP;
3970: