DBA Data[Home] [Help]

APPS.INV_RESERVATION_FORM_PKG dependencies on INV_MOVE_ORDER_PUB

Line 1771: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;

1767: l_api_name CONSTANT VARCHAR2(30) := 'create_move_order_header';
1768:
1769: l_user_id NUMBER := fnd_global.user_id;
1770: l_return_status VARCHAR2(1);
1771: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1772: l_in_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
1773: l_out_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1774: l_out_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
1775:

Line 1772: l_in_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;

1768:
1769: l_user_id NUMBER := fnd_global.user_id;
1770: l_return_status VARCHAR2(1);
1771: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1772: l_in_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
1773: l_out_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1774: l_out_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
1775:
1776: BEGIN

Line 1773: l_out_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;

1769: l_user_id NUMBER := fnd_global.user_id;
1770: l_return_status VARCHAR2(1);
1771: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1772: l_in_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
1773: l_out_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1774: l_out_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
1775:
1776: BEGIN
1777: -- Initialize return status

Line 1774: l_out_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;

1770: l_return_status VARCHAR2(1);
1771: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1772: l_in_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
1773: l_out_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1774: l_out_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
1775:
1776: BEGIN
1777: -- Initialize return status
1778: x_return_status := fnd_api.g_ret_sts_success;

Line 1803: inv_move_order_pub.create_move_order_header

1799: l_in_trohdr_rec.creation_date := SYSDATE;
1800: l_in_trohdr_rec.created_by := l_user_id;
1801: l_in_trohdr_rec.last_update_date := SYSDATE;
1802: l_in_trohdr_rec.last_updated_by := l_user_id;
1803: inv_move_order_pub.create_move_order_header
1804: (p_api_version_number => 1.0,
1805: p_init_msg_list => FND_API.G_FALSE,
1806: p_return_values => FND_API.G_FALSE,
1807: p_commit => FND_API.G_FALSE,

Line 1815: p_validation_flag => inv_move_order_pub.g_validation_yes);

1811: p_trohdr_rec => l_in_trohdr_rec,
1812: p_trohdr_val_rec => l_in_trohdr_val_rec,
1813: x_trohdr_rec => l_out_trohdr_rec,
1814: x_trohdr_val_rec => l_out_trohdr_val_rec,
1815: p_validation_flag => inv_move_order_pub.g_validation_yes);
1816:
1817: IF l_return_status = fnd_api.g_ret_sts_error THEN
1818: RAISE fnd_api.g_exc_error;
1819: END IF ;

Line 1895: l_in_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

1891: l_api_name CONSTANT VARCHAR2(30) := 'create_move_order_line';
1892:
1893: l_user_id NUMBER := fnd_global.user_id;
1894: l_return_status VARCHAR2(1);
1895: l_in_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
1896: l_in_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
1897: l_out_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
1898: l_out_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
1899:

Line 1896: l_in_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;

1892:
1893: l_user_id NUMBER := fnd_global.user_id;
1894: l_return_status VARCHAR2(1);
1895: l_in_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
1896: l_in_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
1897: l_out_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
1898: l_out_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
1899:
1900: BEGIN

Line 1897: l_out_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

1893: l_user_id NUMBER := fnd_global.user_id;
1894: l_return_status VARCHAR2(1);
1895: l_in_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
1896: l_in_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
1897: l_out_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
1898: l_out_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
1899:
1900: BEGIN
1901: -- Initialize return status

Line 1898: l_out_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;

1894: l_return_status VARCHAR2(1);
1895: l_in_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
1896: l_in_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
1897: l_out_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
1898: l_out_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
1899:
1900: BEGIN
1901: -- Initialize return status
1902: x_return_status := fnd_api.g_ret_sts_success;

Line 1951: inv_move_order_pub.create_move_order_lines

1947: l_in_trolin_tbl(1).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_STGXFR;
1948: END IF;
1949: -- bug 5671641 end
1950:
1951: inv_move_order_pub.create_move_order_lines
1952: (p_api_version_number => 1.0,
1953: p_init_msg_list => FND_API.G_FALSE,
1954: p_return_values => FND_API.G_FALSE,
1955: p_commit => FND_API.G_FALSE,

Line 1963: p_validation_flag => inv_move_order_pub.g_validation_yes);

1959: p_trolin_tbl => l_in_trolin_tbl,
1960: p_trolin_val_tbl => l_in_trolin_val_tbl,
1961: x_trolin_tbl => l_out_trolin_tbl,
1962: x_trolin_val_tbl => l_out_trolin_val_tbl,
1963: p_validation_flag => inv_move_order_pub.g_validation_yes);
1964:
1965: IF l_return_status = fnd_api.g_ret_sts_error THEN
1966: RAISE fnd_api.g_exc_error;
1967: END IF ;

Line 2030: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;

2026: l_api_name CONSTANT VARCHAR2(30) := 'delete_move_order';
2027:
2028: l_user_id NUMBER := fnd_global.user_id;
2029: l_return_status VARCHAR2(1);
2030: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2031: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2032: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
2033: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2034: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;

Line 2031: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;

2027:
2028: l_user_id NUMBER := fnd_global.user_id;
2029: l_return_status VARCHAR2(1);
2030: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2031: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2032: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
2033: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2034: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
2035:

Line 2032: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;

2028: l_user_id NUMBER := fnd_global.user_id;
2029: l_return_status VARCHAR2(1);
2030: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2031: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2032: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
2033: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2034: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
2035:
2036: BEGIN

Line 2033: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

2029: l_return_status VARCHAR2(1);
2030: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2031: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2032: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
2033: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2034: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
2035:
2036: BEGIN
2037: -- Initialize return status

Line 2034: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;

2030: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2031: l_in_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
2032: l_trohdr_val_rec INV_MOVE_ORDER_PUB.Trohdr_Val_Rec_Type;
2033: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
2034: l_trolin_val_tbl INV_MOVE_ORDER_PUB.Trolin_Val_Tbl_Type;
2035:
2036: BEGIN
2037: -- Initialize return status
2038: x_return_status := fnd_api.g_ret_sts_success;

Line 2056: inv_move_order_pub.process_move_order

2052: END IF;
2053:
2054: l_in_trohdr_rec.operation := inv_globals.g_opr_delete;
2055: l_in_trohdr_rec.header_id := p_move_order_header_id;
2056: inv_move_order_pub.process_move_order
2057: (p_api_version_number => 1.0,
2058: p_init_msg_list => FND_API.G_TRUE,
2059: p_return_values => FND_API.G_FALSE,
2060: p_commit => FND_API.G_FALSE,