APPS.INV_KANBANCARD_PKG dependencies on MTL_KANBAN_CARD_ACTIVITY

Line 1313: UPDATE mtl_kanban_card_activity

1309:
1310: -- Retained old update statement.
1311: mydebug(' Updating the document header id with :' ||
1312: l_kanban_card_rec.document_header_id);
1313: UPDATE mtl_kanban_card_activity
1314: SET document_header_id = l_kanban_card_rec.document_header_id
1315: WHERE
1316: kanban_card_number = l_kanban_card_rec.kanban_card_number AND
1317: trunc(supply_status) = INV_KANBAN_PVT.G_Supply_Status_InProcess AND

Line 1325: UPDATE mtl_kanban_card_activity

1321: -- Bug Fix: 5344450
1322: -- Added new update statement to update the kanban_size with p_replenish_quantity
1323: mydebug(' Updating the document header id with :' || l_kanban_card_rec.document_header_id||
1324: ' kanban_size : '||p_replenish_quantity);
1325: UPDATE mtl_kanban_card_activity
1326: SET document_header_id = l_kanban_card_rec.document_header_id,
1327: kanban_size = p_replenish_quantity
1328: WHERE
1329: kanban_card_number = l_kanban_card_rec.kanban_card_number AND

Line 1559: INSERT INTO mtl_kanban_card_activity

1555: END delete_row;
1556:
1557: PROCEDURE insert_activity_for_card(p_kanban_card_rec IN inv_kanban_pvt.kanban_card_rec_type) IS
1558: BEGIN
1559: INSERT INTO mtl_kanban_card_activity
1560: (
1561: kanban_activity_id
1562: , replenishment_cycle_id
1563: , kanban_card_id

Line 1613: mtl_kanban_card_activity_s.NEXTVAL

1609: , program_update_date
1610: , source_wip_entity_id
1611: )
1612: VALUES (
1613: mtl_kanban_card_activity_s.NEXTVAL
1614: , NVL(p_kanban_card_rec.current_replnsh_cycle_id, -1)
1615: , p_kanban_card_rec.kanban_card_id
1616: , p_kanban_card_rec.kanban_card_number
1617: , p_kanban_card_rec.inventory_item_id

Line 1694: DELETE FROM mtl_kanban_card_activity

1690: END delete_cards_for_pull_seq;
1691:
1692: PROCEDURE delete_activity_for_card(p_kanban_card_id NUMBER) IS
1693: BEGIN
1694: DELETE FROM mtl_kanban_card_activity
1695: WHERE kanban_card_id = p_kanban_card_id;
1696: EXCEPTION
1697: WHEN fnd_api.g_exc_error THEN
1698: RAISE fnd_api.g_exc_error;

Line 1709: DELETE FROM mtl_kanban_card_activity act

1705: END delete_activity_for_card;
1706:
1707: PROCEDURE delete_activity_for_pull_seq(p_pull_sequence_id NUMBER) IS
1708: BEGIN
1709: DELETE FROM mtl_kanban_card_activity act
1710: WHERE EXISTS(SELECT 'x'
1711: FROM mtl_kanban_cards crd
1712: WHERE crd.kanban_card_id = act.kanban_card_id
1713: AND crd.pull_sequence_id = p_pull_sequence_id);

Line 2526: UPDATE mtl_kanban_card_activity

2522:
2523: -- Retained old update statement.
2524: mydebug(' Updating the document header id with :' ||
2525: l_kanban_card_rec.document_header_id);
2526: UPDATE mtl_kanban_card_activity
2527: SET document_header_id = l_kanban_card_rec.document_header_id
2528: WHERE
2529: kanban_card_number = l_kanban_card_rec.kanban_card_number AND
2530: supply_status = INV_KANBAN_PVT.G_Supply_Status_InProcess AND

Line 2538: UPDATE mtl_kanban_card_activity

2534: -- Bug Fix: 5344450
2535: -- Added new update statement to update the kanban_size with p_replenish_quantity
2536: mydebug(' Updating the document header id with :' || l_kanban_card_rec.document_header_id||
2537: ' kanban_size : '||p_replenish_quantity);
2538: UPDATE mtl_kanban_card_activity
2539: SET document_header_id = l_kanban_card_rec.document_header_id,
2540: kanban_size = p_replenish_quantity
2541: WHERE
2542: kanban_card_number = l_kanban_card_rec.kanban_card_number AND