DBA Data[Home] [Help]

APPS.INV_KANBAN_PKG dependencies on FND_PROFILE

Line 685: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);

681: , x_supply_status_meaning OUT NOCOPY VARCHAR2
682: , p_organization_id IN NUMBER
683: , p_kanban_number IN VARCHAR2) IS
684: l_proc CONSTANT VARCHAR2(30) := 'GET_KANBAN_DETAILS';
685: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
686: CURSOR c_kb_details IS
687: SELECT mkc.kanban_card_type
688: , mkc.card_status
689: , mkc.supply_status

Line 749: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);

745: , x_mo_line_qty_diff OUT NOCOPY NUMBER
746: , p_organization_id IN NUMBER
747: , p_kanban_number IN VARCHAR2) IS
748: l_proc CONSTANT VARCHAR2(30) := 'GET_KANBAN_MO_DETAILS';
749: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
750: -- Bug 4574518, when the kanban card is replenished more than once, there will be more records and the latest record should be used
751: CURSOR c_kb_mo_details IS
752: SELECT * FROM (SELECT m.line_id
753: , m.reference_type_code