APPS.INV_KANBANCARD_PKG dependencies on MTL_KANBAN_CARD_ACTIVITY

Line 1148: UPDATE mtl_kanban_card_activity

1144:
1145: -- Retained old update statement.
1146: mydebug(' Updating the document header id with :' ||
1147: l_kanban_card_rec.document_header_id);
1148: UPDATE mtl_kanban_card_activity
1149: SET document_header_id = l_kanban_card_rec.document_header_id
1150: WHERE
1151: kanban_card_number = l_kanban_card_rec.kanban_card_number AND
1152: supply_status = INV_KANBAN_PVT.G_Supply_Status_InProcess AND

Line 1160: UPDATE mtl_kanban_card_activity

1156: -- Bug Fix: 5344450
1157: -- Added new update statement to update the kanban_size with p_replenish_quantity
1158: mydebug(' Updating the document header id with :' || l_kanban_card_rec.document_header_id||
1159: ' kanban_size : '||p_replenish_quantity);
1160: UPDATE mtl_kanban_card_activity
1161: SET document_header_id = l_kanban_card_rec.document_header_id,
1162: kanban_size = p_replenish_quantity
1163: WHERE
1164: kanban_card_number = l_kanban_card_rec.kanban_card_number AND

Line 1381: INSERT INTO mtl_kanban_card_activity

1377: END delete_row;
1378:
1379: PROCEDURE insert_activity_for_card(p_kanban_card_rec IN inv_kanban_pvt.kanban_card_rec_type) IS
1380: BEGIN
1381: INSERT INTO mtl_kanban_card_activity
1382: (
1383: kanban_activity_id
1384: , replenishment_cycle_id
1385: , kanban_card_id

Line 1435: mtl_kanban_card_activity_s.NEXTVAL

1431: , program_update_date
1432: , source_wip_entity_id
1433: )
1434: VALUES (
1435: mtl_kanban_card_activity_s.NEXTVAL
1436: , NVL(p_kanban_card_rec.current_replnsh_cycle_id, -1)
1437: , p_kanban_card_rec.kanban_card_id
1438: , p_kanban_card_rec.kanban_card_number
1439: , p_kanban_card_rec.inventory_item_id

Line 1516: DELETE FROM mtl_kanban_card_activity

1512: END delete_cards_for_pull_seq;
1513:
1514: PROCEDURE delete_activity_for_card(p_kanban_card_id NUMBER) IS
1515: BEGIN
1516: DELETE FROM mtl_kanban_card_activity
1517: WHERE kanban_card_id = p_kanban_card_id;
1518: EXCEPTION
1519: WHEN fnd_api.g_exc_error THEN
1520: RAISE fnd_api.g_exc_error;

Line 1531: DELETE FROM mtl_kanban_card_activity act

1527: END delete_activity_for_card;
1528:
1529: PROCEDURE delete_activity_for_pull_seq(p_pull_sequence_id NUMBER) IS
1530: BEGIN
1531: DELETE FROM mtl_kanban_card_activity act
1532: WHERE EXISTS(SELECT 'x'
1533: FROM mtl_kanban_cards crd
1534: WHERE crd.kanban_card_id = act.kanban_card_id
1535: AND crd.pull_sequence_id = p_pull_sequence_id);