eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 198: FROM mtl_kanban_cards

194: , l_kanban_card_rec.replenishment_count
195: , l_kanban_card_rec.max_replenishments
196: , l_kanban_card_rec.disable_date
197: , l_kanban_card_rec.replacement_flag
198: FROM mtl_kanban_cards
199: WHERE kanban_card_id = p_kanban_card_id;
200:
201: l_kanban_card_rec.document_type := NULL;
202: l_kanban_card_rec.document_header_id := NULL;

Line 549: INV_LOG_UTIL.TRACE('561 Before Callin INSERT INTO mtl_kanban_cards','insert_row');

545: l_card_status NUMBER;
546: l_supply_status NUMBER;
547: BEGIN
548: fnd_msg_pub.initialize;
549: INV_LOG_UTIL.TRACE('561 Before Callin INSERT INTO mtl_kanban_cards','insert_row');
550: WHILE NOT l_kanban_card_number_ok LOOP
551: SELECT mtl_kanban_cards_s.NEXTVAL
552: INTO l_kanban_card_rec.kanban_card_id
553: FROM DUAL;

Line 551: SELECT mtl_kanban_cards_s.NEXTVAL

547: BEGIN
548: fnd_msg_pub.initialize;
549: INV_LOG_UTIL.TRACE('561 Before Callin INSERT INTO mtl_kanban_cards','insert_row');
550: WHILE NOT l_kanban_card_number_ok LOOP
551: SELECT mtl_kanban_cards_s.NEXTVAL
552: INTO l_kanban_card_rec.kanban_card_id
553: FROM DUAL;
554:
555: IF p_kanban_card_number IS NULL THEN

Line 559: FROM mtl_kanban_cards

555: IF p_kanban_card_number IS NULL THEN
556: BEGIN
557: SELECT 'X'
558: INTO l_dummy
559: FROM mtl_kanban_cards
560: WHERE kanban_card_number = TO_CHAR(l_kanban_card_rec.kanban_card_id)
561: AND organization_id = p_organization_id;
562: EXCEPTION
563: WHEN NO_DATA_FOUND THEN

Line 578: from mtl_kanban_cards

574: -- Also Validate Value from Hook.
575: if l_kanban_card_rec.kanban_card_number is not null then
576: Begin
577: select 1 into l_dummy
578: from mtl_kanban_cards
579: where organization_id = l_kanban_card_rec.organization_id
580: and kanban_card_number = l_kanban_card_rec.kanban_card_number;
581: l_kanban_card_rec.kanban_card_number:=NULL;
582: exception

Line 644: INSERT INTO mtl_kanban_cards

640: l_kanban_card_rec.program_application_id := p_program_application_id;
641: l_kanban_card_rec.program_id := p_program_id;
642: l_kanban_card_rec.program_update_date := p_program_update_date;
643:
644: INSERT INTO mtl_kanban_cards
645: (
646: kanban_card_id
647: , kanban_card_number
648: , pull_sequence_id

Line 880: FROM mtl_kanban_cards

876: , p_attribute15 VARCHAR2
877: ) IS
878: CURSOR get_current_row IS
879: SELECT *
880: FROM mtl_kanban_cards
881: WHERE kanban_card_id = p_kanban_card_id
882: FOR UPDATE OF organization_id NOWAIT;
883:
884: recinfo mtl_kanban_cards%ROWTYPE;

Line 884: recinfo mtl_kanban_cards%ROWTYPE;

880: FROM mtl_kanban_cards
881: WHERE kanban_card_id = p_kanban_card_id
882: FOR UPDATE OF organization_id NOWAIT;
883:
884: recinfo mtl_kanban_cards%ROWTYPE;
885: record_changed EXCEPTION;
886: BEGIN
887: OPEN get_current_row;
888: FETCH get_current_row INTO recinfo;

Line 1246: UPDATE mtl_kanban_cards

1242: end if;
1243: -- end if;
1244: END IF;
1245:
1246: UPDATE mtl_kanban_cards
1247: SET pull_sequence_id = l_kanban_card_rec.pull_sequence_id
1248: , inventory_item_id = l_kanban_card_rec.inventory_item_id
1249: , organization_id = l_kanban_card_rec.organization_id
1250: , subinventory_name = l_kanban_card_rec.subinventory_name

Line 1535: DELETE FROM mtl_kanban_cards

1531:
1532: PROCEDURE delete_row(x_return_status OUT NOCOPY VARCHAR2, p_kanban_card_id NUMBER) IS
1533: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1534: BEGIN
1535: DELETE FROM mtl_kanban_cards
1536: WHERE kanban_card_id = p_kanban_card_id;
1537:
1538: IF (SQL%NOTFOUND) THEN
1539: RAISE NO_DATA_FOUND;

Line 1679: DELETE FROM mtl_kanban_cards

1675: PROCEDURE delete_cards_for_pull_seq(p_pull_sequence_id NUMBER) IS
1676: BEGIN
1677: inv_kanbancard_pkg.delete_activity_for_pull_seq(p_pull_sequence_id);
1678:
1679: DELETE FROM mtl_kanban_cards
1680: WHERE pull_sequence_id = p_pull_sequence_id;
1681: EXCEPTION
1682: WHEN fnd_api.g_exc_error THEN
1683: RAISE fnd_api.g_exc_error;

Line 1711: FROM mtl_kanban_cards crd

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

Line 1801: SELECT mtl_kanban_cards_s.NEXTVAL

1797: fnd_msg_pub.initialize;
1798: INV_LOG_UTIL.TRACE('-- Start eKanban Changes insert_row','insert_row');
1799: IF p_kanban_card_id IS NULL THEN
1800: WHILE NOT l_kanban_card_number_ok LOOP
1801: SELECT mtl_kanban_cards_s.NEXTVAL
1802: INTO l_kanban_card_rec.kanban_card_id
1803: FROM DUAL;
1804:
1805: IF p_kanban_card_number IS NULL THEN

Line 1809: FROM mtl_kanban_cards

1805: IF p_kanban_card_number IS NULL THEN
1806: BEGIN
1807: SELECT 'X'
1808: INTO l_dummy
1809: FROM mtl_kanban_cards
1810: WHERE kanban_card_number = TO_CHAR(l_kanban_card_rec.kanban_card_id)
1811: AND organization_id = p_organization_id;
1812: EXCEPTION
1813: WHEN NO_DATA_FOUND THEN

Line 1832: from mtl_kanban_cards

1828: -- Also Validate Value from Hook.
1829: if l_kanban_card_rec.kanban_card_number is not null then
1830: Begin
1831: select 1 into l_dummy
1832: from mtl_kanban_cards
1833: where organization_id = l_kanban_card_rec.organization_id
1834: and kanban_card_number = l_kanban_card_rec.kanban_card_number;
1835: l_kanban_card_rec.kanban_card_number:=NULL;
1836: exception

Line 1905: INV_LOG_UTIL.TRACE('Before Callin INSERT INTO mtl_kanban_cards','insert_row');

1901: l_kanban_card_rec.max_replenishments := p_max_replenishments;
1902: l_kanban_card_rec.disable_date := p_disable_date;
1903: l_kanban_card_rec.replacement_flag := p_replacement_flag;
1904: --added by javakat
1905: INV_LOG_UTIL.TRACE('Before Callin INSERT INTO mtl_kanban_cards','insert_row');
1906: INV_LOG_UTIL.TRACE('kanban_card_number'||l_kanban_card_rec.kanban_card_number,'insert_row');
1907: INSERT INTO mtl_kanban_cards
1908: (
1909: kanban_card_id

Line 1907: INSERT INTO mtl_kanban_cards

1903: l_kanban_card_rec.replacement_flag := p_replacement_flag;
1904: --added by javakat
1905: INV_LOG_UTIL.TRACE('Before Callin INSERT INTO mtl_kanban_cards','insert_row');
1906: INV_LOG_UTIL.TRACE('kanban_card_number'||l_kanban_card_rec.kanban_card_number,'insert_row');
1907: INSERT INTO mtl_kanban_cards
1908: (
1909: kanban_card_id
1910: , kanban_card_number
1911: , pull_sequence_id

Line 2170: FROM mtl_kanban_cards

2166: , p_replacement_flag NUMBER
2167: ) IS
2168: CURSOR get_current_row IS
2169: SELECT *
2170: FROM mtl_kanban_cards
2171: WHERE kanban_card_id = p_kanban_card_id
2172: FOR UPDATE OF organization_id NOWAIT;
2173:
2174: recinfo mtl_kanban_cards%ROWTYPE;

Line 2174: recinfo mtl_kanban_cards%ROWTYPE;

2170: FROM mtl_kanban_cards
2171: WHERE kanban_card_id = p_kanban_card_id
2172: FOR UPDATE OF organization_id NOWAIT;
2173:
2174: recinfo mtl_kanban_cards%ROWTYPE;
2175: record_changed EXCEPTION;
2176: BEGIN
2177: OPEN get_current_row;
2178: FETCH get_current_row INTO recinfo;

Line 2464: UPDATE mtl_kanban_cards

2460: l_kanban_card_rec.supply_status := l_supply_status;
2461: l_kanban_card_rec.current_replnsh_cycle_id := l_current_replenish_cycle_id;
2462: END IF;
2463:
2464: UPDATE mtl_kanban_cards
2465: SET pull_sequence_id = l_kanban_card_rec.pull_sequence_id
2466: , inventory_item_id = l_kanban_card_rec.inventory_item_id
2467: , organization_id = l_kanban_card_rec.organization_id
2468: , subinventory_name = l_kanban_card_rec.subinventory_name