APPS.INV_KANBANCARD_PKG dependencies on INV_KANBANCARD_PKG

Line 1: PACKAGE BODY inv_kanbancard_pkg AS

1: PACKAGE BODY inv_kanbancard_pkg AS
2: /* $Header: INVKCRDB.pls 120.10.12020000.2 2012/07/09 08:07:11 asugandh ship $ */
3: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_KanbanCard_PKG';
4:
5: TYPE supply_status_change_tbl_type IS TABLE OF VARCHAR2(1);

Line 3: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_KanbanCard_PKG';

1: PACKAGE BODY inv_kanbancard_pkg AS
2: /* $Header: INVKCRDB.pls 120.10.12020000.2 2012/07/09 08:07:11 asugandh ship $ */
3: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_KanbanCard_PKG';
4:
5: TYPE supply_status_change_tbl_type IS TABLE OF VARCHAR2(1);
6:
7: g_true CONSTANT VARCHAR2(1) := fnd_api.g_true;

Line 66: inv_trx_util_pub.TRACE(msg, 'INV_KANBANCARD_PKG', 9);

62: );
63:
64: PROCEDURE mydebug(msg IN VARCHAR2) IS
65: BEGIN
66: inv_trx_util_pub.TRACE(msg, 'INV_KANBANCARD_PKG', 9);
67: END mydebug;
68:
69: FUNCTION check_unique(p_kanban_card_id IN OUT NOCOPY NUMBER, p_organization_id NUMBER, p_kanban_card_number VARCHAR2)
70: RETURN BOOLEAN IS

Line 757: inv_kanbancard_pkg.update_row(

753: ) THEN
754: l_supply_status := l_kanban_card_rec.supply_status;
755: l_card_status := l_kanban_card_rec.card_status;
756: l_current_replnsh_cycle_id := l_kanban_card_rec.current_replnsh_cycle_id;
757: inv_kanbancard_pkg.update_row(
758: x_return_status => l_return_status
759: , p_kanban_card_id => l_kanban_card_rec.kanban_card_id
760: , p_kanban_card_number => l_kanban_card_rec.kanban_card_number
761: , p_pull_sequence_id => l_kanban_card_rec.pull_sequence_id

Line 1677: inv_kanbancard_pkg.delete_activity_for_pull_seq(p_pull_sequence_id);

1673: END insert_activity_for_card;
1674:
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

Line 2030: inv_kanbancard_pkg.update_row(

2026: ) THEN
2027: l_supply_status := l_kanban_card_rec.supply_status;
2028: l_card_status := l_kanban_card_rec.card_status;
2029: l_current_replnsh_cycle_id := l_kanban_card_rec.current_replnsh_cycle_id;
2030: inv_kanbancard_pkg.update_row(
2031: x_return_status => l_return_status
2032: , p_kanban_card_id => l_kanban_card_rec.kanban_card_id
2033: , p_kanban_card_number => l_kanban_card_rec.kanban_card_number
2034: , p_pull_sequence_id => l_kanban_card_rec.pull_sequence_id

Line 2569: END inv_kanbancard_pkg;

2565: x_return_status := fnd_api.g_ret_sts_unexp_error;
2566: END update_row;
2567:
2568:
2569: END inv_kanbancard_pkg;