DBA Data[Home] [Help]

APPS.INL_SIMULATION_PVT dependencies on DUAL

Line 154: FROM dual;

150:
151: -- Get Charge Line nextval
152: SELECT inl_tax_lines_s.NEXTVAL
153: INTO l_tax_line_id
154: FROM dual;
155:
156: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
157: p_procedure_name => l_api_name,
158: p_debug_info => 'Insert into INL_TAX_LINES');

Line 457: FROM dual;

453:
454: -- Get Charge Line nextval
455: SELECT inl_charge_lines_s.NEXTVAL
456: INTO l_charge_line_id
457: FROM dual;
458:
459: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
460: p_procedure_name => l_api_name,
461: p_debug_info => 'Insert into INL_CHARGE_LINES');

Line 818: FROM dual;

814:
815: -- Get Shipment Lines's nextval
816: SELECT inl_ship_lines_all_s.NEXTVAL
817: INTO l_ship_line_id
818: FROM dual;
819:
820: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
821: p_procedure_name => l_api_name,
822: p_debug_info => 'Insert into INL_SHIP_LINES_ALL');

Line 1246: FROM dual;

1242:
1243: -- Get Shipment Header's nextval
1244: SELECT inl_ship_line_groups_s.NEXTVAL
1245: INTO l_ship_line_group_id
1246: FROM dual;
1247:
1248: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1249: p_procedure_name => l_api_name,
1250: p_debug_info => 'Insert into INL_SHIP_LINE_GROUPS');

Line 1685: FROM dual;

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,
1688: p_procedure_name => l_api_name,
1689: p_debug_info => 'Insert into INL_SHIP_HEADERS_ALL');

Line 2012: FROM dual;

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,
2015: p_procedure_name => l_api_name,
2016: p_debug_info => 'Populate Simulation record to be used on INSERT');

Line 2348: FROM dual;

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 (
2351: p_module_name => g_module_name,
2352: p_procedure_name => l_api_name,