APPS.FLM_KANBANCARD_PUB dependencies on INV_KANBANCARD_PKG

Line 143: l_kanban_card_rec := inv_kanbancard_pkg.query_row(p_kanban_card_id => p_kanban_id);

139: X_RETCODE := 'E';
140: return;
141: end if;
142:
143: l_kanban_card_rec := inv_kanbancard_pkg.query_row(p_kanban_card_id => p_kanban_id);
144:
145: if l_kanban_card_rec.supply_status = nvl(p_supply_status_to,l_kanban_card_rec.supply_status) and
146: l_kanban_card_rec.card_status = nvl(p_card_status_to,l_kanban_card_rec.card_status) then
147: -- Invalid parameters passed to supply status APIs.

Line 461: INV_KanbanCard_PKG.insert_row( x_return_status => l_return_status

457: X_RETCODE := 'E';
458: return;
459: end if;
460: end if;
461: INV_KanbanCard_PKG.insert_row( x_return_status => l_return_status
462: , p_kanban_card_id => l_new_card_id
463: , p_kanban_card_number => l_new_card_number
464: , p_pull_sequence_id => l_pull_seq_rec.Pull_Sequence_Id
465: , p_inventory_item_id => l_pull_seq_rec.Inventory_item_id

Line 534: inv_kanbancard_pkg.update_row(x_return_status => l_return_status

530: end if;
531: else
532: if l_card_status_to <> INV_Kanban_PVT.G_Card_Status_Cancel and
533: nvl(p_verify,'N') = 'N' then
534: inv_kanbancard_pkg.update_row(x_return_status => l_return_status
535: , p_kanban_card_id => p_kanban_card_id
536: , p_kanban_card_number => p_kanban_card_number
537: , p_pull_sequence_id => p_pull_sequence_id
538: , p_inventory_item_id => p_inventory_item_id

Line 602: inv_kanbancard_pkg.update_row(x_return_status => l_return_status

598: end if;
599: end if;
600: else
601: if nvl(p_verify,'N') = 'N' then
602: inv_kanbancard_pkg.update_row(x_return_status => l_return_status
603: , p_kanban_card_id => p_kanban_card_id
604: , p_kanban_card_number => p_kanban_card_number
605: , p_pull_sequence_id => p_pull_sequence_id
606: , p_inventory_item_id => p_inventory_item_id

Line 677: inv_kanbancard_pkg.update_row(

673: return;
674: -- other status changes.
675: else
676: if nvl(p_verify,'N') = 'N' then
677: inv_kanbancard_pkg.update_row(
678: x_return_status => l_return_status
679: , p_kanban_card_id => p_kanban_card_id
680: , p_kanban_card_number => p_kanban_card_number
681: , p_pull_sequence_id => p_pull_sequence_id

Line 786: inv_kanbancard_pkg.update_row(

782: return;
783: end if;
784: if nvl(p_verify,'N') = 'N' then
785: l_supply_status_to := p_supply_status;
786: inv_kanbancard_pkg.update_row(
787: x_return_status => l_return_status
788: , p_kanban_card_id => p_kanban_card_id
789: , p_kanban_card_number => p_kanban_card_number
790: , p_pull_sequence_id => p_pull_sequence_id

Line 862: inv_kanbancard_pkg.update_row(

858: end if;
859: if p_card_status = nvl(l_card_status_to,p_card_status) and
860: p_supply_status = nvl(p_supply_status_to,p_supply_status) then
861: if nvl(p_verify,'N') = 'N' then
862: inv_kanbancard_pkg.update_row(
863: x_return_status => l_return_status
864: , p_kanban_card_id => p_kanban_card_id
865: , p_kanban_card_number => p_kanban_card_number
866: , p_pull_sequence_id => p_pull_sequence_id

Line 945: if inv_kanbancard_pkg.supply_status_change_ok(p_kanban_card_id => P_KANBAN_ID,

941: P_SUPPLY_STATUS_TO IN NUMBER)
942: Return NUMBER
943: IS
944: Begin
945: if inv_kanbancard_pkg.supply_status_change_ok(p_kanban_card_id => P_KANBAN_ID,
946: p_from_supply_status => P_SUPPLY_STATUS_FROM,
947: p_to_supply_status => P_SUPPLY_STATUS_TO,
948: p_card_status => null) then
949: return 1;

Line 990: l_kanban_card_rec := inv_kanbancard_pkg.query_row(p_Kanban_Card_Id => p_Kanban_Card_Id);

986: /* In case of production kanban current completed qty is always passed */
987: l_replenish_quantity := nvl (p_replenish_quantity,0);
988:
989: mydebug('In change_card_status_full: kanban card id='||p_Kanban_Card_Id||', replenish_quantity='||l_replenish_quantity);
990: l_kanban_card_rec := inv_kanbancard_pkg.query_row(p_Kanban_Card_Id => p_Kanban_Card_Id);
991:
992: -- if kanban card supply status is already full and receiving more qty or doing a return then return a message no status change
993: if (trunc(l_kanban_card_rec.supply_status) = INV_KANBAN_PVT.G_Supply_Status_Full or l_replenish_quantity < 0) then
994: fnd_message.set_name('FLM', 'FLM_KBN_CARD_STATUS_NOCHANGE');