APPS.INV_KANBANCARD_PKG dependencies on MTL_KANBAN_CARDS

Line 75: FROM mtl_kanban_cards

71: l_dummy VARCHAR2(1);
72: BEGIN
73: SELECT 'X'
74: INTO l_dummy
75: FROM mtl_kanban_cards
76: WHERE organization_id = p_organization_id
77: AND kanban_card_number = p_kanban_card_number
78: AND((p_kanban_card_id IS NULL)
79: OR(kanban_card_id <> p_kanban_card_id));

Line 187: FROM mtl_kanban_cards

183: , l_kanban_card_rec.request_id
184: , l_kanban_card_rec.program_application_id
185: , l_kanban_card_rec.program_id
186: , l_kanban_card_rec.program_update_date
187: FROM mtl_kanban_cards
188: WHERE kanban_card_id = p_kanban_card_id;
189:
190: l_kanban_card_rec.document_type := NULL;
191: l_kanban_card_rec.document_header_id := NULL;

Line 494: SELECT mtl_kanban_cards_s.NEXTVAL

490: BEGIN
491: fnd_msg_pub.initialize;
492:
493: WHILE NOT l_kanban_card_number_ok LOOP
494: SELECT mtl_kanban_cards_s.NEXTVAL
495: INTO l_kanban_card_rec.kanban_card_id
496: FROM DUAL;
497:
498: IF p_kanban_card_number IS NULL THEN

Line 502: FROM mtl_kanban_cards

498: IF p_kanban_card_number IS NULL THEN
499: BEGIN
500: SELECT 'X'
501: INTO l_dummy
502: FROM mtl_kanban_cards
503: WHERE kanban_card_number = TO_CHAR(l_kanban_card_rec.kanban_card_id)
504: AND organization_id = p_organization_id;
505: EXCEPTION
506: WHEN NO_DATA_FOUND THEN

Line 568: INSERT INTO mtl_kanban_cards

564: l_kanban_card_rec.program_application_id := p_program_application_id;
565: l_kanban_card_rec.program_id := p_program_id;
566: l_kanban_card_rec.program_update_date := p_program_update_date;
567:
568: INSERT INTO mtl_kanban_cards
569: (
570: kanban_card_id
571: , kanban_card_number
572: , pull_sequence_id

Line 804: FROM mtl_kanban_cards

800: , p_attribute15 VARCHAR2
801: ) IS
802: CURSOR get_current_row IS
803: SELECT *
804: FROM mtl_kanban_cards
805: WHERE kanban_card_id = p_kanban_card_id
806: FOR UPDATE OF organization_id NOWAIT;
807:
808: recinfo mtl_kanban_cards%ROWTYPE;

Line 808: recinfo mtl_kanban_cards%ROWTYPE;

804: FROM mtl_kanban_cards
805: WHERE kanban_card_id = p_kanban_card_id
806: FOR UPDATE OF organization_id NOWAIT;
807:
808: recinfo mtl_kanban_cards%ROWTYPE;
809: record_changed EXCEPTION;
810: BEGIN
811: OPEN get_current_row;
812: FETCH get_current_row INTO recinfo;

Line 1086: UPDATE mtl_kanban_cards

1082: l_kanban_card_rec.supply_status := l_supply_status;
1083: l_kanban_card_rec.current_replnsh_cycle_id := l_current_replenish_cycle_id;
1084: END IF;
1085:
1086: UPDATE mtl_kanban_cards
1087: SET pull_sequence_id = l_kanban_card_rec.pull_sequence_id
1088: , inventory_item_id = l_kanban_card_rec.inventory_item_id
1089: , organization_id = l_kanban_card_rec.organization_id
1090: , subinventory_name = l_kanban_card_rec.subinventory_name

Line 1357: DELETE FROM mtl_kanban_cards

1353:
1354: PROCEDURE delete_row(x_return_status OUT NOCOPY VARCHAR2, p_kanban_card_id NUMBER) IS
1355: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1356: BEGIN
1357: DELETE FROM mtl_kanban_cards
1358: WHERE kanban_card_id = p_kanban_card_id;
1359:
1360: IF (SQL%NOTFOUND) THEN
1361: RAISE NO_DATA_FOUND;

Line 1501: DELETE FROM mtl_kanban_cards

1497: PROCEDURE delete_cards_for_pull_seq(p_pull_sequence_id NUMBER) IS
1498: BEGIN
1499: inv_kanbancard_pkg.delete_activity_for_pull_seq(p_pull_sequence_id);
1500:
1501: DELETE FROM mtl_kanban_cards
1502: WHERE pull_sequence_id = p_pull_sequence_id;
1503: EXCEPTION
1504: WHEN fnd_api.g_exc_error THEN
1505: RAISE fnd_api.g_exc_error;

Line 1533: FROM mtl_kanban_cards crd

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);
1536: EXCEPTION
1537: WHEN fnd_api.g_exc_error THEN