747: attribute13,
748: attribute14,
749: attribute15,
750: nrq_zero_exception_flag
751: FROM inl_ship_lines_all
752: WHERE ship_line_group_id = p_current_ship_line_group_id;
753:
754: TYPE ShipLines_List_Type IS
755: TABLE OF ShipLines%ROWTYPE;
812: p_procedure_name => l_api_name,
813: p_debug_info => 'Get the next Shipment Line Id');
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,
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');
823:
824: INSERT INTO inl_ship_lines_all (ship_header_id,
825: ship_line_group_id,
826: ship_line_id,
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');
823:
824: INSERT INTO inl_ship_lines_all (ship_header_id,
825: ship_line_group_id,
826: ship_line_id,
827: ship_line_num,
828: ship_line_type_id,