DBA Data[Home] [Help]

APPS.INV_KANBAN_PVT dependencies on INV_GLOBALS

Line 1916: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;

1912: l_trohdr_rec.creation_date := sysdate;
1913: l_trohdr_rec.date_required := p_need_by_date;
1914: l_trohdr_rec.from_subinventory_code := p_kanban_card_rec_tbl(1).source_subinventory;
1915: -- l_trohdr_rec.header_id := l_header_id;
1916: l_trohdr_rec.header_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1917: l_trohdr_rec.last_updated_by := FND_GLOBAL.USER_ID;
1918: l_trohdr_rec.last_update_date := sysdate;
1919: l_trohdr_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1920: l_trohdr_rec.organization_id := p_kanban_card_rec_tbl(1).organization_id;

Line 1924: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;

1920: l_trohdr_rec.organization_id := p_kanban_card_rec_tbl(1).organization_id;
1921: -- l_trohdr_rec.request_number := to_char(l_header_id);
1922: l_trohdr_rec.status_date := sysdate;
1923: l_trohdr_rec.to_subinventory_code := p_kanban_card_rec_tbl(1).subinventory_name;
1924: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
1925: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;
1926: l_trohdr_rec.db_flag := FND_API.G_TRUE;
1927: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
1928:

Line 1925: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;

1921: -- l_trohdr_rec.request_number := to_char(l_header_id);
1922: l_trohdr_rec.status_date := sysdate;
1923: l_trohdr_rec.to_subinventory_code := p_kanban_card_rec_tbl(1).subinventory_name;
1924: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
1925: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;
1926: l_trohdr_rec.db_flag := FND_API.G_TRUE;
1927: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
1928:
1929: select location_control_code

Line 1927: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;

1923: l_trohdr_rec.to_subinventory_code := p_kanban_card_rec_tbl(1).subinventory_name;
1924: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
1925: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;
1926: l_trohdr_rec.db_flag := FND_API.G_TRUE;
1927: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
1928:
1929: select location_control_code
1930: into l_item_locator_control_code
1931: from mtl_system_items

Line 1997: l_trolin_tbl(l_order_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;

1993: l_trolin_tbl(l_order_count).last_update_date := sysdate;
1994: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;
1995: l_trolin_tbl(l_order_count).line_id := FND_API.G_MISS_NUM;
1996: l_trolin_tbl(l_order_count).line_number := l_line_num;
1997: l_trolin_tbl(l_order_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
1998: l_trolin_tbl(l_order_count).organization_id := p_kanban_card_rec_tbl(1).organization_id;
1999: l_trolin_tbl(l_order_count).quantity := p_kanban_card_rec_tbl(l_order_count).kanban_size;
2000: l_trolin_tbl(l_order_count).reference_id := p_kanban_card_rec_tbl(l_order_count).kanban_card_id;
2001: l_trolin_tbl(l_order_count).reference_type_code := INV_Transfer_Order_PVT.G_Ref_Type_Kanban;

Line 2019: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;

2015: -- End of Bug Fix:2340651.
2016:
2017: l_trolin_tbl(l_order_count).to_subinventory_code:= p_kanban_card_rec_tbl(1).subinventory_name;
2018: l_trolin_tbl(l_order_count).uom_code := p_primary_uom_code;
2019: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
2020: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;
2021: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;
2022: END LOOP;
2023:

Line 2021: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;

2017: l_trolin_tbl(l_order_count).to_subinventory_code:= p_kanban_card_rec_tbl(1).subinventory_name;
2018: l_trolin_tbl(l_order_count).uom_code := p_primary_uom_code;
2019: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
2020: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;
2021: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;
2022: END LOOP;
2023:
2024: INV_Transfer_Order_PVT.Process_Transfer_Order
2025: ( p_api_version_number => 1.0 ,

Line 3935: l_move_order_type NUMBER := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;

3931: -- Increased lot size to 80 Char - Mercy Thomas - B4625329
3932: l_lot_number VARCHAR2(80);
3933: l_expiration_date DATE;
3934: l_serial_control_code VARCHAR2(1) ;
3935: l_move_order_type NUMBER := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;
3936: l_failed_lines NUMBER := 0;
3937: l_return_status VARCHAR2(1);
3938: l_msg_count NUMBER ;
3939: l_msg_data VARCHAR2(2000);