DBA Data[Home] [Help]

APPS.INV_RESERVATION_FORM_PKG dependencies on INV_MOVE_ORDER_PUB

Line 1751: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;

1747: l_api_name CONSTANT VARCHAR2(30) := 'create_move_order_header';
1748:
1749: l_user_id NUMBER := fnd_global.user_id;
1750: l_return_status VARCHAR2(1);
1751: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1752: l_in_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
1753: l_out_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1754: l_out_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
1755:

Line 1752: l_in_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;

1748:
1749: l_user_id NUMBER := fnd_global.user_id;
1750: l_return_status VARCHAR2(1);
1751: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1752: l_in_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
1753: l_out_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1754: l_out_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
1755:
1756: BEGIN

Line 1753: l_out_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;

1749: l_user_id NUMBER := fnd_global.user_id;
1750: l_return_status VARCHAR2(1);
1751: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1752: l_in_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
1753: l_out_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1754: l_out_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
1755:
1756: BEGIN
1757: -- Initialize return status

Line 1754: l_out_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;

1750: l_return_status VARCHAR2(1);
1751: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1752: l_in_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
1753: l_out_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1754: l_out_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
1755:
1756: BEGIN
1757: -- Initialize return status
1758: x_return_status := fnd_api.g_ret_sts_success;

Line 1783: inv_move_order_pub.create_move_order_header

1779: l_in_trohdr_rec.creation_date := SYSDATE;
1780: l_in_trohdr_rec.created_by := l_user_id;
1781: l_in_trohdr_rec.last_update_date := SYSDATE;
1782: l_in_trohdr_rec.last_updated_by := l_user_id;
1783: inv_move_order_pub.create_move_order_header
1784: (p_api_version_number => 1.0,
1785: p_init_msg_list => FND_API.G_FALSE,
1786: p_return_values => FND_API.G_FALSE,
1787: p_commit => FND_API.G_FALSE,

Line 1795: p_validation_flag => inv_move_order_pub.g_validation_yes);

1791: p_trohdr_rec => l_in_trohdr_rec,
1792: p_trohdr_val_rec => l_in_trohdr_val_rec,
1793: x_trohdr_rec => l_out_trohdr_rec,
1794: x_trohdr_val_rec => l_out_trohdr_val_rec,
1795: p_validation_flag => inv_move_order_pub.g_validation_yes);
1796:
1797: IF l_return_status = fnd_api.g_ret_sts_error THEN
1798: RAISE fnd_api.g_exc_error;
1799: END IF ;

Line 1875: l_in_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

1871: l_api_name CONSTANT VARCHAR2(30) := 'create_move_order_line';
1872:
1873: l_user_id NUMBER := fnd_global.user_id;
1874: l_return_status VARCHAR2(1);
1875: l_in_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
1876: l_in_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
1877: l_out_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
1878: l_out_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
1879:

Line 1876: l_in_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;

1872:
1873: l_user_id NUMBER := fnd_global.user_id;
1874: l_return_status VARCHAR2(1);
1875: l_in_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
1876: l_in_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
1877: l_out_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
1878: l_out_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
1879:
1880: BEGIN

Line 1877: l_out_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

1873: l_user_id NUMBER := fnd_global.user_id;
1874: l_return_status VARCHAR2(1);
1875: l_in_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
1876: l_in_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
1877: l_out_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
1878: l_out_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
1879:
1880: BEGIN
1881: -- Initialize return status

Line 1878: l_out_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;

1874: l_return_status VARCHAR2(1);
1875: l_in_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
1876: l_in_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
1877: l_out_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
1878: l_out_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
1879:
1880: BEGIN
1881: -- Initialize return status
1882: x_return_status := fnd_api.g_ret_sts_success;

Line 1931: inv_move_order_pub.create_move_order_lines

1927: l_in_trolin_tbl(1).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_STGXFR;
1928: END IF;
1929: -- bug 5671641 end
1930:
1931: inv_move_order_pub.create_move_order_lines
1932: (p_api_version_number => 1.0,
1933: p_init_msg_list => FND_API.G_FALSE,
1934: p_return_values => FND_API.G_FALSE,
1935: p_commit => FND_API.G_FALSE,

Line 1943: p_validation_flag => inv_move_order_pub.g_validation_yes);

1939: p_trolin_tbl => l_in_trolin_tbl,
1940: p_trolin_val_tbl => l_in_trolin_val_tbl,
1941: x_trolin_tbl => l_out_trolin_tbl,
1942: x_trolin_val_tbl => l_out_trolin_val_tbl,
1943: p_validation_flag => inv_move_order_pub.g_validation_yes);
1944:
1945: IF l_return_status = fnd_api.g_ret_sts_error THEN
1946: RAISE fnd_api.g_exc_error;
1947: END IF ;

Line 2010: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;

2006: l_api_name CONSTANT VARCHAR2(30) := 'delete_move_order';
2007:
2008: l_user_id NUMBER := fnd_global.user_id;
2009: l_return_status VARCHAR2(1);
2010: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2011: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2012: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
2013: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2014: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;

Line 2011: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;

2007:
2008: l_user_id NUMBER := fnd_global.user_id;
2009: l_return_status VARCHAR2(1);
2010: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2011: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2012: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
2013: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2014: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
2015:

Line 2012: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;

2008: l_user_id NUMBER := fnd_global.user_id;
2009: l_return_status VARCHAR2(1);
2010: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2011: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2012: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
2013: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2014: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
2015:
2016: BEGIN

Line 2013: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

2009: l_return_status VARCHAR2(1);
2010: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2011: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2012: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
2013: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2014: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
2015:
2016: BEGIN
2017: -- Initialize return status

Line 2014: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;

2010: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2011: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2012: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
2013: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2014: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
2015:
2016: BEGIN
2017: -- Initialize return status
2018: x_return_status := fnd_api.g_ret_sts_success;

Line 2036: inv_move_order_pub.process_move_order

2032: END IF;
2033:
2034: l_in_trohdr_rec.operation := inv_globals.g_opr_delete;
2035: l_in_trohdr_rec.header_id := p_move_order_header_id;
2036: inv_move_order_pub.process_move_order
2037: (p_api_version_number => 1.0,
2038: p_init_msg_list => FND_API.G_TRUE,
2039: p_return_values => FND_API.G_FALSE,
2040: p_commit => FND_API.G_FALSE,