APPS.INL_SIMULATION_PVT dependencies on INL_SHIP_HEADERS

Line 1543: FROM inl_ship_headers_all

1539: attribute13,
1540: attribute14,
1541: attribute15,
1542: rcv_enabled_flag
1543: FROM inl_ship_headers_all
1544: WHERE simulation_id = p_current_simulation_id;
1545:
1546: TYPE ShipHeaders_List_Type IS
1547: TABLE OF ShipHeaders%ROWTYPE;

Line 1683: SELECT inl_ship_headers_all_s.NEXTVAL

1679: p_procedure_name => l_api_name,
1680: p_debug_info => 'Get the next Shipment Header Id');
1681:
1682: -- Get Shipment Header's nextval
1683: SELECT inl_ship_headers_all_s.NEXTVAL
1684: INTO l_ship_header_id
1685: FROM dual;
1686:
1687: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

Line 1689: p_debug_info => 'Insert into INL_SHIP_HEADERS_ALL');

1685: FROM dual;
1686:
1687: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1688: p_procedure_name => l_api_name,
1689: p_debug_info => 'Insert into INL_SHIP_HEADERS_ALL');
1690:
1691: INSERT INTO inl_ship_headers_all (ship_header_id,
1692: ship_num,
1693: ship_date,

Line 1691: INSERT INTO inl_ship_headers_all (ship_header_id,

1687: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1688: p_procedure_name => l_api_name,
1689: p_debug_info => 'Insert into INL_SHIP_HEADERS_ALL');
1690:
1691: INSERT INTO inl_ship_headers_all (ship_header_id,
1692: ship_num,
1693: ship_date,
1694: ship_type_id,
1695: ship_status_code,

Line 1789: WHERE to_parent_table_name = 'INL_SHIP_HEADERS'

1785: SELECT from_parent_table_name,
1786: from_parent_table_id
1787: BULK COLLECT INTO l_from_association_tbl
1788: FROM inl_associations
1789: WHERE to_parent_table_name = 'INL_SHIP_HEADERS'
1790: AND to_parent_table_id = ShipHeaders_List(i).ship_header_id
1791: AND ship_header_id = ShipHeaders_List(i).ship_header_id;
1792: EXCEPTION
1793: WHEN NO_DATA_FOUND THEN

Line 1820: p_to_parent_table_name => 'INL_SHIP_HEADERS',

1816: p_commit => l_commit,
1817: p_current_ship_header_id => ShipHeaders_List(i).ship_header_id,
1818: p_new_ship_header_id => l_ship_header_id,
1819: p_from_parent_table_id => l_from_association_tbl(j).from_parent_table_id,
1820: p_to_parent_table_name => 'INL_SHIP_HEADERS',
1821: p_current_to_parent_table_id => ShipHeaders_List(i).ship_header_id,
1822: p_new_to_parent_table_id => l_ship_header_id,
1823: x_return_status => l_return_status,
1824: x_msg_count => l_msg_count,

Line 2576: FROM inl_ship_headers sh

2572: c_simul_tbl c_simul_tp;
2573:
2574: CURSOR c_ship_hdr(p_simulation_id NUMBER) IS
2575: SELECT sh.ship_header_id
2576: FROM inl_ship_headers sh
2577: WHERE sh.simulation_id = p_simulation_id;
2578:
2579: TYPE c_ship_hdr_tp IS TABLE OF c_ship_hdr%ROWTYPE;
2580: c_ship_hdr_tbl c_ship_hdr_tp;