eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INL_SIMULATION_PVT dependencies on INL_SIMULATIONS

Line 1597: p_debug_info => 'Select data from_association_rec INL_SIMULATIONS');

1593: p_var_value => ShipHeaders_List(i).ship_header_id);
1594:
1595: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1596: p_procedure_name => l_api_name,
1597: p_debug_info => 'Select data from_association_rec INL_SIMULATIONS');
1598:
1599: SELECT s.simulation_id,
1600: 'N',
1601: s.parent_table_name,

Line 1617: FROM inl_simulations s

1613: l_simulation_rec.version_num,
1614: l_simulation_rec.vendor_id,
1615: l_simulation_rec.vendor_site_id,
1616: l_simulation_rec.freight_code
1617: FROM inl_simulations s
1618: WHERE s.simulation_id = p_new_simulation_id;
1619:
1620: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1621: p_procedure_name => l_api_name,

Line 1998: FROM inl_simulations a,

1994: p_debug_info => 'Get the next simulation version');
1995:
1996: SELECT MAX(a.version_num) + 1
1997: INTO l_version_num
1998: FROM inl_simulations a,
1999: inl_simulations b
2000: WHERE a.parent_table_name = b.parent_table_name
2001: AND a.parent_table_id = b.parent_table_id
2002: AND a.parent_table_revision_num = b.parent_table_revision_num

Line 1999: inl_simulations b

1995:
1996: SELECT MAX(a.version_num) + 1
1997: INTO l_version_num
1998: FROM inl_simulations a,
1999: inl_simulations b
2000: WHERE a.parent_table_name = b.parent_table_name
2001: AND a.parent_table_id = b.parent_table_id
2002: AND a.parent_table_revision_num = b.parent_table_revision_num
2003: AND b.simulation_id = p_simulation_id;

Line 2010: SELECT inl_simulations_s.NEXTVAL

2006: p_procedure_name => l_api_name,
2007: p_debug_info => 'Get the next Simulation Id');
2008:
2009: -- Get Simulation Id nextval
2010: SELECT inl_simulations_s.NEXTVAL
2011: INTO l_simulation_id
2012: FROM dual;
2013:
2014: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

Line 2066: FROM inl_simulations

2062: l_simulation_rec.attribute12,
2063: l_simulation_rec.attribute13,
2064: l_simulation_rec.attribute14,
2065: l_simulation_rec.attribute15
2066: FROM inl_simulations
2067: WHERE simulation_id = p_simulation_id;
2068:
2069: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2070: p_procedure_name => l_api_name,

Line 2073: INSERT INTO inl_simulations (simulation_id,

2069: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2070: p_procedure_name => l_api_name,
2071: p_debug_info => 'Insert into Simulation table a copy of the existing record');
2072:
2073: INSERT INTO inl_simulations (simulation_id,
2074: firmed_flag,
2075: parent_table_name,
2076: parent_table_id,
2077: parent_table_revision_num,

Line 2335: FROM inl_simulations sml

2331: IF l_lock_status = 0 THEN -- Successfully locked
2332:
2333: SELECT NVL(MAX(sml.version_num),0) + 1
2334: INTO p_simulation_rec.version_num
2335: FROM inl_simulations sml
2336: WHERE sml.parent_table_name = p_simulation_rec.parent_table_name
2337: AND sml.parent_table_id = p_simulation_rec.parent_table_id
2338: AND parent_table_revision_num = p_simulation_rec.parent_table_revision_num;
2339:

Line 2346: SELECT inl_simulations_s.NEXTVAL

2342: p_procedure_name => l_api_name,
2343: p_var_name => 'p_simulation_rec.version_num',
2344: p_var_value => p_simulation_rec.version_num );
2345:
2346: SELECT inl_simulations_s.NEXTVAL
2347: INTO p_simulation_rec.simulation_id
2348: FROM dual;
2349:
2350: INL_LOGGING_PVT.Log_Variable (

Line 2395: l_debug_msg := 'Inserting data into inl_simulations table';

2391: l_attribute13 := l_flexfield_ln_rec.attribute13;
2392: l_attribute14 := l_flexfield_ln_rec.attribute14;
2393: l_attribute15 := l_flexfield_ln_rec.attribute15;
2394:
2395: l_debug_msg := 'Inserting data into inl_simulations table';
2396: INL_LOGGING_PVT.Log_Statement (
2397: p_module_name => g_module_name,
2398: p_procedure_name => l_api_name,
2399: p_debug_info => l_debug_msg);

Line 2401: INSERT INTO inl_simulations sml

2397: p_module_name => g_module_name,
2398: p_procedure_name => l_api_name,
2399: p_debug_info => l_debug_msg);
2400:
2401: INSERT INTO inl_simulations sml
2402: (sml.simulation_id, -- 01
2403: sml.firmed_flag, -- 02
2404: sml.parent_table_name, -- 03
2405: sml.parent_table_id, -- 04

Line 2564: FROM inl_simulations s

2560: x_msg_data OUT NOCOPY VARCHAR2) IS
2561:
2562: CURSOR c_simul IS
2563: SELECT simulation_id
2564: FROM inl_simulations s
2565: WHERE org_id = p_org_id
2566: ORDER BY s.parent_table_name,
2567: s.parent_table_id,
2568: s.parent_table_revision_num,

Line 2669: DELETE FROM inl_simulations s

2665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2666: END IF;
2667: END LOOP;
2668:
2669: DELETE FROM inl_simulations s
2670: WHERE s.simulation_id = c_simul_tbl(i).simulation_id;
2671: END IF;
2672: END LOOP;
2673: