DBA Data[Home] [Help]

APPS.INL_INTERFACE_PVT dependencies on DUAL

Line 2502: FROM dual;

2498: ELSE
2499: -- Get Shipment Header's nextval
2500: SELECT inl_ship_headers_all_s.NEXTVAL
2501: INTO validHeaders_List(iHead) .ship_header_id
2502: FROM dual;
2503:
2504: INL_LOGGING_PVT.Log_Variable(
2505: p_module_name => g_module_name,
2506: p_procedure_name => l_proc_name,

Line 2790: FROM dual;

2786: WHEN NO_DATA_FOUND THEN
2787: -- Create a Line Group record
2788: SELECT inl_ship_line_groups_s.NEXTVAL
2789: INTO rec_ship_line_groups.ship_line_group_id
2790: FROM dual;
2791: SELECT MAX(ship_line_group_num)
2792: INTO rec_ship_line_groups.ship_line_group_num
2793: FROM inl_ship_line_groups
2794: WHERE ship_header_id = p_ship_header_id;

Line 3082: FROM dual;

3078: ) ;
3079: -- Get the next Shipment Line Id
3080: SELECT inl_ship_Lines_all_s.NEXTVAL
3081: INTO l_ship_line_id
3082: FROM dual;
3083:
3084: INL_LOGGING_PVT.Log_Variable(
3085: p_module_name => g_module_name,
3086: p_procedure_name => l_proc_name,